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.
Requirements Education and Qualifications:
Bachelor's Degree or HND in Computer Science, Information Technology, Accounting, Finance, Computer Engineering, Management Information Systems, or a related discipline.
Professional certifications in Oracle EPM Cloud, Oracle Cloud Infrastructure, or related Oracle technologies will be an advantage.
Training in enterprise data integration, financial systems, database management, or business intelligence is desirable.
Knowledge of financial planning, budgeting, forecasting, consolidation, and reporting processes is beneficial.
Relevant practical experience and demonstrable Oracle EPM integration expertise may be considered in place of some formal qualifications.
Experience:
3 – 5 years of relevant experience in Oracle EPM, enterprise data integration, financial systems implementation, or a related technical role.
Demonstrable experience configuring and maintaining data integrations within Oracle EPM Cloud or related Oracle EPM environments.
Practical experience developing data mappings, configuring data load rules, and troubleshooting integration failures.
Experience integrating Oracle EPM with ERP systems, general ledgers, databases, or other enterprise applications.
Familiarity with financial data reconciliation, validation, and month-end or period-end reporting processes.
Experience supporting system testing, user acceptance testing, implementation, and production support.
Ability to prepare technical documentation and work with functional and technical stakeholders.
Experience with Oracle Fusion Cloud ERP, Oracle EPM Planning, FCCS, or other relevant EPM modules will be an advantage.
Candidates with strong Oracle EPM integration knowledge and demonstrable project experience are encouraged to apply.
Required Skills and Competencies: Technical Skills:
Strong understanding of Oracle EPM Cloud architecture and data integration processes.
Practical experience with Oracle EPM Data Integration, Data Management, Data Exchange, or related integration tools.
Ability to configure import formats, locations, data load rules, mappings, and integration workflows.
Knowledge of data transformation, data validation, reconciliation, and error-handling techniques.
Experience integrating financial data from ERP systems, databases, CSV files, Excel files, and other source systems.
Understanding of Oracle EPM applications such as Planning, Financial Consolidation and Close (FCCS), and Account Reconciliation (ARCS), depending on project requirements.
Knowledge of financial data structures, chart of accounts, dimensions, hierarchies, and metadata management.
Familiarity with SQL and relational databases for data extraction, validation, and troubleshooting.
Working knowledge of REST APIs, web services, and integration automation is an advantage.
Familiarity with scripting or automation using tools such as PowerShell, Python, or Groovy is desirable.
Understanding of data security, access controls, auditability, and data governance principles.
Ability to document integration processes and resolve technical issues efficiently.
Professional Skills:
Strong analytical and problem-solving abilities.
High attention to detail and commitment to data accuracy.
Effective communication and stakeholder management skills.
Ability to work collaboratively with finance, IT, and business teams.
Strong organisational and time-management skills.
Ability to manage multiple integration tasks and meet project deadlines.
Capacity to translate business requirements into practical technical solutions.
Commitment to continuous learning and keeping up with Oracle EPM product developments.