RQ08041 - Specialized IT Consultant - Senior

Rubicon Path; Canada; On-site; CAD 90,000 - 120,000; Full time

Job summary

An IT consulting firm located in Canada is seeking a Senior Specialized IT Consultant with deep expertise in Oracle Hyperion Planning and related tools. This role requires 5-10 years of relevant experience, a strong capacity for strategic guidance, and problem-solving skills. The position offers a hybrid work environment, with three days required in the office. Ideal candidates will have a proven track record in managing complex IT solutions and in advising clients to enhance their organizational efficiency through technology.

Qualifications

• 5-10 years of experience in Oracle Hyperion Planning.
• Experience with SmartView, ODI, Excel Macros, and VBA.
• Demonstrated ability to work in small technical teams.

Responsibilities

• Advise clients on IT to meet business objectives.
• Improve structure and efficiency of IT systems.
• Provide subject matter expertise in field.

Skills

Oracle Hyperion Planning

VBA

Excel Macros

ODI

SmartView

Unix Scripting

Job description

About the job RQ08041 - Specialized IT Consultant - Senior

Description

Note: This contract will require the consultant to work from the office location 3 days per week with the remaining 2 days being worked remotely.

Responsibilities:

A consultant specialized in Oracle Hyperion Planning including the various software add-ons required to support it including SmartView, ODI, Excel Macros, VBA. The requirement is for a senior resource with 5-10 years of experience specialized in this particular software package with a focus on the on-premises version.

Works in partnership with clients, advising them on information technology in order to meet their business objectives or overcome problems, work to improve structure and efficiency of an organizations I&IT systems.

The I&IT Consultant may be used to provide strategic guidance to organizations with regard to Information Management & IT technology, IT infrastructures and the enablement of major business processes through enhancements to IT.

Provides subject matter expertise in their field and highly expert technical assistance.

General Skills:

• Acts as the technical advisor/expert on all aspects of a specific deliverable
• Provide the quality assurance/quality control of specific deliverables
• Anticipates and resolves problems to ensure that the deliverables are completed within budget, to the highest quality, meeting or exceeding expectations
• Develops processes and procedures for implementing deliverables
• Prepares reports and presentations including options, recommendations, implementation plans, etc.
• Works with clients to define the scope of a project and to determine requirements
• Defines software, hardware and network requirements
• Analyzes I&IT requirements giving independent and objective advice on the use of I&IT
• Designs, tests, installs and monitors new systems and develops solutions and implementation of new systems
• Familiar with change-management principles and methodology
• Knowledge and understanding of Information Management principles, concepts, policies and practices

SkillsExperience and Skill Set Requirements

Evaluation Criteria for Skills and Experience as follows:

Core Technical Skills: 40%

• Demonstrated experience (at least 5 years) designing and creating integrated Oracle Hyperion Planning (OnPrem) solutions with version 11 including some demonstrated experience working with version 11.2.
• Demonstrated experience (at least 3 years) coding and sustaining applications using Excel macros and VBA.
• Demonstrated experience working with both the business users and IT development teams to ensure business requirements are properly reflected in the system design, technical specifications and final solution/ prototype.
• Demonstrated experience working in small technical teams (2-3 ) of Hyperion Planning and data integration specialists.
• Demonstrated experience working with ODI to move data into and out of Hyperion Planning.
• Demonstrated experience working with automated scripts using custom-built Unix scripts to migrate and convert data and artefacts moving from one Planning application to another.

Application-Specific Skills: 40%

• Demonstrated experience building Planning applications for the purpose of managing the flow of transfer payments to public sector institutions.
• 3+ years designing and implementing customized front-end solutions using Smart View/Excel/VBA front-ends with Essbase back-end
• Experience with Hyperion solutions (at least one required as per above) designed to integrate with OAM/OIM.
• Familiarity with the use of Oracle APEX as a tool for managing metadata in Hyperion Planning applications in conjunction with ODI batch routines.
• Demonstrated experience deploying and supporting Hyperion Planning applications deployed across the internet to large numbers of users (1000+).
• Familiarity with the funding models used in the education sector.
• Demonstrated ability to work effectively in small teams.
• Demonstrated ability to work and problem solve independently.
• Demonstrated ability to work directly with clients in gathering requirements.
• Demonstrated ability to work with end-users to resolve issues.

MUST

Demonstrated experience building and designing on-premises Hyperion Planning applications (version 11) including all core components: Forms, Reports, Business Rules, Task Lists, meta data loading, Essbase design and optimization with at least 7 years of solid design and development experience.

Experience developing and maintaining custom-developed front-end applications using Excel/VBA and SmartView.

Senior experience Demonstrated experience as a Hyperion Planning Developer - more of a lead and solution designer