Data Engineer, Investment Data Platform

Castleton Tower Consulting, LLC

New York (NY)

Ibrido

USD 120.000 - 160.000

Tempo pieno

14 giorni+

Aumenta le possibilità di ricevere una risposta da questo datore di lavoro

Il tuo curriculum e una lettera di presentazione personalizzati, che corrispondono esattamente a ciò che sta cercando.

Supera i filtri ATS

Descrizione del lavoro

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.

Competenze

  • 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.

Mansioni

  • 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.

Conoscenze

SQL
Python
Data modeling
ETL/ELT
dbt
Airflow
Dagster
Azure Data Factory
Snowflake
Power BI
Testing
CI/CD
Version control

Strumenti

Snowflake
Synapse
Databricks
dbt
ADF
Airflow
Dagster
Power BI
Azure Data Factory

Descrizione del lavoro

The Firm

Castleton Tower is a boutique consulting firm founded by executives who have built and led quantitative research, data science, and technology teams at top-tier hedge funds and asset managers. We work exclusively with investment management firms, including asset allocators, asset managers, hedge funds, family offices, and RIAs, helping them modernize data infrastructure and build AI-ready foundations.

Our engagements combine senior strategy with hands‑on implementation. We assess technical and business strategy, design the architecture, and build the data and AI infrastructure needed to support better investment decisions.

The Opportunity

We are looking for a data engineer to join a prominent asset allocator client as it builds a modern investment data platform. You will work on a small, high-standards team that is replacing a collection of disconnected applications and spreadsheets with a unified data foundation for investment, operations, and reporting.

This is a hands‑on engineering role for someone early in their career who wants to learn from experienced builders, take real ownership, and grow quickly. We care more about how you think, how carefully you work, and how much you want to own than about any specific tool.

What You Will Do
  • 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

Required

  • 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.

Valued

  • Exposure to financial, investment, or private equity data.
  • Azure data services, Azure DevOps pipelines, or Power BI.
  • Experience reconciling data across systems.
Personal Attributes
  • 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 and Placement

Location: Hybrid, Northeast U.S.

This role is intended for full-time placement at a prominent asset allocator client. The successful candidate will work closely with the client's engineering leadership and investment, operations, and technology stakeholders, and spend regular time in the office.

Compensation: Competitive total compensation commensurate with experience.

Ottieni la revisione del curriculum gratis e riservata.

o trascina qui il file.

Similar jobs

Offerte di lavoro simili che vale la pena confrontare

Lead Data Engineer, Investment Data Platform
Lead Data Engineer, Investment Data Platform

Castleton Tower Consulting, LLC • New York (NY)

Ibrido
USD 180.000 - 260.000
Senior Analyst, Data Engineering & Investment Analytics
Senior Analyst, Data Engineering & Investment Analytics

Castleton Tower Consulting, LLC • San Francisco (CA)

Ibrido
USD 100.000 - 150.000
Senior Consultant, AI & Data Engineering
Senior Consultant, AI & Data Engineering

Castleton Tower Consulting, LLC • New York (NY)

Ibrido
USD 250.000 - 500.000
Path to Partnership
Direct Mentorship from Principals
Modern Tech Stack
Data Engineer - Tier 1 Global Asset Manager
Data Engineer - Tier 1 Global Asset Manager

Mondrian Alpha • New York (NY)

In loco
USD 120.000 - 160.000
Data Engineer
Data Engineer

Henderson Scott US • New York (NY)

Ibrido
USD 80.000 - 100.000
Senior Consultant, Strategy & Client Solutions
Senior Consultant, Strategy & Client Solutions

Castleton Tower Consulting, LLC • New York (NY)

Ibrido
USD 250.000 - 500.000
Path to Partnership
Direct Mentorship
Equity for high performers
Senior Consultant, Strategy & Client Solutions
Senior Consultant, Strategy & Client Solutions

Castleton Tower • New York (NY)

Ibrido
USD 250.000 - 500.000
Firm equity available
Director of Engineering
Director of Engineering

Options Consulting Solutions • Boston (MA)

Ibrido
USD 220.000 - 230.000
Base salary
Bonus
Benefits
+1
Investment Data Platform Engineer
Investment Data Platform Engineer

Castleton Tower Consulting, LLC • New York (NY)

Ibrido
USD 120.000 - 160.000
Senior Data Engineer - AI - ETL - Multi Strategy Hedge Fund - NY - Up to $500k TC
Senior Data Engineer - AI - ETL - Multi Strategy Hedge Fund - NY - Up to $500k TC

Mondrian Alpha • New York (NY)

Ibrido
USD 300.000 - 500.000