Connecticut StateDepartment of Administrative Services

Transportation Planner 2 (40 Hour)

Enterprise Geographic Information System

Recruitment #220722-8876FE-001


The State of Connecticut Department of Transportation (DOT) is recruiting for a Transportation Planner 2 in the Bureau of Policy and Planning, Enterprise Geographic Information System (GIS) Unit in Newington, Connecticut. 
About Us: As one of Connecticut’s largest State agencies, DOT employs approximately 3,000 individuals statewide in five distinct bureaus. It is our mission to provide a safe, accessible, and efficient multimodal transportation network that improves the quality of life and promotes economic vitality for the State and the region. We have a significant transportation infrastructure system that is essential to maintaining mobility for Connecticut residents and businesses and supporting economic and community development while preserving the State’s resources. The Department of Transportation is committed to cultivating a diverse staff that is representative of the communities we serve. Applications from individuals having diverse backgrounds and life experiences are strongly encouraged. 

At CTDOT, the Enterprise GIS Unit is integral to the development and continued support of the Department’s Transportation Enterprise Data (TED) Management System, which is a data architecture and set of business processes for managing data. TED provides for a shared and integrated communal data experience from a common data platform while ensuring high quality, managed, authoritative data is consistently available and treated as a high value Department asset. Additionally, the Enterprise GIS Unit is the Department’s lead unit tasked with developing data management & analytical tools and providing visualization services for the rest of the Department.

Benefits: The DOT offers a competitive starting salary and excellent State benefits package including health/dental insurance, generous paid time off, retirement plan, alternate work schedule options and a multitude of other benefits. We also offer the convenience of an on-site, low-cost fitness center, on-site cafeteria, and ample free parking. We are centrally located in Newington with easy access from major highways and by public transportation. This position is full time, 40 hours per week and is in the P-4 (Engineering, Scientific and Technical) bargaining unit.
The Role: This position will work in a lead capacity at an advanced level. The incumbent will act as the unit lead on a variety of tasks to help meet overall Department goals related to enterprise data management. They will play a critical role in the evolving development of data as well as the performance measurement of data assets to support data-driven decisions related to topics such as: safety analysis, project prioritization, return on investment, among others. They will be a critical resource for the Department with expected expertise in relevant technology solutions, data management best practices and applicable policies. This position will require the selected candidate to work with partners across all the Department’s Bureaus performing data analysis, visualization, and synthesis so that the findings can be turned into actionable and easy to consume recommendations.

Watch the video below to see what it's like to be a State of CT employee! 

Selection Plan

To Apply:
  • In order to be considered for this job opening, you must meet the Minimum Qualifications as listed on this job opening. You must specify your qualifications on your application. 
  • The minimum experience and training requirements must be met by the close date on the job opening, unless otherwise specified.
  • Ensure that your application is complete and detailed before submitting it. In order to comply with Public Act 21-69, the State of Connecticut is no longer asking for resumes during the initial application process. You will not be able to make revisions once your application is submitted into the JobAps system.
  • Please select all location(s) and shift(s) you are willing to work on your application. Failure to do so may result in not being considered for vacancies in that specific location.
  • All application materials must be received by the recruiting agency by the time specified on the job opening for the position for which you are applying. Late applications may not be submitted and will not be considered. Exceptions are rare and limited to documented events that incapacitate a candidate during the entire duration of the job posting time period.  It is the candidate’s obligation and responsibility to request an exception and provide a legally recognized justification to accommodate such exception. Requests should be made to
After You Apply: 
  • Although applicants will receive correspondence via email, as a backup they are also encouraged to sign on to their Personal Status Board daily to monitor their status, view all emailed notices and complete tasks required in the recruitment process.
  • This posting may require completion of additional referral questions (RQs). You can access these RQs via an email that will be sent to you after the posting's closing date or by visiting your JobAps Personal Status Board (Certification Questionnaires section). Your responses to these RQs must be submitted by the question's expiration date. Please regularly check your email and JobAps Personal Status Board for notifications. Please check your SPAM and/or Junk folders daily in the event an email provider places auto-notification emails in a user's spam. 
  • At any point during the recruitment process, applicants may be required to submit additional documentation which support their qualification(s) for this position. These documents may include: a cover letter, resume, performance reviews, attendance records, supervisory references, licensure, etc., at the discretion of the hiring agency. Applicants must meet the minimum qualifications as indicated to apply for this position. 
  • The immediate vacancy is listed above, however, applications to this recruitment may be used for future vacancies in this job class. Interviews will be limited to candidates whose experience and training most closely meet the requirements of the position. 
Connect With Us:
  • Due to the large volume of applications received, we are unable to provide confirmation of receipt or status during the recruitment process. Updates will be available through your JobAps portal account. 
  • If have any questions pertaining to this recruitment, please contact


