Resource 1, Inc. · 3 weeks ago
Sr. Ellucian Banner HR/Payroll Functional Consultant
United States
Contract
Remote
Senior Level
$70/hr - $100/hrResource 1, Inc. is seeking a Sr. Ellucian Banner HR/Payroll Functional Consultant for an initial 3 month REMOTE contract to support the integration of an on-premise Banner 9 environment with UKG Pro for outsourced payroll processing. This role focuses on functional expertise, data mapping, and process design while working closely with UKG experts and HR/Finance stakeholders to ensure effective data flows for post-payroll processes.
ConsultingInformation ServicesInformation Technology
Hiring Manager
Jim Loizzi
Responsibilities
Serve as the functional subject matter expert for Banner HR/Payroll (Banner 9, on-prem, Oracle) with deep knowledge of HR/payroll tables, fields, and baseline processes
Analyze existing HR/payroll configurations, data structures, and business processes in Banner, with a focus on how payroll data feeds downstream modules (Finance, Financial Aid, Advancement/Raiser’s Edge, benefits, time and effort)
Define the data mapping between Banner and UKG Pro, including what data must flow Banner → UKG and what post-payroll data must return UKG → Banner
Interpret and document the meaning and usage of critical Banner HR/payroll fields (e.g., activity dates, earnings codes, position numbers, labor distributions) and how they relate to UKG’s person-centric model
Collaborate with UKG functional and technical teams to align on required data elements and clarify field definitions on the UKG side
Work closely with the client’s integration architect to translate functional requirements into detailed mapping documents and integration specifications (what to build, not how to code it)
Help resolve key challenges such as job-level vs. person-level cost allocation, ensuring accurate and compliant distribution of payroll costs in Banner
Identify the minimal viable data set required to maintain critical operations, avoiding over-engineering while ensuring downstream processes continue to function
Define and recommend interim/manual workarounds (e.g., report-based processes from UKG) during the period when systems are not fully synchronized, and assess risks/impacts of delayed data feeds (Finance, Financial Aid, etc.)
Support and guide testing and validation of payroll integrations and post-payroll processes, including test planning, scenario definition, and results analysis
Advise on opportunities to re-engineer or optimize Banner HR/payroll processes to better align with best practices and the new UKG-based payroll model
Provide knowledge transfer and documentation to internal HR, IT, and Finance teams
Qualification
Required
Extensive hands-on functional experience with Ellucian Banner HR and Payroll modules
Deep understanding of HR/payroll tables, fields, and baseline processes
Proven experience working on Banner HR/Payroll integrations with third-party or outsourced payroll systems
Strong ability to interpret complex data models and explain what individual fields represent in operational and post-payroll contexts
Demonstrated experience creating data mapping and integration design documents used by technical teams to build APIs, ETL, or other integration components
Solid understanding of how Banner payroll data feeds downstream functions such as Finance, Financial Aid, benefits, and Advancement
Experience dealing with cost allocation and reconciling job-level vs. person-level payroll structures
Excellent communication skills, capable of translating functional needs into precise, implementation-ready requirements
Preferred
Banner 9 preferred
UKG Pro strongly preferred; other major payroll platforms acceptable if Banner side expertise is strong
Ability to read or write basic SQL for data validation and troubleshooting is a plus
Prior experience in higher education and familiarity with Ellucian/Banner's typical implementation patterns
Company
Resource 1, Inc.
Resource 1 is a privately held national consulting firm established in 1982 with Corporate Headquarters and Technology Center in Oak Brook, Illinois.
Founded in 1982
51-200 employees
Funding
Current Stage
Growth StageLeadership Team
Gary R Moore
President / Managing Partner
Holly Utter
Chief Operations Officer
Company data provided by crunchbase