Transportation Data Analyst I or II DOQ

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 department’s travel monitoring activities. The successful candidate for this position will play a key role in the collection, processing, analysis, and visualization of data from the COG’s travel monitoring program, including data related to travel volume trends, transportation infrastructure data used in regional policy studies, travel forecasting, and performance-based planning and programming.

Duties will include:

• Compiling transportation data from a variety of inputs including federal, state, and jurisdictional sources
• Applying assurance and quality control measures to data
• Analyzing transportation data for inconsistencies and developing solutions to fill data gaps
• Processing and analyzing short-term and continuous traffic count data
• Developing traffic related data consistent with specifications of the Highway Performance Monitoring System (HPMS) program
• Analyzing transportation data to identify trends and updating annual reports and spreadsheets
• Developing and updating geodatabases and related data tables
• Conducting analyses of transportation data, as requested, to assist in various departmental studies
• Drafting Requests for Proposals (RFPs) and task orders for traffic monitoring, and participating on selection committees
• Overseeing contractors’ performance and reviewing data collected
• Researching and utilizing big data products to inform regional travel trends or patterns
• Responding to transportation data inquiries and questions from COG/TPB staff, federal, state and local partners, universities, and consultants
• Preparing memoranda and technical reports
• Reviewing professional reports and other documents and summarizing findings
• Participating in conferences and webinars as well as COG/TPB committee, subcommittee, and user’s group meetings and workshops

SUPERVISORY RESPONSIBILITIES

No direct staff supervisory responsibilities but may be involved in recruitment, supervising interns, and/or oversight of consultants performing field data collection 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.

REQUIRED KNOWLEDGE, SKILLS, AND ABILITIES 

The ideal candidate will possess excellent communication skills and demonstrated skills in critical thinking, judgment, and data analysis. The candidate will possess a strong understanding of traffic data and data formats; experience or familiarity with the application of GIS concepts, including experience with ArcGIS software; experience using statistical and data management software; and experience with the Microsoft Office suite (Word, Excel, PowerPoint, etc.). The candidate will be an excellent team player and focused on delivering high quality work products in support of COG’s metropolitan transportation planning mission.

EDUCATION AND EXPERIENCE

To be considered for the Analyst I position, candidates must possess a bachelor’s degree in statistics, geography, economics, urban and regional planning, transportation planning, transportation engineering, architecture 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 and regional planning, transportation planning, transportation engineering, or an appropriately related field, and 2-3 years of directly applicable work experience. 

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

COMPUTER KNOWLEDGE AND SKILLS

Experience with Microsoft Office programs (Word, Excel, PowerPoint), statistical software (SAS. R), ArcGIS, programming languages such as Python, and other data management software. 

COMMUNICATION SKILLS  

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 communicate within and across teams of individuals.

MATHEMATICAL SKILLS  

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.

REASONING ABILITY  

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.

CERTIFICATES, LICENSES, REGISTRATIONS

No Requirements

PHYSICAL DEMANDS

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is regularly required to talk and hear. The employee frequently is required to stand; sit; and use hands to finger, handle, or feel.  The employee is occasionally required to walk; reach with hands and arms; and stoop, kneel, crouch, or crawl.  Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception, and ability to adjust focus. The employee at times may be required to travel within the region to a data collection location or to attend meetings held at partner agency offices.

WORK ENVIRONMENT

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

The noise level in the work environment is usually quiet.

COG currently operates in a “hybrid” manner, where an employee may be eligible to telework up to two days per week, pending supervisor and Executive Director approval.

Salary Range: $62,652.76 - $87,713.62 Analyst I                             

$66,422.11 - $96,512.36 Analyst II  Salary Depends on Qualifications 

If you would like to apply please click HERE