Overview:
The Opportunity
• Rebuild analytics pipelines and integrate new data models into the data infrastructure
• Refactor existing workflows from LASR/MSS 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/MSS 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
Domain Experience (If any)
Financial / Institutional business experience preferred
Location
Downtown LA, CA
Onsite Requirement
Yes
Number of days onsite
4 days
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/MSS • Skill 7 - Strong Data Analysis (gap analysis between datasets and new structures) • Skill 8 - Familiarity with ICAM data model
