Data Platform Engineer – Python, Dagster & Snowflake

Mitchell Martin Inc.; New York (NY); On-site; USD 120,000 - 160,000; Full time

Job summary

Mitchell Martin Inc. is seeking a data/analytics engineer to join our centralized data team in New York. The role blends software engineering, data engineering, and analytics engineering, focusing on Python assets orchestrated with Dagster to support broad data initiatives.

You will evolve data pipelines, dbt models, and data models in Snowflake, enabling analytics, ML readiness, and cross-department data synthesis. Strong Python, SQL, and collaboration skills are essential.

Qualifications

• Intermediate to advanced Python, including OOP, dataclasses, and exception handling.
• Experience with third-party APIs and vendors to build data pipelines.
• Advanced SQL with CTEs, window functions, and recursive queries.
• Experience with dbt.
• Experience with Dagster (or comparable tools like Airflow).
• Working knowledge of Snowflake or similar cloud data warehouse, including RBAC and data modeling.
• Basic AWS knowledge (IAM and S3).
• Basic HTML/CSS.
• Basic Excel (sorting and filtering).
• Basic GitHub (branching, PRs, secrets/actions).

Responsibilities

• Design, build, and maintain Python-based data assets orchestrated with Dagster across ingestion, transformation, and loading.
• Develop and maintain dbt models to support clean, tested, documented data transformations.
• Build and maintain integrations with third-party APIs and vendor systems to construct reliable data pipelines.
• Standardize and improve data extraction, transformation, loading, and storage processes; organize code in GitHub with proper PR reviews.
• Implement logging, monitoring, and alerting for pipelines.
• Design and maintain data models and schemas in Snowflake with RBAC and access control.
• Organize and automate tasks and infrastructure on AWS.
• Collaborate with technical and non-technical stakeholders to translate needs into pipelines and reports.
• Evaluate and integrate new tools to support business processes; contribute to long-term data platform evolution.

Skills

Problem solving

Project management

Communication

Analytical thinking

Education

Bachelor's degree in Computer Science

Tools

dbt

Dagster

Airflow

GitHub

Snowflake

Job description

Mitchell Martin Inc. is seeking a data/analytics engineer to join our centralized data team in New York. The role blends software engineering, data engineering, and analytics engineering, focusing on Python assets orchestrated with Dagster to support broad data initiatives.

You will evolve data pipelines, dbt models, and data models in Snowflake, enabling analytics, ML readiness, and cross-department data synthesis. Strong Python, SQL, and collaboration skills are essential.