POSITION: ERP Data Coordinators (2 Year Contract, 5 Positions Available)
REPORTS TO: ERP Data Conversion Lead
DEPARTMENT: Corporate Services
LOCATION: North Bay
REFERENCE: 800-53-27
SALARY: $76,960 - $90,532

WHO WE ARE:
Ontario Northland Transportation Commission (ONTC) is an Agency of the Province of Ontario that provides efficient and vital transportation services. We are a modern, forward-thinking organization focused on providing safe and reliable transportation services. ONTC has a rich history of over 120 years and strong connections to the communities we serve. With over 1200 skilled professionals, we work together to enhance transportation services and ensure that they are sustainable for future generations. We offer a dynamic workplace culture, along with a competitive salary, a defined benefit pension plan, paid personal leave days and discounted transportation on our bus and passenger rail services.

ACCOUNTABILITY STATEMENT:
The ERP Data Coordinator ensures enterprise data is accurate, complete, and migration-ready by supporting data preparation, transformation, validation, and reconciliation activities for ERP implementation. This role collaborates with business, technical, and implementation partners to uphold data standards, resolve data issues, and support testing, go-live, and post‑implementation stabilization and improvement.
Ontario Northland is recruiting five (5) Data Coordinators to support data activities across multiple functional areas. While all positions share core Data Coordinator responsibilities, resources will be assigned based on their experience and strengths across areas such as Human Resources, Payroll, Finance, Procurement, CRM, Enterprise Asset Management (EAM), IT, and Manufacturing.
Assignments may span more than one functional area, reflecting the interconnected nature of data and the expected overlap across business domains.
Functional Areas (5 Positions):

• Human Resources / Payroll

• Finance

• Procurement

• Customer Relationship Management (CRM)

• Information Technology (IT) / Enterprise Asset Management (EAM)

• Manufacturing

MAJOR DUTIES/ RESPONSIBILITIES:

• Conduct data investigation and profiling of legacy systems to assess structure, completeness, accuracy, and suitability for ERP migration.

• Perform data cleansing activities by identifying and correcting duplicates, inconsistencies, missing or outdated records, and non standard data formats.

• Standardize and prepare master and transactional data in alignment with approved data standards, naming conventions, business rules, hierarchies, and ERP data model requirements.

• Maintain data cleansing plans, inventories, and issue logs, tracking data ownership, data quality status, remediation actions, dependencies, and progress.

• Collaborate with functional SMEs and data owners to validate cleansed data, document outcomes, and escalate data risks impacting ERP readiness or timelines.

• Prepare and transform legacy data into ERP ready formats in accordance with approved data models, business rules, and transformation logic.

• Support data field mapping between legacy systems and the ERP solution to ensure accurate alignment of source and target data elements.

• Support data extraction, transformation, and loading (ETL) activities by working with technical teams and implementation partners during migration cycles.

• Monitor data migration tools, scripts, and processes to track progress, identify issues, and support timely resolution of conversion errors.

• Perform data validation and reconciliation activities before and after data loads to confirm completeness, accuracy, consistency, and integrity of migrated data.

• Execute and support validation scripts, queries, and reports to identify conversion errors, gaps, or anomalies during test and mock migration cycles.

• Collaborate with functional and technical teams to investigate validation and reconciliation issues, support root cause analysis, and confirm corrective actions.

• Maintain comprehensive data documentation, including data mappings, standards, transformation rules, assumptions, migration logs, validation results, and issue records.

• Support data governance practices by reinforcing data ownership, stewardship responsibilities, approval authorities, and audit and compliance requirements.

• Support cutover readiness, post–go live data stabilization, ongoing data monitoring, and continuous improvement, including assisting functional teams with data related inquiries and issues.

REQUIREMENTS:

• College Diploma in Business, Finance, Human Resources, Engineering, Supply Chain, Information Technology, Information Systems or a related field.

• Minimum of 2 years’ experience working with ERP systems, data administration, or data quality roles, including monitoring data quality, cleansing data, and ensuring data security and integrity.

• Experience in one or more of the following functional areas:

  • Human Resources / Payroll (employee data, confidentiality, payroll systems)
  • Finance (financial data, reconciliations, reporting)
  • Procurement (vendor data, contracts, purchasing systems)
  • Customer Relationship Management (CRM) (customer relationship related data)
  • Enterprise Asset Management / IT systems (e.g., asset data, maintenance systems)
  • Manufacturing (production data, quality, operational reporting)

• Experience working with ERP systems (Oracle preferred).

• Background in data migration, ETL processes, data cleansing, and data transformation.

• Experience working with large datasets and applying data quality and data governance principles.

• Strong skills using SQL, Microsoft Excel, and data analysis tools.

• Experience documenting data structures, data definitions, processes, and data migration or transformation rules.

• Prior involvement in ERP implementations or major system changes.

• Demonstrated ability to collaborate effectively across functional and technical teams.

• Strong computer skills using Microsoft Office applications, including Outlook, Word, Excel, and PowerPoint.

• Knowledge of organizational structure, business processes, and functional requirements.

• Understanding of project lifecycle management, change management, and PMO standards or methodologies.

• Strong analytical, troubleshooting, and problem‑solving skills.

• Agile and innovative mindset with a focus on continuous improvement.

• Proven ability to manage multiple tasks, schedules, and documentation efficiently.

• Demonstrated professionalism in interactions with internal and external stakeholders.

• Commitment to workplace health and safety.

APPLICATION PROCESS: The successful candidate will need to pass the following clearances: criminal record check, employment references and education verification. Candidates should indicate their preferred functional area(s) in their application, in alignment with their expertise and experience.

CLOSING DATE: May 20, 2026, no later than 11:59 p.m. Qualified individuals are invited to apply in writing with a current covering letter and resume (provided in one document), stating reference name and number. We thank all applicants for their interest, however, only those selected for further consideration will be contacted.
If it is determined that any information provided in the application or during the recruitment process is false, misleading, or incomplete, Ontario Northland may discontinue your candidacy from further consideration.

At Ontario Northland, we are committed to employment equity. We value the unique skills and experiences each person brings to Ontario Northland and invite all interested individuals to apply and encourage applications from Indigenous peoples, racialized persons, women, persons with disabilities, and persons who identify as 2SLGBTQIA+.
Ontario Northland will provide accommodation to ensure barrier-free employment in accordance with the Canadian Human Rights Act and the Accessibility for Ontarians with Disabilities Act. You can request accommodation at any stage of the hiring process. If you require an accommodation, please contact Human Resources.
ONTC does not use artificial intelligence (AI) to make or inform hiring decisions. We do use an external applicant tracking system (ATS) to help manage applications efficiently. While the ATS may apply basic automated filters or sorting functions, all applications are reviewed and evaluated by human recruiters.
Les offres d'emploi sont également disponibles en français. Visitez notre site Web sur les carrières ou appelez le 1-800-363-7512, poste 394 pour plus de renseignements.

IgaRj3C2L3