Data Platform Engineer

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

Benefits offered by this job

Training and development opportunities

Robust wellness resources

Gym reimbursement

Job summary

An investment management firm in New York is looking for a motivated technologist to join their Data Platform Team. The role involves building core database technologies and automation frameworks to support innovative investment strategies. Candidates should have over 3 years of experience in the financial sector, strong SQL Server skills, and familiarity with automation frameworks. Benefits include training opportunities and a competitive salary range of $145,000 to $175,000, alongside performance incentives.

Qualifications

• 3+ years of professional experience in the financial sector.
• Experience in enterprise database technologies.
• Ability to analyze execution plans and manage indexing strategies.

Responsibilities

• Build and maintain core database technologies.
• Design resilient, secure, and high-performance systems.
• Shape the firm's next-generation data platform.

Skills

Proficiency in Microsoft SQL Server

Development with SQL, PowerShell, Python

Database performance tuning and optimization

Version control and CI/CD using Git

Communication skills

Tools

Prometheus

Grafana

Jenkins

Azure DevOps

GitHub Actions

Kubernetes

Job description

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.

Qualifications

• 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

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

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

Applicable base salary range: $145,000‑$175,000 USD. This is supplemented by performance‑based incentives and an annual incentive plan.

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.