Software Engineer, Data Platform – Financial Data Lakehouse

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

Job summary

MaxIT Consulting - Max Corporate Group is seeking a Software Engineer, Data Platform to join the data infrastructure team in New York. You will work on a lakehouse that ingests ERP, banking, and warehouse data, transforms it into typed canonical tables, and serves modules including reporting and AI agents.

The role involves end-to-end ownership of architecture slices, strong SQL, and experience with a modern transformation/orchestration stack.

Qualifications

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

Responsibilities

• Build data ingestion and lakehouse capabilities, ingesting data from multiple sources.
• Define data contracts and typed source data at the boundary.
• Manage lakehouse schema across tenants and apply changes.
• Ensure data security with query scoping and tenant isolation.
• Support batch and event-driven processing with observability.

Skills

SQL

Data-intensive systems

TypeScript

Python

Performance optimization

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.