Senior Oracle HCM Consultant - TERM
The City of Red DeerC$57-C$71 / hr
About the role
This approximately 24-month term role requires five years with Oracle Cloud HCM technical tools, including two end-to-end implementations with Canadian scope, plus Oracle HCM certification. You’ll configure modules, workflows and security, lead integrations using OIC, REST/SOAP, HCM Extracts and secure file transfers, and manage HDL data migrations, reporting and testing. Monday to Friday, 75 hours biweekly, with some evening and weekend work when needed.
Are you an experienced Senior Oracle HCM Consultant with a proven track record of leading complex HCM implementations and delivering innovative HR technology solutions?
We are seeking a dynamic professional with extensive expertise in Oracle HCM Cloud, HR processes, and stakeholder engagement to drive successful project outcomes and support organizational transformation.
The Opportunity:
The City of Red Deer is recruiting for the right person to fill the 2-year term position of Senior Oracle HCM Consultant. The Senior Oracle HCM Consultant provides technical expertise in the configuration, integration, maintenance and optimization of The City’s Oracle Cloud HCM system, ensuring solutions align with business requirements and Canadian HR and payroll obligations. The position works collaboratively with internal teams and external partners to resolve technical issues, improve system functionality and build internal knowledge and capability to support the system’s long-term sustainability.
Reporting to the Director, Business Development & Integration Services, the Senior Oracle HCM Consultant provides strong technical expertise delivering integrations, data solutions and hands-on configuration, maintenance and reporting support for The City’s Oracle Cloud Human Capital Management (HCM) system. Working across departments, the position translates approved business requirements into system solutions, resolves reasonable technical issues with hands-on knowledge of Canadian Human Resources (HR)/Payroll data structures, compliance obligations and provincial nuances.
The Senior Oracle HCM Consultant coordinates and advises on – technical solutioning activities with internal teams, external consultants and vendors, validates solutions, and captures configuration and support knowledge through documentation and practical training. This position builds internal technical capability to maintain and improve the HCM Cloud systems following consultant handover. This position provides leadership through expertise, collaboration and coordination, and recommends system design and configuration improvements and ongoing support arrangements within established business and technical approval processes.
Top Key Responsibilities:
Analyze Business Requirements & Recommend Solutions - Partner with HR, Payroll, and business stakeholders to assess requirements and recommend Oracle HCM Cloud solutions that improve processes and operational efficiency.
Configure and Maintain Oracle HCM Cloud - Design, configure, implement, and maintain Oracle HCM modules, workflows, security, notifications, and system configurations.
Lead System Integrations - Develop and support integrations between Oracle HCM Cloud and related systems including Payroll, Workforce Software (WFS), Finance/GL, and other enterprise applications using OIC, REST/SOAP APIs, HCM Extracts, and secure file transfers.
Manage Data Conversions and Migrations - Lead data migration activities using HDL, APIs, and conversion tools while ensuring data accuracy, validation, and reconciliation.
Develop Custom Reports and Extensions - Create and maintain Fast Formulas, BI Publisher reports, OTBI analytics, HCM Extracts, Design Studio configurations, custom workflows, and business process enhancements.
Ensure Reporting and Data Integrity - Develop reconciliation processes, exception reporting, and validation controls to support accurate payroll, benefits, pension, year-end, and T4 processing.
Lead Testing and Quality Assurance - Plan and execute unit, integration, regression, SIT, and UAT testing; manage defect resolution, root cause analysis, and validation of system changes.
Provide Ongoing System Support and Change Management - Troubleshoot issues, resolve user inquiries, coordinate system enhancements, and manage changes through established release and governance processes.
Lead HCM Projects and Continuous Improvement Initiatives - Coordinate Oracle HCM enhancement projects, manage priorities and dependencies, monitor risks, and drive continuous process and system improvements.
Collaborate with Stakeholders and Facilitate Knowledge Transfer - Act as the primary liaison between HR, Payroll, Digital Services, and external consultants while maintaining documentation, delivering training, and ensuring knowledge transfer for long-term system support.
As our preferred candidate, you will have:
Bachelor’s degree in Computing Science, Information Systems, or a related discipline. An equivalent combination of education, training and experience may be considered.
Oracle HCM certification
Minimum five years of experience with Oracle Cloud HCM technical tolls across two end to end implementations including Canadian Scope.
Expert in HDL (persons, work relationships, assignments, elements/balances relevant to Canada), HCM Extracts, REST/SOAP web services and OIC Integration patterns
Proven development of Fast Formulas (Benefits/Compensation/Absence/Payroll-adjacent) and operational audit reporting with BI Publisher and OTBI
Experience supporting HR and payroll systems in a unionized environment with multiple collective agreements and varied employee groups is an asset
Experience working with WFS or a comparable workforce management system, including time and attendance processes, payroll integration and reconciliation is an asset
Competencies
In addition to the 9 Core Competencies (i.e., Ethical Conduct & Values, Service Focus, Problem Solving/Thinking, Planning & Organizing, Leadership, Development, Communication & Interaction, Adaptability & Change Management, Understanding the Municipal Political Environment) – the following are specific to this position:
Advanced functional knowledge of Oracle HCM configuration, processes and related business practices
Strong problem-solving and analytical skills, including the ability to identify underlying causes and recommend practical solutions
Ability to prioritize and organize work, handle multiple assignments and meet deadlines
Ability to collaborate effectively with internal and external contacts and coordinate work through influence
Ability to provide effective advice, information and assistance to a wide range of customers
Ability to follow rigorous project management practice and methodology
Excellent verbal and written communication skills
Knowledge of a variety of software including SQL Developer, PS Query, and MS Excel
Affiliation: Exempt
Status: Term Full-time
Remuneration: $57.04 to $71.31 per hour ($111,655 to 139,589 per annum)
Hours of Work: 75 hours biweekly; Monday to Friday, some evening and weekend work may be required when needed.
Additional Information: The term of this position is anticipated to be approximately 24 months.