M&A HR Impact Modeling Analyst

Meriton; Irving (TX); On-site; USD 95,000 - 140,000; Full time

Job summary

Meriton is a national team of experts driving HVAC innovation through a network of high-performing companies. The M&A Integration Systems Analyst is the analytical engine behind Meriton’s acquisition integration process.

This role builds employee-level models to quantify how compensation and benefits change across acquisitions, covering healthcare premiums, PTO accruals, leave, and pay structures. You will collect and normalize data, map job titles to Meriton’s architecture, and produce QA

Qualifications

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

Responsibilities

• Build and maintain per-employee transition impact models across acquisitions.
• Capture financial and experiential delta for compensation and benefits.
• Produce aggregate cost shifts, benefits wins, and risk flags for leadership.
• Collect, validate, and normalize data from acquired companies; drive data readiness.
• Create import-ready files for HRIS onboarding and post-load QA.
• Own integration mapping: job titles, pay elements, deductions, PTO and holidays.
• Develop dashboards and scorecards for executives; support go/no-go decisions.

Skills

Data analysis

HR analytics

Data visualization

Written communication

Confidentiality

Advanced Excel

Tools

Excel

Power BI

Tableau

Teams

SharePoint

OneDrive

ExponentHR

Job description

Meriton is a national team of experts driving HVAC innovation through a network of high-performing companies. The M&A Integration Systems Analyst is the analytical engine behind Meriton’s acquisition integration process.

This role builds employee-level models to quantify how compensation and benefits change across acquisitions, covering healthcare premiums, PTO accruals, leave, and pay structures. You will collect and normalize data, map job titles to Meriton’s architecture, and produce QA