STATE OF CONNECTICUT EXECUTIVE BRANCH JOBS

Transportation Planner 2 (Enterprise GIS)

Recruitment #241002-8876FE-001

Go Back Apply View Benefits

Introduction

The State of Connecticut Department of Transportation (DOT) is recruiting for two Transportation Planner 2 positions in the Bureau of Policy and Planning, Enterprise GIS, Visualization & Analytics Unit, and the Data Management & Integration Unit, in Newington, Connecticut. 

This office is the lead in developing geospatial data management & analytical tools, management, and administration of the GIS environment and providing analysis & visualization services for the rest of the Department. There will be one position in the Enterprise GIS, Visualization, and Analytics Unit and one in the Data Management & Integration Unit within this office.
  

WHAT WE CAN OFFER YOU

    THE ROLE
    These positions will work in a lead capacity and at an advanced level and require coordinating across diverse teams both internal to CTDOT as well as external partners. The chosen candidates will act as the unit lead on a variety of tasks to help meet overall goals related to enterprise GIS data and application development, data visualization, analytics, and data management. These positions play a critical role in developing data to support decisions related to topics such as safety analysis, project prioritization, and return on investment, among others. 

    The chosen candidates will be critical resources for CTDOT with expected expertise in relevant technology solutions, data management best practices, as well as applicable state and federal policies. These positions supervise data development & integration projects, coordinate across CTDOT to ensure GIS and data management solutions are addressing a variety of business requirements in an efficient manner, and play critical roles in managing the CTDOT Open Data platform. These positions require the ability to adapt quickly to changing needs & re-prioritize based upon evolving trends, as well as possess written and verbal communication skills for coordinating across diverse teams of engineers, planners, and financial administrators (among others), both internal and external to CTDOT.

    Specific Duties of these positions include:
    • Working with cross Bureau personnel, the Transportation Enterprise Data (TED) team, IT, and within the EGIS & Data Management offices 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 & Data Management staff, Subject Matter Experts, and IT personnel to manage the technical components and business processes of CTDOT’s TED and Open Data Portal
    • Configuring commercial off the shelf tools from Esri, VertiGIS, Microsoft, Safe, and others to help meet the data development, visualization, management, and analysis needs of 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 staff to ensure that application interactions and database management practices support the users and minimize performance impact on infrastructure
    • 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; identifying 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 cataloging, business requirements gathering, process flow diagramming, and data gap analysis critical to developing fully integrated solutions
    • Utilize programming languages such as Python, R, or Arcade in order to fill gaps in data management processes such as quality assurance/quality control, or Extract/Transform/Load (ETL) processes
    • Adhere to, enforce, and offer guidance to CTDOT staff related to data governance policies and procedures
    • Develop and conduct training and presentations for relevant stakeholders and customers
    • May aid in training of Transportation Planner 1’s or Connecticut Career Trainees or other CTDOT personnel

    The Enterprise GIS, Visualization & Analytics Unit is responsible for GIS application development for data collection, visualization, and analysis.  This unit works primarily with internal cross-bureau business units to define workflows, develop schemas, test and build front end web-based editing applications and field collection applications using Esri tools, as well as produce analysis or visualization outputs based on business requests.  The unit utilizes web-based and desktop GIS technology to increase access to, and utilization of, authoritative data assets.

    The Data Management & Integration Unit is responsible for management and performance of the Department’s Esri Enterprise ArcSDE database architecture.  That architecture is the foundation for a wide variety of data collection and integration efforts that support functions such as safety analysis, project planning and management, asset management, and operational optimization.  The unit works closely with internal business partners and CTDOT-IT to integrate data across business systems and platforms, develop data quality assessment processes and tools, and administers CTDOT’s data governance program to ensure that data matures into a state of high quality in completeness, timeliness, uniformity, accuracy, and precision.  

    Both units play a critical role in facilitating & continually supporting data-driven decision making. These units provide critical support and enhancements to the Transportation Enterprise Data (TED) Management System, which is a data architecture and set of business processes for managing data, specifically geospatial data. TED provides a shared, integrated, and consistent experience from a common data platform while ensuring quality, managed, authoritative data is available to all stakeholders. 

    POSITION HIGHLIGHTS
    • Monday - Friday
    • Full-time (40 hours per week)
    • First shift
    • Location:  Newington, CT
    • 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
      ABOUT US
      As one of Connecticut’s largest State agencies, DOT employs approximately 3,200 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.

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

      Selection Plan

      To Apply:
      • In order to be considered for this job opening you must meet the Minimum Qualifications as listed on the 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.
      • In order to receive educational credits toward qualification for this job posting, 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 individual listed on this job posting. 
      • 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 current state employees, salary calculations are not necessarily comparable from three branches of state government (i.e., Executive, Legislative, Judicial) to the other.  
      FOR ASSISTANCE IN APPLYING:
      • Please read or watch our Applicant Tips on How to Apply!
      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.
      • Read through this helpful link to prepare for your interview. 
      • 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 in the next twelve (12) months.
      • 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 Sharon McIntosh, at Sharon.McIntosh@ct.gov.

      Follow the State of Connecticut on LinkedIn.

      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: Mathematics, Statistics, Physics, Management Information Systems, Computer Science, Data Science, Geographic Information Systems, Geography or similar related fields 
      • Experience in utilizing an Esri Enterprise ArcSDE data architecture and performing data modeling, data linkage & integration, and GIS web-based application and configuration within that architecture
      • Experience using geospatial data management tools such as Esri’s ArcGIS Desktop Suite (ArcMap, ArcCatalog) 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 similar
      • Experience working with a variety of data analysis, automation, and visualization software products including those available through Esri (e.g. Insights, StoryMaps), Microsoft (PowerBI & PowerAutomate), Tableau, and Safe Software (e.g. FME Forms/Flow)
      • Experience working with relevant programming languages to facilitate geospatial data management, visualization, and analysis such as Arcade, Python, or R
      • Experience managing data projects and the full data lifecycle of enterprise authoritative data that includes generating, creating, processing, storing, managing, analyzing, visualizing, interpreting, governing, and archiving data  
      • Experience in project management techniques for gathering business requirements, developing a scope, defining key milestones, tracking project process, and delegating tasks as appropriate
      • Experience with the unique concerns of a government agency as they apply to data availability, data privacy, state and federal policy, reading and interpreting legislation, and legal ramifications 

      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.


      Click on a link below to apply for this position:

      Fill out the Supplemental Questionnaire and Application NOW using the Internet.


      E-mailPhone: (860) 713-52058am - 4:30pm M-FPowered by JobAps