Req:: Sr ETL Data Engineer _ Remote _ W2 Only

Location: Remote (preference for Pacific, Mountain, or Central time zone in that order)

Duration: 5+ months
Working hours: 9 am – 6 pm (adjustable)

About The Team & The Role

The Core Data team builds and scales the data platform and analytics capabilities that power decision-making across client locations. 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 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 alongside well-defined pipelines with clear acceptance criteria, including dashboard and reporting migrations as they arise.

Responsibilities

• Work with a Staff Data Engineer to understand the migration plan, sequence your work, and provide regular progress updates.
• Refactor existing ETL/ELT code written in PySpark, Databricks Asset Bundles (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.

Requirements

• 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 software development processes.
• Hands-on experience building ELT pipelines using modern cloud data platforms (Databricks experience required).
• Experience 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.