Job Description

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.

Our Company

Founded in 1956, Williams-Sonoma, Inc. is the premier specialty retailer of high-quality products for the kitchen and home in the United States. Our family of brands are Williams Sonoma, Williams Sonoma Home, Pottery Barn, Pottery Barn Kids, Pottery Barn Teen, Rejuvenation, West Elm, Mark & Graham, Outward, and GreenRow. These brands are among the best known and most respected in the industry. We offer beautifully-designed, stylish and functional products for every area of the home, including the kitchen, living room, bedroom, home office, closet, laundry room and even outdoor spaces. We've seen some big changes since our first brick-and-mortar store opened more than half of a century ago. What hasn't changed is our passion for high-quality products, functional design, outstanding customer service, and enhancing the lives of our customers and the communities where we operate. Today, we're a multi-brand, multi-channel, global enterprise supported by state-of-the-art technology and some of the most talented teams in retailing - and we're always looking for new energy and ideas.