Maintenance System Support Analyst

**Marketing Statement**:
As the largest operating company in the integrated TransLink enterprise, Coast Mountain Bus Company (CMBC) operates a fleet of clean-fuel conventional and community shuttle buses, zero-emission trolley buses, and passenger ferry SeaBuses in Metro Vancouver, the largest single transit service area in Canada.

At CMBC, one of BC’s Top Employers, we're committed to providing an innovative, healthy, and engaging workforce. This is reflected in our workforce of over 5,500 employees performing over 400 unique jobs, who are committed and empowered to deliver service that attracts nearly 1.1 million passengers daily and connects people, businesses, and communities in the Metro Vancouver region.

We have the important job of helping our passengers get to work, appointments, visiting with family and friends, and back again every day. Metro Vancouver relies on us, and we take that as a point of pride.

**Responsibilities**:
SUMMARY:
DUTIES AND RESPONSIBILITIES:
Identifying the requirements, assessing the impact of changes, maintaining, developing, and refining related Maintenance Systems including, but not limited to: Annual Workplan for Planning, Brake Reline Management, Maintenance Reporting, Fuel and KM systems, Power BI Dashboards, as well as new and developing Maintenance business processes.
Configuring, testing, improving, and troubleshooting new, or updated systems that have been implemented.
Liaising with BTS units in assessing recommendations and its impact on infrastructure.
Providing guidance and advice to maintenance system users to ensure information availability, quality, integrity, and reliability is maintained.
Reviewing and monitoring various maintenance information sources and systems to identify and resolve issues as well as verify their operation and data quality.
Driving to various CMBC locations to respond to issues and troubleshoot problems with systems.
Providing demos, training and knowledge transfer to end users, peers, and other Business units.

Utilizing programming languages such as, but not limited to: Structured Query Language (SQL), Visual Basic for Applications (VBA), Power Query M, and Data Analysis Expressions (DAX).

Provides guidance and support to Maintenance Systems Coordinators by:
Assigning day to day tasks, checking for accuracy and completion of work in a timely manner.
Verifying scheduled reports on vital business metrics avoiding service disruptions that can affect scheduled operational functions.
Monitoring and escalating change requests in the ticketing queue affecting the safety and security of revenue and non-revenue vehicles, for example: modifying inspection points and related parts avoiding critical failure costing unforeseen corrective maintenance.
Assisting the Assistant Manager in allocating tasks and providing guidance.
Responding to emergency callouts for immediate operation support as required, including off hours.

Coordinates with external support teams to ensure organizational systems are functioning in accordance with business needs by:
Liaising with external companies such as fuel vendors, software vendors, tank monitoring providers, and vendor for oil analysis to understand, assess and determine requirements relating to maintenance systems.
Identifying and assessing the impact of the changes requested by business users to ensure it meets organizational need/requirement and provides recommendation for improvement/adjustments.
Coordinate with external service provider in troubleshooting maintenance required systems to ensure functionality is up to organizational standards.
Ensure functionality of maintenance systems associated hardware, such as trouble shooting, diagnosing, repairs, and/or replacements.

Provides guidance, expertise, and recommendations to various stakeholders in CMBC and TransLink on various reporting systems, analytical tools, processes, and requirements by:
Liaising with internal stakeholders such as Engineering, Training, Maintenance, Planning, Finance, Inventory, BTS, TransLink and CMBC Service Planning, HR, Performance Reporting, Infrastructure, and Bus Services.
Working with internal customers collaboratively to resolve issues and improve existing processes, including making recommendations for changes to reflect current conditions and ensure accurate results.
Providing recommendations to internal project teams as required, not limited to business processes and practices, detail design on systems, user requirements for efficiencies/functionalities.
Conducting and participating in maintenance cost/benefits analyses, derived from reporting or statistical solutions, typically from ad-hoc requests or abnormal behavior within data.
Providing guidance as needed in the use of best practices relating to Asset Management information, Work Management information and Workflow Management within MS and Maintenance Business Processes, to support change management.

Conducts complex analysis, forecasting, ad-hoc reporting