Payroll Excel Analyst

Experience
and Skills Required -

•            
Expert -level proficiency in Microsoft Excel

•            
Demonstrated experience creating payroll calculation spreadsheets

•            
Strong understanding of:

o            
Payroll tax concepts

o            
Withholding calculations

o            
Gross -to -net payroll math

•            
Exceptional attention to detail and accuracy

•            
Ability to explain complex calculations in plain language

•            
Experience handling sensitive and confidential financial data

Full Job Description:

Microsoft
Excel expert with deep experience in payroll calculations and spreadsheet
automation. This role is responsible for designing, auditing,
and maintaining complex Excel spreadsheets used to calculate payroll,
including retroactive pay, tax withholdings, deductions, and employer
contributions. The ideal candidate is precise, analytical, and able to
translate payroll rules into accurate, transparent Excel models.

Key
Responsibilities

• Design and build advanced Excel
  payroll spreadsheets from scratch
  
• Calculate retroactive pay
  (retros) across multiple pay periods
  
• Apply and validate federal,
  state, and local tax deductions
  
• Model payroll scenarios
  including:
  
• Pre -tax and post -tax
  deductions
  
• Employer -paid benefits and
  contributions
  
• Adjustments, corrections, and
  offsets
  
• Use advanced Excel functions to
  ensure accuracy and efficiency, including:
  
• Nested formulas
  
• Lookup functions (XLOOKUP,
  VLOOKUP, INDEX/MATCH)
  
• IF/IFS logic
  
• Pivot tables and
  reconciliation tools
  
• Create clear
  documentation explaining calculations and assumptions
  
• Audit existing spreadsheets for
  errors, inconsistencies, or compliance risks
  
• Collaborate with payroll and
  finance staff to confirm requirements and outcomes
  
• Ensure spreadsheets are
  user -friendly, scalable, and auditable
  

Required
Qualifications

• Expert -level proficiency in
  Microsoft Excel
  
• Demonstrated experience
  creating payroll calculation spreadsheets
  
• Strong understanding of:
  
• Payroll tax concepts
  
• Withholding calculations
  
• Gross -to -net payroll math
  
• Exceptional attention to detail
  and accuracy
  
• Ability to explain complex
  calculations in plain language