The Core Data team builds and scales the data platform and analytics capabilities that power decision-making across Client. Within Core Data, the Vehicle Catalog team owns the vehicle domain — ingesting, curating, and organizing vehicle data for analytics, ML, and BI use cases used by hundreds of stakeholders across dozens of domain teams.
We are migrating the Vehicle Catalog to a new Databricks account while simultaneously building out a new vehicle catalog on that platform. As a Sr. Data Engineer, you will help us refactor and move the existing ETL/ELT and analytics pipelines into the new environment, migrate the underlying data, and validate that everything lands correctly.
This is hands-on migration work. You'll be working alongside our engineers on well-defined pipelines with clear acceptance criteria, and you'll pick up related migration requests — including dashboard and reporting migrations — as they come up.
What You’ll Do
Work with one of our Staff Data Engineers to understand the migration plan, sequence your work against it, and provide regular progress updates.
Refactor existing ETL/ELT code written in PySpark, DABs and dbt from the current Databricks environment to meet the patterns and standards of the new account.
Migrate data pipelines and their underlying datasets, including backfills, and validate parity between source and target.
Build and run reconciliation checks — row counts, schema conformance, freshness, completeness — to confirm migrated data matches the legacy environment.
Migrate dashboards and downstream reporting assets to point at the new datasets, coordinating with the analysts who own them.
Update orchestration, scheduling, alerting, and runbooks so migrated pipelines are supportable after cutover.
Troubleshoot pipeline failures and data discrepancies during and after cutover.
Document what was migrated, what changed, and anything the team needs to know to own it going forward.
Take on adjacent migration and data engineering requests as the program evolves.
| Location | Irvine, CA |
| Job Type | Contractor |
6+ years of experience in Data Engineering, Analytics Engineering, or Software Engineering working with production data systems.
Strong expertise in SQL and Python for building scalable data pipelines and transformations.
Strong familiarity with AI tools like Claude Code / Devin for SW development process
Hands-on experience building ELT pipelines using modern cloud data platforms (Databricks experience required).
Building robust testing frameworks for Data Migration ( Completeness, Quality etc)
Deep experience with dbt, including model development, testing, documentation, and CI/CD integration
Experience designing and operating production-grade data pipelines with monitoring and observability.
Strong collaboration skills and ability to partner with engineering teams, analysts, and operational stakeholders.
Bachelor’s or Master’s degree in Computer Science, Engineering, Mathematics, or related field, or equivalent practical experience.
Prior data or platform migration experience
Nice-to-Have Skills
Familiarity with Fivetran connector management and ingestion architecture.
Experience with data contracts and schema governance.
Knowledge of streaming or near-real-time data pipelines.
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.
Free resume templatesImprove your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.
Free resume builder