Afternoon Data Analyst R Programming Jobs in Middletown, CT

Introduction

\r\nThe State of Connecticut, Department of Transportation (DOT) is now accepting applications for aTransportation Planner 2 position within thePlanning and Data Analysis Unit in the Bureau of Public Transportation in Newington, CT.\r\n\r\n\r\n\r\nThe Planning and Data Analysis Unit is seeking candidates with experience in data analysis, technical planning, and stakeholder coordination. Ideal candidates will be skilled in interpreting and visualizing transit data, applying analytical methods to support planning decisions, managing complex datasets, and collaborating with internal and external partners to advance service planning.\r\n\r\n\r\n\r\n\r\nWHAT WE CAN OFFER YOU\r\n\r\n\r\n Visit our new State Employee Benefits Overview page!\r\n Professional growth and development opportunities.\r\n A healthy work/life balance to all employees.\r\n 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!\r\n 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.\r\n\r\n\r\n\r\n\r\nPOSITION HIGHLIGHTS\r\n\r\n\r\n\r\n Full-time (40 hours per week)\r\n First shift\r\n Location: Newington, CT\r\n P-4 (Engineering, Scientific and Technical) bargaining unit\r\n 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\r\n \r\n \r\n \r\n THE ROLE\r\n The Planning and Data Analysis Unit provides essential analytical and planning support to the Bureau's transit programs and operations. The Unit's work ensures that transit services are effectively planned, performance is monitored, and investments are strategically targeted to meet statewide mobility needs.\r\n \r\n \r\n The Unitis responsible for:\r\n \r\n \r\n Transit planning and service analysis\r\n Developing and maintaining mapping and geospatial resources\r\n Coordinating data collection activities\r\n Producing accurate, timely reports to guide decision making\r\n Preparing required submissions to the Federal Transit Administration's National Transit Database (NTD)\r\n Conducting systemwide and corridor level transit studies such as the Statewide Bus Study\r\n Developing statewide programs including the Bus Stop Enhancement Program\r\n \r\n \r\n The Transportation Planner 2 position:\r\n \r\n \r\n \r\n \r\n Leads development of transit plans and studies, including direction and oversight of consultant work\r\n Coordinates with CTtransit branded service providers and independent transit districts on planning initiatives, performance reporting, program development, and compliance with federal and state requirements\r\n Supports development of service plans, route evaluations, and operational improvements in coordination with internal and external partners\r\n Synthesizes data from multiple sources, integrating datasets to enable extraction, validation, analysis, and visualization\r\n Prepares National Transit Database submissions and other routine performance reports, conducting data analysis and developing visualizations to draw conclusions and provide actionable insights\r\n Produces technical analyses and written reports to meet federal and state reporting requirements and support internal decisionmaking\r\n Develops and delivers presentations, facilitates meetings, and participates in public hearings and other stakeholder meetings\r\n Performs related duties as required\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n Career progression pathway within the State of Connecticut, starting with Transportation Planner 2, (current opening), advancing to Supervising Transportation Planner, and ending with Many more opportunities available! A slogan on the left reads 'Make It Here in your career. Your future as a Transportation Planner 2 has limitless opportunities.'\r\n \r\n Learn more about our Transportation Planners here (Opens in a New Window)\r\n \r\n \r\n ABOUT US\r\n \r\n \r\n \r\n \r\n \r\n \r\n As one of Connecticut's largest State agencies, DOT employs approximately 3,300 individuals statewide in five 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 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.\r\n \r\n \r\n \r\n Learn more about our mission, vision, and values by clickinghere. \r\n \r\n Watch the video below to see what it's like to be a State of CT employee!\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \t\t\t\t\t\t\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n

Selection Plan

\r\nFOR ASSISTANCE IN APPLYING:\r\n\r\nCheck out our Applicant Tips on How to Apply! Need more resources? Visit our Applicant Toolkit for additional support throughout the recruitment process.\r\nBEFORE YOU APPLY:\r\n\r\n 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. \r\n 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 listed on the job posting.\r\n 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.\r\n 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.\r\n 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.\r\n 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.\r\n\r\n\r\n 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.\r\n\r\nAFTER YOU APPLY:\r\n\r\n Some email providers may experience delays or issues delivering messages. To avoid missing important updates-such as referral questionnaires or interview scheduling links-please check your Personal Status Board regularly. For added convenience, you can also enable text (SMS) notifications. To do this, log in to your Personal Status Board and select "Update My Contact Information."\r\n 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).\r\n 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!\r\n 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.\r\n The immediate vacancy is listed above, however, applications to this recruitment may be used for future vacancies in this job class.\r\n 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.\r\n This employer may participate in EVerify and will provide the federal government with your Form I9 information to confirm work authorization.\r\n\r\nQUESTIONS? WE'RE HERE TO HELP:\r\nDue 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 Sharon McIntosh, at Sharon.McIntosh@ct.gov.\r\n\r\n\r\n

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:\r\n\r\n\r\n As assigned by a supervisor, distributes, prioritizes, oversees and reviews office unit work;\r\n Provides staff training and assistance;\r\n Conducts or assists in conducting performance evaluations;\r\n Acts as liaison with operating units, agencies, consultant staff and other outside officials regarding unit office policies and standards;\r\n Prepares correspondence;\r\n Performs related duties as required.\r\n\r\n\r\nADVANCED LEVEL:\r\n\r\n\r\n Performs complex tasks and assignments in developing, coordinating and reviewing transportation planning programs;\r\n Recommends, coordinates or participates in transportation demonstration projects;\r\n Participates in preparation and negotiation of agreements and contracts;\r\n Oversees and participates in corridor studies;\r\n Prepares and reviews reports, studies and surveys in compliance with department standards and needs and state and federal laws and regulations;\r\n Coordinates activities or projects with local, regional, state and federal agencies, consultants and stakeholders as required;\r\n Reviews consultants' work;\r\n Investigates and responds to public inquiries and complaints regarding transportation plans, programs and/or projects;\r\n May make presentations at legislative or public hearings;\r\n Performs related duties as required.\r\n\r\n\r\n

KNOWLEDGE, SKILL AND ABILITY

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

MINIMUM QUALIFICATIONS - GENERAL EXPERIENCE

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

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.\r\n\r\n\r\nNOTE: For state employees this experience is interpreted at the level of a Transportation Planner 1 or Transportation Engineer 2.\r\n

MINIMUM QUALIFICATIONS - SUBSTITUTIONS ALLOWED

\r\n\r\n 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.\r\n A Master's degree in a closely related field may be substituted for one (1) additional year of the General Experience.\r\n\r\n\r\n

PREFERRED QUALIFICATIONS

\r\n\r\n A Bachelor's or Master's degree in Public Administration, Public Policy, Urban or Regional Planning, Urban and Community Studies, Geography, Data Science, Computer Science, Data Analytics, Business Analytics, Statistics, Applied Mathematics, or a closely related field\r\n Experience with project management, including consultant oversight and contract administration\r\n Experience in public transportation planning or operations\r\n Experience in data collection, data management, databases, data analysis, and data visualization\r\n Experience reviewing complex documents and data, deriving insights, and formulating conclusions\r\n Experience producing technical and written reports using effective organization and clarity\r\n Experience working collaboratively within a team, with other technical disciplines, ...