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

Peraton

Linux Systems Administrator Job at Peraton

 ...is seeking a Linux Systems Administrator IV to join our team supporting a mission-critical Intelligence Community customer. In this...  ...to respond onsite during off-hours when required. Deploy software patches and apply system hardening in alignment with Security... 

AMN Healthcare

Non-Invasive Cardiologist Job at AMN Healthcare

 ...Job Description & Requirements Non-Invasive Cardiologist StartDate: ASAP Pay Rate: $472000.00 - $529827.00 Enjoy a fulfilling Cardiology career in Hartford, Connecticut. Trinity Health Of New England, one of the largest Catholic health systems in the United... 

Insurance Services, Inc.

Insurance Agent Job at Insurance Services, Inc.

 ...Job Description Job Description Insurance personal and/or commercial service agent with the ability to multitask into cross-sales. Independent Insurance Agency experience preferred. Licensed for Property & Casualty; Life & Health license preferred. Previous experience... 

Sharon Green - State Farm Agent

Account Representative - State Farm Agent Team Member Job at Sharon Green - State Farm Agent

 ...schedule ~ Opportunity for advancement ~ Paid time off *Work from Home Position - Must have prior State Farm experience. *...  ...answered yes to these questions, working for a State Farm independent contractor agent may be the career for you! State Farm agents market... 

Ridley's Family Markets, Inc.

Store Assistant Manager Job at Ridley's Family Markets, Inc.

 ...essential job duties. The primary responsibilities of the Assistant Store Director position are to maintain outstanding merchandising,...  ...individual department equipment. EXPERIENCE: Must have previous retail management experience. MATH: Basic math skills required....