Transportation Planner 2

GIS Enterprise

Recruitment #221024-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 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.

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 and may also supervise employees of a lower grade. The incumbent will act as the unit lead on a variety of tasks to help meet overall Department goals related to enterprise data management with a focus on geospatial data management. They will play a critical role in the 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.  As a part of the data management solution building process, the candidate will need to gather business requirements of proposed solutions, advise customers on technology capabilities, logically make connections between data systems where appropriate, work collaboratively with partners to implement the solution, and provide training to facilitate adoption. 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.

Examples of Duties: 
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 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 job training of Transportation Planner 1’s or CCT’s;
  • Perform other related duties as assigned.
Competitive starting salary, excellent State benefits package including health and dental insurance, generous paid time off, retirement plan options, alternate work schedule options, telework opportunities, professional development and tuition reimbursement, and a culture that promotes work-life balance

Selection Plan

To Apply:
  • In order to comply with Public Act 21-69, the State of Connecticut is no longer asking for resumes during the initial application process.
  • The minimum experience and training requirements must be met by the close date on the job opening, unless otherwise specified.
  • Please ensure that your application is complete before submitting it. Applicants will be unable to make revisions once their application is submitted into the JobAps system. Applicants who submit and subsequently withdraw their application will not be able to resubmit for the same posting.
  • 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
  • For assistance in applying, please visit our 'Applicant Tips on How to Apply' page
Important Next Step Information for 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 on a daily basis 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 on a daily basis 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, transcripts, diplomas, performance reviews, attendance records, supervisory references, licensure, etc., at the discretion of the hiring agency.
  • The immediate vacancies are 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.
  • Candidates who are offered and accept a position with the State of Connecticut are bound by the State Code of Ethics for Public Officials and State Employees which is available at
Connect With Us:
Due to the large volume of applications received, the State of Connecticut is unable to provide confirmation of receipt or status during the recruitment process. Updates will be available through your JobAps portal account. If you have any questions pertaining to this recruitment please contact Hayley Newhouse at or (860) 986-6918.


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.


WORKING LEAD LEVEL: As assigned by a supervisor distributes, prioritizes, oversees and reviews office unit work; provides staff training and assistance; conducts or assists in conducting performance evaluations; acts as liaison with operating units, agencies, consultant staffs and other outside officials regarding unit office policies and standards; prepares correspondence; performs related duties as required.
ADVANCED LEVEL: Performs complex tasks and assignments in developing, coordinating and reviewing transportation planning programs; recommends, coordinates or participates in transportation demonstration projects; participates in preparation and negotiation of agreements and contracts; oversees and participates in corridor studies; prepares and reviews reports, studies and surveys in compliance with department standards and needs and state and federal laws and regulations; coordinates activities or projects with local, regional, state and federal agencies, consultants and stakeholders as required; reviews consultants’ work; investigates and responds to public inquiries and complaints regarding transportation plans, programs and/or projects; may make presentations at legislative or public hearings; performs related duties as required.


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 problem-solving with an emphasis on data architecture & modeling, data linkage & integration, and GIS web-based application configuration.
  • 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, display, and analysis (e.g. Python, Arcade, 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.