Essbase Migration Consultant

Company Description

Version 1 has celebrated 30 years in business and continues to be trusted by global brands to deliver technology and transformation solutions that drive customer success. Our deep expertise enables our customers to navigate the rapidly evolving technology landscape. We foster strong partnerships with global technology leaders including Microsoft, AWS, Oracle, Red Hat, OutSystems, Snowflake, ensuring that our customers are provided with the highest quality solutions and services. 

 We’re an award-winning employer reflecting how our employees are at the very heart of  what we do: 

• UK & Ireland's premier AWS, Microsoft & Oracle partner 
• 3300+ strong, €350/£300m revenue business 
• 10+ years as a Great Place to Work in Ireland & UK 
• Best Workplace for Women in the UK & Ireland by GPTW 
• Best Workplace for Wellbeing in the UK by GPTW 

We’re a core values driven company, we hire people who share our values, and we reward those who display and foster them, it’s deeply embedded within our DNA. Invest in us and we’ll invest in you!. 

Job Description

Role Overview

We are looking for a seasoned Essbase Consultant to drive the migration of on-premise Oracle Essbase / Hyperion applications to Oracle EPM Cloud / OCI. The ideal candidate will have strong hands-on experience in Essbase technologies and cloud transformation with proven delivery of multiple migration projects.

This role requires deep technical expertise, strong migration experience, and the ability to work closely with business and IT stakeholders to deliver a seamless cloud transition.

Key Responsibilities

1. Migration & Transformation

• Lead and execute end-to-end migration of Essbase/Hyperion applications from on-premise to Oracle EPM Cloud / OCI.
• Perform application assessment, environment discovery, and dependency analysis.
• Define migration strategies such as Lift & Shift, Re-architecture, or Hybrid approaches.
• Convert and optimize Essbase cubes (BSO/ASO) for cloud deployment.

2. Architecture & Solution Design

• Design scalable and high-performance cloud EPM architectures.
• Identify and implement cloud-native enhancements and best practices.
• Redesign calculation logic, data flows, and integrations as needed.

3. Development & Configuration

• Develop and maintain:
  • Essbase cubes (BSO/ASO)
  • Calc scripts and business rules
  • MaxL scripts and automation
• Configure:
  • Planning applications
  • Metadata, hierarchies, and dimensions
  • Security and access models

4. Data Integration & Validation

• Define and execute data migration, reconciliation, and validation plans.
• Implement integrations using FDMEE / Data Integration / ODI.
• Ensure data accuracy and completeness post-migration.

5. Testing & Deployment

• Lead SIT, UAT, and performance testing cycles.
• Troubleshoot and resolve migration and performance issues.
• Support cutover planning and go-live activities.

6. Performance Optimization

• Optimize cube performance, aggregation design, and calculation efficiency.
• Address performance bottlenecks in cloud environments.

7. Stakeholder Collaboration

• Work with Finance, IT, and business users to gather and validate requirements.
• Provide solution recommendations and technical guidance.
• Communicate risks, timelines, and progress effectively.

8. Documentation & Post-Go-Live Support

• Prepare detailed technical and migration documentation.
• Provide post-migration hypercare and production support.
• Conduct knowledge transfer sessions.

Qualifications

Mandatory Requirements

• 7+ years of experience in Essbase / Hyperion / Oracle EPM.
• Minimum 2 end-to-end Essbase / Hyperion to EPM Cloud migration implementations (MANDATORY).
• Strong hands-on experience with:
  • Essbase (BSO & ASO)
  • Hyperion Planning / EPM Suite
  • Oracle EPM Cloud (EPBCS / PBCS / FCCS)
• Proven expertise in:
  • Migration strategies, tools, and LCM
  • Data migration and reconciliation
• Strong experience in:
  • Calc scripts, MaxL, and business rules
  • Data integration tools (FDMEE / ODI / Data Integration)

Preferred Skills

• Experience with:
  • Groovy scripting and REST APIs in EPM Cloud
  • OCI architecture and deployment
• Familiarity with:
  • Agile / DevOps methodologies in EPM implementations
• Oracle certifications in:
  • Essbase / Oracle EPM Cloud

Soft Skills

• Strong problem-solving and analytical thinking
• Excellent communication and stakeholder management
• Ability to lead modules independently and mentor junior team members

Education

• Bachelor’s degree in Computer Science, Information Systems, Finance, or related field.

Success Criteria

• Successful delivery of cloud migration projects with minimal disruption
• Improved system performance post-migration
• High stakeholder satisfaction and adoption

Additional Information

Why Version 1? 

 At Version 1, we believe in providing our employees with a comprehensive benefits package that prioritises their wellbeing, professional growth, and financial stability. 

• Share in our success with our Quarterly Performance-Related Profit Share Scheme, where employees collectively benefit from a share of our company's profits 
• Strong Career Progression & mentorship coaching through our Strength in Balance & Leadership schemes with a dedicated quarterly Pathways Career Development programme 
• Flexible/remote working, Version 1 is tremendously understanding of life events and people’s individual circumstances and offer flexibility to help achieve a healthy work life balance 
• Financial Wellbeing initiatives including; Pension, Private Healthcare Cover, Life Assurance, Financial advice and an Employee Discount scheme 
• Employee Wellbeing schemes including Gym Discounts, Bike to Work, Fitness classes, Mindfulness Workshops, Employee Assistance Programme and much more. Generous holiday allowance, enhanced maternity/paternity leave, marriage/civil partnership leave and special leave policies 
• Educational assistance, incentivised certifications, and accreditations, including AWS, Microsoft, Oracle, and Red Hat 
• Reward schemes including Version 1’s Annual Excellence Awards & ‘Call-Out’ platform. 
• Environment, Social and Community First initiatives allow you to get involved in local fundraising and development opportunities as part of fostering our diversity, inclusion and belonging schemes. 

And many more exciting benefits… drop us a note to find out more.    

Version 1 is an equal opportunities employer. 

We are committed to building a diverse, inclusive and respectful workplace where everyone feels valued and able to thrive. We welcome applications from people of all backgrounds, identities and lived experiences, and we value the different perspectives people bring including those shaped by disability and neurodiversity. 

We want every candidate to have a positive and accessible recruitment experience. If you need reasonable adjustments at any stage of the process, please contact your recruiter at Version 1. We will consider all requests carefully, respectfully and confidentially. 

Video links: 

https://www.youtube.com/watch?v=F_d3ELTH5zo 

#LI-EB1