Oracle Essbase consultant

Capgemini; Montreal; On-site; CAD 70,000 - 90,000; Full time

Job summary

A global technology consulting firm is hiring a Permanent Recruiter in Montreal to source IT, Digital, and AI talent. The role involves maintaining financial systems, supporting budgeting processes, and enhancing financial reporting. Candidates should possess strong SQL skills, experience with Oracle EPM, and excellent problem-solving abilities in a collaborative environment.

Qualifications

• Strong understanding of SQL and relational databases.
• Excellent troubleshooting, problem-solving, and analytical skills.
• Strong communication skills and a client service mindset.
• Ability to work independently and collaboratively in a fast-paced environment.
• Experience in Oracle EPM 11.2.x (Essbase, Hyperion Planning, Hyperion Financial Reporting).
• Experience with Essbase (BSO/ASO), calculation scripts, and metadata management.
• Solid understanding of financial planning, budgeting, and reporting processes.

Responsibilities

• Maintain the Hyperion financial planning and consolidation system.
• Support budgeting, forecasting, consolidation, and reporting needs.
• Troubleshoot and resolve system issues; apply patches and updates.
• Manage and optimize data integrations and workflows.
• Document system architecture and configurations.
• Continuously improve existing Hyperion processes.

Skills

SQL understanding

Troubleshooting skills

Analytical skills

Communication skills

Client service mindset

Experience with Essbase

Proficiency in SQL / PLSQL

Linux/Windows experience

Tools

Oracle EPM 11.2.x

Hyperion Planning

Smart View

Perl

Shell Scripts

Powershell

Job description

Overview

Permanent Recruiter | Hiring for Direct hire - IT, Digital and AI / ML talent across US. | Matching Visionaries with Vocations

Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you’d like, where you’ll be supported and inspired by a collaborative community of colleagues around the world, and where you’ll be able to reimagine what’s possible. Join us and help the world’s leading organizations unlock the value of technology and build a more sustainable, more inclusive world.

Responsibilities

• Maintain the Hyperion financial planning and consolidation system to ensure high availability and performance.
• Support budgeting, forecasting, consolidation, and reporting needs across the organization.
• Troubleshoot and resolve system issues; apply patches and updates as needed.
• Manage and optimize data integrations, transformation rules, and system workflows.
• Document system architecture, processes, and configurations.
• Continuously improve existing Hyperion processes for efficiency and reliability.
• Collaborate with Finance and IT teams to deliver solutions aligned with business needs.
• Design, develop, and maintain EPM applications, metadata, forms, reports, and business rules.
• Provide insights to enhance financial processes and reporting.
• Conduct user training and support end-users effectively.
• Troubleshoot EPM application issues and provide ongoing support.
• Scripting knowledge to understand existing setup of automations and update them as applicable, calc scripts in Planning etc.

Qualifications

• Strong understanding of SQL and relational databases.
• Excellent troubleshooting, problem-solving, and analytical skills.
• Strong communication skills and a client service mindset.
• Ability to work independently and collaboratively in a fast-paced environment.
• Experience in Oracle EPM 11.2.x (Essbase, Hyperion Planning, Hyperion Financial Reporting, Smart View).
• Experience with Essbase (BSO / ASO), calculation scripts, and metadata management.
• Solid understanding of financial planning, budgeting, and reporting processes.
• Proficiency in SQL / PLSQL, Perl, Shell Scripts and Powershell.
• Working experience in LINUX / Windows Environments.

Capgemini is an Equal Opportunity Employer

Capgemini is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity / expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law.

This is a general description of the Duties, Responsibilities and Qualifications required for this position. Capgemini will consider reasonable accommodations that might involve varying job requirements and/or changing the way this job is performed, provided that such accommodations do not pose an undue hardship.

Capgemini is committed to providing reasonable accommodations during our recruitment process. If you need assistance or accommodation, please reach out to your recruiting contact.