Data Engineer, Market Data

MIO Partners | Investment management

2h 8m ago

Hybrid

Full Time

United States of America

$160k USD/yr

Title: Data Engineer, Market Data Location: New York

MIO Partners Inc. (MIO) is a global, world-class investment and advisory institution with a decades-long track record of performance for our clients through multiple market cycles. Our team of approximately 250 people provides asset management and advisory services to current and former McKinsey employees. We manage more than $20 billion in assets across public and private markets. We are headquartered in New York City, with offices in Atlanta, Georgia; West Palm Beach, Florida; Germany; Hong Kong; Singapore; Spain; and the UK.

We provide objective advice on long-term wealth building and create distinctive investment products that deliver value relative to market-based benchmarks. We operate two core lines of business: (i) our advisory team provides advice, wealth planning, and retirement services to approximately 2500 individual clients, and (ii) our investments business consists of alpha-seeking alternative investment strategies across public and private markets.

A defining characteristic of our business is our perfect alignment with our clients. Our extraordinary mandate as a boutique investment and advisory firm, grounded in a core set of principles, enables us to create unique products and services while keeping our clients’ interests front and center.

Much of our success can be attributed to our insatiable intellectual curiosity. We seek to hire individuals who are passionate about our mission and values, and who always strive toward excellence. We care about fostering a culture of continual improvement, as individuals and as an organization, and are excited to work with individuals who have a similar growth mindset. We are proud to have a culture that promotes the highest ethical standards and investor-focused values, alongside a commitment to diversity and inclusivity and a highly collaborative work environment.

MIO (and related entities) is an independent, indirect, and wholly owned subsidiary of McKinsey & Company.

Position

MIO is seeking a Data Engineer to join our Research & Investment Technology team and help build and scale our market data platform. This is an opportunity for an early- to mid-level professional to deepen their expertise at the intersection of data engineering and financial markets.

In this role, you will work alongside experienced engineers and architects to ingest, transform, and ensure the quality of market data from leading providers such as Bloomberg, LSEG, and ICE. You will gain hands-on experience with modern data pipelines, cloud-based infrastructure, and the complexities of financial datasets, while building a strong foundation in scalable data systems that support research and trading workflows.

Primary responsibilities

Data Pipeline Development
- Build and maintain ETL/ELT pipelines for market and reference data
- Support data ingestion, transformation, and loading across systems
- Monitor pipeline performance and troubleshoot issues under guidance
Data Modeling: Analyze vendor datasets across asset classes and map them to the MIO canonical data model
Vendor Integration: Integrate data from providers such as Bloomberg and Refinitiv; normalize and standardize datasets for firmwide use
Stakeholder Collaboration: Partner with Portfolio Managers and Analysts to deliver reliable, bespoke data solutions for research and trading
System Architecture: Contribute to the design and evolution of scalable data architectures using modern frameworks and cloud services
Infrastructure Management: Manage and optimize data infrastructure, including Aurora SQL and NoSQL databases (e.g., Redshift); support the evolution of scalable storage solutions
Data Management and Operations: Monitor platform health, manage alerts, and resolve production issues within defined SLAs
Data Quality and Governance: Implement data quality checks and controls to ensure accuracy, consistency, and reliability across datasets
Cost Review and Optimization: Review our data usage, infrastructure, and vendor spend; identify opportunities to improve efficiency and align with budget

Required skills & qualifications

Bachelor’s or master’s in computer science, engineering, or a related quantitative field
5+ years of experience working with financial datasets, preferably in buy-side (hedge fund) or capital markets environments, including renowned data providers such as Bloomberg, ICE, or LSEG
Strong programming skills in Python and SQL; experience building and maintaining ETL/ELT pipelines working with orchestration tools is preferred
Hands-on experience with AWS, including services such as S3, Aurora, Athena, Redshift, and Lambda
Experience with CI/CD practices and AWS-native tooling
Familiarity with data governance, lineage, and data quality frameworks
Solid understanding of financial data concepts, including market data, security masters, time-series data, and reference data across asset classes (e.g., commodities, fixed income, FX, digital asset, etc.)

Applicants must be authorized to work in the U.S. without the need for employer-sponsored work authorization, now or in the future.

MIO has adopted a flexible, hybrid model that supports a blend of in-office and remote work. Our office is in New York City.

Certain US states require MIO Partners, Inc. to include a reasonable estimate of the salary range for this role. Actual salaries may vary and may be above or below the range based on various factors, including, but not limited to an individual’s assigned office location, experience, and expertise. Certain roles are also eligible for bonuses, subject to MIO’s discretion and based on factors such as individual and/or organizational performance. Additionally, MIO offers a comprehensive benefits package, including medical, dental and vision coverage, telemedicine services, life, accident and disability insurance, parental leave and family planning benefits, caregiving resources, a generous retirement program, financial guidance, and paid time off.

Base salary range

$160,000—$160,000 USD

MIO Partners, Inc. (MIO) is an equal opportunity employer. MIO will consider all applicants regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, veteran status, or disability status.

We are committed to protecting your privacy. Please review our Applicant Privacy Policy for a detailed explanation of how we collect, use, and protect your personal information.

Required Skills

pythonsqlawsredshiftlambdas3

Required Languages

🇬🇧 English