Data Engineer
California, United States
Job Description
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
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
Apply
Similar Jobs
Project Engineer or Sr. Project...
Job Highlights Provide project engineering, equipment design, and constr...
Electrical Engineer – Jr., Mid,...
Job Highlights The Electrical Engineer is responsible for designing, mai...
Process Control Engineer
Job Highlights The Process Control Engineer provides process control eng...
Sr. Systems Engineer, Medical Device
About Company Mizuho OSI is the leader in the markets for specialty surg...