Oracle Technical Lead - Hyperion - Assistant Director

At EY, we’re committed to shaping your future with confidence. We help you succeed in a globally connected environment with diverse teams and support your career growth. Join us to build a better working world.

About the Role

This role requires extensive Oracle expertise to support the Global Planning & Budgeting portfolio. The position focuses on EPM systems, including Hyperion Planning, Essbase, and FDM, which represent more than 80% of the workload. You will work with Oracle Cloud Enterprise Performance Management (EPM) processes and solutions, including Planning, FDMEE, and Hyperion Financial Reporting.

Responsibilities

• Translate detailed business requirements, design deliverables, and solution architecture into comprehensive technical specifications.
• Maintain effective and consistent communication within the team, with peers, leadership, and other IT groups. Proactively raise issues to project managers and leads when necessary.
• Produce high-quality application engineering deliverables in accordance with project timelines.
• Build and unit test projects to detailed design specifications.
• Provide thought leadership and technical guidance to engineering staff.
• Lead a team of developers across multiple locations and time zones.
• Develop and deliver technical systems.
• Ensure compliance with architectural principles, global product guidelines, usability standards, and related requirements.
• Provide support and documentation to assist in sustaining the project during the transition to production.
• Adhere to application engineering methodologies, standards, and code reviews.
• Provide feedback on application engineering methodologies, standards, and leading practices.
• Identify potential points of contention for missed activities and notify project leadership of situations and remediation plans.
• Minimize technical exposure and risk on projects.
• Work closely with Application Engineering Team/Group Leads, Technical Leads, Solutions Delivery, Operations managers, and Peer Staff Engineers.

Requirements

• More than 13 years of proven, hands-on experience gathering requirements and designing, developing, customizing, testing, and implementing Oracle Cloud services, including Oracle Cloud Infrastructure (OCI) IaaS/PaaS, Essbase databases, and Enterprise Planning and Budgeting Cloud Service within the Oracle EPM SaaS suite.
• Well-versed with Oracle Hyperion Planning 11.1.2.x, FDMEE, and Hyperion Financial Reports.
• Exceptional understanding of multidimensional concepts.
• Experience working on large and complex Essbase design and development.
• Expert-level experience in all areas of Essbase such as outline design, member formula, Calc script, MaxL script, Report script, load rule, ASO, and BSO storage.
• Ability to create batch scripts using epmautomate, CLI, MAXL.
• Build custom scripting using Rest-API, Groovy, and Java.
• Create pipelines to trigger hourly, weekly, and nightly schedules.
• Create custom Groovy scripting for flex forms (EPBCS).
• Create Groovy Business Rules to trigger jobs on OCI Essbase.
• Extensive experience in developing Hyperion Forms, Task Lists, menus, and smart lists.
• Extensive experience implementing Oracle EPM solutions globally.
• Extensive business process experience in Financial Planning & Forecasting.
• Extensive understanding of financial statements, budgeting, forecasting processes, and consolidation processes.
• Exposure in supporting budgeting activities like Annual budgets and forecasts.
• Clear understanding of a full lifecycle development in a Hyperion Planning environment, including design, development, and maintenance of Essbase databases.
• Experience in process/technical optimization of Hyperion Planning and Essbase-based processes.
• Well-versed in setting up Hyperion Planning environments, developing Hyperion Planning solutions, and migration to production and non-production environments.
• Proficient in SQL Server areas such as writing complex stored procedures, schema design, and SSIS packages.
• Intermediate, firsthand experience with the Excel Essbase Add-in, Smart View VBA, and the Essbase API.
• Experience in Hyperion Financial Reporting.
• Experience working in a Windows environment and experience in batch scripting.

Analytical/Decision Making Responsibilities

• Proactively identify and address application engineering strengths, weaknesses, opportunities, and threats.
• Anticipate project issues before they occur; define the problem; identify potential causes; work with the team to identify solutions; select and implement the most appropriate solution.
• Apply judgment in implementing application engineering methodologies, processes, and practices to specific project/program requirements.
• Manage multiple technical challenges across assigned projects with strong analytical and critical-thinking skills.

Skills

• 10-15 years’ hands-on experience with Oracle EPM System including Hyperion Planning, Essbase, FDMEE.
• Prior experience with version 11.1.2.x Oracle EPM.
• Hyperion products certifications preferred.
• Strong knowledge of Essbase and Calc Scripts/Calc Manager.
• Experience in developing Hyperion Forms, Task Lists, menus, and smart lists.
• Hands-on experience with Smart View VBA.
• Experience in Hyperion Financial Reporting.
• Strong ability to understand finance and accounting principles.
• Experience working with large Hyperion Application Development and support projects.
• Experience working with global implementations of Oracle EPM.
• Solid interpersonal communication and organizational skills to operate as a contributing member of global technical teams.
• Strong technical skills in designing, developing, debugging, documenting, and implementing applications.
• Strong knowledge and experience in the Agile development methodology.

Qualifications

A degree in Computer Science or a related discipline or equivalent work experience. Oracle Certifications are preferred.

Schedule

Availability during U.S. Eastern Time business hours is required. This role follows a team-led and leader-enabled hybrid model, with an expectation to work in person 40-60% of the time over the course of an engagement, project, or year.

Pay

The base salary range for this job in all geographic locations in the US is $122,200 to $228,600. The base salary range for New York City Metro Area, Washington State, and California (excluding Sacramento) is $146,700 to $259,700. Individual salaries are determined by factors including education, experience, knowledge, skills, and geography.

Benefits

• Comprehensive compensation and benefits package.
• Medical and dental coverage.
• Pension and 401(k) plans.
• Flexible vacation policy based on personal circumstances.
• Designated EY Paid Holidays, Winter/Summer breaks, Personal/Family Care, and other leaves of absence to support well-being.