Data Engineer

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

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