Oracle EPM Data Integration Lead Consultant

Lever, Inc.; Canada; A distancia; CAD 110.000 - 150.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Remote work in Canada

Unlimited vacation

Virtual healthcare

Online courses

Leadership development

Tuition reimbursement

Descripción de la vacante

Lever, Inc. is seeking an Oracle EPM Data Integration Lead Consultant based in Canada to design, implement, and optimize end-to-end integrations between Oracle EPM Cloud apps and other systems. This remote opportunity offers challenging client engagements and continuous learning.

You will work with stakeholders to map data, automate flows, and ensure data quality, security, and alignment with enterprise standards using EPM tools, APIs, and scripting.

Formación

• Bachelor's or Master's degree in CS/IS/SE or related field.
• 5+ years with Oracle EPM Cloud and data integration.
• Experience with FCCS/EPBCS/PCMCS/ARCS.
• Strong SQL skills (ANSI/Oracle/T-SQL).
• Proficient in Java, Groovy, or C# for integrations.
• Familiar with Oracle REST APIs and EPM Automate.
• English communication; French is a plus.
• Experience with EPM tools: ODI, FDMEE, CDM, and related pipelines.

Responsabilidades

• Design, develop, deploy, and maintain Oracle EPM data integrations.
• Register source apps, configure mappings, automate data movement.
• Define mappings, transformations, and validation procedures.
• Automate workflows using EPM Automate, REST APIs, scripting.
• Monitor jobs, troubleshoot data issues, and ensure reliability.
• Collaborate with stakeholders and enterprise architects.
• Prepare design documents, runbooks, and system guides.
• Support testing and UAT to verify data flows.
• Identify opportunities to optimize architecture and data quality.

Conocimientos

Oracle EPM Cloud

Data integration

SQL

REST APIs

Java

Groovy

C#

Problem-solving

Communication

English proficiency

Educación

Bachelor's or Master's in CS/IS/SE

BE/BTech/MCA qualifications

Herramientas

ODI

FDMEE

CDM

EPM Integration Agent

Pipelines

Data Exchange

Lodging with EPM Automate

Descripción del empleo

This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for an Oracle EPM Data Integration Lead Consultant based in Canada.

Overview

Join a technology consulting environment where innovation, collaboration, and digital transformation drive meaningful business outcomes. As an Oracle EPM Data Integration Lead Consultant, you will design, implement, and optimize end-to-end integrations between Oracle Enterprise Performance Management (EPM) Cloud applications and diverse enterprise systems. You will play a key role in ensuring accurate, secure, and automated data flows that support financial planning, consolidation, reconciliation, and performance management processes. Working closely with business stakeholders and technical teams, you will translate complex requirements into reliable integration solutions aligned with enterprise architecture standards. You will leverage Oracle EPM integration tools, APIs, scripting, and database technologies to improve data quality and operational efficiency. This remote opportunity offers challenging client engagements, continuous learning, and the chance to contribute to impactful enterprise technology initiatives.

Accountabilities

• Integration Design and Implementation: Design, develop, deploy, and maintain end-to-end integrations between Oracle EPM Cloud applications and various source and target systems, ensuring reliable and scalable data exchange.
• Data Integration Management: Register source applications, configure integrations and mappings, export data to target systems or files, and automate data movement through integration pipelines.
• Data Mapping and Transformation: Define and maintain data mappings, transformation rules, and validation procedures to ensure accuracy, consistency, and integrity across connected systems.
• Automation and Scripting: Automate integration workflows using EPM Automate, batch files, REST APIs, and relevant scripting technologies to streamline recurring processes and minimize manual intervention.
• Monitoring and Troubleshooting: Monitor integration jobs, analyze execution logs, identify data discrepancies, investigate failures, and implement timely corrective actions to maintain reliable operations.
• Stakeholder Collaboration: Work with business stakeholders, technical teams, and enterprise architects to gather requirements, define integration specifications, and ensure solutions align with business objectives and technical standards.
• Project Coordination: Proactively communicate project progress, dependencies, risks, blockers, and delivery updates to relevant stakeholders, supporting effective planning and execution.
• Technical Documentation: Develop and maintain integration design documents, configuration records, operational runbooks, and system administration guides to support knowledge transfer and ongoing maintenance.
• Testing and Quality Assurance: Support integration testing and user acceptance testing (UAT), validate data flows, and ensure solutions meet functional and technical requirements before deployment.
• Continuous Improvement: Identify opportunities to optimize integration architecture, improve automation, strengthen data quality, and enhance the performance and maintainability of Oracle EPM solutions.

