Investment Data Platform Engineer

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

Job summary

Castleton Tower Consulting, LLC is seeking a data engineer to join a prominent asset allocator client. You will help replace scattered apps with a unified data foundation for investment, operations, and reporting, taking ownership and growing quickly in a hands‑on role.

You will work on a small, high‑standards team, building pipelines, modeling data, and delivering trusted datasets and Power BI reports. This is a hybrid Northeast U.S. placement with strong growth potential.

Qualifications

• 3 to 5 years of hands‑on experience in 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

dbt

Airflow

Dagster

Azure Data Factory

Snowflake

Power BI

Testing

CI/CD

Version control

Tools

Snowflake

Synapse

Databricks

dbt

ADF

Airflow

Dagster

Power BI

Azure Data Factory

Job description

Castleton Tower Consulting, LLC is seeking a data engineer to join a prominent asset allocator client. You will help replace scattered apps with a unified data foundation for investment, operations, and reporting, taking ownership and growing quickly in a hands‑on role.

You will work on a small, high‑standards team, building pipelines, modeling data, and delivering trusted datasets and Power BI reports. This is a hybrid Northeast U.S. placement with strong growth potential.