Castleton Tower

Director / Senior Director, AI & Data Engineering

Northeast US · Director

Sponsorship not specifiedDetected 70 days ago
PythonCode ReviewGitSQLSnowflakeDatabricksAWSAzureCloud PlatformsAirflowdbtData EngineeringData ScienceData VisualizationAccountingResearchLeadership

About the role

  • This is not a narrow individual-contributor engineering role.
  • The right person can still get close to the code, but their broader mandate is to turn fragmented data, tooling, and process into a scalable operating model for an investment organization.
  • AI-enabled engineering: Use modern AI development tooling, including tools such as Claude Code, OpenAI Codex, Cursor, GitHub Copilot, and Databricks AI capabilities, to accelerate delivery without compromising quality, controls, or maintainability.

Responsibilities

  • Design and implement the data team structure, hiring plan, delivery model, and long-term technical roadmap.
  • Set engineering standards for code review, testing, documentation, observability, data quality, and production support.
  • Manage internal team members, contractors, vendors, and implementation partners where appropriate.
  • Build a culture of ownership, technical rigor, and pragmatic delivery.
  • Architect and build scalable data platforms across warehouse, lakehouse, orchestration, transformation, and BI layers.
  • Develop data models and applications that support portfolio analytics, investment operations, risk reporting, finance, and executive reporting.
  • Create durable pipelines and controls for high-value investment and operational datasets.
  • Design human-in-the-loop processes for AI-generated code, analysis, and operational outputs.
  • We work exclusively with investment management firms, including asset allocators, asset managers, hedge funds, family offices, and RIAs, helping them modernize data infrastructure and build AI-ready foundations.

Requirements

  • 10+ years of progressive experience in data engineering, analytics engineering, data platforms, or technical data leadership.
  • 3+ years managing engineers, analytics engineers, data platform teams, or cross-functional technical delivery teams.
  • Ability to communicate clearly with senior non-technical stakeholders and translate business needs into durable technical systems.
  • Experience in investment management, asset allocation, hedge funds, private markets, family offices, RIAs, fintech, or financial data products.
  • Experience with portfolio analytics, manager research, risk reporting, investment operations, fund accounting, or performance reporting datasets.
  • Help the organization build the data and governance foundation required for responsible AI adoption.
  • Proven ability to design and build production data platforms using Python, SQL, modern warehouse/lakehouse technologies, and orchestration tools.
  • Strong architectural judgment across data modeling, governance, quality, observability, security, and operational resilience.
  • Practical fluency with AI-assisted development tools such as Claude Code, OpenAI Codex, Cursor, GitHub Copilot, or similar systems.
  • Executive presence, high ownership, and comfort operating in ambiguous environments.
  • Experience building or modernizing data teams in a high-expectation investment, finance, or institutional environment.
  • Hands-on exposure to Snowflake, Databricks, dbt, Dagster, Airflow, AWS, Azure, Sigma, Tableau, Looker, or similar tooling.
  • Experience evaluating vendors and implementation partners, including build-versus-buy decisions.

Skills

  • Evaluate and rationalize tooling across Snowflake, Databricks, dbt, Dagster/Airflow, cloud infrastructure, BI, and internal applications.

Compensation

  • Competitive total compensation commensurate with experience.

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.

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