First Platform Data Engineer — Lakehouse & Snowflake

Doctronic; New York (NY); On-site; USD 200,000 - 275,000; Full time

Job summary

Doctronic seeks a dedicated Data Engineer to own data plumbing from production systems to the lakehouse and warehouse. You will transform data into trusted, documented tables and control access.

This role serves AI, product, finance, partnerships, and data teams across the company. You will build CDC pipelines from MariaDB, PostgreSQL, and MongoDB into S3 + Iceberg and Snowflake, establish a dbt layer for core metrics, and implement an orchestration tool with alerts.

Qualifications

• 5+ years of data engineering experience owning production data platforms end to end.
• Proficient in SQL and Python with ELT/CDC pipelines.
• Experience with lakehouse/warehouse stacks (S3, Iceberg, Snowflake) and catalog layers.
• Familiarity with transformation frameworks (dbt) and orchestration tools (Airflow, Dagster, Glue).
• Strong AWS fundamentals: IAM, Lambda, Kinesis, Glue.
• Ability to operate with high autonomy in a flat, engineering-first org.
• Excellent communication with product, finance, and AI teams.

Responsibilities

• Build robust CDC pipelines from production databases into the lake and Snowflake warehouse.
• Stand up a dbt-based transformation layer for tested, version-controlled models.
• Choose and implement an orchestration tool with automatic runs and alerts.
• Design access control for PHI, HIPAA Safe Harbor, anonymization, and deletion workflows.
• Create a single governed data copy read by analytics, finance, and AI teams.
• Support AI data needs for model training and governance over data products.
• Design and develop a best-practice warehouse architecture with layered data.

Skills

SQL

Python

ELT/CDC pipelines

dbt

Airflow

Dagster

Snowflake

Iceberg

S3

AWS basics

HIPAA awareness

Tools

Fivetran

Airbyte

dbt

Snowflake

Apache Iceberg

S3

Dagster

Airflow

Glue

Job description

Doctronic seeks a dedicated Data Engineer to own data plumbing from production systems to the lakehouse and warehouse. You will transform data into trusted, documented tables and control access.

This role serves AI, product, finance, partnerships, and data teams across the company. You will build CDC pipelines from MariaDB, PostgreSQL, and MongoDB into S3 + Iceberg and Snowflake, establish a dbt layer for core metrics, and implement an orchestration tool with alerts.