CGI - Oracle EPM/BI Consultant

Job description :

We are looking for an experienced Oracle EPM / BI Consultant to support and enhance budgeting, forecasting, reporting, and management control applications within an Oracle ecosystem.

The ideal candidate should combine strong business understanding with excellent analytical and problem-solving skills and be able to interact effectively with both Finance and IT stakeholders.

Business Skills :

- Strong understanding of Finance, Budgeting, Forecasting, and Management Reporting processes.

- Ability to analyze business requirements and propose functional and technical solutions.

- Strong analytical mindset and troubleshooting capabilities.

- Ability to support business users during budgeting cycles, forecasting exercises, and reporting activities.

- Ability to investigate and identify root causes of data discrepancies.

Technical Skills (Mandatory) :

Oracle EPM / Hyperion :

- Strong experience with Hyperion Planning (On-Premise and/or Cloud).

- Good knowledge of Essbase administration and development.

- Metadata and dimension management.

- Business Rules and Calculation Scripts development.

- Data loading processes and Smart View.

Oracle Data Integration :

- Strong experience with Oracle Data Integrator (ODI).

- Development and maintenance of mappings, packages, variables, and scenarios.

- Monitoring and troubleshooting of ODI data integration processes.

Reporting & Analytics :

- Strong experience with Oracle Analytics Server (OAS).

- Dashboard and reporting development.

- Data analysis and reporting support.

Database :

- Advanced SQL skills.

- Strong PL/SQL development skills.

- Oracle Database expertise.

- Query optimization and performance tuning.

Main Responsibilities :

- Support and maintain Oracle EPM and BI applications.

- Analyze and resolve functional and technical issues.

- Develop and enhance ODI integration processes.

- Design and optimize SQL and PL/SQL components.

- Develop and maintain Essbase calculation scripts and business rules.

- Support Finance and Controlling users.

- Contribute to reporting and analytics solutions within OAS.

- Participate in enhancement and continuous improvement initiatives.

Profile :

- Minimum 5 years of experience in Oracle EPM / BI environments.

- Proven experience with Hyperion Planning, Essbase, ODI, OAS, Oracle SQL, and PL/SQL.

- Strong communication skills and ability to work with business and technical teams.

- Excellent analytical and problem-solving abilities.

- Autonomous and proactive.

Key Skills :

- Hyperion Planning & Essbase

- Advanced SQL

- ODI Expertise

- OAS Reporting & Analytics

- Strong Finance & Controlling Business Knowledge

- Excellent Analytical & Troubleshooting Skill

- Ability to bridge Business and IT teams