Software Engineer, Data Platform – Financial Data Lakehouse

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

Job summary

MaxIT Consulting is seeking a Software Engineer, Data Platform to join the data infrastructure team behind a fast-growing financial data and accounting automation platform in New York, NY. You will own a slice of the data lakehouse stack, from ingestion to serving data to accounting modules and AI agents.

You should have 3+ years of experience with data-intensive systems, strong SQL, and experience with a modern orchestration stack.

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.

Responsibilities

• 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.

Skills

SQL

Columnar stores

Query performance

TypeScript

Python

Data-intensive systems

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.