Senior Oracle HCM Consultant - TERM

Red Deer; Red Deer; On-site; CAD 79,000 - 98,000; Full time

Job summary

The City of Red Deer is seeking a Senior Oracle HCM Consultant to lead configurations, integrations and reporting for its Oracle Cloud HCM environment. You will work across HR, payroll and IT to translate business needs into scalable system solutions, ensuring Canadian compliance and data integrity.

Reporting to the Director of Business Development & Integration Services, the role emphasizes hands-on configuration, stakeholder engagement, and knowledge transfer, with a 24‑month term and a

Qualifications

• Bachelor’s degree in Computing Science, Information Systems, or a related discipline.
• Oracle HCM certification
• Minimum five years of experience with Oracle Cloud HCM technical tools across two end-to-end implementations including Canadian scope.
• Expert in HDL, HCM Extracts, REST/SOAP web services and OIC integration patterns.
• Proven development of Fast Formulas and reporting with BI Publisher/OTBI.
• Experience with WFS/workforce management and payroll integration is an asset.
• Knowledge of Canadian HR/payroll data structures, compliance and provincial nuances.

Responsibilities

• Analyze Business Requirements & Recommend Solutions - Partner with HR, Payroll, and stakeholders to assess requirements and recommend Oracle HCM Cloud solutions.
• Configure and Maintain Oracle HCM Cloud - Design, configure, implement, and maintain modules, workflows, security, notifications, and system configurations.
• Lead System Integrations - Develop and support integrations between Oracle HCM Cloud and Payroll, WFS, Finance/GL and other systems using OIC, APIs, HCM Extracts.
• Manage Data Conversions and Migrations - Lead data migration activities using HDL, APIs, and conversion tools.
• Develop Custom Reports and Extensions - Create and maintain BI Publisher reports, OTBI analytics, HCM Extracts, and custom workflows.
• Ensure Reporting and Data Integrity - Develop reconciliation processes and validation controls for payroll, benefits, pension and year-end processing.
• Lead Testing and QA - Plan and execute unit/integration/SIT/UAT testing and defect resolution.
• Provide Ongoing System Support and Change Management - Troubleshoot, coordinate enhancements and manage changes.
• Lead HCM Projects - Coordinate enhancements, manage priorities, risks, and continuous improvements.
• Collaborate with Stakeholders and Knowledge Transfer - Liaise with HR, Payroll, Digital Services and external consultants; deliver training and handover.

Job description

About Red Deer

Red Deer sits at the heart of Central Alberta along the QEII corridor, perfectly positioned between Calgary and Edmonton. With more than 100,000 residents and a regional reach of over 300,000, it’s a growing hub for business, services, and opportunity.

Here, big-city amenities meet small-city ease. Enjoy abundant parks and trails, vibrant arts and culture, excellent recreation and education, and a strong sense of community.

With easy access to lakes, outdoor adventures, and the mountains, plus a thriving economy and high quality of life, Red Deer is an inviting place to live, work, and grow.

About The City of Red Deer Municipal Government

The City of Red Deer is a dynamic municipal organization with a $480M operating budget, a $60M capital program, and a workforce of nearly 1,700 employees. It is focused on growing with purpose by attracting talented, community-minded people who want to make a difference.

Guided by the vision “Our City, One Voice,” Red Deer is building a thriving, inclusive, and connected community, with priorities centered on a vibrant economy, community wellbeing, and strong engagement.

At its core, the City values its people, embracing diverse perspectives and fostering a culture of collaboration, innovation, and shared success.

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:

1. 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.
2. Configure and Maintain Oracle HCM Cloud - Design, configure, implement, and maintain Oracle HCM modules, workflows, security, notifications, and system configurations.
3. 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.
4. Manage Data Conversions and Migrations - Lead data migration activities using HDL, APIs, and conversion tools while ensuring data accuracy, validation, and reconciliation.
5. 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.
6. Ensure Reporting and Data Integrity - Develop reconciliation processes, exception reporting, and validation controls to support accurate payroll, benefits, pension, year‑end, and T4 processing.
7. 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.
8. Provide Ongoing System Support and Change Management - Troubleshoot issues, resolve user inquiries, coordinate system enhancements, and manage changes through established release and governance processes.
9. 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.
10. 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.

The City of Red Deer does not permit the use of unauthorized internet resources or Artificial Intelligence (AI) tools (for example, Copilot, ChatGPT or any other form of AI) during interviews or any supervised or timed assessments. Any violation may be investigated and result in serious consequences, including the rejection of your application.

We thank you for your application. Only those selected for an interview will be contacted.