Planning Maintenance Analyst

Salary: $78,000-$98,000

Official JD:

Position Summary:

Provides support for the maintenance division through the organization, collection, compilation, formatting and presentation of key performance indicators to advise business decisions and assess the organization’s progress relating to the division and department goals. Manages short- and long-term divisional results to maximize production support and expenditure. Responsible for ensuring an efficient and accurate utilization of the computerized maintenance management system (CMMS) and Power BI. Uses analytical skills and critical thinking to improve division performance.

KeyResponsibilities/Duties:

• Build infrastructure requirement for extraction, transformation, and loading of data.

Design and maintain data models used for reporting and analytics.

• Create dashboards and KPIs to show business performance to management.

• Understand business strategy to build timely and scalable insights to enable quick and accurate data driven decisions.

• Analyze various sources of data to determine the best fields for specific KPIs and ensure data accuracy by validating data for new and existing tools.

• Develop preventive, predictive, and corrective maintenance plans and schedules for the companies assets (wharves, cranes, roadways, utilities, terminals, fleet, buildings, marine structures, etc.).

• Own the design and development of automated solutions for recurring reporting and indepth analysis.

• Analyze planning data to define manpower, parts and other resources required to meet terminal demands

• Perform a variety of activities in planning, scheduling, and documentation, including reports and presenting findings

• Develop CMMS tool to meet department demands, including maintain accurate and prompt data collection

• Perform analysis of workload, staff allocation and material resources by developing flexible forecasting tools

Develop methods of tracking operational costs for container and general cargo facilities.

• Manage budget preparation and monitoring of department expenses with Maintenance Managers of container and general cargo facilities; analyze and report variances in expense on a monthly and quarterly basis; provide information on developing trends.

• Design dashboards, forms, and reports that capture key performance indicators (KPI’s) and identify key trends to assist in establishing proactive solutions to drive improved performance

• Facilitate continuous improvement activities, kaizen events, visual process mapping, and other exercises for varying work groups

• Review and recommend short- and long-term plans and course of action; ensure planned project needs are properly budgeted and delivered on time

• Assemble detailed spreadsheets, charts, and graphs to illustrate technical reports; analyze data and reports to provide accurate and timely recommendations to management for decision-making purposes

• Analyze, troubleshoot, and resolve moderate to complex issues reported by end- users via research, testing and scenario re-creation as it relates to Maximo and Power BI; create and execute, functions to support business operations.

Make recommendations for long-term solutions to stabilize the system.

• Work closely with project management teams and other support staff to monitor terminal projects

• Track and report key maintenance metrics (asset downtime, mean time between failures, preventive maintenance compliance, maintenance costs, labor utilization, backlog).

• Participate in Master Plan development for container and general cargo facilities

• Promote the organization’s safety culture and participate with monthly safety audits

Education/Experience:

• Bachelor’s degree in Computer Science, information systems, Business Administration, Maritime Administration, or related major in a public or accredited private academic institution required

• 5+ years related terminal equipment knowledge required.

• Familiarity with computerized maintenance management systems (CMMS) or enterprise asset management (EAM) software (Maximo, Infor, SAP, etc.)

Knowledge, Skills, Abilities and Behaviors:

• Strong data analysis and reporting skills (Excel, Power BI, SQL. Etc.)

Experience with SQL, SQL Server, ETL design, and RDBMS.

• Fluent in finance, statistics, datasets, and scripting.

• Understanding of Power Query M and DAX

• Accuracy and completeness of asset data in CMMS/EAM

• Knowledge of terminals and terminal operations

• Knowledge of accounting processes and procedures

• Knowledge of project management

• Communication, presentation and public speaking skills

• Decision making skills •

Data interpretation skills

• Ability to use Microsoft Office Suite programs

• Ability to prioritize needs and provide feedback

• Ability to capture relevant complex data and analyze same

• Ability to conceptualize, communicate concepts and take a global perspective

• Demonstrated ability to champion projects, implement process improvement initiatives, and collaborate with and coach internal customers

• Ability to achieve results

• Ability to work under stress.

• A Transportation WorkerIdentification Credential (TWIC) must be obtained prior to day one of employment and be maintained for the duration of employment