Transportation Data Specialist (Research Assistant 1)
University of Connecticut
Location: Storrs, Connecticut
Preferred Education: Bachelor’s
Internal Number: 495850-2276_1637132057
The Connecticut Transportation Institute (CTI) is looking for a full-time Research Assistant 1 to assist in the engineering and behavioral transportation safety analysis and the development of software applications for transportation systems to query, visualize and analyze transportation related behavior, crashes and assets.
Under the direction of the Director of the Connecticut Transportation Safety Research Center (CTSRC), the successful candidate will assist in data collection, consolidation, validation, and integration efforts related to migration from a limited non-geospatial roadway attribute database to a Model Inventory of Roadway Elements (MIRE) compliant geospatially accurate database, with the ultimate goal of aiding the advancement of the State's data driven safety analysis capabilities.
DUTIES AND RESPONSIBILITIES
Performing data scrubbing and quality control checks of asset datasets before integration into the production database;
Coordination with Department data stewards on asset development and Linear Referencing system (LRS) integration requirements;
Coordination activities between the Department and UConn CTSRC on data integration and availability for use in safety analysis;
Asset data migration from the legacy database to the geospatial LRS database;
LRS development work related to alignment changes, new road construction, additional desired segment locations, and other miscellaneous LRS accuracy improvement activities.
Bachelor's degree; Geography, GIS, or Computer Science Degree. Other related disciplines that are deemed appropriate and relevant to this position may also be considered.
Knowledge of the basic logic used for database design and the ability to understand and apply that logic to existing and developing databases;
Knowledge of Oracle, SQL, and Microsoft Access database structures;
Basic understanding of geospatial asset location methodology and asset relationships;
Familiarity with materials related to national safety data integration efforts and industry best practices;
Excellent oral and written communication skills;
Ability to establish and maintain cooperative relations with superiors, associates, and additional data stakeholders, including municipal representatives and the general public;
Attention to detail, particularly related to enforcing data validation rules and quality assurance/quality control procedures;
Ability to handle and prioritize multiple assignments/tasks.
Familiarity with ESRI, EXOR, or open source (QGIS) mapping/GIS tools;
Familiarity with basic load/extract/query procedures associated with GIS functions (FME, PowerBI);
Familiarity with applicable federal and state guidelines regarding data collection, LRS integration, and data visualization, particularly the Model of Roadway Inventory Elements (MIRE) and All Roads Network of Linear Referenced Data (ARNOLD).
This is a full-time 12-month position based on available funding, subject to annual renewal. Salary will be commensurate with successful candidate's background and experience. The University offers a competitive salary and outstanding medical and retirement benefits, including employee/spouse and dependent tuition reimbursement at the University of Connecticut.
TERMS AND CONDITIONS OF EMPLOYMENT
Employment at the University of Connecticut is contingent upon the successful candidate's compliance with the University's Mandatory Workforce COVID-19 Vaccination Policy. This Policy states that all workforce members are required to have or obtain a Covid-19 vaccination as a term and condition of employment at UConn, unless an exemption or deferral has been approved.
Employment of the successful candidate is contingent upon the successful completion of a pre-employment criminal background check.
Please apply online at https://hr.uconn.edu/jobs, Staff Positions, Search #495850 to upload a resume, cover letter, and contact information for three (3) professional references.
This job posting is scheduled to be removed at 11:55 p.m. Eastern time on November 29, 2021.
All employees are subject to adherence to the State Code of Ethics, which may be found at http://www.ct.gov/ethics/site/default.asp.
The University of Connecticut is committed to building and supporting a multicultural and diverse community of students, faculty and staff. The diversity of students, faculty and staff continues to increase, as does the number of honors students, valedictorians and salutatorians who consistently make UConn their top choice. More than 100 research centers and institutes serve the University's teaching, research, diversity, and outreach missions, leading to UConn's ranking as one of the nation's top research universities. UConn's faculty and staff are the critical link to fostering and expanding our vibrant, multicultural and diverse University community. As an Affirmative Action/Equal Employment Opportunity employer, UConn encourages applications from women, veterans, people with disabilities and members of traditionally underrepresented populations.
The University of Connecticut is a national leader among public research universities, with more than 30,000 students seeking answers to critical questions in classrooms, labs, and the community. A culture of innovation drives this pursuit of knowledge throughout the University’s network of campuses. Connecticut’s commitment to higher education helps UConn attract students who thrive in the most competitive environments, as well as globally renowned faculty members. Our school pride is fueled by a history of success that has made us a standout in Division I athletics. UConn fosters a diverse and vibrant culture that meets the needs and seizes the opportunities of a dynamic global society.