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. • Provides support using “Big Data” sources to generate traffic data statistics that support other CDOT units, FHWA and other internal/external stakeholders. Integrates big data with traditional traffic counts to support traffic data requests and development of annual year-end traffic data reporting. Works with FHWA to develop plans that integrate big data into federally mandated traffic reporting. • Provides maps in response to questions/requests for information from management. • Updates and maintains Traffic Analysis Unit GIS databases and performs spatial analyses related to the databases. 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 all of the following: • 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: • A complete CDOT Application for Announced Vacancy (please submit online using the green 'APPLY' button at the top of this announcement) • 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.) • 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. • A detailed chronological resume. Resumes must be uploaded as an attachment to your online application. • I f 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. • 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. 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. We highly recommend that you set up your email to accept messages from " state.co.us " and " info@governmentjobs.com " addresses. It is your responsibility to ensure that your email will accept these notices and/or review your junk mail and spam filtered email. Immediately after you submit your application you should receive an email that confirms that you successfully submitted an application for this position. If you do not, try submitting again until you receive the confirmation email. Be sure to also check your junk folder for email communications from the State of Colorado's website. 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. • Part, or all, of the comparative analysis for this position may be a structured application review, which involves a review of the information you submit in your application materials by Subject Matter Experts (SMEs) against the preferred qualifications. • Be sure your application materials specifically address your qualifications, experience, work products, and accomplishments as they relate to the Major Duties, Minimum Qualifications, and Preferred Qualifications sections as listed above. Failure to include adequate information or follow instructions by the deadline for application may result in your application not being accepted for this position and may affect your inclusion as a qualified candidate in any step of the selection process and placement on the eligible list. • A top group, up to six candidates, will be invited to schedule an interview with the hiring manager. Transfer, Non-Disciplinary Demotion or Reinstatement If you believe that you are eligible to be considered as a transfer, non-disciplinary demotion, or reinstatement to this vacancy, you must submit a completed application following the directions in this job announcement and you will be included in the selection process along with other qualified applicants. If you are the finalist for this position after the selection process, Human Resources will confirm your eligibility to be appointed as a transfer, non-disciplinary demotion, or reinstatement applicant. Employment Screening If an applicant reaches the finalist stage of the hiring process, the Colorado Department of Transportation may procure a consumer report and/or investigative consumer report on the applicant in connection with his/her application for employment purposes, as defined under the Fair Credit Reporting Act. These reports may be obtained at any time after receipt of the applicant's authorization. As part of the employment screening an applicant will be requested to disclose any deferred judgments and convictions as well as an explanation of the circumstances around any arrest or conviction. In the event that a screening returns information that the applicant believes is not accurate, he or she will have an opportunity to dispute the information with “Accurate.” Accurate, a consumer reporting agency, will obtain the report for CDOT. Further information regarding Accurate including its privacy policy, may be found online at www.accurate.com . Accurate is located at 200 Spectrum Center Drive Suite 1100, Irvine, CA 92618. The report may contain information bearing on the applicant's character, general reputation, personal characteristics, and mode of living. The information that may be included in the report includes social security number trace, criminal records check, public court records checks, educational records, and driving records checks . CDOT will only request credit reports insofar as they relate to the position for which the applicant is applying. The information contained in the report will be obtained from private and/or public record sources. The applicant will have the right, upon written request made within a reasonable time after receipt of a notice, to request disclosure of the nature and scope of any investigative consumer report. Appeal Rights If you receive notice that you have been removed from consideration during the selection or comparative analysis process for this position, you may file an appeal with the State Personnel Board and/or request a review by the State Personnel Director. A standard appeal form is available on the State Personnel Board website, spb.colorado.gov . If you appeal, your appeal must be submitted in writing on the official appeal form, signed by you or your representative, and received at the following address within ten (10) days of your receipt of this notice: Colorado State Personnel Board/State Personnel Director, Attn: Appeals Processing, 1525 Sherman Street, 4th Floor, Denver, CO 80203. Fax: 303-866-5038. Phone: 303-866-3300. Email address: dpa_state.personnelboard@state.co.us . The ten-day deadline and these appeal procedures also apply to all charges of discrimination. Refer to Chapters 4 and 8 of the State Personnel Board Rules and Personnel Director's Administrative Procedures, 4 CCR 801, for information about the appeals process. The State Personnel Board Rules and Personnel Director's Administrative Procedures are available at spb.colorado.gov . ADAAA Accommodations CDOT is committed to the full inclusion of all qualified individuals. As part of this commitment, our agency will assist individuals who have a disability as defined by the ADA Amendments Act of 2008 (ADAAA) with any reasonable accommodation requests related to employment, including completing the application process, interviewing, completing any pre-employment testing, or participating in the employee selection process, and/or to perform essential job functions where the requested accommodation does not impose an undue hardship. If you have a disability and require reasonable accommodation to ensure you have a positive experience applying or interviewing for this position, please direct your inquiries to Lynn Livingston at LynnR.Livingston@state.co.us Former State Employees Former employees of the Colorado Department of Transportation System or any other State of Colorado Department or Agency, who were disciplinarily terminated or resigned in lieu of termination, must disclose this information on his/her application. LL (SAP #50003374/PCR #67533)

Requirements

Must-haves

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.
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 integrating traffic data with online spatial and nonspatial applications.
Provides maps in response to questions/requests for information from management.
Updates and maintains Traffic Analysis Unit GIS databases and performs spatial analyses related to the databases.
Database Administration and Maintenance

Nice-to-haves

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.
Competency in using database software, SQL and/or RDBMS databases and traffic data processing software.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sql

Platform: governmentjobs
Effort: medium

Benefits

Benefits detected in the listing.

Dental

Vision

401k

Paid Time Off

Wellness

Professional Development