Business Intelligence Analyst

Washington D.C
Sep 10, 2019
Sep 25, 2019
Full Time
Department Marketing Statement - Business Intelligence Analysts

Come join the Applied Planning Intelligence unit in Metro's Planning Office - a team delivering complex data analysis to inform executive decision-making and improve Metro's performance for customers. The team integrates and leverages big data to develop actionable intelligence on ridership and the customer experience. Analyses touch on a wide range of topics, including service, performance, operations, fare policy, the customer experience, customer impacts of policy proposals, 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. More than one position may be available depending on the qualifications of the candidates.

Minimum Qualifications:


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.


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

Medical Group:

Ability to complete satisfactorily the medical examination for this job. The incumbent must be able to perform the essential functions of the job with or without reasonable accommodation.

Job Summary/Duties:

This role 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, researches 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.

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

Evaluation Criteria:

Consideration will be given to applicants whose resumes demonstrate the required education and experience. Applicants should include all relevant education and work experience.

Evaluation criteria may include one or more of the following:
  • Personal Interview
  • Skills Assessments
  • Verification of education and experience
  • Criminal Background Check
  • Credit history report for positions with fiduciary responsibilities
  • Successful completion of a medical examination including a drug and alcohol screening
  • Review of a current Motor Vehicle Report


Washington Metropolitan Area Transit Authority, a Federal contractor, is an Equal Opportunity / Affirmative Action employer. All qualified applicants receive consideration for employment without regard to race, color, creed, religion, national origin, sex, gender, gender identity, age, sexual orientation, genetic information, physical or mental disability, or status as a protected veteran, or any other status protected by applicable federal law, except where a bona fide occupational qualification exists. Our hiring process is designed to be accessible and free from discrimination.

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.