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 agile 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?

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

📌 Senior Oracle HCM Consultant (Canada)
🏢 City of Red Deer
📍 Canada