Principal Data Engineer - Remote ELT & Data Pipelines

Jobot; New York (NY); Remote; USD 170,000 - 205,000; Full time

Benefits offered by this job

Annual performance bonus

Medical, dental, vision coverage

401k with 4% match

Unlimited PTO

Remote flexibility

Competitive compensation packages

Job summary

Jobot is hiring a highly skilled Principal Data Engineer to design, build and scale modern data pipelines and architectures for enterprise analytics. This hands-on role emphasizes ELT, dimensional modeling and cloud data platforms with significant ownership from ingestion to curated data marts.

The ideal candidate has 5+ years of ELT experience, strong SQL/Python skills and a track record in TDD, Git workflows and CI/CD in data environments.

Qualifications

• 5+ years of experience building ELT pipelines in a Data Warehouse environment.
• Strong experience with dimensional data modeling (Kimball, Data Vault, Medallion).
• Hands-on expertise with dbt, Airflow or Dagster.
• Strong experience with Snowflake or similar cloud data warehouses, distributed data systems, Kubernetes environments.
• Deep understanding of append-only data modeling & point-in-time data structures, column-oriented/analytical SQL modeling.
• Strong proficiency in Python and SQL.
• Experience implementing test-driven development for data pipelines, Git-based workflows and CI/CD best practices.

Responsibilities

• Design, build and scale modern data pipelines and architectures to support analytics, reporting and data products.
• Own data lifecycle from ingestion through curated data marts with focus on performance, scalability and quality.

Skills

Python

SQL

ELT development

Dimensional modeling

Data quality

CI/CD

Education

Bachelor’s degree in Computer Science, Engineering, or equivalent experience

Tools

dbt

Airflow

Dagster

Snowflake

Kubernetes

Job description

Jobot is hiring a highly skilled Principal Data Engineer to design, build and scale modern data pipelines and architectures for enterprise analytics. This hands-on role emphasizes ELT, dimensional modeling and cloud data platforms with significant ownership from ingestion to curated data marts.

The ideal candidate has 5+ years of ELT experience, strong SQL/Python skills and a track record in TDD, Git workflows and CI/CD in data environments.