Intermediate Data analyst to support the program to replace an ERP system, which is at the end of life for a transportation industry

S.i. Systems

  • Canada
  • Contract
  • Full-time
  • 1 month ago
Our client is seeking an Intermediate Data analyst to support the program to replace an ERP system, which is at the end of life for a transportation industryDuration is one year. Work Mode - Hybrid (minimum of 3 days per week in person). Location Montreal or WinnipegProject Scope
  • 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.
Must Haves
  • SSIS and SQL Server
  • Financial ERP
- Reservation System- Banks Reporting tool- Payment processing solutions and services- Cash Receipts Processor- Partner Commission processorNice to Have
  • Airline Industry
  • Bilingual
ResponsibilitiesThe 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.

S.i. Systems