Transportation Planner 2-Enterprise GIS, Data Visualization, and Analytics

Transportation Planner 2

Enterprise GIS, Data Visualization, and Analytics

Recruitment #250829-8876FE-001

Location

Newington, CT
 

Date Opened

9/3/2025 12:00:00 AM

Salary

$87,546 - $126,001 annually

Job Type

Open to the Public

Close Date

9/18/2025 11:59:00 PM

Go Back Apply View Benefits

Introduction

The State of Connecticut, Department of Transportation (CTDOT), is accepting applications for the position of Transportation Planner 2 in the Bureau of Policy and Planning, Enterprise GIS, Data Visualization and Analytics Unit, at our Headquarters in Newington, CT. 

At CTDOT, the Enterprise GIS, Data Visualization, and Analytics Unit is integral to the development and continued enhancement and support of the desktop and web-browser based data management architecture at CTDOT. The Unit identifies and documents business processes for managing critical Department data and develops custom tools using configurable products to meet the needs of the internal and external stakeholders. This ensures that high quality and authoritative data is made available to all users through a common data platform and manages the Department’s data as the high value asset that it is. Additionally, the Enterprise GIS, Data Visualization, and Analytics Unit is the lead on and providing specific analytics and visualization services for the rest of the Department.

WE CAN OFFER YOU

• Visit our new State Employee Benefits Overview page!
• Professional growth and development opportunities.
• A healthy work/life balance to all employees.
• Join an award-winning agency! CTDOT was recently awarded the Employer of the Year award by the Connecticut Society of Civil Engineers (CSCE) and named the Women's Transportation Seminar (WTS) CT Employer of the Year for 2024!
• We also offer the convenience of an on-site, low-cost fitness center, on-site cafeteria, and Electric Vehicle (EV) charging at our Newington, CT, Headquarters facility. All DOT facilities have ample free parking with easy access from major highways or by public transportation.

THE ROLE

The Transportation Planner 2 role will work in a lead capacity and will act as the unit lead on a variety of tasks to help meet overall Department goals related to enterprise data management. The selected candidate will play a critical role in the development of authoritative data as well as the performance measurement of data assets to support data-driven decisions related to topics such as: safety analysis, project prioritization, conflict detection, external data integration, and return on investment, among others. This position is a critical resource for the Department with required expertise in relevant technology solutions, data management best practices and applicable state and federal 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 and flexible data insight products.

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

• Working collaboratively with bureau representatives, 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 and analysis across the agency;
• Working with EGIS staff, DOT GIS Subject Matter Experts, and DOT IT personnel for management and maintenance components that interact with the Enterprise ArcSDE architecture, including web service management & tuning, Open Data, and Esri’s collaboration data sync process.
• Configuring commercial off the shelf (COTS) tools such as those from Esri, Microsoft, Safe, and others to help meet the data management, visualization, and analysis needs of Department stakeholders;
• Working with data stakeholders to 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 datasets 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
• Adhering to and offering guidance to DOT staff related to data governance policies and procedures;
• Developing and conducting training and presentations for all relevant stakeholders and customers;
• May supervise or aid in training of Transportation Planner 1’s or CCT’s;
• Performing other related duties as assigned.

POSITION HIGHLIGHTS

Learn more about our Transportation Planners by clicking here!

ABOUT US

As one of Connecticut's largest State agencies, DOT employs approximately 3,300 individuals statewide in five bureaus. It is the DOT's mission to improve quality of life through transportation. 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 environmental and cultural 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. 

Learn more about our mission, vision, and values by clicking here!

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

Selection Plan

Check out our Applicant Tips on How to Apply! Need more resources? Visit our Applicant Reference Library for additional support throughout the recruitment process.     

BEFORE YOU APPLY: 

