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-59-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 r esponsible for performing data cleansing in the legacy system and data construction for the new Hexagon EAM system.

Major Duties/ Responsibilities

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

REQUIREMENTS:

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

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

CLOSING DATE: June 22, 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