Data Engineer – ClickHouse, SQLMesh & TypeScript (Fintech)

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

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.