Human Resources Payroll

Job Title:

Human Resource Management - Technical Specialist 4 Duration: 05 Months (With the possibility of extension)

Location:

Las Vegas, NV 89119-ONSITE Pay Rate: $40/ Hour on w2 without any benefits. Job Description :
Key Responsibilities

• Design and build advanced Excel payroll spreadsheets from scratch
• Apply and validate federal, state, and local tax deductions
• 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

• Expert-level proficiency in Microsoft Excel
• Demonstrated experience creating payroll calculation spreadsheets
• Strong understanding of:
• 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