• Meet Minimum Qualifications: Ensure you meet the Minimum Qualifications listed on the job opening by the job closing date. You must specify your qualifications on your application. The minimum experience and training requirements listed must be met by the close date on the job opening, unless otherwise specified.  
• Educational Credits: List your earned credits and degrees from accredited institutions accurately on your application. To receive educational credits towards qualification, the institution must be accredited. If the institution of higher learning is located outside of the U.S., you are responsible for providing documentation from a recognized USA accrediting service which specializes in determining foreign education equivalencies to the contact listed below by the closing date on the job posting.
• Resume Policy: Per Public Act 21-69, resumes are not accepted during the initial application process. As the recruitment process progresses, candidates may be required to submit additional documentation to support their qualification(s) for this position. This documentation may include: a cover letter, resume, transcripts, diplomas, performance reviews, attendance records, supervisory references, licensure, etc., at the request and discretion of the hiring agency. 
• Preferred Shift/Location: 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 or shift. 
• Timely Submission: All application materials must be received by the job posting deadline. You will be unable to make revisions once you officially submit your application to the State.  Late submissions are rarely accepted, with exceptions only for documented events that incapacitate individuals during the entire duration of the job posting. Request exceptions by emailing DAS.SHRM@ct.gov. 
• Salary Calculations: For current state employees, salary calculations are not necessarily comparable from one of the three branches of state government (i.e., Executive, Legislative, Judicial) to the other.
• Note: The only way to apply to this posting is via the ‘Apply’ or ‘Apply Online’ buttons on the official State of Connecticut Online Employment Center job posting.

AFTER YOU APPLY: 

• Referral Questions: This posting may require completion of additional Referral Questions (RQs), which must be completed by the questionnaire’s expiration date. If requested, RQs can be accessed via an email sent to you after the job close date or by visiting your JobAps Personal Status Board (Certification Questionnaires section).   
• Prepare For An Interview: Interviews are limited to those whose experience and training are most aligned with the role. To prepare, review this helpful Interview Preparation Guide to make the best impression! 
• Stay connected! Log in daily to your JobAps Personal Status Board to track your status and check email (including spam/junk folders) for updates and tasks.  
• The immediate vacancy is listed above, however, applications to this recruitment may be used for future vacancies in this job class.  
• Note: This position will be filled in accordance with contractual language, reemployment, SEBAC, transfer, promotion and merit employment rules. 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, available at www.ct.gov/ethics.

QUESTIONS? WE’RE HERE TO HELP: 

Due to high volume, we are unable to confirm receipt or provide status updates directly. For recruitment updates, please check your Personal Status Board and review our Frequently Asked Questions. If you have additional questions about the recruitment process, reach out to Jasmyn Raymond at Jasmyn.Raymond@ct.gov. 

Join the State of Connecticut and take your next career step with confidence!

PURPOSE OF JOB CLASS (NATURE OF WORK)

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.

EXAMPLES OF DUTIES

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.

KNOWLEDGE, SKILL AND ABILITY

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

MINIMUM QUALIFICATIONS - GENERAL EXPERIENCE

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

MINIMUM QUALIFICATIONS - SPECIAL EXPERIENCE

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.

MINIMUM QUALIFICATIONS - SUBSTITUTIONS ALLOWED

• College training may be substituted for the General Experience on the basis of fifteen (15) semester hours equalling one-half (1/2) year of experience to a maximum of four (4) years for a Bachelor's degree.
• A Master's degree in a closely related field may be substituted for one (1) additional year of the General Experience.

PREFERRED QUALIFICATIONS

• A Bachelor’s or Master’s degree in Geographic Information Systems or Geography Mathematics, Statistics, Physics, Management Information Systems, Computer Science, Data Science, Environmental Science, Data Mining.
• Experience in managing an Enterprise GIS data architecture & 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 desktop version (FME Form) 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 (e.g. Python, R, 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 Flow).
• Experience working collaboratively across teams and with other State, and federal agencies, outside stakeholders and the public. 
• Experience with the unique concerns of a Government agency as they apply to data availability, policy constraints, and legal considerations. 

SPECIAL REQUIREMENTS

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

Conclusion

AN AFFIRMATIVE ACTION/EQUAL OPPORTUNITY EMPLOYER

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

ACKNOWLEDGEMENT

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.