Skip to content

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
Mid level
Experience
3+ 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 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, 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
  • Python
  • SQL
  • Snowflake
  • Airflow
  • dbt
  • ETL
  • Power BI
  • Databricks
  • Data Warehousing
  • CI/CD
  • 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/yr4d ago85· Excellent

More at Castleton Tower

All roles

Keep exploring

Data Engineer, Investment Data Platform

No pay listed · HirQ 54

Apply