Payroll Business Analyst

Job Summary

The Payroll Reporting Analyst supports payroll operations through advanced reporting, payroll system administration, and configuration management. This role combines payroll expertise with business intelligence (BI) reporting to ensure payroll accuracy, regulatory compliance, and efficient system functionality. The analyst will develop reporting solutions, manage payroll system configurations, review system interfaces, and support system changes and annual benefits enrollment activities.

Key Responsibilities

Payroll Reporting & Analytics

• Develop, maintain, and deliver payroll reports using advanced excel functions/macros, BI tools and payroll reporting platforms.
• Build and develop dashboards and analytical reports to support payroll operations, finance, HR, and compliance teams.
• Analyze payroll data to identify trends, discrepancies, and opportunities for process improvement.
• Support ad-hoc reporting requests from internal stakeholders.
• Ensure data accuracy and integrity between payroll systems and reporting tools.

Advanced Excel & Data Management

• Utilize advanced Excel capabilities including pivot tables, Power Query, complex formulas and macros to streamline payroll reporting and validation processes.
• Create automated validation tools to identify payroll discrepancies, tax issues, and data inconsistencies.
• Develop standardized payroll reporting templates and automation tools used across payroll operations.
• Manage large datasets from multiple systems and ensure data accuracy and integrity

Payroll System Administration

• Serve as a primary administrator for the payroll system, managing system configuration, maintenance, and ongoing operational support.
• Manage payroll configuration elements including earnings codes, deduction codes, PTO and accrual codes, benefit deductions and payroll policies and system parameters.
• Configure and maintain state and local tax codes in accordance with regulatory requirements.
• Maintain system tables, mappings, and configuration settings required for payroll processing.
• Document system configurations, procedures, and changes.

Payroll System Changes & Enhancements

• Support the implementation and testing of payroll system changes, upgrades, patches, and enhancements.
• Coordinate change management activities including testing, validation, and deployment of payroll system updates.
• Partner with HRIS, IT, and payroll teams to implement system improvements and new functionality.
• Perform system testing and validation to ensure payroll accuracy after system updates or configuration changes.

Interface & Data Integration Management

• Review, monitor, and troubleshoot payroll interfaces between HRIS, timekeeping, benefits, and other integrated systems.
• Investigate and resolve interface errors and data discrepancies.
• Partner with internal teams and external vendors to maintain and enhance system integrations.
• Conduct testing for interface updates and data integration changes.

Payroll Configuration & Setup

• Set up and maintain earnings codes, deduction codes, and PTO accrual and usage codes.
• Configure and maintain payroll tax settings including state, local, and special tax jurisdictions.
• Support payroll configuration for new entities, locations, or organizational changes.
• Ensure proper mapping of payroll elements across integrated systems.

Benefits Enrollment Support

• Support payroll activities related to annual benefits enrollment.
• Configure and update benefit deduction codes and payroll mappings during open enrollment periods.
• Test and validate benefit deduction changes to ensure accurate payroll processing.
• Partner with HR and Benefits teams to implement benefit plan updates within the payroll system.

Compliance & Process Improvement

• Ensure payroll configurations comply with federal, state, and local regulations.
• Support payroll audits and documentation requests.
• Identify opportunities to improve payroll reporting, automation, and system processes.
• Develop and maintain documentation for payroll system configuration, reporting tools, and operational procedures.

Qualifications Required

• Degree in Accounting, Finance, Human Resources, Information Systems, or related field.
• 3–5+ years of payroll systems, payroll reporting, or payroll analytics experience.
• Advanced expertise in Microsoft Excel, including:
  • Pivot tables and advanced formulas
  • Power Query
  • Macros and VBA automation
• Strong experience with payroll data analysis and reporting.
• Experience configuring payroll system components including earnings, deductions, PTO, and tax codes.
• Knowledge of payroll tax regulations including multi-state and local taxes.
• Strong analytical and problem-solving skills.

Preferred

• Strong Experience with payroll/HRIS platforms (e.g., UKG, and Kronos).
• Experience supporting open enrollment payroll configurations.

• Advanced experience with BI reporting tools such as Power BI or Tableau.

• Experience supporting payroll system implementations or major system upgrades

Advanced Excel and data analysis skills.

Our Culture & Values

We believe that taking care of our people is vital to our success and we strive to offer equitable and transparent practices for all. We prioritize connection, growth, and wellbeing.

People First

Putting People First means investing in overall well-being and opportunities to grow and advance within the organization. Depending on the position and location, here are a few highlights of what benefits may be available:

Benefits

• A generous discount on all WSI brands

• A 401(k) plan and other investment opportunities

• Paid vacations, holidays, and time off to volunteer

• Health benefits, dental and vision insurance, including same-sex domestic partner benefits

• Tax-free commuter benefits

• A wellness program that supports your physical, financial and emotional health
  

Continued Learning

• In-person and online learning opportunities through WSI University

• Cross-brand and cross-function career opportunities

• Resources for self-development

• Advisor (Mentor) program

• Career development workshops, learning programs, and speaker series
  

WSI will not now or in the future commence an immigration case or "sponsor" an individual for this position (for example, H-1B or other employment-based immigration).

This role is not eligible for relocation assistance.

Williams-Sonoma, Inc. is an Equal Opportunity Employer. Williams-Sonoma, Inc. will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of the San Francisco Fair Chance Ordinance, or other applicable state or local laws and ordinances.