Hyperion Planning and Freeform database administrator

4 weeks ago

Montréal QC, Canada sourcevolution Full time

• Database Administration:o 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.o 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.o Resolve problems with data quality issues through independent assessment and applying logical framework.o 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.o 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:o Solid understanding of financial concepts, reporting, and analysis.o 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-------------------------------------------------------------------------------------------------------------Langues parlées et écrites / Languages spoken and written: French, EnglishNiveau d’expérience / Level of experience: JuniorAnnées d’expérience / Years of experience: 3-5 yearsExigences minimum/ Minimum requirements:• Bachelor's degree or relevant experience preferred• Minimum 3-5 years of demonstrated experience in managing and updating on premise Oracle Hyperion and/or Oracle Freeform application• Knowledge and understanding of best practices surrounding designs, tests, and implementation of Hyperion application and/or Oracle Freeform changes.• Experience with Essbase Reporting and/or Oracle Freeform is a requirement• Strong knowledge of Microsoft Excel is a requirement• Experience using CA PPM Clarity and Power BI is recommended• Effective communication skills and the ability to adapt communication to a wide audience• Attention to detail and quality is essential• Customer-oriented and the ability to deal effectively with multiple demands• Familiarity with agile work processes is an assetTechnologies demandées / Technologies required:• Hyperion planning and ideally Oracle Freeform as we are migrating in the fall to freeformAutres exigences / Other requirements:Certifications et/ou expérience / Certification and/or experience:

  • Data Analyst

    6 days ago

    Montréal, QC, Canada Astek Full time

    Créé en France en 1988, Astek est un acteur mondial de l’ingénierie et du conseil en technologies. Fort de son expertise dans de nombreux secteurs industriels et tertiaires, Astek accompagne ses clients internationaux dans le déploiement intelligent de leurs produits et de leurs services, et dans la mise en œuvre de leur transformation digitale. ...

  • Analyste de données

    5 days ago

    Montréal, QC, Canada Astek Full time

    Le Groupe Astek Créé en France en 1988, Astek est un acteur mondial de l’ingénierie et du conseil en technologies. Fort de son expertise dans de nombreux secteurs industriels et tertiaires, Astek accompagne ses clients internationaux dans le déploiement intelligent de leurs produits et de leurs services, et dans la mise en œuvre de leur...

  • Analyste de données

    6 days ago

    Montréal, QC, Canada Astek Full time

    Le Groupe Astek Créé en France en 1988, Astek est un acteur mondial de l’ingénierie et du conseil en technologies. Fort de son expertise dans de nombreux secteurs industriels et tertiaires, Astek accompagne ses clients internationaux dans le déploiement intelligent de leurs produits et de leurs services, et dans la mise en œuvre de leur...

  • Hyperion PBCS Administrator

    4 months ago

    Montréal (St-Laurent ), Canada CAE Full time

    Role and Responsibilities Hyperion Administrator - PBCS (Corporate)Passionate about your field? Looking for a work environment where you can innovate, reach greater heights and collaborate with experts from a wide range of sectors? Want to join a world‐class company and industry leader and be proud to contribute to our projects and mission? Come share your...

  • Database Administrator

    2 weeks ago

    Montréal, QC, Canada American Iron and Metal Full time

    **Company Description** American Iron & Metal (AIM) is a family-owned company and recognized global leader in the metal recycling industry with more than 125 sites and 4000 employees worldwide. We have continued to prosper for the last eight decades thanks to the dedication of our employees and the ongoing trust and support of our customers. Become part of...

  • Database Administrator

    3 months ago

    Montréal, Canada American Iron and Metal Full time

    **Company Description** American Iron & Metal (AIM) is a family-owned company and recognized global leader in the metal recycling industry with more than 125 sites and 4000 employees worldwide. We have continued to prosper for the last eight decades thanks to the dedication of our employees and the ongoing trust and support of our customers. Become part of...

  • Database Administrator

    2 weeks ago

    Montréal-Est, Canada American Iron and Metal Full time

    Job DescriptionAs a Database Administrator, you will play a pivotal role in maintaining and evolving AIM's Data management and efficiency to support and enhance our core business operations. Your mission is to lead and contribute to transformational projects and ensure continuous service improvement, security, and operational reliability across our...

  • SQL Database Administrator

    4 weeks ago

    Montréal, QC, Canada CloudVital Full time

    We are looking for an experienced SQL Database Administrator to join our team! As a SQL Server Database Administrator you will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systemsThis is a long term position for a Database professional wanting to grow with the organization in a work culture...

  • Database Administrator

    3 months ago

    Montréal, Canada Cloudvital Technologies Full time

    We are hiring Infrastructure Database Administrator for one of the fast-growing dynamic companies! **Job Title**:Database Administrator **Job Location**:Montreal **Job Type**: Hybrid - **This is a Hybrid role with 3 days in office and 2 days remote**_ **Major Roles & Responsibilities**: 1. Database Infrastructure Engineering for stability and...

  • Database Administrator

    2 months ago

    Montréal-Est, Canada American Iron and Metal Full time

    Company Description American Iron & Metal (AIM) is a family-owned company and recognized global leader in the metal recycling industry with more than 125 sites and 4000 employees worldwide. We have continued to prosper for the last eight decades thanks to the dedication of our employees and the ongoing trust and support of our customers. Become part of team...

  • Database Administrator

    5 days ago

    Montréal-Est, Canada American Iron and Metal Full time

    Company DescriptionAmerican Iron & Metal (AIM) is a family-owned company and recognized global leader in the metal recycling industry with more than 125 sites and 4000 employees worldwide. We have continued to prosper for the last eight decades thanks to the dedication of our employees and the ongoing trust and support of our customers.Become part of team...

  • Database Administrator

    2 weeks ago

    Montréal-Est, Canada American Iron and Metal Full time

    Company DescriptionAmerican Iron & Metal (AIM) is a family-owned company and recognized global leader in the metal recycling industry with more than 125 sites and 4000 employees worldwide. We have continued to prosper for the last eight decades thanks to the dedication of our employees and the ongoing trust and support of our customers.Become part of team...

  • Database Administrator

    3 months ago

    Montréal, Canada Cloudvital Technologies Full time

    We are hiring Mainframe DB2 for one of the fast growing dynamic company Job Title: Database Administrator Job Location: Montreal **Job Type**: Hybrid - **This is a Hybrid role with 3 days in office and 2 days remote **_ **Required skills**: - Extensive hands-on experience in the use of z/OS and related software packages and tools - Extensive experience...

  • Database Administrator

    3 months ago

    Montréal, QC, Canada Genpact Full time

    With a startup spirit and 90,000+ curious and courageous minds, we have the expertise to go deep with the world’s biggest brands—and we have fun doing it! We dream in digital, dare in reality, and reinvent the ways companies work to make an impact far bigger than just our bottom line. We’re harnessing the power of technology and humanity to create...

  • Database Administrator

    3 months ago

    Montréal, QC, Canada Genpact Full time

    With a startup spirit and 90,000+ curious and courageous minds, we have the expertise to go deep with the world’s biggest brands—and we have fun doing it! We dream in digital, dare in reality, and reinvent the ways companies work to make an impact far bigger than just our bottom line. We’re harnessing the power of technology and humanity to create...

  • SQL Database Administrator with XML

    4 weeks ago

    Montréal, QC, Canada CloudVital Full time

    We are looking for an experienced SQL Database Administrator to join our team! As a SQL Server Database Administrator you will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systemsThis is a long term position for a Database professional wanting to grow with the organization in a work culture...

  • Database Administrator

    4 months ago

    Montréal, QC, Canada Genpact Full time

    With a startup spirit and 90,000+ curious and courageous minds, we have the expertise to go deep with the world’s biggest brands—and we have fun doing it! We dream in digital, dare in reality, and reinvent the ways companies work to make an impact far bigger than just our bottom line. We’re harnessing the power of technology and humanity to create...

  • Database Administrator

    4 months ago

    Montréal, QC, Canada Genpact Full time

    With a startup spirit and 90,000+ curious and courageous minds, we have the expertise to go deep with the world’s biggest brands—and we have fun doing it! We dream in digital, dare in reality, and reinvent the ways companies work to make an impact far bigger than just our bottom line. We’re harnessing the power of technology and humanity to create...

  • Database Systems Administrator

    1 week ago

    Montréal-Est, Quebec, Canada American Iron and Metal Full time

    About American Iron & MetalAmerican Iron & Metal (AIM) is a family-owned company and a global leader in the metal recycling industry with over 125 sites and 4,000 employees worldwide. We have continued to thrive for eight decades thanks to the dedication of our employees and the ongoing trust and support of our customers.Our BusinessWe are a multifaceted...

  • Database Systems Administrator

    1 week ago

    Montréal-Est, Quebec, Canada American Iron and Metal Full time

    About American Iron & MetalAmerican Iron & Metal (AIM) is a family-owned company and a global leader in the metal recycling industry with over 125 sites and 4,000 employees worldwide. We have continued to thrive for eight decades thanks to the dedication of our employees and the ongoing trust and support of our customers.Our BusinessWe are a multifaceted...