Parts Data Coordinator (2 Year Contract)

POSITION: Parts Data Coordinator (2 Year Contract)

REPORTS TO: Manager, Enterprise Asset Management

DEPARTMENT: Finance

LOCATION: North Bay

REFERENCE: 800-59B-24

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:

• Good understanding of established process (and securities) for uploading, modifying/updating data information.
• Perform data migration audit, reconciliation and exception reporting.
• Coordinates audits, counts, location of slow moving inventories
• Develop Standard Operating Procedures, and Job Aids to support maintenance of data, and processes.
• Work with data collection team for weekly cadence, status reporting etc.
• Assist and train stores employees on use of tools, spreadsheets and documents used for data collection or naming conventions
• Involvement in EAM project meetings, training and outreach related to Data Cleansing activities, processes and applications.
• Analyze data to identify gaps, alert stakeholders about risk, and propose actions to act on the findings.
• Work with team to develop data mapping from legacy system to new system
• Development of the Parts Data Standards, as well as maintain clear and comprehensive documentation of data definitions
• 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 closely with Information Technology team for data cleansing and data loads.
• Understand end-to-end data flows and data dependencies.
• Consult with ONTC groups to gather input, feedback and ensure needs are met
• Maintain database locations, shared drives and files on our sharepoint site.
• Work with group managers to help produce, organize and review data analytics, improving operational and management efficiencies.

REQUIREMENTS:

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

BACKGROUND INVESTIGATION: The successful candidate will need to pass the following clearances: criminal record check, employment references and education verification.

CLOSING DATE: July 11, 2023 no later than 11:59 p.m. We thank all applicants for their interest; however, only those selected for an interview will be contacted. Qualified individuals are invited to apply in writing with a current covering letter and resume (provided in one document), stating reference name and number.

Ontario Northland is an equal opportunity employer. Accommodation is available for applicants with disabilities throughout the recruitment process. Please contact Human Resources.

Les offres d'emploi sont également disponibles en francais. Visitez notre site Web sur les carrières ou appelez le 1-800-363-7512, poste 494 pour plus de renseignements.

Powered by JazzHR

1IL0y4ijzY