Data Engineer

MIO Partners, Inc. (MIO) provides proprietary investment products to McKinsey’s retirement plan and partners and offers independent, high-quality financial advice to McKinsey’s partners. We manage a wide array of investment vehicles with significant expertise and a long and successful track record in alternative strategies, including hedge funds and private equity. We have a multibillion-dollar portfolio of assets under management, and we manage assets for and advise only McKinsey-related clients; we do not accept outside or third-party investments.  

MIO is a values-based organization that is strongly aligned with our investors’ interests. MIO measures success as performance relative to a market-based benchmark.  

MIO, a 250+ person registered investment adviser, provides ample opportunities for somebody with an entrepreneurial drive to shine. We strive to meet the highest professional standards and build an organization that attracts, develops, and retains exceptional people. MIO is a wholly owned subsidiary of McKinsey, but our activities are kept entirely separate from those of the consulting Firm. 

Position

MIO’s IT team seeks a Data Engineer with deep understanding of large-scale data handling and processing best practices in a cloud native environment, building scalable systems. This individual will work closely with data/software engineers, architects, business users, and other stakeholders to design and implement data solutions, including databases, data warehouses, and data models that meet organizational needs, define data standards, and implement a data governance process. This role is critical to enable efficient data analytics for informed decision-making that supports the organization's overall business needs. The Data Engineer will also be expected to work collaboratively with others in IT to realize the full life cycle of system development projects, from requirements gathering to application design, data modeling, coding, testing, delivery, support, and enhancements.

Primary responsibilities

The successful candidate will have extensive technical experience working for financial services firms, such as asset managers, hedge funds, and/or broker/dealers.

The new hire must lead by example and work collaboratively to:

• Help Data Management team to drive the successful execution of annual OKR commitments, ensuring alignment with business objectives and optimizing data processes for measurable impact.
• Work closely with external data management partners to onboard MIO’s use cases.
• Help organize MIO’s data assets for up-and-coming technologies such as GenAI.
• Define data governance policies and oversee implementation, including any external data management platforms, to ensure data quality, accuracy, and consistency.
• Develop and implement data ingestion, transformation, and synchronization processes between in-house systems and external platforms.
• Work with data scientists, engineers, business users, and other stakeholders to understand their data needs and ensure solutions align with business goals.
• Build Data Administration automation tools/methods.
• Maintain detailed documentation for data architecture, flows, and system configurations.
• Raise the bar on our development capabilities, standards, and processes.
• Synthesize requirements gathered from various teams within/outside of IT and suggest creative solutions; where appropriate, guiding MIO to “do it the right way”
• Following a scrum methodology, organize with end users, business analysts, and other architects and developers.
• Recommend positive steps toward standardizing development processes, including technology selection, deployment steps, code reviews, and IT tools.
• Partner with platform engineering, QA, and operations teams to promote standardization, consistency, and improved security posture.

Our applications are primarily developed using Python/Django and libraries such as Pandas, NumPy, PL/SQL. In addition, we utilize SQL Server, MySQL, Elastic Search, Redis, Kafka, Tableau, and various third-party APIs and data sources.

Primary responsibilities estimated percentage allocation

• 10% Technology Leadership: design, mentoring.
• 10% Relationship Building: requirements gathering, brainstorming with end users.
• 80% Heads Down Development

Attributes of the successful candidate

The successful candidate would exhibit the following behaviors, values, and attributes:

• Driven by ownership. People with an ownership mindset don’t just complete tasks—they take full responsibility for outcomes. They step in to fix issues beyond their direct remit, foster collaboration, and push for excellence. They don’t point fingers; they analyze failures and work to prevent them. True owners proactively develop their skills and drive impact, ensuring the whole team succeeds.
• Strives for excellence. The best people set a high bar instinctively—they never settle for anything less than excellence. They deliver impact without over-engineering, take initiative where others hesitate, and build high-caliber networks to stay ahead. They spot overlooked issues, reframe obstacles into opportunities, and follow through relentlessly. When others stop, they find another way. Their drive isn’t about external validation but delivering exceptional results every time.
• Fueled by curiosity. The best people ask plenty of good questions—they challenge assumptions, seek deeper understanding, and explore beyond their domain. Their curiosity fuels continuous learning, helping them uncover insights others miss. They do not just grow themselves; they elevate those around them by sharing knowledge and pushing for better answers. For them, improvement is not a task—it’s a mindset.
• Problem-solving excellence. Exceptional problem solvers define problems clearly, breaking down complex challenges into manageable components using structured methodologies like issue trees and the MECE principle. They prioritize issues, develop testable hypotheses, and create detailed work plans with timelines. Their structured approach ensures they address root causes, not just symptoms. They move swiftly, with a strong bias for action, yet thoughtfully, balancing efficiency with thoroughness to deliver impactful solutions.
• Client service orientation. MIO’s ultimate clients are our investors; producing returns is our mission. Our IT team plays a critical role in enabling that mission by deeply understanding the needs of the investment team and other key functions. The best IT professionals do not just respond to requests—they put themselves in the business user’s shoes and truly grasp what drives decisions. They anticipate needs, develop high-impact solutions, and apply critical judgment, ensuring their work adds value while avoiding unnecessary complexity or cost. A successful IT person works tirelessly to understand and cater to their business needs.

Desired background

• At least 3+ years of hands-on experience in one or more of the following areas: data strategy, data architecture, (modern) data platform architecture, data modeling, data governance, business Intelligence, Big Data, reporting & data warehousing, AI, and Machine Learning.
• A minimum of 2 years of hands-on experience in developing/maintaining large-scale Python-based applications
• Bachelor of science in computer science or other related discipline (although strong experience with a less directly related degree will be considered)
• Experience with relational (e.g., SQL Server, MySQL, Oracle) and non-relational databases (e.g., NoSQL, MongoDB)
• Strong understanding of Cloud technologies (preferably AWS)
• Good understanding of the different data architecture patterns: data warehouse, data marts, data modeling, ontologies, etc.
• Design and development experience with data and analytics-intensive applications using Pandas and NumPy libraries is highly desired.
• Ability to write high-performing SQL queries, procs, tables, and views.
• Familiar with general ETL design and development
• Good intuition for end-user requirements gathering; iterative and collaborative approach to design.
• Practical understanding of design patterns and experience in system design
• Ability to lead a development team.
• Strong client relationship management skills and excellent written/verbal communication skills to interact at all levels.

Initial success criteria

The successful candidate will be expected to hit the ground running, working on hands-on projects, and simultaneously contributing to MIO’s data strategy standards and best practices.  During the first six months, the Data Engineer will have learned enough about MIO’s business, processes, and applications that they should have accomplished the following:

• Owned some key projects and data-intensive systems that are being built to establish MIO’s data standards and best practices
• Made hands-on contributions to the progress of the project portfolio
• Forged solid relationships with key partners, and developed a vocabulary that demonstrates a strong understanding of our products and services

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.