Data Engineer, Market Data

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

• 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.)