Software Engineer, Data Platform – Lakehouse (On-site NY)

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

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.