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.

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!

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.

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.

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.