Jobs · Engineering · California

Senior Analyst, Data Engineering & Investment Analytics

Castleton Tower Consulting, LLC · San Francisco, CA · 2 mo ago
HybridEngineeringFull-time

About the role

We're looking for someone who lives at the intersection of data engineering and investment analytics. You'll be equally comfortable building a production data pipeline in Python and presenting portfolio analytics insights to a CIO.

Responsibilities

  • Partner with investment professionals (PMs, CIOs, COOs, Heads of Operations) to understand their analytical needs and translate them into data products
  • Build customized dashboards, analytics tools, and quantitative investment applications
  • Present data-driven insights and recommendations to senior client stakeholders
  • Identify opportunities where better data infrastructure can improve investment processes
  • Design and implement scalable data platforms (data warehouses, data lakes) and end-to-end data pipelines for investment firms
  • Develop and optimize production-grade code (Python/SQL) for data transformation and financial analysis
  • Build and maintain data models that support portfolio analytics, risk reporting, and investment operations
  • Leverage AI-assisted development tools to accelerate delivery

Requirements

  • 5+ years of hands-on experience in a role that combined data/analytics engineering with business analysis or investment analytics
  • Prior experience within investment management, financial services, or firms that serve them (hedge funds, asset managers, fintech, financial consulting)
  • Proficiency in Python and advanced SQL for both data engineering and analytical work
  • Experience with modern data platforms (Snowflake, Databricks, or similar) and data modeling principles
  • Demonstrated ability to communicate technical concepts to non-technical investment professionals
  • Comfort working directly with senior clients and managing stakeholder expectations

Qualifications

  • Required: 5+ years of hands-on experience in a role that combined data/analytics engineering with business analysis or investment analytics
  • Required: Prior experience within investment management, financial services, or firms that serve them (hedge funds, asset managers, fintech, financial consulting)
  • Required: Proficiency in Python and advanced SQL for both data engineering and analytical work
  • Required: Experience with modern data platforms (Snowflake, Databricks, or similar) and data modeling principles
  • Valued: Demonstrated ability to communicate technical concepts to non-technical investment professionals
  • Valued: Comfort working directly with senior clients and managing stakeholder expectations

Benefits

This role offers a path to join a leading Bay Area-based asset allocator, with an anticipated transition by January 2027.

Similar jobs