Transportation Planner I/II Data Analyst

Washington D.C.
Aug 10, 2021
Sep 14, 2021
Full Time

The Metropolitan Washington Council of Governments (MWCOG or simply COG) is an independent, nonprofit association that brings area leaders together to address major regional issues in the District of Columbia, suburban Maryland, and Northern Virginia. The National Capital Region Transportation Planning Board (NCRTPB or simply TPB) is the federally designated Metropolitan Planning Organization (MPO) for the Washington, D.C. metropolitan area. The TPB is also one of several policy boards that operate at COG. COG is the administrative agent for the TPB, and the TPB is staffed by COG’s Department of Transportation Planning (DTP). COG has a staff of about 120 employees, half of whom work in the DTP. COG was founded in 1957. The TPB was created in 1965 and became associated with COG in 1966.


The Council of Governments' (COG) Department of Transportation Planning seeks a Transportation Data Analyst for the Planning Data and Research Team to primarily support the Continuous Airport Systems Planning (CASP) program. The successful candidate for this position will play a key role in the collection, processing, analysis, and visualization of data from the COG’s biennial regional air passenger survey, travel volume trends, demographic, and transportation infrastructure data used in regional policy studies, forecasting, and performance-based planning and programming.

Duties will include:

  • processing and analyzing travel surveys, traffic, and transportation infrastructure data (e.g., bridge and pavement conditions);
  • providing logistics planning and operational support to the Washington-Baltimore Regional Air Passenger Survey, conducted every two-years;
  • preparing airport ground access forecasts using input data from the air passenger survey, cooperative forecasts of population, households and employment, and FAA terminal area forecasts for the region’s three large commercial airports;
  • processing, analyzing, and synthesizing large datasets and creating visualizations and other data summaries;
  • synthesizing land use and demographic data to inform regional forecasting;
  • developing visualizations of these data using Geographic Information System (GIS) software and other data visualization tools;
  • developing improved methods to more reliably measure and report on year-to-year changes in regional travel trends;
  • applying assurance and quality control measures to data;
  • supporting the Transportation Planning Board’s Aviation Technical Subcommittee; and
  • writing and presenting technical reports and policy-oriented information reports



No direct staff supervisory responsibilities but may be involved in recruitment, supervising interns, and/or oversight of consultants during air passenger survey operations.  Such responsibilities may include interviewing, hiring, and training interns; planning, assigning, and directing work; appraising performance; rewarding and disciplining; addressing complaints and resolving problems.


The ideal candidate will possess excellent communication skills and demonstrated skill in critical thinking, judgment, and data analysis. This candidate will also have a strong academic background in statistical analysis, land use and transportation planning, , data science, and research methods. Experience with computer software packages used for database development, statistical analysis, and reporting is required as is knowledge of the use of survey and other data in regional transportation planning activities as well as airport systems and ground access planning, is also highly desirable. Experience with GIS software (ArcGIS) is preferred.


To be considered for the Analyst I position, candidates must possess a bachelor’s degree in statistics, geography, economics, urban or regional planning, transportation planning, or an appropriately related field, and 0-1 years of directly applicable work experience. 

To be considered for the Analyst II position, candidates must possess a master’s degree in statistics, geography, economics, urban or regional planning, transportation planning, or an appropriately related field, and 2-3 years of directly applicable work experience. 

Any equivalent combination of experience and training which provides the required knowledge, analytical and writing skills and abilities will be considered.


Experience with Microsoft Office programs (Word, Excel, PowerPoint), statistical software (SAS preferred), ArcGIS, data management, and data visualization software. 


Ability to read, analyze, and interpret common scientific and technical journals, financial reports, and legal documents. Ability to respond to common inquiries or complaints from members, regulatory agencies, community leaders and citizens. Ability to effectively present information to top management, public groups, and/or boards of directors.


Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, and decimals. Ability to compute percentages, rates, and ratios and to draw and interpret numeric charts and graphs.


Ability to define problems, collect data, establish facts, and draw valid conclusions. Ability to interpret an extensive variety of instructions furnished in written, oral, diagram, or schedule form and deal with a variety of abstract and concrete variables in situations where only limited standardization may exist.


No Requirements

The Metropolitan Washington Council of Governments is committed to compliance with federal and state laws requiring that MWCOG only hires workers who are lawfully entitled to work in the United States (U.S. citizens or nationals and non-citizens with valid work authorization) without discrimination. MWCOG does not sponsor Visas of any type.  All persons employed by Metropolitan Washington Council of Governments are required to comply with the Immigration Reform and Control Act of 1986 by presenting documents to verify identity and authorization to work in the United States.

Acceptable forms of identification are listed by the Department of Homeland Security / U. S. Citizenship and Immigration Services on Form I-9, Employment Eligibility Verification.

Further information can be found on MWCOG’s Human Resources webpage (

MWCOG is an Equal Employment Opportunity (EEO) employer. We do not discriminate on the basis of race, religion, color, sex, age, national origin, disability, sexual orientation or any other class protected by state or federal laws in admission or access to our programs, services, activities, hiring, and employment practices.


Similar jobs