Oracle EPM Solutions Architect

We are seeking an experienced Oracle EPM Solutions Architect to join our client’s dynamic technical team on a full-time remote basis. In this role, you will be responsible for designing, developing, optimizing, and maintaining global financial planning and accounting consolidation systems. You will play a key role in supporting the organization’s financial transformation by developing solutions that enhance planning, budgeting, forecasting, reporting, and consolidation processes.

Job Responsibilities

• Design and develop complex business rules using both Calculation Manager and Groovy scripting to meet business requirements.
• Automate data administration tasks using Python, Groovy, CDM APIs, and EPM Automate.
• Support multiple Planning and Consolidation applications within the Oracle EPM Cloud suite.
• Create and deliver innovative reporting solutions, including narrative reporting, management dashboards, financial reports, and KPIs.
• Optimize and tune the performance of Planning and Consolidation applications.
• Conduct system integration, performance, and user acceptance testing to ensure quality and efficiency.
• Collaborate with financial teams to translate business needs into technical solutions.
• Prepare and maintain comprehensive documentation, including design documents, test plans, training materials, and procedural guides.

Requirements

• 7+ years of experience in Oracle EPM (Hyperion Planning) design, development, and administration, including at least 3 years of experience with Oracle EPM Cloud (EPBCS, FCCS).
• In-depth understanding of Oracle EPM Cloud and on-premises Hyperion architecture, with experience in hybrid applications and financial modules.
• Strong proficiency in Groovy scripting, with a proven track record of writing complex code to optimize system functionality.
• Experience in integrating Oracle EPM with ERP systems such as JDE, SAP, NetSuite, and tools like Anaplan, and Snowflake.
• Expertise in financial reporting, including the creation of reports, charts, pivots, dashboards, books, and automated snapshot reports.
• Advanced skills in automation using SQL, batch scripting, and EPMAutomate for data loads and integrations.
• Experience with FDMEE/data management for automating data loads and managing integrations.
• Strong knowledge of SQL development, including stored procedures (PL/SQL), triggers, and queries.
• Ability to provide innovative solutions and proactively suggest best practices aligned with system functionality.
• A solid understanding of financial statements (Income Statement, Balance Sheet, and Cash Flow) and key financial KPIs.

Preferred Qualifications:

• Experience in financial transformation initiatives and a strong background in FP&A (Financial Planning & Analysis).
• Familiarity with corporate performance management (CPM) and enterprise performance management (EPM) processes.
• Strong analytical and problem-solving skills, with the ability to translate complex business needs into technical solutions.

System Requirements

• At least 15mbps for the main internet and at least 10mbps for backup
• A desktop or laptop that has an i5 processor with at least 8 GB RAM and an i3 processor for backup
• Note: Back-ups should still be able to function when there is a power interruption
• A webcam
• Noise-canceling USB Headset
• Quiet, Dedicated Home Office
• Smartphone

Benefits

• Join Our Dynamic Team: Experience our fun, inclusive, innovative culture that values your unique contributions and supports your professional growth.
• Embrace the Opportunities: Seize daily chances to learn, innovate, and excel. Make a real impact in your field.
• Limitless Career Growth: Unlock a world of possibilities and resources to propel your career forward.
• Fast-Paced Thrills: Thrive in a high-energy, engaging atmosphere. Embrace challenges and reap stimulating rewards.
• Flexibility, Your Way: Embrace the freedom to work from home or any location of your choice. Create your ideal work environment.
• Work-Life Balance at Its Best: Say goodbye to stressful commutes and hello to quality time with loved ones. Achieve a healthy work-life integration to perform at your best.