Requirements

• Education: Bachelor's or master's degree in Computer Science, Information Systems, Software Engineering, or a related discipline, including B.Tech, BE, M.Tech, or MCA qualifications.
• Professional Experience: At least 5 years of relevant experience working with Oracle EPM Cloud applications, data integration solutions, and enterprise data management processes.
• Oracle EPM Expertise: Hands-on experience with Oracle EPM Cloud analytical applications such as Financial Consolidation and Close Cloud Service (FCCS), Enterprise Planning and Budgeting Cloud Service (EPBCS), Profitability and Cost Management Cloud Service (PCMCS), or Account Reconciliation Cloud Service (ARCS).
• Integration Technologies: Strong practical knowledge of Oracle EPM integration tools and frameworks, including Pipelines, Cloud Data Management (CDM), Data Exchange, FDMEE, EPM Integration Agent (EPMIA), and Oracle Data Integrator (ODI).
• Data Management Skills: Experience extracting, transforming, mapping, validating, and loading data across source and target systems, with a strong understanding of data quality and consistency.
• Database and SQL Proficiency: Experience with relational database management systems and strong SQL skills, including ANSI SQL, T-SQL, or Oracle SQL.
• Programming Experience: Working knowledge of Java, Groovy, or C# for developing and supporting integration components and custom solutions.
• Oracle Automation and APIs: Familiarity with Oracle EPM REST APIs, EPM Automate commands, and related data management capabilities, including CDM, FDM, or FDMEE.
• Scripting Skills: Experience with PowerShell, VBScript, Jython, Python, or Groovy is an advantage.
• Testing and Integration: Experience supporting system integration testing, user acceptance testing, and troubleshooting complex integration scenarios.
• Additional Technical Assets: Familiarity with Oracle Integration Cloud (OIC) and experience preparing detailed integration design documents and system administration guides are considered advantageous.
• Communication Skills: Proficient English is required to collaborate daily with colleagues and managers outside Quebec. Intermediate French is an asset.
• Analytical and Problem-Solving Abilities: Strong troubleshooting, critical-thinking, and attention-to-detail skills, with the ability to identify root causes and develop effective solutions.
• Collaboration and Ownership: Ability to work effectively with cross-functional teams, manage competing priorities, communicate risks proactively, and take ownership of technical deliverables.

Benefits

• Remote Work Flexibility: Remote work arrangements in Canada, supporting flexibility and work-life balance.
• Flexible Time Off: Access to an Unlimited Vacation Plan to help you rest and recharge.
• Healthcare and Wellness: Access to 24/7 virtual healthcare and a comprehensive wellness portal supporting physical, mental, emotional, and financial well-being.
• Professional Development: Access to thousands of online courses and certifications through partnerships with leading education providers.
• Leadership Development: Opportunities to participate in leadership development programs and expand your professional capabilities.
• Tuition Reimbursement: Financial support for eligible external training to encourage continuous learning and career advancement.
• Employee Share Purchase Plan: Opportunity to become a shareholder through an employee share purchase program with matched contributions.
• Meaningful Client Engagements: Work on challenging enterprise technology projects that support digital transformation and business performance.
• Collaborative Environment: Join a diverse, inclusive team that values innovation, knowledge-sharing, and continuous improvement.
• Inclusive Recruitment: Commitment to equal employment opportunities and accessible recruitment processes, with accommodations available when required.

We appreciate your interest and wish you the best!