Enterprise Resource Planning Data Coordinator

POSITION: ERP Data Coordinators (2 Year Contract 5 Positions Available)
REPORTS TO: ERP Data Conversion Lead
DEPARTMENT: Corporate Services
LOCATION: North Bay
REFERENCE:
SALARY: $76960 - $90532

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 postimplementation 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 postgo 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 problemsolving 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. Wethank 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 demploi sont également disponibles en français. Visitez notre site Web sur les carrières ou appelez le 1- poste 394 pour plus de renseignements.