InDepth Engineering Solutions, LLC

Sr. Data Engineer

InDepth Engineering Solutions, LLC

Mechanical Or Industrial Engineering · 51-200 employees

19 h ago
Remote data-engineer Senior (5-10 yrs) Contractor
Log in to apply, save this posting, or score it against your profile with AI.

About the role

You will lead the migration of existing ETL/ELT and analytics pipelines to a new Databricks environment while ensuring data parity and quality. Additionally, you will update orchestration, scheduling, and reporting assets to ensure the new pipelines are fully supportable.

What they look for

Data Engineering SQL Python PySpark Databricks dbt ETL ELT Data Migration Cloud Data Platforms CI/CD Data Observability Data Reconciliation Analytics Engineering Software Engineering

Requirements

Candidates must have 6+ years of experience in data or software engineering with strong expertise in Python, SQL, and Databricks. A bachelor's or master's degree in a technical field is required, along with proven experience in production-grade data pipeline design and migration.

Full description

This is a remote position.

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.

Salary will be based on the location and experience.

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 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

Similar roles