Senior Consultant, Data Engineering & Analytics
Department: Consulting
Location: New York City
Compensation: $250K – $500K • Firm equity available for high performers
Employment Type: FullTime
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
There are more than 50,000 engineering jobs:
Subscribe to membership and unlock all jobs
Engineering Jobs
60,000+ jobs from 4,500+ well-funded companies
Updated Daily
New jobs are added every day as companies post them
Refined Search
Use filters like skill, location, etc to narrow results
Become a member
🥳🥳🥳 452 happy customers and counting...
Overall, over 80% of customers chose to renew their subscriptions after the initial sign-up.
To try it out
For active job seekers
For those who are passive looking
Cancel anytime
Frequently Asked Questions
- We prioritize job seekers as our customers, unlike bigger job sites, by charging a small fee to provide them with curated access to the best companies and up-to-date jobs. This focus allows us to deliver a more personalized and effective job search experience.
- We've got over 200,000 jobs from 15,000+ vetted companies. No fake or sleazy jobs here!
- We aggregate jobs from 15,000+ companies' career pages, so you can be sure that you're getting the most up-to-date and relevant jobs.
- We're the only job board *for* software engineers, *by* software engineers… in case you needed a reminder! We add thousands of new jobs daily and offer powerful search filters just for you. 🛠️
- Every single hour! We add 2,000-3,000 new jobs daily, so you'll always have fresh opportunities. 🚀
- Typically, job searches take 3-6 months. EchoJobs helps you spend more time applying and less time hunting. 🎯
- Check daily! We're always updating with new jobs. Set up job alerts for even quicker access. 📅
What Fellow Engineers Say