Senior Data Platform Architect — Investment Data & AI

Castleton Tower; United States; Hybrid; USD 180,000 - 240,000; Full time

Job summary

Castleton Tower is a boutique consulting firm that helps asset managers modernize data infrastructure and build AI-ready foundations. We seek a senior, hands-on data engineering lead to build a unified data platform for a prominent asset allocator client, combining strategy with implementation across data, operations, and reporting.

You will design the warehouse and lakehouse, write production-grade Python and SQL, enforce engineering standards, and mentor engineers while partnering with

Qualifications

• 8+ years hands-on data engineering, analytics engineering, or software engineering focused on data platforms.
• 3+ years leading technical work, as a tech lead, principal or staff engineer, or engineering manager who still builds.
• Expert SQL and Python, and deep data modeling and architecture judgment that goes beyond any single tool.
• Production experience with modern warehouse and lakehouse platforms (Snowflake, Databricks, or similar), dbt, and orchestration tools (Dagster, Airflow, or similar).
• Strong software engineering practice: version control, code review, automated testing, and CI/CD applied to data.
• Track record of shipping and operating systems you built, described in terms of what you delivered.

Responsibilities

• Architect and build core investment data domains such as security and entity reference data, positions and transactions, performance, risk, and private‑markets fund data.
• Design data models that are correct, reconcilable, and point-in-time aware, with tests and controls that catch problems before users do.
• Own reliability, performance, and cost of the platform, including monitoring, alerting, and incident follow‑through.
• Review others' work closely, send it back when it isn't right, and make the next version better.
• Evaluate tooling and vendors across Snowflake, dbt, Dagster/Airflow, and Azure, and make pragmatic build‑versus‑buy calls.

Skills

Data engineering

Team leadership

Python

SQL

Data modeling

Warehouse/Lakehouse

dbt

Orchestration

Tools

Snowflake

Databricks

dbt

Dagster

Airflow

Azure

Job description

Castleton Tower is a boutique consulting firm that helps asset managers modernize data infrastructure and build AI-ready foundations. We seek a senior, hands-on data engineering lead to build a unified data platform for a prominent asset allocator client, combining strategy with implementation across data, operations, and reporting.

You will design the warehouse and lakehouse, write production-grade Python and SQL, enforce engineering standards, and mentor engineers while partnering with