Parts Data Coordinator

**POSITION** Parts Data Coordinator (New)
**REPORTS TO**: Manager, Inventory and Warehousing
**DEPARTMENT**: Strategic Procurement
**LOCATION**: North Bay
**REFERENCE**: 800-185-25
**SALARY**: $73,112 - $86,008

**WHO WE ARE**:
Ontario Northland Transportation Commission (ONTC) is an Agency of the Province of Ontario that provides efficient and vital transportation services. We employ over 900 skilled professionals and are over 120 years old and proud of our heritage and connection to the communities we serve. We are focused on moving forward with the goal of being a valued leader in transportation. We offer competitive salary, excellent benefits, a defined benefit pension plan, paid vacation, 3 paid personal leave days along with discounted transportation on our bus and passenger rail services.

**ACCOUNTABILITY STATEMENT**:
The Parts Data Specialist will be responsible for data cleansing, manipulation, transformation, and execution of Ontario Northland parts data sets into condensed formats. This role is responsible for performing data cleansing in the legacy system and data construction for the new Hexagon EAM system.

**MAJOR DUTIES/ RESPONSIBILITIES**:

- Act as supply chain data Subject Matter Expert (SME) contributing knowledge regarding legacy system data, migration approach, and understanding of new system data requirements
- Work with team to develop data mapping from legacy system to new system
- Understand end-to-end data flows and data dependencies
- Analyze data to identify gaps, alert stakeholders about risk, and propose actions to act on the findings
- Work with group managers to help produce, organize and review data analytics, improving operational and management efficiencies
- Perform data migration audit, reconciliation and exception reporting
- Work with data collection team for weekly cadence, status reporting etc
- Consult with ONTC groups to gather input, feedback and ensure needs are met
- Perform audits, counts, location of slow moving inventories
- Develop Standard Operating Procedures, and Job Aids to support maintenance of data, and processes
- Development of the Parts Data Standards, as well as maintain clear and comprehensive documentation of data definitions
- Work closely with Information Technology team for data cleansing and data loads
- Maintain database locations, shared drives and files on our sharepoint site
- Assist and train stores employees on use of tools, spreadsheets and documents used for data collection or naming conventions

**REQUIREMENTS**:

- Diploma in Business Management, Office Administration, Data Science and Analytics, Economics or combination of equivalent education and work experience
- 3-5 years’ of direct Supply Chain work and project experience
- Knowledge of EAM/CMMS (Centralized Maintenance Management Systems), ERP, reporting software products is preferred
- Experience in data cleansing, data construction and data collection
- Experience establishing and monitoring KPI’s
- Research, analytical and reasoning skills to assess and prepare a variety of reports
- Knowledgeable in shipping & receiving, warehousing, operating warehousing equipment
- Experience with AS400 system is an asset
- Experience with system migrations considered an asset
- Strong working knowledge of MS Office including Outlook, Word, Excel and PowerPoint
- Proficiency with MS Excel functions and formulas including VLOOKUP, pivot tables, conditional formatting, logic functions and filter/sorting
- Organizational skills; organizing large-volume files/databases and completing inventories
- Experience training employees in a shipping/receiving environment
- Excellent communication skills, self-starter with the ability to take initiative, and keen attention to detail
- Ability to work independently and in a team environment
- Commitment to health & safety

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.
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.

lwxRDP3RaY