Apply on Employer Site

Beacon Pointe · 10 hours ago

Senior Data Engineer, Information Technology – Data & Development

Newport Beach, CA

Full-time

Onsite

Senior Level

Beacon Pointe is a multi-billion-dollar Registered Investment Advisor with a commitment to providing objective investment advice. They are seeking a Senior Data Engineer to oversee the data infrastructure, develop data models, and enhance analytics environments to support business insights and actions.

Financial Services

Growth Opportunities

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

Qualification

Data modelingData lakesWarehousesETL designImplementationAWSAzurePython programmingSQL queriesData analysisVisualizationAnalytical skillsProactiveProblem-solving skillsCommunication skillsSelf-motivated

Required

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

Preferred

Bachelor's degree or above in computer science, Information Technology, or a related field is preferred

Company

Beacon Pointe

Beacon Pointe Advisors is one of the largest independent Registered Investment Advisory firms (RIAs) in the nation, working with institutions, defined contribution plans, individuals, and families.

Founded in 2002