Database administrator

We are looking for a Database Administrator to support financial planning and analysis processes in an Oracle Hyperion/Essbase environment, with an upcoming migration to Oracle Freeform. The role involves ETL process management, data integration, and post-migration system optimization. The candidate will have a solid understanding of financial concepts, be able to produce financial reports, and contribute to process automation. Experience of 3 to 5 years with Hyperion/Essbase and Oracle Freeform, as well as advanced skills in Excel and Power BI, are required.

contact us: Jean-Sebastien Hinse

Advantages
Hyperion Planning and Freeform database administrator #826

Lieu de travail / Location: Montreal, QC (2020) 2x semaine au bureau
Début du mandat / Start Date: 2024-09-09
Fin du mandat / End Date: 2025-10-17
Possibilité de renouvellement / Potential for extension: Yes
Info pour renouvellement / Extension info:
Maternity leave replacement depending on the return of the employee

2x professionnal reference
Credit and criminal background check
Laptop provided
Ãquipe / Team: IT FP&A
Dept: IT Finance

Responsibilities
Database Administration:
Support IT Financial Planning & Analysis processes in Hyperion/Essbase and eventually Oracle Freeform application by maintaining application as well as troubleshoot issues and provide direction on appropriate resolution.
Oversee data and metadata integration processes from CA PPM Clarity into cube to ensure seamless flow of financial data and manage ETL -Extract, Transform and Load- process for month end, year end and budget.
Resolve problems with data quality issues through independent assessment and applying logical framework.
Support annual budget planning exercise, managing regular budget updates on a timely basis while adapting the Hyperion/Freeform application as needed for future budget requirements.
Help ensure CA PPM Clarity data quality and related PM/PCO processes are consistent with the needs of IT Planning and the budget management process
Support: Oversee maintenance and regular updates of cube
Pre-Migration preparation: Collaborate with the migration team to ensure the Oracle Freeform environment is prepared and optimized for the upcoming migration from Oracle Hyperion.
Post Migration Support: Ensure the Oracle Freeform system is fully operational and optimized following the migration. Address any post-migration issues and assist in system stabilization.
System optimization: Adapt application as needed to change organizational requirements, including updates to Forms, Reports, Business Rules, Calculation Scripts, Attribute Dimensions, Substitution Variables, etc.
Financial Acumen:
Solid understanding of financial concepts, reporting, and analysis.
Experience working with finance teams to develop and implement financial reporting solutions.
Reporting: Prepare analyses and reports using Power BI, MS Excel, Smart View and Oracle Essbase
Processes: Contribute to process automation using Power BI, Excel / VBA / Macros, Essbase retrievals or other tools.
Documentation: Documenting monthly job processes and making recommendations for process improvements
Training and Support: Deliver onboarding training as well as day to day support in IT Financial Planning & Analysis processes

Qualifications
Exigences minimum/ Minimum requirements:
- Basic Experience with Essbase Reporting and/or Oracle Freeform is a requirement
- Strong knowledge of Microsoft Excel is a requirement
- Effective communication skills and the ability to adapt communication to a wide audience
- Langues parlées et écrites / Languages spoken and written: Bilingual or anglophone
- Attention to detail and quality is essential
- Customer-oriented and the ability to deal effectively with multiple demands

Asset :
- Minimum 3-5 years of demonstrated experience in managing and updating on premise Oracle Hyperion and/or Oracle Freeform application
- Basic Knowledge and understanding of best practices surrounding designs, tests, and implementation of Hyperion application and/or Oracle Freeform changes.
- Experience using CA PPM Clarity and Power BI is recommended
- Familiarity with agile work processes is an asset

Technologies demandées / Technologies required:
Hyperion planning and ideally Oracle Freeform as we are migrating in the fall to freeform

Summary
For more information and to submit your application, please contact us: Jean-Sebastien Hinse

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.

---