EPBCS Analyst

Job Description

Key Responsibilities 

EPBCS Application Design & Development 

• Design and implement EPBCS applications covering: 
• Financial Planning (Revenue, Expense, OPEX, CAPEX) 
• Workforce Planning 
• Capital Asset Planning 
• Profitability and cost allocation models 
• Configure: 
• Cubes, dimensions, hierarchies, and metadata 
• Forms, dashboards, and task lists 
• Business rules and validation logic 

Business Rule Development & Automation 

• Develop and maintain calculation logic using: 
• Business Rules (Calculation Manager) 
• Groovy scripts (for validation and automation) 
• Implement: 
• Allocations 
• Driver-based planning 
• Currency conversions 
• Forecasting models 
• Optimize calculation performance and data processing efficiency. 

Data Integration & Management 

• Manage data integrations between EPBCS and source systems (ERP, data warehouses). 
• Work with: 
• Data Management (FDMEE / EPM Data Integration) 
• Smart Push / Data Maps 
• REST APIs (where applicable) 
• Perform data validation, reconciliation, and troubleshooting. 

Reporting & Analysis 

• Build and support financial reports and dashboards using: 
• Smart View (Excel-based reporting) 
• Management reports / Financial reporting tools 
• Support ad hoc analysis for FP&A teams and business users. 

Production Support & Enhancements 

• Provide L2/L3 support for EPBCS applications. 
• Troubleshoot application, data, and performance issues. 
• Support monthly/quarterly budgeting and forecasting cycles. 
• Handle enhancements, change requests, and system improvements. 

Business Collaboration 

• Work closely with finance, FP&A, accounting, and business stakeholders. 
• Translate business requirements into EPBCS design and configurations. 
• Facilitate requirement gathering, solution design, and UAT support. 

Testing & Deployment 

• Lead testing activities, including: 
• Unit testing 
• System integration testing 
• UAT support 
• Manage migrations across environments (DEV / TEST / PROD). 
• Ensure proper documentation of releases and changes. 

Governance & Documentation 

• Maintain functional and technical design documents. 
• Ensure compliance with financial governance and audit requirements. 
• Support change management and release processes. 

Qualifications

Qualifications

Required Skills & Qualifications 

• Bachelor's degree in IT, computer science, finance, accounting, or a related field. 
• 35 years of experience in Oracle EPM / Hyperion / EPBCS implementations. 
• Strong hands-on experience in: 
• EPBCS configuration and administration 
• Financial planning and forecasting models 
• Business rules and calculation logic 
• Strong understanding of FP&A processes (budgeting, forecasting, variance analysis). 
• Experience with: 
• Data integration tools (FDMEE / Data Management) 
• Smart View reporting 
• Metadata and dimensional modeling 

Preferred Skills 

• Experience with **Oracle Enterprise Planning and Budgeting Cloud Service implementations**. 
• Knowledge of Groovy scripting in EPM Cloud. 
• Exposure to Essbase architecture and optimization. 
• Experience with REST APIs and automation. 
• Strong Excel and financial modeling skills. 
• Experience in Agile project environments. 

Soft Skills 

• Strong analytical and problem-solving skills 
• Excellent communication with finance and IT stakeholders 
• Ability to handle financial close and planning cycles under deadlines 
• Strong attention to detail and accuracy 
• Stakeholder management and requirement translation skills