Business Intelligence Analyst

Washington D.C
May 26, 2023
Jun 11, 2023
Full Time
Department Marketing Statement

Do you have a passion for public transit? Do you want to help Metro understand how people use the system, what factors influence their travel choices, and how customers are impacted by policy proposals? Can you quickly show a busy executive what a large database is telling us about transit ridership patterns? Do you want to help improve Metro from the inside?

If you said yes to any of these questions, you might be the next Business Intelligence Analyst on the Ridership and Mobility Analysis team in Metro's Planning office. Our team integrates and leverages big data to develop actionable intelligence on ridership, regional mobility, and the customer experience. Analyses touch on a range of topics, including the impact of planned service changes, unplanned disruptions, special events, fare policy, changing regional travel patterns, and more.

We are looking for candidates with critical thinking, data science, and research skills; experience working with transportation data and querying SQL databases; and a passion for improving public transit service for riders. The right candidates can transform a large dataset into useful information, and help turn information into ideas and action.

General Hybrid Work Statement:

This opportunity is a hybrid opportunity allowing for flexibility between virtual and in-person work subject to the Authority's telework policy.


  • Graduation from an accredited college or university with a Bachelor's degree in Planning, Engineering, Computer Science or a related technical field.

  • A minimum of two (2) years of progressively responsible experience in business intelligence, data analytics, data science, or a related field.

  • N/A

  • Master's degree in Planning, Engineering, Computer Science or a related technical field.


The Business Intelligence Analyst will support strategic planning activities in the Office of Planning. The incumbent gathers, organizes, and analyzes system data with a particular focus on ridership and revenue patterns across all modes. The employee is required to aggregate multiple sources of data from large datasets, extract insights, develop recommendations, create visualizations, and support the preparation of technical presentations and documents based on the analysis. The results provide critical information that supports planning staff and other WMATA offices' decision making. The incumbent also participates in strategic and tactical planning discussions to identify key questions and areas to be analyzed.


Under the direction of senior staff:
  • Supports planning data analysis on a wide range of topics as needed (e.g., line load conditions, station conditions, ridership trends, capital investment tracking, and/or investment analysis).
  • Performs data evaluation and integration; data cleansing, standardization, un-duplication; data processing, data warehousing, and database design.
  • Summarizes surveys, research operational strategies, prepares reports and recommendations for internal customers and participates as a team member on initiative development.
  • Creates dashboards and develops visualizations and graphics to support PLAN's technical analysis to supply non-technical audiences with understandable information.
  • Maintains effective working relationships with individuals and organizations with whom interface, and cooperation are required.

  • N/A

The functions listed are not intended to limit specific duties and responsibilities of any particular position. Nor is it intended to limit in any way the right of managers and supervisors to assign, direct and control the work of employees under their supervision.

Evaluation criteria may include one or more of the following:
  • Skills and/or behavioral assessment
  • Personal interview
  • Verification of education and experience (including certifications and licenses)
  • Criminal Background Check (a criminal conviction is not an automatic bar to employment)
  • Medical examination including a drug and alcohol screening (for safety sensitive positions)
  • Review of a current motor vehicle report


WMATA is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other status protected by applicable federal law.

This posting is an announcement of a vacant position under recruitment. It is not intended to replace the official job description. Job descriptions are available upon confirmation of an interview.

Similar jobs