Oracle Technical Lead - Hyperion - Assistant Director

At EY, we’re all in to shape your future with confidence. We’ll help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go. Join EY and help to build a better working world.

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. Strong daily working knowledge of Oracle Cloud Enterprise Performance Management (EPM) processes and solutions, including Planning, FDMEE, and Hyperion Financial Reporting, is essential.

Responsibilities

• Translate detailed business requirements, design deliverables, and solution architecture into comprehensive technical specifications.
• Maintain effective and consistent communication within the team, with peers, the leadership team, and peers in other IT groups. Proactively raise issues to Project Manager, Team, and Group Leads when necessary.
• Produce high-quality application engineering deliverables in accordance with the project timeline.
• Build and unit evaluate a project to detailed design specifications.
• Provide thought leadership and technical guidance to engineering staff.
• Lead a team of developers across multiple locations/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 where necessary.
• Adhere to Application Engineering methodologies, standards, and code reviews.
• Provide feedback regarding application engineering methodologies, standards, and leading practices when appropriate.
• Identify potential points of contention for missed activities and notify project leadership of the situation and remediation plan.
• Minimize technical exposure and risk on projects.
• Work closely with Application Engineering Team/Group Leads and Technical Leads to understand strategic goals/objectives and translate them into actionable plans.
• Collaborate with Solutions Delivery to build solutions as part of end-to-end projects.
• Support Operations managers effectively and efficiently during the transition phase.
• Coordinate project deliverables on projects involving multiple 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.
• 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 prod and non-prod 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.
• Proactively 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 requirements of projects/programs which may include product design engineering, information security, code maintainability, and reliability.
• Strong analytical and critical-thinking skills to manage multiple technical challenges across assigned projects.

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.
• Working with large Hyperion Application Development and support projects.
• Experience working with Global implementations of Oracle EPM.
• Solid interpersonal communication and organizational skills required to operate as a contributing member of global technical teams that deliver quality services.
• Strong technical skills designing, developing, debugging, documenting, and implementing applications.
• Strong knowledge and experience in the Agile development methodology.

Qualifications

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

Location

Alpharetta, GA with availability during U.S. Eastern Time business hours 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 within those ranges are determined through a wide variety of factors including but not limited to education, experience, knowledge, skills, and geography.

Benefits

• Comprehensive compensation and benefits package where you’ll be rewarded based on your performance and recognized for the value you bring to the business.
• Medical and dental coverage.
• Pension and 401(k) plans.
• A wide range of paid time off options, including flexible vacation policy, designated EY Paid Holidays, Winter/Summer breaks, Personal/Family Care, and other leaves of absence when needed to support your physical, financial, and emotional well-being.

Schedule

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