Request ID: 107563-1 Title: Oracle Hyperion Architect Essbase 21C Migration Locations: Auburn Hills, MI Duration: 6+ Months Pay Range: $55.00 - $63/Hour on W2 /C2C (All inclusive) Experience: 07+ Years
We are seeking an experienced Oracle Hyperion Essbase 21C Migration Architect to lead the architecture, design, and migration of Oracle Essbase environments from legacy versions to Essbase 21C on Azure Cloud. The ideal candidate will have deep expertise in Oracle Essbase, Hyperion Planning, cube architecture, migration strategies, performance optimization, and cloud transformation initiatives.
The candidate will serve as the technical authority for the Hyperion-to-Azure transformation, leading migration activities, optimizing Essbase environments, and collaborating with finance, infrastructure, security, and cloud teams to deliver a scalable and high-performing EPM platform.
Key Responsibilities:
Essbase 21C Architecture & Migration
Design and govern the target-state architecture for Oracle Essbase 21C on Azure IaaS/PaaS.
Lead migration initiatives from:
Essbase 11.x / 19c to Essbase 21C
On-premises Hyperion environments to Azure Cloud
Assess existing Essbase applications and cubes (BSO/ASO) and define:
Migration strategy
Conversion approach
Object remediation plans
Compatibility assessment with Essbase 21C features
Oversee migration of:
Applications
Cubes
Outlines
Calc scripts
MaxL scripts
MDX scripts
Data loads
Security filters
Substitution variables
Cube Design & Performance Optimization
Design and optimize Essbase BSO and ASO cube architectures.
Analyze existing cube structures and recommend redesign strategies for Essbase 21C performance improvements.
Optimize:
Aggregation strategies
Memory and cache configurations
Parallel processing
Calculation performance
Lead performance benchmarking activities before and after migration.
Integration & Ecosystem Support
Support integrations with:
Hyperion Planning
Hyperion Financial Management (HFM)
Financial Consolidation and Close Cloud Service (FCCS)
Oracle EBS/Fusion ERP systems
Coordinate reporting integrations with:
Smart View
Financial Reporting tools
Support hybrid cloud/on-premises coexistence strategies where required.
Leadership & Stakeholder Management
Act as the technical SME and authority for Hyperion-Essbase-to-Azure transformation initiatives.
Collaborate with:
Finance teams
Infrastructure teams
Security teams
Azure Cloud Architects
Application teams
Mentor Hyperion developers and cloud engineers.
Provide migration estimates, technical recommendations, risk assessments, and mitigation strategies.
Required Skills & Qualifications:
Strong hands-on experience with Oracle Essbase 21C.
Extensive experience with Oracle Hyperion and Essbase architecture.
Expertise in:
Essbase BSO cube design
Essbase ASO cube design
MaxL scripting
MDX queries
Calculation scripts
Essbase REST APIs
Experience migrating:
Essbase 11.x/19c environments to Essbase 21C
On-premises Essbase environments to Azure Cloud
Strong understanding of Hyperion Planning and HFM.
Experience with Oracle EPM ecosystem and enterprise financial applications.
Experience with Azure cloud architecture (IaaS/PaaS).
Strong knowledge of cube performance tuning and optimization techniques.
Experience leading technical migration projects and working with cross-functional teams.
Strong communication, leadership, and stakeholder management skills.