Skip to content

Lead Data Engineer, Investment Data Platform

Castleton TowerBoston, MAHybrid

First seen Sep 23 · open 58 days · posted onceNo pay listed

HirQ verdict

54/100 · Fair. Based on age, reposts, pay, the company's hiring and ghost signals.

Low ghost risk
True age
58 days
Reposts
Posted once

See the evidence behind this score.

Pro shows each part of the score, the reasons, the pay percentile and the listing history.

HirQ's ghost-risk estimate and company labels are automated opinions based on what we observe on employers' public job boards: how long a listing has been open, whether it was re-listed, wording in the description, and how often roles on that board close. They are not statements about an employer's intent, and a high-risk listing can still be a real opening. Figures are as of the date shown. How we measure

At a glance

Pay
No pay listed
Level
Lead
Experience
8+ years
Type
FullTime
Team
Consulting
Work setup
Hybrid

“Location: Hybrid, Boston, MA”

Pay vs market

Employer-posted ranges for Data & Analytics roles in MA in the last 12 months (103 postings).

$119k
25th pct/yr
$163k
Median/yr
$189k
75th pct/yr
$77k · 10th90th · $212k

This job: No pay listed

Castleton Tower hiring

Company page
SteadyHiring45· WeakBanking, Insurance & Finance
Open roles
6
New in 30 days
0
Closed in 30 days
1
Hiring trend, 13 weeksPro
Follow-through: ••%Pro

About the role

From Castleton Tower's careers page, checked Nov 21

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 senior, hands-on data engineering lead to help a prominent asset allocator client build a modern investment data platform. The firm has outgrown a collection of disconnected applications and spreadsheets and is building a unified data foundation across its investment, operations, and reporting functions.

This is a builder's role. The right person has deep technical expertise, writes and reviews production code, and holds a high bar for quality. They know what good data engineering looks like, and when work falls short of it they fix it and help the team raise its standards. You will lead technical work across a small, growing team and partner directly with the head of the function.

WHAT YOU WILL OWN

  • Platform architecture: Design and build the warehouse and lakehouse, data models, orchestration, and semantic layers that the investment organization runs on.
  • Hands-on delivery: Build production-grade Python, SQL, dbt, and orchestration work yourself, including batch and near-real-time pipelines.
  • Engineering standards: Bring software engineering discipline to data: code review, testing, CI/CD, documentation, observability, and data quality controls.
  • Technical leadership: Lead and mentor engineers through design reviews and pairing, set the technical direction for your area, and own outcomes end to end.
  • Business partnership: Work with investment, operations, finance, and reporting stakeholders to turn their needs into durable data products.
  • AI-enabled engineering: Use tools such as Claude Code, Codex, Cursor, and Copilot to move faster without compromising quality or controls.

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

QUALIFICATIONS

Required

  • 8+ years of hands-on experience in 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.

Strongly Valued

  • Experience with investment management systems and data: security master, IBOR/ABOR, OMS, risk, performance, fund accounting, or client reporting.
  • Private markets data, including entity mapping across sources without universal identifiers.
  • Azure data services (Azure Data Factory, Azure DevOps pipelines, Synapse) and Power BI.
  • Experience in asset allocators, asset managers, hedge funds, private markets firms, or financial data providers.

PERSONAL ATTRIBUTES

  • Craftsman mindset: you care about the parts of the system nobody sees.
  • High standards for yourself and the people around you, delivered constructively.
  • Ownership: you see problems through to resolution without being asked.
  • Clear communicator with both engineers and investment professionals.

LOCATION AND PLACEMENT

Location: Hybrid, Boston, MA

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.

Skills mentioned

  • Azure
  • dbt
  • Python
  • SQL
  • Snowflake
  • Airflow
  • CI/CD
  • Databricks
  • Observability
  • Power BI
  • Excel
Apply on Castleton Tower's siteOpens Castleton Tower's own application page.

Similar jobs

Same role or field, nearby or remote, ranked by HirQ score.

Senior Data Analyst, Hardware

ŌuraHybrid - Los Angeles, California; Hybrid - San Francisco, California; Remote - Boston, Massachusetts; Remote - New York, New YorkHybrid

$174k–$205k/yr4d ago89· Excellent

Data Engineer II

Yes EnergyBoston, Massachusetts, United States, Boulder, Colorado, United States, Chicago, Illinois, United StatesHybrid

$90k–$136k/yr3d ago85· Excellent

More at Castleton Tower

All roles

Keep exploring

Lead Data Engineer, Investment Data Platform

No pay listed · HirQ 54

Apply