Ellucian Banner HR/Payroll Consultant (Only Visa Independent Candidate/W2)

Responsibilities

• Validate employee records and HR/payroll datasets for accuracy, completeness, and consistency.
• Reconcile payroll data and investigate discrepancies between source records, calculations, and system outputs.
• Review benefits data and related payroll deductions for accuracy.
• Validate time and attendance information and its impact on payroll.
• Write SQL queries to extract, analyze, reconcile, and report on Banner HR/payroll data.
• Develop and support HR/payroll reports, validation checks, and exception reports.
• Support payroll testing by comparing expected results with actual outputs and documenting issues.
• Assist with HR/payroll migrations, implementations, or upgrades, including data mapping, conversion validation, and reconciliation.
• Work with business and technical stakeholders to clarify requirements and resolve data issues.
• Document reporting logic, validation procedures, reconciliation findings, and testing results.

Required Qualifications

• Hands-on experience with Ellucian Banner HR/Payroll.
• Strong understanding of employee data, payroll processes, benefits, and time and attendance.
• Strong SQL skills for data extraction, validation, reconciliation, and reporting.
• Experience identifying and resolving HR/payroll data discrepancies.
• Experience supporting payroll testing and validating system results.
• Experience supporting HR/payroll implementations, migrations, or upgrades.
• Ability to explain technical findings clearly to HR and Payroll users.
• Ability to work independently in a remote, part-time consulting capacity.

Preferred Background

• Higher education consulting or university HR/payroll systems experience.
• Experience working with complex Banner data structures, legacy configurations, or limited documentation.
• Experience creating repeatable validation checks and clear supporting documentation.