Oracle Technical Lead - Hyperion - Assistant Director

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. The position involves strong daily working knowledge of Oracle Cloud Enterprise Performance Management (EPM) processes and solutions, including Planning, FDMEE, and Hyperion Financial Reporting, with an exceptional understanding of multidimensional concepts and experience working on large and complex Essbase design and development.

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 while ensuring compliance with architectural principles, global product guidelines, and usability standards.
• Provide support and documentation to assist in sustaining the project during the transition to production.
• Adhere to application engineering methodologies, standards, and code reviews.
• Identify potential points of contention for missed activities and notify project leadership of remediation plans.
• Work closely with application engineering teams, solutions delivery, operations managers, and peer staff engineers to coordinate project deliverables.
• Proactively identify and address application engineering strengths, weaknesses, opportunities, and threats.
• Anticipate project issues, define problems, identify potential causes, and implement solutions.
• Apply judgment in implementing methodologies, processes, and practices for project requirements, including product design, information security, code maintainability, and reliability.

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.
• 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, 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.
• Proficient in setting up Hyperion Planning environments, developing solutions, and migrating 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 with batch scripting.

Qualifications

• 10-15 years of hands-on experience with Oracle EPM System, including Hyperion Planning, Essbase, and FDMEE.
• Prior experience with version 11.1.2.x Oracle EPM.
• Hyperion products certifications preferred.
• Strong knowledge of Essbase and Calc Scripts/Calc Manager.
• Hands-on experience with Smart View VBA.
• 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.

Education

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. The expectation is to work in a team-led and leader-enabled hybrid model, with in-person collaboration 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 U.S. 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 value brought to the business.
• Medical and dental coverage.
• Pension and 401(k) plans.
• Flexible vacation policy, allowing you to decide how much vacation time you need based on personal circumstances.
• Time off for designated EY Paid Holidays, Winter/Summer breaks, Personal/Family Care, and other leaves of absence to support physical, financial, and emotional well-being.

Work Location

Alpharetta, GA.