Data Engineer – ClickHouse, SQLMesh & TypeScript

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

Job summary

MaxIT Consulting is seeking a Software Engineer, Data Platform in New York, NY, to join the data infrastructure team behind a scalable financial data platform. You will own data ingestion, lakehouse management, and end-to-end data pipelines.

Ideal candidates have 3+ years in data-intensive software engineering, strong SQL and modern transformation stacks (dbt, Dagster, Airflow), and proficiency in TypeScript with Python familiarity. This is an in-person role in New York City.

Qualifications

• 3+ years of software engineering with data-intensive systems.
• Strong SQL, columnar stores, and query performance.
• Experience with modern transformation stacks (dbt, Dagster, Airflow).
• Proficient in TypeScript; Python familiarity.

Responsibilities

• Ingest data from diverse sources and build a lakehouse backend.
• Define data contracts and ensure data quality and observability.
• Scale data processing for reporting and analytics across tenants.
• Collaborate across product, analytics, and infrastructure teams.

Skills

SQL

TypeScript

Python

Data engineering

Tools

dbt

Dagster

Airflow

SQLMesh

Job description

New York, NY | On-site | Full-time

MaxIT Consulting is looking for a Software Engineer, Data Platform to join the data infrastructure team of a fast-growing, venture-backed financial data and accounting automation platform.

The Opportunity

The team builds the financial data plane behind the product: a lakehouse that ingests raw data from ERPs, banks, payment processors and customer warehouses, transforms it into typed canonical tables and serves it to accounting modules, reporting and AI agents. Every engineer owns a slice of the architecture end to end.

What You Might Work On

• Incremental, watermark-based ingestion from API sources, file inboxes and Postgres-to-ClickHouse replication.
• Data contracts and typed source data, enforced at the boundary.
• Lakehouse schema management across tenants (declare, codegen, apply).
• Data security: query scoping, ACLs and tenant isolation.
• Batch and event-driven processing, data correctness and observability.
• Reporting scalability from board-level P&L down to a single transaction.

Required Qualifications

• 3+ years of software engineering experience, with meaningful time on data-intensive systems.
• Strong SQL and a working 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.

Nice to Have

• ClickHouse, Iceberg or Athena.
• Multi-tenant data isolation, PII handling or SOC 2 / audit-driven controls.
• Exposure to financial or accounting data (ERPs, GL, subledgers).
• Temporal, Inngest or similar orchestration systems.

Work Arrangement

In-person role in New York, NY. Candidates must already be authorized to work in the United States.