Principal Solution Engineer - Oracle EPM and Hyperion HFM
$120,000 - $150,380
ApplyPrincipal Solution Engineer - Oracle EPM and Hyperion HFM
Posted 18 days ago
SENIORITY
Lead
SALARY
$120,000 - $150,380
About the role
- Provide Oracle Best Practice knowledge to aid in the design processes. He/She will perform the necessary configuration to convert the requirements into a business solution.
- Experience with all phases of implementation including business process blueprint, detailed design, configuration, testing, and support.
- Work with the business to gather requirements, develop proof of concepts for new technologies/solutions, and suggest business process improvisation to reduce complexity in custom application.
- Maintain a solutions roadmap that enables business outcomes and are able toF reliably forecast business needs in the 3-5 year horizon.
- Lead projects that execute against this roadmap. This includes development from concept through realization including enhancements, new modules / systems / solutions, quality improvements and productivity improvements.
- Manage and optimize data flows between Oracle EPM tools and source systems like SAP, leveraging tools such as FDMEE, Data Management, and EPM Automate.
- Act as the primary technical support for the EPBCS platform, resolving issues related to business rules, data loads, and matadata changes
- Perform monthly and yearly administration tasks, including metadata updates, dimension maintenance, data loads, and security provisioning.
- Monitor application performance, conduct routine maintenance, and ensure data integrity across all planning modules (Workforce, Capital, Projects, Financials).Manage metadata updates, security, and user provisioning, including coordinating with Oracle support for system upgrades and patching.
- Maintain and optimize data integration, mapping, and transformation activities using Oracle Data Management.
- Streamline data flow between EPBCS and ERP systems, specifically focusing on SAP and other third-party sources.
- Develop and enhance automation scripts using EPM Automate for nightly jobs, metadata updates, and data synchronization.
- Analyze and tune existing Business Rules, Calculation Scripts, and Essbase cubes to enhance performance, focusing on reducing calculation times.
- Identify and implement opportunities to leverage Groovy scripting for more complex, efficient business rules.
- Optimize data import/export processes for faster, more accurate forecasting cycles.
- Collaborate with FP&A and finance teams to gather requirements for enhancements, translating them into technical solutions.
- Support the creation of, and updates to, complex Web Forms, Dashboards, and Smart View reports.
- Bachelor's or master's degree in finance, Computer Science, Information Systems, or a related field.12+ years' hands-on experience in Oracle EPM Cloud implementations and support.
- Deep expertise in Oracle EPBCS/PBCS, Essbase (BSO/ASO), and Data Management.
- Proven experience integrating Oracle EPM and Hyperion HFM with SAP (via EPM Integration Agent or flat files) and other non-SAP systems. Proficiency in EPM Automate, Calculation Manager, and Groovy scripts.
- Strong understanding of financial planning, financial consolidation principles, GAAP/IFRS budgeting, forecasting, and reporting processes. Oracle EPM Cloud Certified Implementation Specialist is a plus. Experience implementing at least two full-cycle implementations.
- Work Environment
- Indoor Office Environment
- Join American Water...We Keep Life Flowing
Before you apply
Applying takes about a minute. These four things decide how fast it moves after that.
Your profile is current
It's what we read first. Occupations, seniority and locations matter more than a long history.
Two examples you can talk through
Not a portfolio — just two pieces of work where you can explain the decisions and what you'd change.
A number in mind
What you're on now and what would make you move. We negotiate better when we know both.
Your notice period
Employers plan around it, and it's the question that stalls offers most often.
Once you apply, someone reads it and calls you before anything reaches the employer — usually within two working days.
More like this
