Castleton Tower

Senior Consultant, AI & Data Engineering

New York City · Senior

Sponsorship not specified$250k-$500kDetected 85 days ago
PythonFull-Stack DevelopmentSQLSnowflakeDatabricksAWSGCPAzureCloud Platformsscikit-learnPandasNumPySparkAirflowdbtData EngineeringData ScienceFinancial AnalysisAccountingResearchLeadershipMentoring

About the role

  • This role emphasizes hands-on engineering while maintaining strategic client engagement.

Responsibilities

  • 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.
  • Lead full-scope projects from architecture design to production deployment
  • Strategic Impact: Lead full-scope projects from architecture design to production deployment
  • 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
  • Collaborate with client investment teams to translate investment process requirements into robust, automated tools and data products

Requirements

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

Nice to have

  • 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

Skills

  • No armies of junior consultants learning on your dime.
  • Our engagements blend high-level strategy with hands-on technical implementation.
  • 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

Compensation

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

Benefits

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

Company info

  • 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're looking for a technical leader who can design and build data platforms for investment firms.
Apply directly at Castleton Tower →Create a free account for alerts like thisView Castleton Tower immigration profile

This listing is sourced directly from Castleton Tower's careers page and normalized into a canonical job model.