Oracle Technical Lead - Hyperion - Assistant Director

Ernst & Young Oman; Buffalo (NY); On-site; USD 122,000 - 260,000; Full time

Benefits offered by this job

Hybrid work model

Medical and dental coverage

Pension and 401(k)

Job summary

EY is seeking an experienced ET role focused on Oracle Cloud EPM, including Hyperion Planning and Essbase, to support a global planning and budgeting portfolio.

Responsibilities include translating business requirements into technical specs, delivering quality engineering work, and guiding a team across multiple time zones. EY emphasizes collaboration, architecture compliance, and ongoing client support.

Qualifications

• 13+ years of Oracle Cloud EPM experience including OCI IaaS/PaaS and Essbase.
• Experience with Hyperion Planning 11.1.2.x, FDMEE and Hyperion Financial Reports.
• Strong understanding of multidimensional concepts.
• Experience with large/complex Essbase design and development.
• Proficient in batch scripting and automation tools.

Responsibilities

• Translate business requirements and design deliverables into technical specs.
• Maintain clear communication within team and leadership; raise issues to PM as needed.
• Produce high-quality application engineering deliverables per project timeline.
• Build and evaluate projects to detailed design specs.
• Provide technical guidance to engineering staff.
• Lead a team of developers across multiple locations/time zones.
• Develop and deliver technical systems with governance and standards.

Skills

Oracle EPM System

Hyperion Planning

Essbase

FDMEE

Hyperion Financial Reporting

SQL Server

Batch scripting

Groovy/Java scripting

REST API

Smart View VBA

Education

Bachelor's degree in Computer Science or related discipline

Oracle Certifications

Tools

MAXL

EPMAutomate

REST API

Job description

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.

Role Summary:

• This ET 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.

• Exceptional understanding of multidimensional concepts.

• Experience working on large and complex Essbase design and development.

Job Summary:

A successful candidate is responsible for:

• Translating detailed business requirements, design deliverables, and solution architecture into comprehensive technical specifications.

• Maintaining effective and consistent communication within the team, with peers, the leadership team and the peers in other IT groups. Proactively raise issues to Project Manager, Team and Group Leads when necessary.

• Producing high quality application engineering deliverables in accordance with the project timeline.

• Building and unit evaluating a project to detailed design specifications.

• Providing thought leadership and technical guidance to engineering staff.

• Leading a team of developers across multiple locations / time zones.

Essential Requirements for a role in PB development:

• 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. Candidate must be familiar and able 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 EssbaseExtensive experience in developing Hyperion Forms, Task Lists, menu, and smart lists.

• Extensive experience implementing Oracle EPM solutions globally.

• Extensive business process experience on Financial Planning & Forecasting

• Extensive understanding of financial statements, budgeting and forecasting process and consolidation process

• Exposure in supporting budgeting activities like Annual budgets, 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 package.

• 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 environment and experience in batch scripting.

Functions of the Job:

• 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.

• Adheres to Application Engineering methodologies, standards, code reviews.

• Provide feedback regarding application engineering methodologies, standards and leading practices when appropriate.

• Identifies potential points of contention for missed activities and notify project leadership of situation and remediation plan.

• Minimizes technical exposure and risk on projects.

• Work closely with:

• Application Engineering Team/Group Leads and Technical Leads to understand strategic goals/objectives and translate into actionable plans.

• Application Engineering Team/Group Leads and Technical Leads to successfully implement, use, and monitor EY initiatives.

• Solutions Delivery to build solutions as part of end-to-end projects.

• Operations managers to support the project effectively and efficiently during the transition phase.

• Peer Staff Engineers to properly coordinate project deliverables on projects involving multiple Staff Engineers.

Analytical/Decision Making Responsibilities:

• Proactively identifies and addresses application engineering strengths, weaknesses, opportunities, and threats.

• Proactively anticipates project issues before they occur; defines the problem; identifies potential causes; works with team to identify solutions; selects and implements most appropriate solution.

• Applies 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.

Technical Skills Required:

• 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, menu 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.

Education Requirements:

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

• Oracle Certifications

Preferred Work Location and Reason

Alpharetta, GA and availability during U.S. Eastern Time business hours is required.

What we offer you

The compensation ranges below are provided in order to comply with United States pay transparency laws. Other geographies will follow their local salary guidelines, which may not be a direct conversion of published US salary ranges. At EY, we’ll develop you with future-focused skills and equip you with world-class experiences. We’ll empower you in a flexible environment, and fuel you and your extraordinary talents in a diverse and inclusive culture of globally connected teams. Learn more .

• We offer a comprehensive compensation and benefits package where you’ll be rewarded based on your performance and recognized for the value you bring to the business. 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. In addition, our Total Rewards package includes medical and dental coverage, pension and 401(k) plans, and a wide range of paid time off options.

• 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.

• Under our flexible vacation policy, you’ll decide how much vacation time you need based on your own personal circumstances. You’ll also be granted time off for 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.

EY accepts applications for this position on an on-going basis.

EY focuses on high-ethical standards and integrity among its employees and expects all candidates to demonstrate these qualities.

EY | Building a better working world

EY is building a better working world by creating new value for clients, people, society and the planet, while building trust in capital markets.

Enabled by data, AI and advanced technology, EY teams help clients shape the future with confidence and develop answers for the most pressing issues of today and tomorrow.

EY teams work across a full spectrum of services in assurance, consulting, tax, strategy and transactions. Fueled by sector insights, a globally connected, multi-disciplinary network and diverse ecosystem partners, EY teams can provide services in more than 150 countries and territories.

EY provides equal employment opportunities to applicants and employees without regard to race, color, religion, age, sex, sexual orientation, gender identity/expression, pregnancy, genetic information, national origin, protected veteran status, disability status, or any other legally protected basis, including arrest and conviction records, in accordance with applicable law.

EY is committed to providing reasonable accommodation to qualified individuals with disabilities including veterans with disabilities. If you have a disability and either need assistance applying online or need to request an accommodation during any part of the application process, please call 1-800-EY-HELP3, select Option 2 for candidate related inquiries, then select Option 1 for candidate queries and finally select Option 2 for candidates with an inquiry which will route you to EY’s Talent Shared Services Team (TSS) or email the TSS at [e-mail] .