M&A Integration Systems Analyst

Role Summary

The M&A Integration Systems Analyst is the analytical engine behind Meriton's acquisition integration process. This role builds and maintains per-employee transition impact models, quantifying the financial and experiential changes resulting from healthcare premiums, PTO, holiday schedules, and other benefits.

Key Responsibilities

• Build and maintain a per-employee transition impact model for every acquisition, capturing financial and experiential deltas.
• Produce aggregate impact summaries, including total cost shifts, benefit wins, and areas of concern.
• Identify individual outliers and flag employees experiencing significant negative financial impacts.
• Create clear, decision-ready formats such as charts, comparison tables, and summary dashboards.
• Update impact models as integration decisions are finalized.
• Collect, validate, and normalize employee data from acquired companies.
• Build and maintain standardized intake templates and produce import-ready files for ExponentHR onboarding loads.
• Maintain integration mapping workbooks across all active acquisitions, ensuring alignment with Meriton's job architecture and pay structures.
• Own and maintain QA, reconciliation, and controls processes, including data validation, post-load HRIS checks, first-payroll variance reconciliations, deduction audits, and PTO balance audits.
• Track defects and root causes to closure, applying lessons learned to improve templates and processes for future acquisitions.
• Manage per-acquisition integration scorecards, tracking readiness, mapping completion, QA status, open risks, and milestone progress.
• Contribute structured data to Power BI reporting for the Director's executive dashboard.

Qualifications

• 4+ years in HR analytics, compensation analysis, total rewards, HRIS, or a comparable data-intensive HR operations role.
• Advanced Excel proficiency: complex modeling, scenario analysis, conditional logic, pivot tables, and structured mapping.
• Demonstrated ability to build employee-level financial models that translate program differences into individual and aggregate dollar impacts.
• Strong written communication skills for translating model outputs into clear narratives and risk flags.
• Demonstrated ability to manage sensitive employee data with precision and strict confidentiality.
• Proficiency with Microsoft 365: Excel, Teams, SharePoint, OneDrive; Power BI experience strongly preferred.

PREFERRED EXPERIENCE

• Experience in total rewards analysis, benefits benchmarking, or compensation modeling across company transitions.
• Experience supporting HRIS implementations or integrations; ExponentHR experience is a strong plus.
• Familiarity with benefits plan structures (medical, PTO, leave, HSA/FSA) and how they translate to employee cost.
• Exposure to M&A integration, multi-company HR environments, or acquisitive organizations.
• Experience with Power BI, Tableau, or comparable data visualization tools.