In the Department of Transportation and the Connecticut Airport Authority this class is accountable for acting as a working lead and/or for performing the most complex tasks in transportation planning studies, programs and related activities.


Daily tasks include, but are not limited to, the following duties:

  • Working with bureau representatives, the TED team, IT, and within the DOT Enterprise GIS (EGIS) unit to identify opportunities to develop data access products and management solutions to support; strategic data-driven decision making, program outcome assessments, cost benefit analysis, operational efficiencies, data visualization capabilities, and ad-hoc queries across the agency;
  • Working with EGIS staff, DOT Subject Matter Experts, and DOT IT personnel for management and maintenance of the Enterprise ArcSDE architecture, including development and implementation of ETL processes, geodatabase replication, and collaboration among other functions;
  • Configuring commercial off the shelf (COTS) tools such from Esri, VertiGIS, Microsoft, Safe, and others to help meet the data management, visualization, and analysis needs of Department stakeholders;
  • Working with data stakeholders, leveraging data visualization and analysis tools to advance business intelligence and timely knowledge transfer for teams;
  • Analyzing data, deriving insights, formulating conclusions, and presenting results to business stakeholders;
  • Examining data sets to determine the best analysis plan to address key business questions; identifies opportunities for improvements in data collection, validation, maintenance and access for data owners, stewards, and custodians;
  • Working with data owners, stewards, and custodians to assess data maturity and identify data needs related to improving the uniformity, completeness, timeliness, & accuracy of authoritative Department data;
  • Performing and assisting with data management functions such as data cataloguing, business requirements gathering, process flow diagramming, and data gap analysis critical to developing fully integrated solutions;
  • Adhere to and offer guidance to DOT staff related to data governance policies and procedures;
  • Develop and conduct training and presentations for all relevant stakeholders and customers;
  • May supervise or aid in training of Transportation Planner 1’s or CCT’s;
  • Perform other related duties as assigned which can be viewed here


Considerable knowledge of multi-modal transportation planning theory, practices and methodologies; knowledge of environmental considerations involved in transportation planning; interpersonal skills; oral and written communication skills; ability to develop and use computer software including planning models and other programs related to planning process; analytical ability; ability to forecast trends based upon empirical data; ability to comprehend and interpret laws and regulations; some lead ability.


Seven (7) years of professional experience in transportation civil engineering or transportation, urban, regional or environmental planning.


One (1) year of the General Experience must include individual responsibility for the coordination of complex planning projects in a relevant planning area.
Note: For State Employees this is interpreted at the level of Transportation Planner 1 or Transportation Engineer 2.


1. College training may be substituted for the General Experience on the basis of fifteen (15) semester hours equaling one-half (1/2) year of experience to a maximum of four (4) years for a Bachelor's degree.
2. A Master's degree in civil engineering, transportation, urban, regional or environmental planning may be substituted for one (1) additional year of the General Experience.


  • Experience or education in: Mathematics, Statistics, Physics, Management Information Systems, Computer Science, Data Science, Data Mining, Geographic Information Systems or Geography.
  • Experience utilizing problem-solving skills with an emphasis on data architecture & modeling, data linkage, and GIS (Geographic Information System) application configuration.
  • Experience coordinating across diverse teams of engineers, planners, and financial administrators (among others), both internal to the Department as well as external partners.
  • Experience using geospatial data management tools such as Esri’s ArcGIS Desktop Suite (ArcMap, ArcCatalog, etc.) ArcGIS Pro, QGIS, Esri’s ArcGIS Enterprise web-based suite (Web-App Builder, Survey123, Collector, Field Maps, Workforce, Experience Builder), Safe Software’s Feature Manipulation Engine (FME) and others.
  • Experience working with a wide variety of datasets and databases (e.g. Oracle, ArcSDE, SQL).
  • Experience working with relevant programming languages to facilitate geospatial data management and analysis (e.g. Python, R).
  • Experience working with a variety of data analysis, automation, and visualization software products including those available through Esri (e.g. Insights, StoryMaps, etc.), Microsoft (PowerBI & PowerAutomate), Tableau, and Safe Software (e.g. FME Server).
  • Experience with the unique concerns of a Government agency as they apply to data availability, policy constraints, and legal considerations.


1. Incumbents in this class may be required to possess and retain a valid Motor Vehicle Operator’s license.
2. Incumbents in this class may be required to travel.



The State of Connecticut is an equal opportunity/affirmative action employer and strongly encourages the applications of women, minorities, and persons with disabilities.

Click on a link below to apply for this position:

Fill out the Supplemental Questionnaire and Application NOW using the Internet.

The State of Connecticut is an Affirmative Action/Equal Opportunity Employer and strongly encourages the application of women, minorities and persons with disabilities.