Senior Enterprise Data Management (EDM) Consultant

Keste; Canada; On-site; CAD 90,000 - 120,000; Full time

Job summary

A consulting firm in Canada is seeking a highly skilled Lead Data Integration Consultant to manage client engagements and deliver data integration solutions for Oracle EPM Cloud applications. Ideal candidates should possess extensive experience in Oracle Data Integration and strong skills in SQL, PL/SQL, and Python. This role involves collaborating with clients, implementing solutions, developing ETL processes, and staying updated with industry trends. If you are motivated and possess excellent problem-solving abilities, apply today to make a significant impact.

Qualifications

• 5-10 years of consulting experience or in a related field.
• Experience leading full-lifecycle Oracle Data Integration implementations.
• In-depth knowledge of relevant technologies and systems.

Responsibilities

• Design and develop data integration solutions for Oracle EPM Cloud applications.
• Collaborate with clients to understand their business objectives and challenges.
• Implement and configure data integration processes.

Skills

Expert knowledge in data integration

Strong communication skills

Problem-solving skills

Team collaboration

Scripting in SQL, PL/SQL, Python

Education

Bachelor’s degree in Computer Science, Information Systems

MBA or related master's degree

Tools

Oracle Data Exchange

Oracle Data Management

Oracle Integration Cloud

Job description

JOB SUMMARY

A Lead Consultant at Argano is a highly experienced professional in the consulting family responsible for managing mid‑to‑large‑size client engagements and contributing to the growth and development of the consulting practice. They provide expert advice, guidance, and solutions related to technology to businesses and organizations. They are indirect mentors in other areas and grades. Their goal is to help clients optimize their technology infrastructure, processes, and strategies to achieve their business objectives more efficiently and effectively. Lead consultants work with security, data management, and crisis management and should demonstrate exceptional knowledge of technology to deliver quality work that will drive customer satisfaction, with excellent communication skills, and the ability to work well within a team.

We are seeking a highly skilled and motivated Lead Data Integration Consultant to join our dynamic team. The ideal candidate will have extensive experience in Oracle Enterprise Performance Management (EPM) Cloud data integration development. As a Lead Data Integration Consultant, you will be responsible for designing, developing, and implementing data integration solutions to support our clients' EPM Cloud applications.

RESPONSIBILITIES

• Design and develop data integration solutions for Oracle EPM Cloud applications, including Oracle Planning and Budgeting Cloud (Planning), Oracle Financial Consolidation and Close Cloud (FCC) and Oracle Account Reconciliation (Reconciliation) applications.
• Collaborate with clients to understand their business objectives, challenges, and technology requirements. Conduct thorough assessments to identify areas where technology can drive improvements and efficiencies.
• Implement and configure data integration processes using tools such as Oracle Data Exchange (DE), Oracle Data Management (DM) and Oracle Integration Cloud (OIC).
• Develop and maintain ETL processes to extract, transform, and load data from various source systems into Oracle EPM Cloud applications.
• Provide technical support and troubleshooting for data integration issues.
• Provide expert advice on technology solutions and tools that can enhance the client's operations. Help clients make informed decisions about adopting and implementing new technologies.
• Perform data mapping, validation, and unit testing to ensure data accuracy and integrity.
• Conduct training sessions and provide documentation to clients to ensure successful adoption of data integration solutions.
• Stay current with industry trends and best practices in data integration and Oracle EPM Cloud technologies.
• Continuously monitor the performance of implemented solutions to identify areas for improvement or optimization. Provide recommendations for updates, upgrades, or modifications, as needed.

MINIMUM AND/OR PREFERRED QUALIFICATIONS

EDUCATION

• Bachelor’s degree in Computer Science, Information Systems, or a related field.
• MBA, relevant master's degree, or PhD, a plus.

EXPERIENCE

• 5 – 10 years of consulting experience or in a related field.
• Experience Leading 8 – 10 different, full‑lifecycle Oracle Data Integration implementations.
• Experience leading functional and technical design sessions, with hands‑on experience implementing Oracle Data Exchange (DE), Oracle Data Management (DM), and Oracle Integration Cloud (OIC).
• Experience leading a team of consultants and properly managing deliverables.
• Strong experience inscripting languages such as SQL, PL/SQL, and Python.
• Experience with Data Exchange loading data and metadata, required.
• Excellent problem‑solving skills and attention to detail.
• Strong communication and interpersonal skills.
• Ability to work independently and as part of a team.
• Preferred consulting experience in a similar role in a professional services firm or industry experience at a strategic level is required.
• Previous experience working in IT companies.
• In‑depth knowledge of the relevant technologies and systems.

CERTIFICATES, LICENSES, REGISTRATIONS

• Oracle Cloud Enterprise Performance Management Data Integration Implementation Certified Professional – preferred
• Other Oracle Cloud Enterprise Performance Management Implementation Specialist Certifications (Planning, Consolidations, Reconciliations, Narrative Reporting) – desired