Senior Data Engineer, Information Technology – Data & Development
Beacon Pointe, Newport Beach, CA, United States
Job Description
The Senior Data Engineer will oversee the department’s data infrastructure, including developing a data model, integrating large amounts of data from different systems, building & enhancing a data lake-house & subsequent analytics environment, and writing scripts to facilitate data analysis. This role will work closely & collaboratively with members of the executive team and various departments across the organization to define requirements, mine & analyze data, and deploy high-quality data pipelines to support analytics needs & data ingestion from recently acquired firms. The Data team is responsible for turning data into information that leads to insights and actions to improve the business.
Responsibilities
- Build & continuously enhance a data lake-house that ingests data from different sources to create a unified system for unstructured, semi-structured, and structured data.
- Combine & analyze data from the lake-house to create analytical reports & insights for executive management.
- Responsible for developing complex queries in SQL, SPL, stored procedures, or PowerBI from a very large data volume and multiple data sources.
- Able to use and apply the right analytical techniques to identify hidden patterns & trends that can be leveraged to improve the business.
- Lead data analysis to solve complex data issues and support data research requests.
- Perform data analytics, visualization, dashboard customization, and alerts in various cloud platforms such as Azure, Redshift, PowerBI, Tableau.
- Partner with strategic vendors to connect external data sources.
- Build logic that will connect & ingest data sources from newly acquired offices.
- Help improve data quality & efficiency for various platforms.
- Build process automation, algorithms, & prototypes.
- Audit & enhance data quality & reliability.
- Work as a team to create data integrations with other systems.
- Monitor and develop data integration tools to provide support for business processes across internal platforms (Tamarac Reporting, eMoney, HubSpot, Box).
- Stay current with trends, techniques, technology, and other factors impacting the job.
Qualifications
- Technical expertise with data models, data mining, and segmentation techniques.
- Extensive experience with processing large sets of unstructured, semi-structured, and structured data.
- Extensive experience building, maintaining, and enhancing data lakes and data warehouses.
- Extensive experience working in AWS (Amazon Web Services), Azure, Tableau, & Snowflake.
- Extensive experience in ETL design, implementation, and maintenance.
- Extensive experience in programming knowledge for Python & C/C++ and strong in writing complex DB query SQL.
- Experience with data modeling and working with Big Data.
- Experience with data analysis and visualization, particularly PowerBI & Tableau.
- Strong analytical experience & skills that can extract actionable insights from raw data to help improve the business.
- Designing and implementing real-time pipelines.
- Ability to effectively manage data, data storage, and data security.
- Great numerical and analytical skills.
- Excellent problem-solving skills and the ability to troubleshoot and resolve platform-related issues.
- Strong communication skills with the ability to collaborate effectively with cross-functional teams and stakeholders.
- Proactive and self-motivated with a passion for continuous learning and staying updated with Salesforce best practices and new features.
- Bachelor’s degree or above in computer science, Information Technology, or a related field is preferred.