Remote Lead Data Engineer - Snowflake & IDMC

ReqRoute,Inc; California (MO); Remote; USD 150,000 - 190,000; Full time

Job summary

ReqRoute,Inc. seeks a Senior/Lead Data Engineer to design, build, and support scalable cloud data solutions for healthcare analytics and reporting. You will own end‑to‑end data pipelines with Snowflake, IDMC, Python, and CI/CD in a remote CST-hour role across the US.

We require 8+ years in data engineering, strong Snowflake and IDMC expertise, and hands‑on experience with AWS or Databricks. Leadership and collaboration with cross‑functional teams are essential for success.

Qualifications

• 8+ years in data engineering, ETL development, and enterprise DW.
• Strong Snowflake expertise in SQL, loading, security, performance.
• Strong IDMC development experience with CDI mappings, tasks, deployment, monitoring.
• Proficiency in Python and SQL, plus Git-based CI/CD.

Responsibilities

• Design, develop, test, deploy, and support scalable data pipelines using Snowflake and IDMC.
• Implement ETL/ELT solutions, dimensional models, and SCD Types 1 and 2.
• Develop efficient SQL and Python components, reusable frameworks, automation, and validation utilities.
• Build CI/CD pipelines for data code, IDMC assets, Snowflake objects, testing, and environment promotion.
• Optimize Snowflake performance, scalability, reliability, security, and cost; support AWS/Databricks workloads.
• Implement data quality, reconciliation, lineage, monitoring, governance, and audit controls.
• Troubleshoot production issues and partner with architecture, QA, DevOps, analytics, and business teams.
• Lead design and code reviews, mentor engineers, and drive engineering standards.

Skills

Snowflake

Informatica IDMC

ETL/ELT

Dimensional warehousing

Python

CI/CD

AWS

Databricks

Leadership

Education

Bachelor's degree

Tools

Git

Jenkins

Azure DevOps

GitHub Actions

Job description

ReqRoute,Inc. seeks a Senior/Lead Data Engineer to design, build, and support scalable cloud data solutions for healthcare analytics and reporting. You will own end‑to‑end data pipelines with Snowflake, IDMC, Python, and CI/CD in a remote CST-hour role across the US.

We require 8+ years in data engineering, strong Snowflake and IDMC expertise, and hands‑on experience with AWS or Databricks. Leadership and collaboration with cross‑functional teams are essential for success.