Business Intelligence Analyst

Washington D.C
Feb 18, 2021
Mar 04, 2021
Full Time
The Washington Metropolitan Transportation Authority, Office of Planning is seeking a candidate to join our Capital and Systems Intelligence (CSI) team, a small group of data scientists who use SQL, Python, and other data science tools to transform our many raw data sources into datamarts, dashboards, tools, and visualizations to inform capital plans and programs, and transit systems performance and planning. A successful candidate will have a passion for public transportation, be adept at critical thinking and creative problem solving, and has fun wading knee-deep through unprocessed data generated by operational systems. This role involves some team work and daily check-ins, but successful candidates will be self-starters who can tackle tough tasks with limited oversight. While Oracle database and Tableau currently make up the primary analytical platform, candidates with other software development and/or big data analytical skills -- including R, Python, et al.-- are encouraged to apply.

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:
  • 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