Senior Consultant, Data Engineering & Analytics

Posted 2 Months Ago
Be an Early Applicant
New York City, NY
In-Office
250K-500K Annually
Senior level
Fintech • Consulting
The Role
Lead the design and implementation of data platforms and pipelines for investment firms, collaborating with teams to develop automated tools and ensure data integrity.
Summary Generated by Built In

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 (RIAs, family offices, hedge funds, and asset allocators) helping them modernize their data infrastructure and build AI-ready foundations.

What makes us different: We're a lean firm where senior practitioners do the actual work. No armies of junior consultants learning on your dime. Our engagements blend high-level strategy with hands-on technical implementation. We'll assess your technical & business strategy, design your data architecture and also code up the full stack infrastructure where needed.

The Opportunity

We're looking for a technical leader who can design and build data platforms for investment firms. This role emphasizes hands-on engineering while maintaining strategic client engagement. You'll architect data warehouses, build production pipelines, and develop quantitative tools that directly support investment decisions.

What you'll get:

  • Strategic Impact: Lead full-scope projects from architecture design to production deployment

  • Direct Mentorship: Work alongside the firm's Principals on every engagement

  • Modern Tech Stack: Work with best-in-class tools (Snowflake, Databricks, dbt, Dagster, cloud infrastructure, etc.) and cutting-edge AI/agentic development workflows

  • Path to Partnership: Clear trajectory toward firm equity and partnership for high performers

Core Responsibilities

Technical Leadership

  • Lead the design and implementation of scalable data platforms (data warehouses, data lakes) and end-to-end data pipelines

  • Develop and optimize production-grade code (Python/Spark) for data transformation and financial analysis

  • Build customized analytical applications, dashboards, and quantitative investment tools

  • Ensure efficient delivery and adherence to data governance and integrity standards

Client Engagement

  • Collaborate with client investment teams to translate investment process requirements into robust, automated tools and data products

  • Provide technical and project leadership across engagements

  • Understand client business context to ensure technical solutions solve real problems

Qualifications

Required:

  • 7+ years of hands-on experience in a technical or analytical role (Quant, Quant Dev, Data Scientist, or Data Engineer). Minimum of 5 years for highly exceptional candidates

  • Prior experience at hedge funds, fintech firms/startups, market makers, or top-tier asset management firms. Experience at top technology or strategy consulting firms considered on a case-by-case basis

  • Demonstrated project leadership, ideally overseeing technical delivery from inception to production

  • Proficiency in Python (Pandas, NumPy, Scikit-learn) and advanced SQL query optimization

  • Experience with at least one major cloud platform (AWS, GCP, or Azure) and associated data services (Snowflake, Databricks)

  • Deep understanding of data modeling and data warehousing principles

Valued:

  • Familiarity with data pipeline orchestration tools (Airflow, Dagster, Prefect)

  • Experience building quantitative trading or investment tools

  • Background in financial data (market data, portfolio analytics, fund accounting)

Personal Attributes:

  • High ownership mentality: you see problems through to resolution without being told

  • Understands what high-quality work looks like and how to deliver it

  • Curious and interested in learning about new technologies and the investment industry

  • Seeks to understand the broader business context, not just the technical requirements

  • Independent thinker who takes initiative

Location & Compensation

Location: Hybrid in the NYC area. Expect to travel roughly one week per month for on-site client work.

Compensation:

  • Total expected compensation: $250 to $500K+ (commensurate with experience)

  • Firm equity available for high performers

Top Skills

Airflow
AWS
Azure
Dagster
Databricks
GCP
Python
Snowflake
Spark
SQL
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
3 Employees
Year Founded: 2021

Similar Jobs

Tomo Mortgage Logo Tomo Mortgage

Growth Marketing Manager

Fintech • Other • Real Estate • Financial Services
Hybrid
New York City, NY, USA
160 Employees
90K-130K Annually

Mastercard Logo Mastercard

Director, Growth Segment Partnerships

Blockchain • Fintech • Payments • Consulting • Cryptocurrency • Cybersecurity • Quantum Computing
Hybrid
Harrison, NY, USA
38800 Employees
182K-291K Annually

Mastercard Logo Mastercard

Director, Strategy & Commercialization - Open Finance

Blockchain • Fintech • Payments • Consulting • Cryptocurrency • Cybersecurity • Quantum Computing
Hybrid
Harrison, NY, USA
38800 Employees
179K-305K Annually

Mastercard Logo Mastercard

Vice President, Healthcare Commercial Payments

Blockchain • Fintech • Payments • Consulting • Cryptocurrency • Cybersecurity • Quantum Computing
Hybrid
Harrison, NY, USA
38800 Employees
235K-375K Annually

Similar Companies Hiring

Rain Thumbnail
Blockchain • Fintech • Payments • Financial Services • Cryptocurrency • Web3 • Infrastructure as a Service (IaaS)
New York, NY
100 Employees
Scotch Thumbnail
Software • Retail • Payments • Fintech • eCommerce • Artificial Intelligence • Analytics
US
25 Employees
Kepler  Thumbnail
Fintech • Software
New York, New York
6 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account