Payroll Excel Analyst Job at Novalink Solutions, Las Vegas, NV

YXcyMzF6YU84S1NMZjMxZUJCV2pFNWMwY2c9PQ==
  • Novalink Solutions
  • Las Vegas, NV

Job Description

Payroll Excel Analyst

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
  • Experience handling sensitive and confidential financial data
Novalink Solutions

Job Tags

Local area

Similar Jobs

CompHealth

Locum Tenens Job Opportunity in NY for Neurologist Job at CompHealth

Interested in this assignment? Or maybe you still have not found what you are looking for? Contact one of our specialty-specific recruiters to get access to our vast network of open jobs, including some jobs that never get posted. CompHealth will handle all the details ...

BrightPath Kids USA

Child Care Assistant Teacher Job at BrightPath Kids USA

 ...community of over 5,000 dedicated employees, and experience competitive pay and benefits, including a...  ...home away from home for children in our care, according to NAEYC guidelines....  ...communication with parents/guardians about their child. Top Reasons to join BrightPath Kids:... 

Golden Technology

Cybersecurity Analyst Job at Golden Technology

 ...years of experience in cybersecurity roles with hands-on exposure to the specified technologies. ~ Expertise in Cisco Umbrella, Secure Web Gateways, and SSL decryption configurations. ~ Proficient in vulnerability management tools and Cloud Security Posture... 

American Mechanical Corporation

Experienced HVAC Service Technician Job at American Mechanical Corporation

 ...performed and parts used. Required Qualifications & Skills Education: High school diploma/GED; completion of an HVAC program or apprenticeship is preferred. Certification: EPA Universal certification is generally required for handling refrigerants. Experience: 14... 

Maine Medical Center

Operating Room Assistant Job at Maine Medical Center

 ...weekend coverage. Summary: The Perioperative Services Technician I role is responsible for assisting with the care of the patient in the Operating Room by transporting and lifting/positioning for surgery, cleaning and assisting in Operating Room turnovers,...