Data Platform Engineer

Capstone Investment Advisors•New York, NY

1d•$145,000 - $175,000

About The Position

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:

Requirements

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

Nice To Haves

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