USA-Irvine-The Capital Group of companies, Inc.

Request-ID: 22680-1
Role: Data Engineer

Location: Downtown LA, CA (4 Days Onsite)

Duration: 6-12+ Months Contract

Must Have Skills
• Skill 1 - Strong Data Engineering expertise
• Skill 2 - Databricks
• Skill 3 - PySpark
• Skill 4 - Data pipeline development and rebuilding
• Skill 5 - Integration of new data models
• Skill 6 - Refactoring workflows from LASR/Client
• Skill 7 - Strong Data Analysis (gap analysis between datasets and new structures)
• Skill 8 - Familiarity with ICAM data model

Domain Experience (If any)
Financial / Institutional business experience preferred

The Opportunity
• Rebuild analytics pipelines and integrate new data models into the data infrastructure
• Refactor existing workflows from LASR/Client to Databricks and PySpark
• Develop familiarity with the ICAM data model and support data integration efforts
• Assess and identify gaps between existing datasets and new data structures from STEP and ICAM
• Support exploratory analytics use cases including analyzing consultant organization behavior and understanding Field Consultant preferences
• Explore opportunities to leverage tools like Claude for ad hoc data access based on progress of core data integration work

What You Need
• Strong data engineering expertise
• Experience with Databricks and PySpark
• Experience in refactoring workflows from LASR/Client to modern platforms
• Strong data analysis skills to identify gaps between datasets and new data structures
• Familiarity with ICAM data model
• Experience working with complex data environments
• Prior experience within the financial industry is helpful
• Power BI experience is a nice-to-have