Data Analyst II, Facilities Maintenance

WHO WE'RE LOOKING FOR

Are you a data-driven problem solver who enjoys turning maintenance and asset data into actionable insights that keep operations running smoothly?

The Data Analyst II reports directly to the Manager, Facilities Operations & Maintenance. This position is responsible for administering and coordinating maintenance of new and existing software systems and technology in the administrative and financial systems for Facilities Maintenance. Serve as subject matter expert for CMTA financial modules (i.e., Oracle, Planview), SharePoint, Hexagon EAM, and others. Coordinate the budget development for Facilities Maintenance programs and manage the variance reporting during the fiscal year updating the VP, Manager, and other Departmental personnel on budget status. The Data Analyst is required to work independently under limited supervision of the Manager, Facilities Maintenance with extensive latitude in using initiative and independent judgment to support the Facilities Maintenance team administratively and financially with asset management, records management, benchmarking, quality assurance support, and other assigned facility management related duties.

WHAT YOU'LL BE DOING

Note: The duties and primary responsibilities below are intended to describe the general content of and requirements of this job and are not intended to be an exhaustive statement of duties.

• Support asset management activities within Hexagon EAM, ensuring accurate classification including updates to maintenance cycles, performing routine data audits, enforcing data standards to support reliable reporting and maintenance planning, task instructions, and recurring schedules; act as subject‑matter expert for Hexagon EAM.

• Support the preventive maintenance program in Hexagon EAM by developing PM schedules, maintaining task libraries, automating recurring work orders, and monitoring compliance to ensure consistent and effective maintenance execution.

• Support the development of maintenance insights by creating operational dashboards, monitoring key performance indicators, and providing recurring and ad‑hoc reporting to support data‑driven decision‑making for Facilities leadership.

• Analyze maintenance and asset performance data to identify reliability issues, support lifecycle planning, and uncover cost drivers and operational inefficiencies that inform improvements in maintenance strategy.

• Collaborate across internal teams and external partners to ensure CMMS data integrity, provide user support, and align system information with organizational initiatives such as capital planning, SOGR, and strategic asset management.

• Support reactive, preventive, and predictive work order triage, assignments, and reporting; provide general facilities operations and maintenance support.

• Oversee daily management of department supplies, equipment, and facilities, including inventory, logistics, energy management support, quality assurance, benchmarking, and security coordination.

• Serve as department records management representative; manage archiving, retrieval, retention, and destruction of records; respond to open records requests in compliance with Capital Metro policies.

• Maintain property record-keeping systems covering warranties, vendor work, preventative maintenance logs, property condition inspections, and building inspections.

• Prepare and maintain cost spreadsheets for capital and operational projects; ensure monthly distribution to leadership and Finance.

• Provide administrative and financial support to the VP, Manager, and staff; document and communicate operational needs; identify irregularities and actions required to maintain continuity of work operations.

• Support Capital Metro’s safety culture by following safety and security policies, considering safety in every action and reporting safety and security concerns.

• Perform other duties as required and/or assigned.

WHAT YOU BRING

• Bachelor's degree in business administration, Administrative Services, or related field.  Additional experience may be substituted on a year-for-year basis up to four (4) years.
• Three (3) years progressively responsible experience in administrative office management which includes three (3) years accounts payables and budget preparation experience, three (3) years financial system experience, and three (3) years of SQL experience required.
• Oracle financial systems experience preferred.
• Enterprise Asset Management systems experience required.
• Computerized maintenance management system (CMMS) experience required.

Knowledge, Skills, and Abilities: 

• Proficient with soft