Hybrid Investment Data Platform Engineer

Castleton Tower; Boston; Hybrid; PHP 7,561,000 - 10,082,000; Full time

Benefits offered by this job

Hybrid work model

Job summary

Castleton Tower is seeking a data engineer to join a prominent asset allocator client in Boston. You will build and operate a unified data foundation, replacing disconnected apps with scalable pipelines, dashboards, and reporting.

This hands-on role is ideal for someone early in their career who wants ownership, learns quickly, and grows toward senior engineering. You will work hybrid and collaborate with investment and operations teams.

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

Code review

Testing

Monitoring

Tools

dbt

Snowflake

Airflow

Dagster

Azure Data Factory

Azure

Power BI

Job description

Castleton Tower is seeking a data engineer to join a prominent asset allocator client in Boston. You will build and operate a unified data foundation, replacing disconnected apps with scalable pipelines, dashboards, and reporting.

This hands-on role is ideal for someone early in their career who wants ownership, learns quickly, and grows toward senior engineering. You will work hybrid and collaborate with investment and operations teams.