Oracle Technical Lead - Hyperion - Assistant Director

At EY, we’re committed to shaping your future with confidence. Join us and help build a better working world through globally connected, diverse teams.

About the Role

This role requires extensive Oracle expertise to support the Global Planning & Budgeting portfolio. EPM systems, including Hyperion Planning, Essbase, and FDM, 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, and apply a strong understanding of multidimensional concepts.

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 leadership 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 while ensuring compliance with architectural principles, global product guidelines, and usability standards.
• Provide support and documentation to assist in sustaining the project during transition to production.
• Adhere to Application Engineering methodologies, standards, and code reviews; provide feedback on these when appropriate.
• Identify potential points of contention for missed activities and notify project leadership with 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 to coordinate project deliverables.

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 to 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.
• Proficient 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 Windows environments and 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 requirements, including product design engineering, information security, code maintainability, and reliability.
• Manage multiple technical challenges across assigned projects using 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 Agile development methodology.

Qualifications

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

Schedule

Availability during U.S. Eastern Time business hours is required.

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, with rewards based on performance and recognition for the value you bring.
• Medical and dental coverage.
• Pension and 401(k) plans.
• Flexible vacation policy, allowing you to decide how much vacation time you need.
• Designated EY Paid Holidays, Winter/Summer breaks, Personal/Family Care, and other leaves of absence to support your well-being.

Join us in our team-led and leader-enabled hybrid model, where most people in external, client-serving roles work together in person 40-60% of the time over the course of an engagement, project, or year.