Data Platform Engineer: Lakehouse Ingestion (NYC On-site)

MaxIT Consulting - Max Corporate Group

New York (NY)

On-site

USD 120,000 - 190,000

Full time

28 hours ago

Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

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.