Lead Investment Data Platform Engineer

Castleton Tower; New York (NY); Híbrido; USD 180.000 - 240.000; Jornada completa

Descripción de la vacante

Castleton Tower is seeking a senior, hands‑on data engineering lead to build a modern investment data platform for a prominent asset allocator. You will design the warehouse and lakehouse, develop production pipelines in Python and SQL, and raise the bar for data quality and engineering discipline.

You will lead a small team, mentor engineers, and partner with investment, operations, and reporting stakeholders to deliver durable data products.

Formación

• 8+ years of hands-on data engineering or analytics engineering focused on data platforms.
• 3+ years leading technical work as a tech lead, principal, staff engineer, or engineering manager who still builds.
• Expert SQL and Python, with deep data modeling and architecture judgment beyond a single tool.
• Production experience with modern warehouse and lakehouse platforms (Snowflake, Databricks) and orchestration tools.

Responsabilidades

• Architect the warehouse and lakehouse, data models, orchestration, and semantic layers for the investment organization.
• Deliver production-grade Python, SQL, dbt, and orchestration work, including batch and near-real-time pipelines.
• Bring software engineering discipline to data: code reviews, testing, CI/CD, documentation, observability, and data quality controls.
• Lead and mentor engineers through design reviews and pairing, set the technical direction, own outcomes end to end.
• Collaborate with investment, operations, finance, and reporting stakeholders to turn needs into durable data products.
• Leverage AI-enabled tooling to move faster without compromising quality or controls.

Conocimientos

Data engineering

Python

SQL

Data modeling

Snowflake

dbt

Dagster/Airflow

Leadership

Cloud platforms

Herramientas

Snowflake

Databricks

Airflow

dbt

Descripción del empleo

Castleton Tower is seeking a senior, hands‑on data engineering lead to build a modern investment data platform for a prominent asset allocator. You will design the warehouse and lakehouse, develop production pipelines in Python and SQL, and raise the bar for data quality and engineering discipline.

You will lead a small team, mentor engineers, and partner with investment, operations, and reporting stakeholders to deliver durable data products.