Data Analyst

Data Analyst at WTW

The North America Data Analyst plays a critical role in ensuring the accurate, timely, and compliant delivery of payroll across the United States, Canada, and Puerto Rico. This role partners closely with Payroll Operations, HR, Finance, and external vendors to support payroll processing, reporting, reconciliations, and continuous improvement initiatives. The ideal candidate brings analytical capability and a customer-focused mindset within a complex, multi-jurisdiction environment; some payroll knowledge preferred. This is a fully remote and full-time opportunity open to candidates located across the US.

The Role

• Support end-to-end payroll activities for North America, ensuring accuracy and timeliness.
• Review and validate data input by Analytics Team.
• Monitor and assist with various payroll discrepancies.
• Import and analyze data files from various internal/external sources.

Analysis, Reporting & Reconciliation

• Prepare and analyze payroll reports, reconciliations, variance analyses et all.
• Support year-end activities.
• Identify trends, risks, and improvement opportunities using payroll data.

Stakeholder & Vendor Partnership

• Serve as a key point of contact for payroll-related inquiries escalated from Service Now or internal partners.
• Collaborate with HR, Benefits, HRIT teams to resolve complex payroll issues.
• Liaise with payroll vendors (e.g., ADP) to support system updates, issue resolution, and enhancements.

Process Improvement & Projects

• Contribute to payroll standardization and improvement initiatives.
• Support payroll system changes, testing, and implementations, including enhancements and regulatory updates.
• Document payroll processes and controls to support operational consistency.

The Requirements

• 3-5 years of Data Analytics experience supporting multi-state U.S. payroll; Canada experience preferred.
• Strong analytical skills with the ability to interpret and explain payroll data.
• Experience with payroll systems (ADP Workforce Now and/or Vantage preferred).
• Proficiency in Alteryx, Microsoft Excel, and other Microsoft Office applications.
• High attention to detail and commitment to data accuracy.
• Strong problem-solving and root-cause analysis skills.
• Ability to manage multiple priorities in a deadline-driven environment.
• Clear, professional communication skills with a strong customer service orientation.
• Comfort working cross-functionally and adapting to change.

Compensation and Benefits

Base salary range and benefits information for this position are being included in accordance with requirements of various state/local pay transparency legislation. Please note that salaries may vary for different individuals in the same role based on several factors, including but not limited to location of the role, individual competencies, education/professional certifications, qualifications/experience, performance in the role and potential for revenue generation (Producer roles only). The base salary compensation range being offered for this role is $80,000.00-$85,000.00 USD annually. This role is also eligible for an annual short-term incentive bonus.

WTW provides a competitive benefit package which includes the following (eligibility requirements apply):

• Health and Welfare: Mental health/emotional wellbeing (including Employee Assistance Program), medical (including prescription drug coverage and fertility benefits), dental, vision, Health Savings Account, Commuter Accounts, Health Care and Dependent Care Flexible Spending Accounts, company-paid life insurance, supplemental life insurance, AD&D, group accident, group critical illness, group legal, identity theft protection, wellbeing program, adoption assistance, surrogacy assistance, auto/home insurance, pet insurance, and other work/life resources.
• Leave Benefits: Paid Holidays, Annual Paid Time Off (includes state/local paid leave where required), Short-Term Disability, Long-Term Disability, Other Leaves (e.g., Bereavement, FMLA, ADA, Jury Duty, Military Leave, and Parental and Adoption Leave), Paid Time Off (only included for Washington roles).
• Retirement Benefits: Qualified contributory pension plan (if eligible) and 401(k) plan with annual nonelective company contribution. Non-qualified retirement plans available to senior level colleagues who satisfy the plans’ eligibility requirements.

Key skills/competency

• Data Analysis
• Payroll Processing
• Data Validation
• Financial Reporting
• Reconciliation
• Vendor Management
• Process Improvement
• Alteryx Proficiency
• Microsoft Excel
• Problem Solving