Transportation Planner 2 (Enterprise GIS)

Organization: State of Connecticut Department of Transportation

Posted: April 23, 2024 | Closing: May 6, 2024

Job Description

Recruitment #240419-8876FE-001

Location:  Newington, CT
Date Opened:  4/23/2024 12:00:00 AM
Salary:  $85,410 – $122,927/year
Job Type:  Open to the Public
Close Date:  5/6/2024 11:59:00 PM

Click this link to learn more and apply:

The State of Connecticut Department of Transportation (DOT) is recruiting for a Transportation Planner 2 in the Bureau of Policy and Planning, Enterprise GIS, Visualization, and Analytics Unit at our Headquarters in Newington, Connecticut.


This position will work in a lead capacity and requires written and verbal communication skills for coordinating across diverse teams both internal to the Department as well as external partners. The chosen candidate will act as the unit lead on a variety of tasks to help meet overall Department goals related to enterprise GIS data and application development, data visualization, and analytics.  This position plays a critical role in developing data to support data-driven decisions related to topics such as: safety analysis, project prioritization, and return on investment, among others. This is a critical role 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.


  • Monday – Friday
  • Full-time (40 hours per week)
  • First shift
  • Location:  Newington, CT
  • In the P-4 (Engineering, Scientific and Technical) bargaining unit.
  • This position is eligible to apply for telework after successful completion of the working test period, and thereafter, in accordance with the Telework Policy. The Policy can be found here: Employees in their initial working test period must work on site in the office.
  • This position will report to a Transportation Supervising Planner or employee of a higher level.


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

  • Working with cross Bureau personnel, the Transportation Enterprise Data (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 to manage the technical components and business processes of the Department’s Open Data Portal
  • Configuring commercial off the shelf (COTS) tools such from Esri, VertiGIS, Microsoft, Safe, and others to help meet the data development, visualization, and analysis needs of Department stakeholders;
  • Configure and deploy self service web applications that support data collection, user-driven data management, data analysis and dashboarding, and data driven report writing
  • Working with Data Management and Integration staff to ensure that application interactions and database management practices support the users and minimize impact on infrastructure
  • Working with data stakeholders, leverage 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;
  • 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.


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 experience is interpreted at the level of a Transportation Planner 1 or Transportation Engineer 2.


  • 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.
  • 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.


  • Preferred degrees : Mathematics, Statistics, Physics, Management Information Systems, Computer Science, Data Science, Environmental Science, Planning, Geographic Information Systems or Geography.
  • Experience in utilizing an Enterprise ArcSDE data architecture, data modeling, data linkage, and GIS 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, visualization, and analysis (Arcade).
  • 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 handling with the unique concerns of a Government agency as they apply to data availability, policy constraints, and legal considerations.


  • Incumbents in this class may be required to possess and retain a valid Motor Vehicle Operator’s license.
  • 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.
As defined by Sec. 5-196 of the Connecticut General Statutes, a job class is a position or group of positions that share general characteristics and are categorized under a single title for administrative purposes.  As such, a job class is not meant to be all-inclusive of every task and/or responsibility.

How to Apply

Click this link to apply:

< View All Job Listings