Senior Consultant, Data Engineering & Analytics

The role

You will design and build data platforms and end-to-end data pipelines for investment firms. This role involves architecting data warehouses, developing quantitative tools, and providing technical leadership for client engagements.

What you will do

• Lead the design and implementation of scalable data platforms and end-to-end data pipelines
• Develop and optimize production-grade code 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
• Collaborate with client investment teams to translate requirements into automated tools and data products
• Provide technical and project leadership across engagements
• Understand client business context to ensure technical solutions solve real problems

Required qualifications

• 7+ years of hands-on experience in a technical or analytical role (Quant, Quant Dev, Data Scientist, or Data Engineer)
• Prior experience at hedge funds, fintech firms/startups, market makers, or top-tier asset management firms
• Demonstrated project leadership, ideally overseeing technical delivery from inception to production
• Proficiency in Python (Pandas, NumPy, Scikit-learn)
• 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

Nice to have

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

Benefits

• 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

About the company

Castleton Tower is a boutique consulting firm founded by executives from top-tier hedge funds and asset managers. They work with investment management firms to modernize data infrastructure and build AI-ready foundations.