Senior Data Engineer

Job Title : Senior Data Engineer
Location : 14410 My ford Road, Irvine, California, United States of America, 92606
Duration:4 Months
Experience:8-10 year

Job Description
• Job Title: Sr Data Engineer
• Worksite location: Remote with Bill rate, please keep in mind location of the candidate. Submit at market rate.
Would prefer someone in Pacific, Mountain or Central time zone in that order, if possible.
• Working hours: 9am - 6pm , can adjust
• Travel: N/A

About the Team & the Role
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
o Work with one of our Staff Data Engineers to understand the migration plan, sequence your work against it, and provide regular progress updates.
o 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.
o Migrate data pipelines and their underlying datasets, including backfills, and validate parity between source and target.
o Build and run reconciliation checks - row counts, schema conformance, freshness, completeness - to confirm migrated data matches the legacy environment.
o Migrate dashboards and downstream reporting assets to point at the new datasets, coordinating with the analysts who own them.
o Update orchestration, scheduling, alerting, and runbooks so migrated pipelines are supportable after cutover.
o Troubleshoot pipeline failures and data discrepancies during and after cutover.
o Document what was migrated, what changed, and anything the team needs to know to own it going forward.
o Take on adjacent migration and data engineering requests as the program evolves.

Qualifications
Required
o 6+ years of experience in Data Engineering, Analytics Engineering, or Software Engineering working with production data systems.
o Strong expertise in SQL and Python for building scalable data pipelines and transformations.
o Strong familiarity with AI tools like Claude Code / Devin for SW development process
o Hands-on experience building ELT pipelines using modern cloud data platforms (Databricks experience required).
o Building robust testing frameworks for Data Migration ( Completeness, Quality etc)
o Deep experience with dbt, including model development, testing, documentation, and CI/CD integration
o Experience designing and operating production-grade data pipelines with monitoring and observability.
o Strong collaboration skills and ability to partner with engineering teams, analysts, and operational stakeholders.
o Bachelor's or Master's degree in Computer Science, Engineering, Mathematics, or related field, or equivalent practical experience.
o Prior data or platform migration experience

Nice-to-Have Skills
o Familiarity with FiveTran connector management and ingestion architecture.
o Experience with data contracts and schema governance.
o Knowledge of streaming or near-real-time data pipelines.