Senior Data Engineer, Information Technology – Data & Development

Beacon Pointe Advisors•Newport Beach, CA

About The Position

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.

Requirements

Technical expertise with data models, data mining, and segmentation techniques.
Extensive experience with processing large sets of unstructured, semi-structured, and structed 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 programing knowledge for Python & C/C++ and strong in wiring 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.

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 process across internal platforms (Tamarac Reporting, eMoney, HubSpot, Box)
Stay current with trends, techniques, technology, and other factors impacting the job.