Maintenance Analytics Lead: Power BI & SQL Insights

Washington Metroplitan Area Transit Authority; Sterling (VA); On-site; USD 110,000 - 160,000; Full time

Job summary

WMATA is seeking a Maintenance Data Analytics Manager to transform maintenance, asset, and work order data into actionable insights that improve system reliability and service delivery. You will develop dashboards, analyze equipment trends, identify recurring failures, and measure KPIs to inform executive decisions.

In this leadership role, you will build Power BI dashboards, leverage SQL for data connections, automate reporting, and collaborate with stakeholders to optimize resources and

Qualifications

• Bachelor’s degree in Data Science, Mathematics, Statistics, Engineering, or a related field.
• Minimum six (6) years of progressive experience in data visualization or visual reporting.
• Experience working with large data sets.

Responsibilities

• Leads the design of dashboard visualizations for Power BI and connects dashboards to data sets using SQL.
• Develops charts, maps, and graphical presentations of maintenance and quantitative information via dashboards and automated reports.
• Recommends and develops effective data visualizations to improve leadership communications.
• Partners across infrastructure, operations, and data analysis teams to deliver reporting products.
• Leads project-based deliverables for internal and external reporting.
• Conducts quality checks on data sources to ensure accurate decision making.

Skills

Power BI

SQL

Data visualization

Dashboard design

Stakeholder communication

Education

Bachelor’s degree in Data Science, Mathematics, Statistics, Engineering, or related field

Tools

Power BI

Excel

Job description

WMATA is seeking a Maintenance Data Analytics Manager to transform maintenance, asset, and work order data into actionable insights that improve system reliability and service delivery. You will develop dashboards, analyze equipment trends, identify recurring failures, and measure KPIs to inform executive decisions.

In this leadership role, you will build Power BI dashboards, leverage SQL for data connections, automate reporting, and collaborate with stakeholders to optimize resources and