Senior Solutions Designer (Oracle EPM / Hyperion Financial Management)
Senior Level
Position Details
Category
| Details
|
|---|
Position Title
| Senior Solutions Designer
|
Client
| Enterprise Financial Services Division
|
Ministry
| Ministry of Public and Business Service Delivery and Procurement
|
Location
| 222 Jarvis Street, Toronto, Ontario
|
Work Arrangement
| 100% Onsite – 5 days per week
|
Contract Start Date
| October 1, 2026
|
Contract End Date
| March 31, 2027
|
Duration
| 122 Business Days
|
Daily Bill Rate
| |
Openings
| 1
|
Security Clearance
| No clearance required
|
Submission Deadline
| November 24, 2026 – 10:30 AM
|
Maximum Submissions
| 1 Candidate
|
Position Overview
The Enterprise Financial Services Division is seeking an experienced Senior Solutions Designer with strong Oracle EPM Cloud and Hyperion Financial Management (HFM) expertise to lead a Proof of Concept (POC) initiative evaluating the migration of its existing Public Accounts Consolidation application, CONSOL, from the legacy Oracle Hyperion Financial Management (HFM) platform to Oracle Financial Consolidation and Close Cloud Service (FCCS).
The successful candidate will lead the assessment of the existing financial consolidation application, evaluate the target-state Oracle EPM Cloud solution, and develop a working Proof of Concept to demonstrate the feasibility of migrating CONSOL to FCCS.
This role requires a combination of strong financial systems knowledge, enterprise solution architecture, Oracle EPM application design, financial consolidation experience, business analysis, and project delivery capabilities.
The consultant will work closely with business stakeholders, technical teams, vendors, and senior management to assess the current environment, identify migration requirements, evaluate solution options, and provide recommendations for the full-scale migration initiative.
Key Responsibilities
1. Oracle EPM Cloud Solution Design and Migration
Lead the Proof of Concept initiative to assess the feasibility of migrating the existing CONSOL Public Accounts Consolidation application from Hyperion Financial Management (HFM) to Oracle EPM Cloud.
Assess and evaluate Oracle Financial Consolidation and Close Cloud Service (FCCS) as the target solution.
Analyze existing HFM application architecture, functionality, configurations, financial consolidation processes, and reporting requirements.
Design and develop solution approaches for migrating existing HFM consolidation applications to Oracle EPM Cloud.
Evaluate application compatibility, migration complexities, integration requirements, and potential technical challenges.
Configure the target environment and application components required for the POC.
Develop and execute the POC to validate the proposed migration approach.
Provide technical recommendations and solution design documentation to support future implementation.
2. Financial Management and Consolidation Expertise
Apply strong financial domain knowledge in financial planning, management accounting, forecasting, consolidation, and financial reporting.
Understand public accounts consolidation processes and financial management requirements.
Analyze existing financial consolidation workflows and identify opportunities for optimization.
Assess financial application capabilities against business and reporting requirements.
Support the migration and implementation of large-scale financial management applications.
Provide production application support, troubleshoot application issues, and coordinate with vendors, consultants, and technical teams to resolve challenges.
Ensure proposed solutions align with financial operations, internal controls, and controllership requirements.
3. Business Analysis and Analytical Skills
Lead business requirements gathering sessions with business users, technical teams, and stakeholders.
Analyze business requirements and translate them into functional and technical solution designs.
Assess the impact of proposed solutions on existing business processes, financial policies, and operational procedures.
Evaluate current-state business processes against industry best practices.
Analyze multidimensional financial datasets and identify gaps, dependencies, and opportunities for improvement.
Conduct cost-benefit analyses and feasibility assessments for proposed technology solutions.
Develop recommendations addressing business needs, technical constraints, and long-term technology objectives.
Assess existing system performance, capacity, and technical limitations, recommending appropriate improvements.
4. Solution Architecture and Technical Documentation
Develop current-state and future-state solution architectures and design documentation.
Evaluate technology options, emerging trends, and Oracle EPM Cloud capabilities against organizational requirements.
Assess system integration, performance, scalability, availability, security, and recovery requirements.
Prepare technical specifications covering application configuration, installation, testing, and performance.
Evaluate the feasibility of application expansion, renovation, replacement, or migration.
Develop technical documentation, solution recommendations, implementation approaches, and migration strategies.
Ensure alignment with corporate IT information mandates, enterprise architecture standards, and technology strategies.
5. Project Planning and Delivery
Lead and coordinate the POC activities, ensuring milestones, deliverables, and timelines are achieved.
Develop recommendations for the future full-scale migration project, including required tasks, dependencies, resource considerations, and estimated duration.
Identify risks, assumptions, constraints, and dependencies associated with the proposed migration.
Apply established project management methodologies, including Software Development Life Cycle (SDLC), Waterfall, and Agile.
Support project planning, implementation, testing, and transition activities.
Apply project management principles and methodologies, including PMBOK practices.
Ensure compliance with internal controls, business management frameworks, financial operations, and controllership models.
6. Stakeholder Engagement and Communication
Collaborate with business stakeholders, technical teams, vendors, consultants, and project management teams.
Facilitate business requirements gathering sessions, workshops, and solution discussions.
Prepare and deliver presentations outlining findings, technical assessments, POC outcomes, and recommendations.
Communicate complex technical and financial concepts effectively to senior management and business stakeholders.
Participate in project status meetings, committees, and stakeholder consultations.
Build consensus, negotiate solutions, mediate conflicting requirements, and influence stakeholders at different organizational levels.
Requirements
Required Qualifications and Mandatory Skills
Candidates must demonstrate the following experience and capabilities:
1. Oracle EPM Cloud and Financial Technical Solution Design
Strong hands-on knowledge and experience in Oracle EPM Cloud solutions and solution design.
Experience with Oracle Financial Consolidation and Close Cloud Service (FCCS) is preferred but not mandatory.
Strong application expertise in analyzing, solutioning, and designing the migration of existing Hyperion Financial Management (HFM) consolidation applications.
Experience implementing and providing ongoing support for the migration of large-scale financial applications.
Knowledge and experience with financial planning, management accounting, and financial reporting applications, including forecasting, financial consolidations, and public accounts.
2. Financial Systems and Consolidation Expertise
Strong understanding of financial management systems and financial consolidation processes.
Experience designing and implementing financial management, reporting, and consolidation applications.
Ability to assess existing financial applications and recommend appropriate migration and modernization solutions.
Understanding of financial operations, internal controls, and controllership models.
3. Business Analysis and Analytical Skills
Demonstrated experience leading business requirements gathering and analysis.
Ability to assess business processes, identify gaps, evaluate impacts on policies and procedures, and recommend improvements.
Experience conducting feasibility assessments and cost-benefit analyses.
Strong analytical skills, including the ability to analyze multidimensional datasets and evaluate financial business processes against best practices.
4. Communication and Stakeholder Management
Excellent verbal and written communication skills.
Experience facilitating requirements-gathering sessions and stakeholder workshops.
Ability to develop and deliver presentations to clients, stakeholders, senior management, and technical teams.
Strong collaboration, negotiation, mediation, and consensus-building skills.
Ability to influence stakeholders and work effectively across business and technical teams.
5. Project Management and Delivery
Experience with formal systems implementation and project delivery methodologies.
Knowledge and practical experience with SDLC, Waterfall, and Agile methodologies.
Strong organizational skills and ability to manage multiple deliverables, deadlines, and project targets.
Understanding of project management principles and methodologies, including PMBOK.
Experience working with internal controls, business management frameworks, financial operations, and controllership models.
Additional General Requirements
Experience planning, migrating, implementing, and sustaining large, complex system development projects.
Experience designing and developing large-scale, highly available, mission-critical server applications.
Knowledge of system security, disaster recovery, and application performance procedures.
Ability to evaluate existing system performance and capacity and recommend improvements.
Knowledge of enterprise IT standards, corporate information mandates, and technology strategic plans.
Excellent problem-solving, decision-making, interpersonal, and teamwork skills.
Ability to work independently and collaboratively while consistently meeting deadlines.
Nice-to-Have Qualifications
Previous experience working with the Ontario Public Service (OPS) or other public sector organizations.
Direct experience with Oracle FCCS implementation and migration projects.
Experience with government financial consolidation, public accounts, and controllership environments.
Important Assignment Conditions
Important submission and interview requirements
This is a strictly onsite position at 222 Jarvis Street, Toronto.
Candidates must be available to work onsite five days per week, Monday to Friday.
Standard working hours are 8:00 AM – 5:00 PM, excluding lunch.
The interview will be conducted in person.
Candidates unable to attend an onsite interview will be declined.
An assignment/presentation will form part of the interview process.
Only one candidate can be submitted against this requisition.