Skip to main contentA logo with &quat;the muse&quat; in dark blue text.

Data Architect

AT MIO Partners Inc.
MIO Partners Inc.

Data Architect

New York, NY

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.

Want more jobs like this?

Get jobs in New York, NY delivered to your inbox every week.

By signing up, you agree to our Terms of Service & Privacy Policy.


Position

MIO's Enterprise IT team seeks a Data Architect who will be responsible for developing and managing overall data architecture and strategy. This individual will work closely with data/software engineers, business users, and other stakeholders to design and implement data solutions, including databases, data warehouses, and data models that meet organizational needs. This role is critical to enable efficient data analytics for informed decision-making that supports the organization's overall business needs. The Data Architect 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:
  • Provide technical leadership and direction for data management projects that align with long-term business objectives
  • Help design a data infrastructure that supports complex data analytical services and is consistent with MIO's data system footprint
  • Contribute to thought leadership in build vs. buy decisions for data management solutions
  • Work closely with external data management partners to onboard MIO's use cases
  • 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
  • Evaluate new data technologies, tools, and best practices, advising on potential adoption.
  • Work with data scientists, engineers, business users, and other stakeholders to understand their data needs and ensure solutions align with business goals
  • 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 DevOps, QA, and AppSecOps 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
  • 15% Technology Leadership: design, mentoring, requirements gathering
  • 15% Relationship Building: requirements gathering, brainstorming with end users
  • 20% Team management/leadership
  • 50% 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 7+ 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.
  • 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.
  • Experience working closely with business leaders to identify business needs and data opportunities
  • Formal problem-solving and/or analytical training/experience a plus, as is experience working with management consultants
  • CFA or FRM a plus
  • 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, balancing short-term tactical needs and longer-term in-flight projects needed by business teams. During the first six months, the Data Architect will have learned enough about MIO's business, processes, and applications that they should have accomplished the following:
  • Led ongoing Proof of Concepts (POCs) with external partners as part of our strategic vision to enhance data management capabilities in Finance and Backoffice operations
  • Played a key role in the decision-making process for selecting the appropriate data management partner(s)
  • Gathered and documented finance and back-office reporting requirements while onboarding various accounting systems
  • Managed a team of junior/mid-level developers, taking responsibility for their productivity and code quality
  • 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
  • Begun to contribute to the broader MIO IT conversation, considering how our data architecture, systems architecture, and technology choices need to evolve to provide the best experience to our decision-makers
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

$225,000-$225,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.

Client-provided location(s): New York, NY, USA
Job ID: Mio_Partners-4681529008
Employment Type: Other

Perks and Benefits

  • Health and Wellness

    • Virtual Fitness Classes
  • Diversity and Inclusion

    • Employee Resource Groups (ERG)