Private Markets Operations Specialist

Why Work at Mercer Advisors? For more than 40 years, Mercer Advisors has been helping families amplify and simplify their financial lives by integrating financial planning, investment management, business management, tax, estate, insurance, and more, all managed by a single team. We deliver the kind of comprehensive care once reserved for only the wealthiest households.

S. * Mercer Advisors offers a workplace that stands apart in the financial industry. More than half of our employees and client-facing professionals are women, reflecting the clients we serve.

With a flexible, national footprint, we build our teams around exceptional talent — wherever they are. Join us and help families amplify and simplify their financial lives with confidence. * Mercer Advisors was ranked #1 for RIA firms with up to $70 billion in assets.

The Barron’s top RIA ranking is based on a combination of metrics – including size, growth, service quality, technology, succession planning and others. No fee was paid for participation in the ranking, however, Mercer Advisors has paid a fee to Barron’s to use the ranking in marketing. Please see important information about the ranking criteria methodology here .

Job Summary: The Private Market Operations Specialist is responsible for ensuring data integrity, reporting accuracy, and operational continuity across Private Investment Services systems—primarily Orion and Arch. This role owns the data feed between various alternative reporting systems and Orion, ensures private investment positions are correctly reflected in all reporting environments, and supports onboarding of new private investment accounts for both organic clients and M A-acquired firms. Essential Job Functions for this role include: Ensure accurate private investment reporting in Orion, including positions, transactions, valuations, and performance.

Own and manage the Arch → Orion data feed, validating that all private investment data flows correctly. Monitor daily data exceptions and reconciliation reports, resolving breaks across Arch, Orion, and custodial records. Troubleshoot data mapping issues, valuation discrepancies, and performance calculation errors with internal teams and vendors.

Assist with the private investment portion of M A onboarding, including data migration, position setup, and historical mapping. Review and convert legacy spreadsheets or systems from acquired firms into Arch and Orion. Support processing and validation of capital calls, distributions, and periodic valuations as needed.

Maintain documentation for reporting standards, system workflows, and data processes. Collaborate with Technology, Data Engineering, Reporting, and Operations teams to ensure data integrity and system stability. Communicate clearly with advisors and internal stakeholders regarding reporting status, data issues, and resolutions.

Other duties as needed Knowledge, Skills, and Abilities: 3–5 years of experience in investment operations, data operations, portfolio accounting, or alternative investments. Strong understanding of Orion (or similar reporting systems), including reconciliation, data mapping, and performance reporting. Working knowledge of private market investments, including capital calls, distributions, valuations, and fund statements.

Experience managing or troubleshooting data feeds between financial systems and resolving data discrepancies. Ability to interpret custodial records, investment statements, and fund documentation with a high level of accuracy. Advanced analytical and problem‑solving skills, with strong attention to detail and proficiency in Excel.