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

Hero Home Services

Part-Time/Seasonal Customer Service Rep Job at Hero Home Services

 ...completion of their service. About the Role Looking for a summer role that builds real career skills and works around your...  ...service, operations, and business systems. It's a great fit for college students or anyone early in their career looking to gain experience,... 

Performance Foodservice

Truck Driver CDL A- $10,000 Sign-on Bonus Job at Performance Foodservice

 ...Job Description Job Description: Position Details: ~ Drivers average $104,000 annually ~5-day work week Monday-Friday...  ...CDL-A Driveris responsible for driving a tractor trailer or straight truck on intrastate and interstate local, over-the-road (OTR), shuttle... 

Young World Physical Education

Literacy Teacher for Adult Incarceration Remote Role Job at Young World Physical Education

 ...Young World Physical Education in Breckenridge, Texas, seeks a dedicated Academic Teacher to provide quality education to incarcerated students. This full-time role involves planning and directing learning activities while adhering to the Windham School District curriculum... 

Relay Express

Full Size Cargo Van Or Sprinter Van Driver Needed Job at Relay Express

 ...Overview Full Size Cargo Van Or Sprinter Van Driver Needed1 month ago Be among the first 25 applicantsThis range is provided by Relay Express,...  ...Responsibilities Perform a mix of out-of-town (OOT) expedited deliveries and local deliveries.We are primarily ON-DEMAND. Orders... 

Fox Cities Builders

Accounts Payable Specialist Job at Fox Cities Builders

 ...Join a team where your attention to detail and organization make a real impact. Fox Cities Builders is seeking an Accounts Payable Specialist to support our financial operations across multiple entities. This role is ideal for someone who is organized, proactive,...