Investment Data Platform Engineer

Castleton Tower; United States; Hybrid; USD 110,000 - 150,000; Full time

Job summary

Castleton Tower is a boutique consulting firm helping investment managers modernize data infrastructure and build AI-ready foundations. We seek a data engineer to join a prominent asset allocator client, building a unified data platform for investment, operations, and reporting.

This hands-on role suits someone early in their career who wants real ownership, learns from experienced builders, and aims to grow quickly while delivering trusted datasets and reports.

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

Snowflake

dbt

Airflow

Dagster

Power BI

Azure

Tools

Azure Data Factory

Dagster

Airflow

Azure Synapse

Databricks

Job description

Castleton Tower is a boutique consulting firm helping investment managers modernize data infrastructure and build AI-ready foundations. We seek a data engineer to join a prominent asset allocator client, building a unified data platform for investment, operations, and reporting.

This hands-on role suits someone early in their career who wants real ownership, learns from experienced builders, and aims to grow quickly while delivering trusted datasets and reports.