Oracle EPM Data Integration Specialist

Athena Institute of Business and Technology (AIBT) is building Africa’s next generation of business, policy, and tech leaders, through flexible, practical, and impact-driven learning. We are recruiting to fill the position below:

Job Title: Oracle EPM Data Integration Specialist

Location: Remote

Employment Type: Full-time

Job Description

We are seeking a skilled and detail-oriented Oracle EPM Data Integration Specialist to design, develop, implement, and maintain data integration solutions within the Oracle Enterprise Performance Management (EPM) environment. The successful candidate will be responsible for integrating financial and operational data from multiple source systems into Oracle EPM applications, ensuring data accuracy, consistency, security, and reliability. The role involves configuring data integration processes, developing mappings, automating data loads, troubleshooting integration issues, and supporting financial planning, budgeting, forecasting, consolidation, and reporting activities. The ideal candidate should possess strong knowledge of Oracle EPM Cloud, data integration methodologies, financial data structures, and data transformation techniques, with the ability to collaborate effectively with finance, IT, and business teams.

Key Responsibilities

Design, configure, and maintain data integration solutions between source systems and Oracle EPM applications. Implement and manage data integrations using Oracle EPM Data Integration, Data Management, Data Exchange, and related integration capabilities, as applicable to the organisation's environment. Configure data sources, import formats, locations, periods, categories, data load rules, and data mappings. Develop and maintain dimension mappings, member mappings, and transformation rules to ensure accurate alignment of data across systems. Integrate data from ERP systems, general ledgers, relational databases, flat files, and other enterprise applications into Oracle EPM. Support integrations with Oracle Fusion Cloud ERP, Oracle ERP systems, and other financial applications where required. Configure and maintain data load processes for Oracle EPM Planning, Financial Consolidation and Close (FCCS), Account Reconciliation (ARCS), and other relevant EPM modules. Develop, schedule, and monitor automated data integration jobs and workflows. Validate imported data, reconcile source and target balances, and investigate discrepancies to ensure data integrity. Troubleshoot integration failures, mapping errors, data load issues, and performance bottlenecks. Work with finance and business stakeholders to understand reporting requirements, financial dimensions, chart of accounts, and data transformation needs. Support metadata management, dimension updates, application refreshes, and related data administration activities where required. Develop and maintain technical documentation covering integration configurations, mappings, schedules, dependencies, and troubleshooting procedures. Implement appropriate security controls and follow organisational data governance standards. Support system testing, user acceptance testing (UAT), deployment, and post-implementation support. Identify opportunities to automate, optimise, and improve data integration processes. Collaborate with functional consultants, solution architects, developers, and finance teams to deliver reliable EPM solutions.