Oracle EPM Developer
Location: Remote
Duration: 12+ Months
Job Description
We are seeking an experienced Oracle EPM Developer to be a critical technical resource embedded within Production Support Team (PST) supporting a financial client. This role is responsible for the administration, configuration, and day-to-day support of Oracle EPM Cloud environment — encompassing EPBCS, PCMCS, EDMCS, Financial Reporting and Narrative Reporting modules. The consultant is directly engaged in month-end financial close cycle, monthly forecasting, and annual budgeting processes, working closely with the FP&A team and key business stakeholders.
What You’ll Do
Month-End Financial Close Support:
- Oversee EPM pre-close activities and prepare systems for daily actuals feeds
- Ensure accurate and timely data loads from Oracle ERP, OFSAA, and ADP into respective EPM modules
- Perform source/target data validation and resolve data discrepancy queries
- Resolve interface issues between EDMCS (central hierarchy system) and downstream EPM, ERP, EPBCS, and PCMCS systems
- Support Smart View and ad-hoc reporting requests from business teams
Monthly Forecast Cycle:
- Collaborate with FP&A to execute forecast adjustments across P&L, NIR, expenses, balance sheet, rate models, workforce and CAPEX models
- Perform monthly PCMCS forecast allocations using actual headcount data and push allocated figures back to EPBCS
- Handle ad-hoc requests related to user access, system issues, and data anomalies throughout the forecast cycle
Annual Budget Cycle:
- Open annual budget cycles and execute five-year financial model inputs and updates
- Load and maintain employee data in the budget environment; configure new/future hire setups per FP&A and HR inputs
- Perform PCMCS budget allocations using budget headcount data and publish back to EPBCS.
System Administration & Maintenance:
- Schedule, monitor, and troubleshoot daily loads (data & Metadata), business rules, interfaces, and automation jobs across all EPM modules
- Review and apply monthly Oracle Cloud updates; ensure continued stability and optimal performance of all EPM applications
- Maintain system documentation and support audit requests as required.
BAU Project Support:
- Support PCMCS, Workforce, CAPEX and Projects module integrations as part of upcoming BAU initiatives
- Drive automation of new EPM processes in alignment with CAI's PST roadmap and clients strategic objectives
What You’ll Need
Required:
- Bachelor’s or Associate’s Degree in Information Technology or related field, or equivalent experience
- 5+ years of hands-on experience with Custom and OOTB Oracle EPM Cloud (EPBCS, PCMCS, EDMCS, Financial Reporting and Narrative reporting) Modules
- Demonstrated experience supporting month-end close, forecasting, and annual budgeting processes in a financial services environment
- Proficiency in data management, data integrations, and Rest API
- Strong understanding of Oracle ERP integration, OFSAA data feeds, and ADP payroll interfaces with EPM modules
- Experience administering and troubleshooting Oracle Cloud EPM automation jobs and business rules and Groovy Scripting
- Solid analytical skills with the ability to perform data validation and root cause analysis for data discrepancies
- Excellent written and verbal communication skills; ability to engage effectively with FP&A, HR, and IT stakeholders
- Familiarity with banking operations and regulations to ensure compliance
- Understanding of financial data and its implications for operational and strategic decision-making
- Familiarity with ITSM ticketing tools such as ServiceNow and working knowledge of ITIL framework principles
- Experience with Unix/Linux command line, SQL Server, and Windows Server environments
- Strong technical writing skills with the ability to create comprehensive process and system documentation
- Ability to manage client relationships and handle escalated or difficult stakeholder interactions effectively
- Understanding of security protocols and practices, particularly within banking and regulated financial environments
- Willingness to learn and adapt to new technologies, platforms, and evolving system requirements
Preferred:
- Experience working in a managed services or production support capacity (ITSM/ServiceNow familiarity a plus)
- Oracle EPM Cloud certification or equivalent Oracle partner credentials
- Knowledge of FP&A processes within banking or financial services
- Familiarity with PCMCS profitability allocations and workforce planning modules
- Prior experience supporting BAU projects and automating EPM workflows
Physical Demands
- Ability to safely and successfully perform the essential job functions consistent with the ADA and other federal, state and local standards
- Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings, etc.
- Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard and monitor