Data Platform Engineer | ClickHouse, SQLMesh, TypeScript — On-site NYC

MaxIT Consulting - Max Corporate Group; New York (NY); On-site; USD 120,000 - 180,000; Full time

Job summary

MaxIT Consulting is seeking a Software Engineer, Data Platform to join the data infrastructure team building a lakehouse that ingests ERP data, banks, and other sources, then transforms it into typed tables for accounting, reporting, and AI agents.

You will own a slice of the architecture end-to-end, work on ingestion, data contracts, lakehouse schema, and data security, with emphasis on SQL performance and modern orchestration tools like SQLMesh, dbt, Dagster, and Airflow.

Qualifications

• 3+ years of software engineering experience on data-intensive systems.
• Strong SQL and understanding of columnar stores, partitioning and query performance.
• Experience with a modern transformation / orchestration stack (SQLMesh, dbt, Dagster, Airflow or similar).
• Strong general-purpose programming, primarily TypeScript, with some Python.

Responsibilities

• Ingest data from sources and build end-to-end data pipelines.
• Implement lakehouse schema management and data contracts.
• Ensure data security and tenant isolation across the platform.
• Optimize batch and streaming processing for reliability and observability.
• Support reporting and analytics for accounting modules.
• Collaborate with cross-functional teams to own features end-to-end.

Skills

SQL

TypeScript

Python

Data-intensive systems

Query performance

Tools

SQLMesh

dbt

Dagster

Airflow

Job description

MaxIT Consulting is seeking a Software Engineer, Data Platform to join the data infrastructure team building a lakehouse that ingests ERP data, banks, and other sources, then transforms it into typed tables for accounting, reporting, and AI agents.

You will own a slice of the architecture end-to-end, work on ingestion, data contracts, lakehouse schema, and data security, with emphasis on SQL performance and modern orchestration tools like SQLMesh, dbt, Dagster, and Airflow.