Investment Data Platform Engineer

Castleton Tower; New York (NY); Hybrid; USD 120,000 - 180,000; Full time

Job summary

Castleton Tower is seeking a data engineer to join a prominent asset allocator client, building a modern data platform for investment, operations, and reporting. You will replace scattered spreadsheets with a unified data foundation and own meaningful datasets end-to-end.

This hands-on role targets early-career engineers who want real ownership, learning from experienced builders, and rapid growth in a hybrid Northeast U.S. environment.

Qualifications

• 3 to 5 years of hands-on data engineering, analytics engineering, or a closely related software role.
• Strong SQL and Python, and solid grounding in data modeling and ETL/ELT.
• Experience with a modern data warehouse (Snowflake, Synapse, Databricks, or similar) and a transformation or orchestration tool (dbt, ADF, Airflow, Dagster, or similar).
• Habits of a careful engineer: version control, code review, testing, and monitoring.
• Strong analytical ability and attention to detail.

Responsibilities

• Build and maintain data pipelines and transformations in SQL and Python, using dbt, Snowflake, and orchestration tools such as Dagster, Airflow, or Azure Data Factory.
• Model investment and operational data (positions, transactions, performance, reference data, and private-markets fund data) so it is accurate and easy to use.
• Write tests, data quality checks, and reconciliations that prove the numbers are right, and fix the root cause when they aren’t.
• Ship through code review and CI/CD, and help keep production pipelines monitored and reliable.
• Work with analysts and investment teams to understand what they need, and deliver datasets and reports (including Power BI) they can trust.
• Use AI-assisted development tools to work faster while keeping quality high.

Skills

SQL

Python

Data modeling

ETL/ELT

Data warehousing

Testing

Monitoring

Code review

Tools

Snowflake

Synapse

Databricks

dbt

Azure Data Factory

Airflow

Dagster

Power BI

Job description

Castleton Tower is seeking a data engineer to join a prominent asset allocator client, building a modern data platform for investment, operations, and reporting. You will replace scattered spreadsheets with a unified data foundation and own meaningful datasets end-to-end.

This hands-on role targets early-career engineers who want real ownership, learning from experienced builders, and rapid growth in a hybrid Northeast U.S. environment.