Traffic Data Analyst (Analyst III) - Denver

State of Colorado; Denver (CO); On-site; USD 95,000 - 125,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

Life insurance

Disability insurance

PERA retirement

Tuition reimbursement

Professional development

Public Service Loan Forgiveness

Job summary

The Colorado Department of Transportation (CDOT) seeks a Traffic Data Analyst to analyze traffic statistics, maintain GIS maps, and support statewide planning efforts. The role collaborates with CDOT, FHWA, and MPOs to provide data-driven insights for long-range and corridor planning.

Applicants should have extensive experience with GIS, data analytics, and databases, and be able to develop reports and data visualizations to support transportation decisions.

Qualifications

• Six years of professional work experience in Information Systems, GIS, Civil Engineering, Transportation Planning, Statistics or related field with at least two years in acquiring, analyzing, and interpreting traffic data; database management and GIS technologies.
• Or a combination of relevant education and experience totaling six years in these areas.
• Experience with GIS and databases is preferred.

Responsibilities

• Analyze traffic statistics for long-range and corridor planning.
• Develop GIS maps and geodatabases for analysis and reporting.
• Support data integration with CDOT data warehouses and related systems.
• Coordinate with FHWA, MPOs, and planning partners on data needs and reporting.
• Prepare data reports and respond to specialized data requests.

Skills

GIS technologies

Data analytics

Traffic data analysis

Database management

Education

Bachelor's degree in Information Systems, Computer Science, GIS, Civil Engineering, Transportation Planning or related field

Tools

SQL

SAP

GIS software

Job description

This position is only open to Colorado state residents.

New employees to the State will be paid biweekly. There are 26 biweekly pay periods in a year.

About CDOT

CDOT employees make a difference by providing freedom, connection, and experience to the traveling public, while also keeping them safe. The State of Colorado offers competitive medical, dental and vision insurance, life and disability insurance, and flexible spending and health savings accounts. Visit the State of Colorado benefits for details, current premium rates and a summary video about benefits. The state also offers PERA retirement, great optional PERA plans such as 401K, a generous paid time off package of annual, sick, holiday and other leave, strong career growth, tuition reimbursement and professional development. Perks include Colorado Employee Assistance Program (CSEAP) counseling, wellness, credit union membership and employee discount program. Visit CDOT Benefits for details. Some positions may qualify for Public Service Loan Forgiveness.

CDOT for All

CDOT’s strength is our people, and our commitment to our people is to shape, support, and sustain the employee experience, and ultimately, create a supportive workplace where everyone, regardless of gender, race, ethnicity, religion, national origin, age, sexual orientation, gender identity, citizenship status, education, disability, socio-economic status, or any other identity, has the opportunity to thrive.

The eligible list created from this announcement may be used to fill current and future vacancies for a period of up to 6 months.

A bout the Work Unit

This position is located in The Colorado Department of Transportation’s (CDOT’s) Division of Transportation Development’s Office of Transportation Analytics, Traffic Analysis Unit. The Unit assembles, analyzes, and interprets motorized and non-motorized traffic data. This information is used to develop long-range plans, corridor-specific plans, assessments of mobility on the transportation systems, and to support investment level decision making and report traffic trends. The Unit participates in the development of transportation plans and provides support for engineering and construction activities.

About the Position

