← Back to jobsJob ID col-cmv8nfli20g0voz01s1uthkv3

Financial ServicesPosted 30+ days ago

Data Engineer, Investment Data Platform

Full-time
Hybrid
3+ years
Competitive
Posted 30+ days ago

Castleton Tower Consulting is a boutique consulting firm that helps investment management firms modernize data infrastructure and build AI-ready foundations. The company is seeking an early-career Data Engineer to build and maintain a unified investment data platform, develop reliable pipelines and data models, and deliver trusted datasets and reports for analysts and investment teams.

Financial Services

Posted
30+ Days Ago
Source
jobs.ashbyhq.com
Sector
Information Technology & AI

Opens the employer's application page in a new tab

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

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
  • High ownership: you take problems to resolution without being told
  • Curious and quick to learn; you want to understand the investment side, not only the pipelines
  • High standards for your own work, and open to direct feedback
  • Energy and drive to grow into a senior engineer
  • Location: Hybrid, Northeast U.S

Preferred

  • Exposure to financial, investment, or private equity data
  • Azure data services, Azure DevOps pipelines, or Power BI
  • Experience reconciling data across systems

Required skills

SQLPythonData ModelingETL/ELTSnowflakedbtAzure Data FactoryAirflowDagsterVersion ControlCode Review

Full job description

Castleton Tower Consulting is a boutique consulting firm that helps investment management firms modernize data infrastructure and build AI-ready foundations. The company is seeking an early-career Data Engineer to build and maintain a unified investment data platform, develop reliable pipelines and data models, and deliver trusted datasets and reports for analysts and investment teams.

Financial Services

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

Preferred

  • Exposure to financial, investment, or private equity data
  • Azure data services, Azure DevOps pipelines, or Power BI
  • Experience reconciling data across systems

Benefits

  • Hybrid work arrangement in the Northeast U.S.
  • Full-time placement at a prominent asset allocator client
  • Opportunities to learn from experienced builders, take real ownership, and grow quickly

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
  • High ownership: you take problems to resolution without being told
  • Curious and quick to learn; you want to understand the investment side, not only the pipelines
  • High standards for your own work, and open to direct feedback
  • Energy and drive to grow into a senior engineer
  • Location: Hybrid, Northeast U.S
  • Exposure to financial, investment, or private equity data
  • Azure data services, Azure DevOps pipelines, or Power BI
  • Experience reconciling data across systems
  • 3 to 5 years of hands-on experience in data engineering, analytics engineering, or a closely related software role.

Required skills

  • SQL, Python, Data Modeling, ETL/ELT, Snowflake, dbt, Azure Data Factory, Airflow, Dagster, Version Control, Code Review, Data Testing and Quality Checks

Preferred skills

  • Exposure to financial, investment, or private equity data, Azure data services, Azure DevOps pipelines, or Power BI, Experience reconciling data across systems

Experience

  • 3+ years

Company

  • Castleton Tower empowers asset allocators and asset managers to harness the full potential of their data.
  • https://www.castletontowerllc.com/

Job details

Employment type

Full-time

Seniority level

3+ years

Date posted

Sep 23, 2026

Work mode

Hybrid

Job source

jobs.ashbyhq.com

Company

Financial Services

Information Technology & AI

Castleton Tower empowers asset allocators and asset managers to harness the full potential of their data.

See all 6 jobs from Financial Services →

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Engineer jobs in United States

Coinbase

1d ago

New

Senior Software Engineer, Data Engineering Platform

Full-timeRemoteUnited States$186K – $219K/yr

Coinbase is hiring a Senior Software Engineer for its Data Platform team. The role builds and maintains SDKs, self-service applications, reusable abstractions, and security and observability tooling that help internal teams create, manage, and use data…

Why similarSame roleETL/ELTPython

Curana Health

1d ago

New

Data Engineer

Full-timeRemoteUnited StatesCompetitive

Curana Health is hiring a Data Engineer to build, optimize, and maintain data pipelines supporting clinical, operational, and analytical reporting.

Why similarSame roleAzure Data FactoryPython

Airbnb

1d ago

New

Data Engineer Tech Foundations

Full-timeRemoteUnited States$162K – $186K/yr

Airbnb is hiring a Data Engineer to build and operate reliable, reusable datasets and pipelines that support AI usage and cost measurement, Unit Economics, enterprise application data, and critical financial metrics.

Why similarSame roleData ModelingPython

Get new Data Engineer jobs in United States by email

Create job alert

Data Engineer, Investment Data Platform

Financial Services · Competitive

Apply on company site