EPM Data Integration Senior Analyst

Role Overview/Purpose
We are seeking a Senior Analyst with expertise in Oracle EPM Data Integrations to join our EPM team. The successful candidate will manage and optimize data flows across Oracle EPM Cloud applications, ensuring seamless data integration from various source systems. This role will leverage tools like EPM Data Management/Exchange, and other integration technologies to streamline data loading and transformation processes, enabling efficient and accurate financial and operational reporting.

Key Roles and Responsibilities

Develop and manage data integration processes across Oracle EPM applications, including Planning, Financial Consolidation and Close, and other modules, using Oracle Data Management, ODI, EPM Automate, and REST APIs.

Automate data loads, backups, job executions, and other administrative tasks, reducing manual intervention and ensuring efficient, reliable processes.

Utilize EPM REST APIs to enhance integration capabilities, including developing custom automation scripts and enabling seamless interaction with external systems for data exchange.

Design and implement ETL (Extract, Transform, Load) processes for transforming and validating financial data as it moves from ERP systems, or external databases into Oracle EPM applications.

Develop data mapping rules and transformation logic within Oracle Data Management, ensuring data integrity and compliance with financial reporting standards.

Monitor, troubleshoot, and resolve data integration issues, ensuring timely and accurate data flows to Oracle EPM systems. Develop error-handling mechanisms for failed integrations.

Collaborate with IT, finance, and business teams to understand data requirements and build integration solutions that meet organizational goals for reporting, analysis, and planning.

Implement data security protocols and ensure compliance with internal controls and regulatory requirements when handling sensitive financial data.

Continuously improve data integration processes by staying up-to-date with Oracle EPM Cloud updates, emerging data integration technologies, and best practices.

Collaborating with key individuals involved

Bridge the gap between business requirements and technical specifications, ensuring effective communication and understanding.

Support users within the EPM community and across the wider business, enabling efficient utilization of EPM functionalities.

Collaborate actively with the Finance teams across the Group to identify and implement continuous process and system improvements, driving our business initiatives forward.

Support system training programs and conduct training sessions for global business users.

Play an active role in mentoring and developing junior team members, fostering excellence and expanding our knowledge base.

Skills & Experience
5+ years of experience in Oracle EPM data integration, with a focus on Oracle Data Management/Data Exchange, EPM REST APIs, EPM Automate.

Proven ability to design and manage data integrations, job scheduling, data loading, and automation across Oracle EPM Cloud applications.

Strong proficiency with REST APIs, including experience in building custom API integrations to support data movement and automation within the Oracle EPM Cloud environment.

Experience with Oracle Data Integrator (ODI) and Oracle Integration Cloud (OIC) for developing and optimizing complex data pipelines.

Knowledge of ETL processes, data mapping, and transformation techniques to ensure accurate data flow from source systems (ERP, general ledgers, databases) to Oracle EPM.

Proficiency in writing and managing SQL queries, scripting languages (e.g., Python, Shell scripting), and automation scripts for error handling and job execution.

Experience with scripting for backup, migration, and administrative task automation.

Knowledge of data governance, security protocols, and compliance standards when working with sensitive financial data, ensuring proper controls are in place.

Strong analytical and problem-solving skills, with the ability to troubleshoot and resolve complex data integration and automation issues.

Ability to work collaboratively with cross-functional teams, including IT, finance, and business units, to deliver solutions that meet data integration requirements.

Experience on other EPM modules (PBCS, FCCS, TRCS, ARCS, EDM) is a plus.

Experience with Groovy scripts is a plus.

Oracle EPM Cloud certification is a plus.

Motivated to learn new technologies and expand your functional and technical expertise to other Oracle EPM Cloud products. BENEFITS WE OFFER

Access to Learnerbly, Udemy, and a Self-Development Fund for upskilling.

Career growth through Internal Mobility Programs.

Comprehensive Health Insurance for you and dependents.

Well-Being Fund and 24/7 Assistance Program for holistic wellness.

Hybrid Model: 2 office days/week with flexible leave policies, including maternity, paternity, and sabbaticals.

Free Meals, Cab Allowance, and a Home Office Setup Allowance.

Employer PF Contribution, gratuity, Personal Accident & Life Insurance.

Sharesave Plan to purchase discounted company shares.

Volunteering Leave and Team Events to build connections.

Recognition through the Kudos Platform and Referral Rewards.