Data Platform Engineer

We see the world differently at Capstone Investment Advisors. You will, too.

Capstone Investment Advisors, LLC (“Capstone”) is a global asset manager, dedicated to exploring alpha opportunities in derivatives and complementary strategies that persist across market cycles. With approximately $11.8 billion of AUM (as of November 1, 2025) and 326 employees, Capstone is headquartered in New York with offices in London, Amsterdam, Stamford, Los Angeles, Boston, Tokyo, Milan, Texas, and Maryland. Since 2004, through strategic insight, market-leading expertise, and advanced technology, we have sought to anticipate and harness the complexities of world markets, creating unique opportunities for our clients, team, and industry.

With our sophisticated, global client base, we recognize that our success is deeply connected to real people. For that reason, we take a human approach to everything we do, focusing largely on collaborative performance. Our workflow and process are built around the belief that by sharing ideas, we achieve greater outcomes. This gives you greater access to resources, direct exposure to senior leadership, and new opportunities to experiment and innovate.

The Team

The Data Platform Team builds and maintains the core database technologies and automation frameworks that power Capstone’s cutting-edge investment strategies. Our mission is to build a highly automated, self-service platform that enables teams across the firm to innovate at scale.

We are looking for a motivated technologist who thrives on solving complex challenges and designing resilient, secure, and high-performance systems. You will play a key role in shaping the firm’s next-generation data platform, with opportunities to learn advanced technologies and contribute to mission-critical systems. This role offers exceptional exposure to diverse areas of the hedge fund, providing opportunities to influence critical systems and deliver impactful solutions.

Our future colleague has these skills:

• 3+ years of professional experience, ideally within the financial sector (equity, credit, derivatives trading environments)
• Engineering experience in enterprise database technologies, with strong proficiency in Microsoft SQL Server (MSSQL)
• Development experience across multiple languages (SQL, PowerShell, Python) for solving complex problems and building automation
• Automation-first mindset, including experience with Infrastructure as Code (IaC) and scripting for repeatable deployments
• Database performance tuning and optimization: ability to analyze execution plans, manage indexing strategies, and troubleshoot query bottlenecks
• Database design and modelling fundamentals: normalization, constraints, transactions, and schema versioning
• Version control and CI/CD experience: Git workflows and automated deployments using tools such as Jenkins, Azure DevOps, or GitHub Actions
• Leverage open-source monitoring tools (e.g., Prometheus, Grafana) for performance and health checks
• Excellent verbal and written communication skills for collaboration and documentation

Do you possess these Bonus Skills:

• Experience with Apache Iceberg on object storage (S3) and engines like Spark/Trino.
• Exposure to multiple database platforms such as PostgreSQL, Snowflake, Amazon Redshift, MongoDB, Cassandra, etc.
• Exposure to distributed data platforms (Kafka)
• Familiarity with enterprise infrastructure (storage, networking, compute), Linux administration (Red Hat) and Windows Server.
• Exposure to Kubernetes

Benefits & Compensation Information:

Our team is our most important asset and investment. We value and respect our colleagues and their well-being inside and outside the workplace and our culture reflects this. We offer a robust and competitive benefits program to ensure the well-being of our colleagues.

Some benefits included in this role are:

• Training and development opportunities
• Robust Wellness Resources: Physical, Mental and Financial
• Time-Off, Retirement and Commuter Benefits
• Gym Reimbursement and other Discounts

The applicable base salary range for this role is $145,000-$175,000 USD. The base pay offered will be determined on factors such as experience, skills, training, l