Job Description

Link Technologies (LinkTechConsulting.com), a Las Vegas-based IT consulting firm, is currently looking for a Technical Specialist – Excel Expert to join our team.

 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

Link Technologies is an equal opportunity employer. All qualified applicants will receive consideration for employment without discrimination based on race, color, religion, sex, gender identity/expression, sexual orientation, national origin, protected veteran status, disability, or any other factors protected by law.