Data Engineer

Data EngineerThe Capital Group of companies, Inc. is looking for a Data Engineer in Downtown LA, CA (4 Days Onsite) for a 6-12+ Months Contract.Must Have Skills:Strong Data Engineering expertiseDatabricksPySparkData pipeline development and rebuildingIntegration of new data modelsRefactoring workflows from LASR/ClientStrong Data Analysis (gap analysis between datasets and new structures)Familiarity with ICAM data modelDomain Experience (If any): Financial / Institutional business experience preferredThe Opportunity:Rebuild analytics pipelines and integrate new data models into the data infrastructureRefactor existing workflows from LASR/Client to Databricks and PySparkDevelop familiarity with the ICAM data model and support data integration effortsAssess and identify gaps between existing datasets and new data structures from STEP and ICAMSupport exploratory analytics use cases including analyzing consultant organization behavior and understanding Field Consultant preferencesExplore opportunities to leverage tools like Claude for ad hoc data access based on progress of core data integration workWhat You Need:Strong data engineering expertiseExperience with Databricks and PySparkExperience in refactoring workflows from LASR/Client to modern platformsStrong data analysis skills to identify gaps between datasets and new data structuresFamiliarity with ICAM data modelExperience working with complex data environmentsPrior experience within the financial industry is helpfulPower BI experience is a nice-to-have