Principal Solution Engineer - Oracle EPM and Hyperion HFM

Principal Solution Engineer - Oracle EPM and Hyperion HFM

Requisition : 109877

Posting

Start Date:

5/6/26

Salary Range: $120,000 - $150,380

The base salary range represents a good faith salary range for this position. This position is eligible for annual incentive pay and has the opportunity for continued salary growth. If you are hired, your base salary compensation will be determined based on factors such as market, geography, skills, education and/or experience. At American Water, we are committed to pay equity. In addition to compensation, you will be offered a comprehensive benefits package including 401(k), Defined Contribution Plan, Employee Stock Purchase Plan, medical, prescription, dental and vision coverage, plus disability, paid time off, life insurance, voluntary benefits, health and wellness programs and more.

American Water is also proud to offer employees learning opportunities and work experiences to grow professionally.

Looking for an experienced Oracle EPM (Enterprise Planning and Budgeting Cloud Service) and Hyperion HFM Consolidation professional to support, maintain, and optimize our existing EPBCS and Hyperion Financial Management (HFM) systems. The ideal candidate will be responsible for ensuring the stability, performance, and efficiency of financial planning models and Hyperion Financial Management (HFM). This role requires technical expertise in EPM Automate, Data Management, and complex integrations with SAP (S/4

HANA and/or ECC) and other non‑SAP systems. Will serve as the primary technical contact for both Oracle system including EPBCS and on‑prem Hyperion HFM, ensuring alignment with the ongoing transformation program and supporting any mergers and acquisitions activities as required.

• Provide Oracle Best Practice knowledge to aid in the design processes. Perform the necessary configuration to convert 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 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 metadata 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,…