Business Intelligence (BI) Analyst

Basic Function

Responsible for developing, maintaining, and analyzing data for Facilities Maintenance. The Business Intelligence (BI) Analyst supports the department by performing data analysis, developing dashboards, visualization reports, and metrics that provide business insight and aid in business decision-making. Collaborates with subject-matter experts for objectives and Key Performance Indicators (KPIs) in designing relevant reports and dashboards. Perform duties in a safe, efficient manner and in compliance with all applicable rules and safety procedures.

Responsibilities and Specific Duties

• Collaborates with subject matter experts in creating dashboards and reports to monitor KPIs such as preventive maintenance compliance, energy efficiency, and asset lifecycle performance.
• Collects, cleans, and validates facilities-related data from Computerized Maintenance Management Systems (CMMS), Building Management Systems (BMS), Internet of Things (IoT) sensors, and other sources.
• Applies business analytical tools to collect and analyze data for use in project planning and decision-making.
• Analyzes trends in work orders, equipment downtime, and space utilization to identify cost-saving opportunities.
• Creates, automates, updates, disseminates, and communicates reports and analyses.
• Works with Facilities, Sustainability, and Finance teams to understand reporting requirements and deliver actionable insights.
• Maintains documentation for Business Intelligence (BI) processes, data models, and reporting standards specific to facilities operations.
• Monitors data quality and troubleshoots issues related to facilities data integrity.
• Stays informed on Business Intelligence information best practices and emerging technologies relevant to facilities management.
• May serve as Project Manager for special projects as assigned by the VP Facilities Maintenance.
• Provides excellent customer service to METRO’s internal and external customers.
• Applies SMS (Safety Management System) methods and principles in daily routine and supports all aspects of the agency’s Public Transportation Agency Safety Plan (PTASP).
• Promotes safety awareness and follows safety procedures to reduce or eliminate accidents.
• Performs other job-related duties as assigned.
• Pay Range : $63,200 - $82,800

Education Requirement

Bachelor’s degree in Business Analytics, Facilities Management, Data Science, or related field

Years & Experience Required

0–2 years in data analysis, reporting, or BI-related roles (internship experience acceptable). Use of BI Reporting (Tableau) ArcGIS Pro.

Knowledge & Skills Required

Basic proficiency in SQL for querying facilities data. Familiarity with BI tools (Power BI, Tableau, or similar). Understanding of Excel for data manipulation and reporting. Strong analytical and problem-solving abilities. Excellent communication and collaboration skills. Attention to detail and ability to manage multiple tasks.

Additional Information

The Metropolitan Transit Authority of Harris County, Texas has a zero-tolerance drug and alcohol policy for all employees. All internal and external applicants will be required to undergo drug testing before employment and will be subject to further drug and/or alcohol testing throughout their employment. Further, employees who perform safety-sensitive functions will submit to drug and/or alcohol testing in accordance to the Department of Transportation (DOT) and the Federal Transit Administration (FTA) regulatory requirements. We provide equal opportunity to all qualified individuals regardless of race, color, religion, age, sex, national origin, veteran status, genetic information, or disability.