Oracle Technical Lead - Hyperion - Assistant Director
Ernst and Young1 month ago
Base Salary
$122k - $229k/yr
Responsibilities
- Translate business requirements, design deliverables, and solution architecture into comprehensive technical specifications.
- Design, develop, customize, test, implement, and maintain Oracle EPM and Hyperion Planning applications.
- Develop Essbase outlines, member formulas, Calc scripts, MaxL scripts, Report scripts, load rules, and ASO/BSO storage solutions.
- Create batch, Groovy, Java, REST API, and pipeline-based automation for scheduled jobs and Oracle EPM processes.
- Lead developers across multiple locations and time zones while providing technical guidance and thought leadership.
- Deliver application engineering work according to project timelines, architectural principles, product guidelines, usability standards, and quality requirements.
- Support documentation and transition activities for production, including Hyperion environment setup, migration, monitoring, and ongoing support.
- Identify project risks, technical issues, missed activities, and remediation plans, and communicate them to project and technical leadership.
- Apply application engineering methodologies and practices related to product design, information security, maintainability, and reliability.
- Collaborate with engineering leads, technical leads, solution delivery, operations managers, and peer staff engineers on global implementations.
Requirements
- More than 13 years of hands-on experience gathering requirements and designing, developing, customizing, testing, and implementing Oracle Cloud and Oracle EPM solutions.
- 10–15 years of hands-on Oracle EPM System experience, including Hyperion Planning, Essbase, and FDMEE.
- Experience with Oracle Cloud Infrastructure IaaS/PaaS, Essbase databases, and Enterprise Planning and Budgeting Cloud Service.
- Expert-level experience with Essbase outline design, member formulas, Calc scripts, MaxL scripts, Report scripts, load rules, and ASO/BSO storage.
- Experience with Hyperion Planning 11.1.2.x, Hyperion Financial Reporting, Hyperion Forms, Task Lists, menus, smart lists, and full lifecycle development.
- Experience creating epmautomate, CLI, MAXL, Groovy, Java, REST API, and batch scripts, including Groovy business rules and flex-form scripting.
- Experience creating scheduled pipelines and automating hourly, weekly, and nightly jobs.
- Experience with global Oracle EPM implementations and financial planning, forecasting, budgeting, and consolidation processes.
- Proficiency with SQL Server, complex stored procedures, schema design, SSIS packages, Windows environments, and batch scripting.
- Intermediate hands-on experience with the Excel Essbase Add-in, Smart View VBA, and the Essbase API.
- Experience with large Hyperion application development and support projects and with optimizing Hyperion Planning and Essbase processes.
- Strong technical skills in designing, developing, debugging, documenting, and implementing applications.
- Strong understanding of finance and accounting principles, multidimensional concepts, and financial statements.
- Strong analytical, critical-thinking, communication, organizational, and coordination skills for global technical teams.
- Strong knowledge of Agile development methodology.
- A degree in Computer Science or a related discipline, or equivalent work experience.
- Oracle certifications are preferred.
Benefits
- Base salary range is $122,200 to $228,600 for U.S. geographic locations; higher ranges apply to New York City Metro Area, Washington State, and California excluding Sacramento.
- Benefits include medical and dental coverage, pension and 401(k) plans, paid time off, EY paid holidays, winter and summer breaks, personal and family care leave, and other leaves of absence.
- The role is based in Alpharetta, Georgia, requires availability during U.S. Eastern Time business hours, and follows a hybrid model with most client-serving employees working in person 40–60% of the time.
- Flexible vacation is provided based on individual circumstances.
- Applications are accepted on an ongoing basis.
About Ernst and Young
Ernst & Young (EY) provides audit/assurance, tax, consulting, strategy and transactions services to enterprises, financial institutions, and public‑sector clients. Structured as a global network of partner‑owned member firms, it sells professional services on a fee basis, including a dedicated Financial Services Organization for banking, insurance, and capital markets. Headquartered in London, EY was formed in 1989 from the merger of Ernst & Whinney and Arthur Young, and operates in 150+ countries.