STATE OF CONNECTICUT EXECUTIVE BRANCH JOBS

Transportation Planner 2

GIS Enterprise

Recruitment #230308-8876FE-001

Introduction


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. 

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.

Comprehensive Benefit Offerings:
  • Industry leading health benefits, including medical and dental coverage 
  • Extensive pension plan and supplemental retirement offerings 
  • Paid time off - including paid holidays per calendar year
  • Professional growth and professional development opportunities
  • A healthy work/life balance to all employees!
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.
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. 

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.

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 or shift.
  • 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 DAS.SHRM@ct.gov.
FOR ASSISTANCE IN APPLYING:
Important Information After You Apply:
  • 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 questionnaire'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.
  • 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.
  • Note: 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.
  • Interviews will be limited to candidates whose experience and training most closely meet the requirements of the position.
  • The immediate vacancy is listed above, however, applications to this recruitment may be used for future vacancies in this job class.
  • 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 www.ct.gov/ethics.
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. Should you have any questions pertaining to this recruitment, please contact Hayley Newhouse, at Hayley.Newhouse@ct.gov.

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

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

MINIMUM QUALIFICATIONS - SUBSTITUTIONS ALLOWED

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.

PREFERRED QUALIFICATIONS

  • Experience or education in: Mathematics, Statistics, Physics, Management Information Systems, Computer Science, Data Science, Data Mining, Geographic Information Systems or Geography.
  • Experience problem-solving 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.

SPECIAL REQUIREMENTS

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.

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.