Planning Maintenance Analyst

Addison Group; Houston (TX); On-site; USD 90,000 - 130,000; Full time

Job summary

Addison Group is seeking a data analytics professional to support maintenance operations in Houston. You will design data models, build dashboards, and optimize CMMS data flows to enable timely, data-driven decisions for terminal facilities.

The role requires strong SQL, Excel and Power BI skills, plus CMMS/EAM familiarity (Maximo/Infor/SAP). A bachelor’s degree and 5+ years in related settings are preferred, with a focus on asset management analytics.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or related field.
• 5+ years of terminal equipment knowledge and related experience.
• Familiarity with CMMS/EAM software such as Maximo, Infor or SAP.

Responsibilities

• 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 for decisions.
• Analyze data to determine best fields for KPIs and ensure data accuracy.
• Develop maintenance plans and schedules for company assets.
• Own the design and development of automated reporting solutions.
• Analyze planning data to define manpower, parts and resources.
• Track maintenance metrics and report variances monthly and quarterly.

Skills

Data analysis

Power BI

SQL

Excel

Communication

Education

Bachelor’s degree in Computer Science or related field

Tools

Maximo

Infor

SAP

Job description

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
• Ability to use Microsoft Office Suite programs