Intermediate to Senior IT Data Analyst - BILINGUAL

at  Prime Consulting Group Prime Groupe Conseils

JOB DESCRIPTION

Location: Montreal (preferably) or Winnipeg
Start Date: may 2024
Length of term: March 31, 2025 (1 year)
Work schedule: 40 hours/week
Work mode: Hybrid work (3 days/week in office presence required)
Project/Assignment
Support the program to replace the Enterprise Resource Planning (ERP) system, which is at the end of life. The key objective of this project is to transform the Finance organization leveraging technology around a centralized financial core system across all entities.

The scope of the project is:

• Transformation of processes and structures to align with best practices with a clear vision and TOM (targeted operating model) for Finance and Tax
• Centralization of Financial Core systems across the company’s entities + creation of a Finance Data Hub + replacing Peoplesoft, Hyperion and Back Office.

Functional Accountabilities
The Intermediate to Senior IT Data Analyst will be part of the team responsible for the development and deployment of highly effective financial transformation strategies and will assist with the assessment of the company’s requirements and data to execute data cleanse, conversion, and migration activities. Additionally, the analyst will play a key role in system integration and functionality testing to advance digital finance maturity level.

In greater detail, key areas of responsibility include the following:

• Collaborate with internal and external stakeholders to understand and document business requirements for the financial ERP for system configuration.
• Conduct interviews to gather comprehensive business process information and use cases.
• Document data flows, interfaces, and dependencies.
• Collaborate with project managers and business leads to ensure alignment with business goals.
• Ensure data accuracy, integrity, and consistency during data conversion and migration processes. Data conversion and migration include, but is not limited to:
• Master Data (Chart of Accounts and GL, Banks, Assets, Vendor, Customer, Projects)
• Transactional Data (Bookings, Account Balances, Invoices, Bank transactions, Asset continuity schedule)
• Ensure data accuracy, integrity, and consistency during data cleanse and cross-company de-duplication activities. Data cleanse activities apply to master data objects.
• Assist in the testing and validation of system integrations and functionality to guarantee data accuracy and consistency. Integrations include, but are not limited to the following systems:
• Reservation System
• Banks Reporting tool
• Payment processing solutions and services
• Cash Receipts Processor
• Partner Commission processor
• Future-state integrations (HR system, Reconciliation tool, OCR tool)
• Assist in the identification of business roles and responsibilities for the development of system role-based access controls.
• Address any post-implementation data issues and work to identify and resolve data root causes of discrepancies.
• Working with internal and external stakeholders, project resources, technical, subject matter, and other experts.
• Identify new and existing business requirements and process efficiencies, recommend solutions.
• Ability to make decisions and comfortably explain and/or present rationale in routine update meetings with business and IT stakeholders.
• Identify gaps, potential issues and risks and provide recommendations to enhance processes and financial performance.

REQUIREMENTS AND QUALIFICATIONS

Years of Experience required

• 5 or more years’ experience

Required skills

• A strong entrepreneurial spirit and desire to learn are essential in this role. The successful candidate must possess strong project management, communication, and presentation skills. Collaboration, diplomacy, and tact are also central as the role entails engaging, representing, and motivating a variety of stakeholders with divergent perspectives, objectives, and interests.
• The individual must have excellent organizational skills and the flexibility to adapt to a continuously evolving environment. Finally, the successful candidate will enjoy working in an environment where everyday challenges will include finding common ground between multiple stakeholder groups and finding creative ways to gain alignment such that all parties can succeed.
• In addition to a university degree in a relevant field of study (business, math, engineering, and supply chain) the successful candidate will demonstrate excellent analytical skills plus the ability to multi-task, work under pressure, and accommodate changing priorities.
• Proficiency with Microsoft Office software (Word, Excel, and PowerPoint) is required.
• Experience using and supporting Finance Business Systems would be an asset.
• Due to the confidential nature of our work, a high degree of professionalism and discretion is required.
• Flexibility with work hours and occasional travel may also be necessary.
• SSIS and SQL Server experience required (mandatory).

Linguistic Requirements:

• Based on equal qualifications, preference will be given to bilingual candidates. French-English bilingualism is an asset, as the employee may be required to work with resources outside of Quebec.

Please refer the Job description for details