Database Platform Engineer

Capstone Investment Advisors; New York (NY); On-site; USD 145,000 - 175,000; Full time

Benefits offered by this job

Training & development

Wellness resources

Time-off & retirement

Gym reimbursement

Job summary

Capstone Investment Advisors seeks a data platform engineer to build and maintain core database technologies and automation. You will help shape Capstone’s next‑generation data platform, delivering high‑performance, secure data solutions for trading and analytics.

You bring 3+ years in finance tech, MSSQL mastery, and automation via SQL, PowerShell, and Python, plus IaC and CI/CD experience. This NYC role offers competitive base pay and growth within a collaborative team.

Qualifications

• 3+ years of professional experience in financial technology or derivatives trading environments.
• Proficiency in MSSQL and enterprise database technologies.
• Experience with SQL, PowerShell and Python for automation.
• IaC mindset with scripting for repeatable deployments.
• Experience with performance tuning, indexing, and query troubleshooting.
• Database design, normalization, constraints and versioning.
• Git workflows and automated deployments (Jenkins, Azure DevOps, or GitHub Actions).
• Monitoring with open‑source tools (Prometheus, Grafana).
• Excellent written and verbal communication.

Responsibilities

• Build and maintain core database technologies and automation frameworks.
• Shape Capstone’s next‑generation data platform and ensure security/performance.
• Collaborate with teams firm‑wide to enable scalable data solutions.

Skills

MSSQL

SQL Development

PowerShell

Python

IaC

CI/CD

Query optimization

Database design

Git workflows

Prometheus Grafana

Communication

Tools

Jenkins

Azure DevOps

GitHub Actions

Kubernetes

Job description

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

Capstone is a global, alternative investment management firm operating across a broad range of derivatives-based strategies with a deep understanding of volatility. With approximately $14.6 billion of AUM and 315 employees (as of September 1, 2026, Capstone was formed in 2007 and is headquartered in New York with offices in London, Amsterdam, Tokyo, California, Stamford, Boston, and Milan.

At Capstone, we constantly aim to expand our view of how WE SEE THE WORLD DIFFERENTLY® in order to create opportunity. Our commitment to provoking the evolution of asset management provides us with a perpetual hunger for knowledge that we believe drives the improvement of our particular approach to investment. We seek to harness the complexities of global derivatives markets with disciplined strategic insight, an experienced, accomplished team and advanced technology to create sustainable value. We’ve created a particular approach to investment that we believe drives continuous improvement and opportunities for our clients, team and industry.

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, location, certifications, education, and any applicable minimum wage requirements. Decisions will be determined on a case‑by‑case basis. In addition to the base salary, this position may be eligible for performance‑based incentives.

In addition to base compensation, this role is eligible for an annual incentive plan. To learn even more about being part of the team, visit us online: Careers - Capstone (capstoneco.com)

Don’t forget to follow us on LinkedIn

Capstone’s Commitment

At Capstone, we value a diverse, equitable, and inclusive workplace where all employees feel appreciated and respected. Our commitment to a nondiscriminatory approach extends equal opportunities for employment and advancement across our programs, departments, and locations. We actively seek and appreciate a variety of life experiences and heritages and advocate for the amplification of all voices. At Capstone, we're all about creating a workplace where you can thrive and make a real impact. We value innovation, teamwork, trust, and discipline, and we know you do too.

Experimentation:

We love fresh ideas and encourage you to try new things. Here, you’ll have the freedom to innovate and help shape our strategies.

Collaboration:

We’re big on teamwork. You'll join a supportive community where everyone’s input matters, and we learn from each other every day.

Trust:

We believe in building strong, honest relationships. You'll be part of an environment where your contributions are respected and integrity is key.

Discipline:

In our fast‑paced world, staying focused is crucial. We commit to high standards and a disciplined approach, helping you grow both personally and professionally.

Be part of a team that values your creativity and dedication. Together, let's push boundaries and achieve great things.

Equal Opportunity Employer

Capstone is committed to creating an inclusive environment where we welcome people of different backgrounds. Capstone considers applications for employment without regard to all applicable protected characteristics, including race, color, religion, ethnicity, national origin, gender, sexual orientation, gender identity or expression, age, parental status, veteran status, or disability status.