This position serves as liaison/resource to CDOT, The Federal Highway Administration (FHWA) and Metropolitan Planning Organizations (MPO's) for analysis of traffic statistics and issues related to traffic monitoring activities. The Analyst develops and implements strategies to acquire, analyze, process, report and interpret data on traffic characteristics (i.e. volume, vehicle weight, classification and speed) for long-range and corridor specific planning purposes as well as highway design. This position is responsible for supporting the generation of traffic data statistics and reports needed by internal CDOT units, used to supplement FHWA reporting mandates and supports CDOT statewide short-duration traffic count data analysis and updates traffic data warehouses.

Your duties and responsibilities will include, but are not limited to, the following:

Spatial Traffic Data Analysis, and Traffic Data Analysis

• Integrates data for year-end Annual Average Daily Traffic (AADT) processing and other traffic related statistics.
• Provides operational status mapping.
• Supports the short-term traffic count contract activities by providing maps that show site locations where the contractors will perform work.
• Provides sample location maps and analysis on an as-needed basis for transportation planning, traffic engineering, and other CDOT support functions.
• Supports traffic analysis business processes by facilitating geographic data development, statistical analysis, integration and dissemination including providing GIS maps and geodatabases of historical and current locations showing analysis of changes in traffic volumes and vehicle types to support decision making processes related to transportation planning, highway design, and federal reporting.
• Supports integrating traffic data with online spatial and nonspatial applications.

Database Administration and Maintenance

• Supports the year-end data processing of motorized data using specialized traffic data management software and statistical analysis.
• Works with data structures, production databases, software systems and processes to contribute to CDOT data warehouses.
• Utilizes spatial technologies and participates in decision making with other CDOT database administrators.
• Works as part of a team to develop recommendations for information technology applications, develop methodologies to integrate databases and create processes for quality assurance.
• Works to keep traffic databases and table information up-to-date and accurate by analyzing data usage, trends, and purpose.
• Supports and incorporates additional data into the CDOT traffic analysis software, SQL and/or relational database management systems (RDBMS) databases and spatial databases.

Technical Consulting and Liaison

• Provides support to planning and technical committees that determine policies/standards for traffic analysis used for decision making, planning, mandated reporting and highway design.
• Participates in technical data groups to coordinate multi-agency data collection and traffic analysis efforts. Groups may consist of MPO planners, environmental specialists, engineers, consultants and information management professionals.
• Interprets specific traffic data and coordinates information used in planning documents, formal reports and/or public meetings.
• Provides and completes daily customer service activities including responding and processing special data requests and coordinating special count requests.

Transportation Planning Support

• Supports the development of traffic and mobility related statistics/information and participates in transportation planning activities by creating and analyzing traffic-related data and statistics to define current conditions as well as creating models and analytical processes to project future traffic patterns and identify trends.
• Designs traffic collection plans to monitor trends over the long term.
• Makes determinations on where traffic data collection activities indicate improvements are warranted and which of these are to be recommended as viable candidates to include in long-range plans.
• Works with a team to develop specifications and create standards.

Contract Administration

• Prepares cost analysis documentation.
• Coordinates with procurement officials to identify and assist with appropriate solicitation methods and processes and contractor selection.
• Participates in vendor selection committees.
• Creates data collection schedules for contractors.
• Monitors compliance and authorization of payments.
• Determines quality assurance processes associated with contracted traffic data collection activities.

Other duties as assigned.

Work Environment:

• Primarily 8:00 AM – 5:00 PM work hours, Monday-Friday
• Limited overnight statewide travel as well as out of state travel to attend meetings/conferences.

Minimum Qualifications

Experience Only

• At least six (6) years professional work experience in Information Systems, Computer Science, GIS, Civil Engineering, Civil Engineering Technology, Transportation Engineering, Urban or Regional Planning, Transportation Planning, Statistics, Mathematics, Data Analytics, Traffic Data Analysis or another field closely related to the major job duties that included at least two (2) of full-time professional experience in acquiring, analyzing, and interpreting traffic data; database management and, utilizing GIS technologies.

OR

Experience and Education

A combination of relevant education and experience equal to at least six (6) years

• Education from an accredited college or university, in Information Systems, Computer Science, GIS, Civil Engineering, Civil Engineering Technology, Transportation Engineering, Urban or Regional Planning, Transportation Planning, Statistics, Mathematics, Data Analytics or another field of study closely related to the major duties will be considered.
• Professional experience acquiring, analyzing, and interpreting traffic data; database management and utilizing GIS technologies will be considered.

Please Note

The required experience must be substantiated within the work experience section of your application. “See Resume” statements on the application or resumes in lieu of a complete application may not be accepted. Additional information submitted after the closing date of this announcement will not be considered in the review of your application. In addition, part-time work will be prorated.

College Transcripts

If you are using education to qualify, a legible copy of your official or unofficial college transcript(s) or an official foreign credential evaluation report must be submitted with your application. Transcripts must show your name, the name of the school, completed credit hours, and (if applicable) that a degree was conferred. Transcripts from colleges or universities outside of the United States must have been assessed for U.S. equivalency by a NACES educational credential evaluation service. The credential evaluation report must be an official report. Failure to provide a transcript or official foreign credential evaluation report may result in your application being rejected and you will not be able to continue in the selection process for this position.

Conditions of Employment

• Must pass a pre-employment screening which may include social security number trace, criminal records check, public court records check, educational records, and driving records checks. More information in the supplemental information section.

Preferred Qualifications

The exceptional applicant will be an experienced traffic data analyst with proven ability or accomplishment in the following:

• Demonstrated success with the duties listed in the Description of the Job section.
• Years of State service experience related to the duties of this position.
• Highest work/personal ethics and integrity.
• Experience acquiring, analyzing and interpreting spatial data and transportation/traffic data.
• Experience performing statistical analysis.
• Extensive experience developing maps.

• Experience using GIS technologies.
• Experience with/competency in using database software, SQL and/or RDBMS databases, and traffic data processing software.
• Experience with specialized traffic data types (volume, weight, classification and speed).
• Experience working with big data sources and vendors.
• Experience managing databases, including creating/running reports; creating multiple queries, forms, and tables. performing quality assurance and quality control of data; integrating new data and converting/moving data to new databases and documenting database processes.
• Competency in using database software, SQL and/or RDBMS databases and traffic data processing software.
• Experience providing project management support.
• Experience with contract administration and management.
• Experience with state procurement processes.
• Proven ability to manage multiple assignments, priorities, and projects in a demanding environment.
• Strong time and project management skills, including prioritization.
• Customer service focus.
• Ability to work under tight deadlines and be adaptable to changing assignments.
• Ability to take initiative to solve problems in an innovative manner.
• Ability to partner with various stakeholders with sensitivity to their needs, priorities, promises made and commitments.
• Effective interpersonal and relationship building skills.
• Excellent reasoning, investigative, analytical, and problem-solving skills and ability.
• Effective oral and written communication skills including facilitation and presentation skills.
• Strong attention to technical detail and accuracy.
• Passion for safety.
• Ability to work effectively in both independent and team situations.
• Fluency in Microsoft Office Suite (Word, Excel, Access), Google applications, Gmail, SAP, GIS, and the ability to quickly learn other software systems.

Applicant Checklist

Complete Applications must include the following documents:

1. A complete CDOT Application for Announced Vacancy (please submit online using the green 'APPLY' button at the top of this announcement)
2. A complete Supplemental Questionnaire (The questionnaire is part of the online application. You will be prompted to answer them as you are completing your online application.)
3. A cover letter that describes your interest in this position, how your experience aligns with the minimum and preferred qualifications of this position. Cover letters must be uploaded as an attachment to your online application. Cover letters will not be accepted after the closing date and time of the announcement.
4. A detailed chronological resume. Resumes must be uploaded as an attachment to your online application.
5. If you are using education to qualify, a copy of your official or unofficial transcript showing all coursework, degree(s) conferred, your name and the name of your school, or your formal NACES accreditation repot. Please submit this as an attachment to your online application.
6. If you are a veteran, a copy of your DD214. Please submit this as an attachment to your online application.

Please note that you may redact information on your attachments that identifies your age, date of birth, or dates of attendance at or graduation from an educational institution.

Only complete applications submitted by the closing date for this announcement will be given consideration. Every effort must be made to submit all application materials by the announcement close date. Where unusual circumstances prevent timely acquisition of transcripts, they must be submitted within five business days of the announcement close date. Resumes will not be accepted in lieu of a completed application. Failure to submit properly completed documents by the closing date of this announcement may result in your application being rejected.

The State of Colorado strives to create a Colorado for All by building and maintaining workplaces that value and respect all Coloradans through a commitment to equal opportunity and hiring based on merit and fitness.

The State is resolute in non-discriminatory practices in everything we do, including hiring, employment, and advancement opportunities.

The Hiring Process: All applications that are received by the closing of this announcement will be reviewed against the minimum qualifications in this announcement. Candidates who meet the minimum qualifications proceed to the next step.

Colorado Revised Statutes require that state employees are hired and promoted based on merit and fitness through a comparative analysis process.

Notifications: All correspondence regarding your status in the selection/examination process will be via email. Include your current working email address on your application and check your email frequently as you could receive time sensitive correspondence regarding this position. It is your responsibility to ensure that your email will accept notices from state.co.us and [e-mail] addresses.