Principal Solution Engineer Oracle EPM and Hyperion HFM

Share Our Purpose. Be Yourself. Feel Valued. People are the heart of our business. As an American Water employee, you will be offered a competitive salary and health benefits package, along with opportunities to develop, grow, and evolve your career. Our benefits packages focus on key areas such as health & wellness, emotional & well-being, and savings for current & future goals. We are Beautifully Different. We strongly believe having diversity across our company makes us more successful and helps us provide essential services to our customers. We are stronger because we embrace different ideas, viewpoints, experiences, and backgrounds. American Water is the best choice for your next role! Click here for more information on our inclusion, diversity, and equity journey. About American Water American Water (NYSE: AWK) is the largest regulated water and wastewater utility company in the United States. With a history dating back to 1886, We Keep Life Flowing® by providing safe, clean, reliable and affordable drinking water and wastewater services to more than 14 million people across 14 regulated jurisdictions and 18 military installations. American Water’s 6,500 talented professionals leverage their significant expertise and the company’s national size and scale to achieve excellent outcomes for the benefit of customers, employees, investors and other stakeholders. As one of the fastest growing utilities in the U.S., American Water expects to invest $30 to $34 billion in infrastructure repairs and replacement, system resiliency and regulated acquisitions over the next 10 years. The company has a long-standing history of executing its core operations, aligned with sustainable best practices, through its commitments to safety, affordability, customer service, protecting the environment, an inclusive workforce and strengthening communities. American Water has been recognized on the 2023 Bloomberg Gender-Equality Indexfor the fifth consecutive year, ranked 18th on Barron’s 100 Most Sustainable U.S. Companies 2023 List, earned the U.S. Department of Homeland Security SAFETY Act designation and U.S. Environmental Protection Agency’s WaterSense® Excellence Award, among additional state, local and national recognitions. For more information, visit amwater.com and join American Water on LinkedIn, Facebook, Twitter and Instagram. Primary Role 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/4HANA 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. Key Accountabilities

• 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.Knowledge/Skills
• Ability to serve as a liaison between technical, quality assurance and non-technical stakeholders throughout the development and deployment process.
• Ability to create and maintain testing scripts.
• Experience with creating training materials and assisting with user orientation and training.
• Good communication and interpersonal skills to collaborate with business stakeholders and development teams and to make project presentations.
• Excellent time-management skills and ability to plan ahead for scheduled tasks.
• Versatile, dynamic, demonstrates initiative, results oriented, flexible and able to work under tight deadlines.
• Flexibility to adjust to multiple demands, shifting priorities, ambiguity, and rapid change.
• Utility Industry experience is a Plus.

Experience/Education

• 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

• Up to 9.25% employer retirement contribution, including a 4% 401(k) match and an additional 5.25% employer contribution after a one‑year vesting period
• Eligibility for the American Water Annual Performance Program
• Comprehensive medical, dental, vision, and prescription coverage starting the first of the month following your start date
• Benefit previews available at americanwaterbenefits.com (Non‑Union Employee tab)
• Hybrid work model offering autonomy and flexibility in how work gets done
• A collaborative, purpose‑driven culture with colleagues who care deeply about water and the environment
• Up to $10,000 in qualified tuition reimbursement to support ongoing education