COLLEGE CO-OP Wastewater Engineering (Capital Planning/SBU Risk Reduction)
City of Cincinnati
Get a reply from this employer
Your resume and cover letter, tailored to exactly what they’re hiring for.
Job summary
City of Cincinnati MSD Wastewater Engineering Division is seeking a Spring Semester College Co-op Student Intern starting January 18, 2027. This role offers hands-on experience in engineering data analysis, GIS applications, database management, and program development within a utility environment.
You will collect and organize data from multiple sources, develop ArcGIS maps, run SQL queries, use Python to automate tasks, and help deliver dashboards and reports that support risk reduction and
Qualifications
- Currently pursuing a Bachelor's degree in Civil, Environmental, Mechanical, Computer Science, Data Analytics, GIS, Engineering Technology or related technical discipline
- Experience with ArcGIS or geographic information systems is preferred
- Coursework or experience in database management and SQL required
- Experience using Microsoft Excel for data analysis recommended
- Familiarity with Python or another programming language is a plus
- Understanding of data visualization techniques is helpful
- Strong organizational and analytical skills and ability to work with large datasets
Responsibilities
- Collect and organize data from multiple internal and external sources
- Develop GIS‑based maps and dashboards using ArcGIS
- Perform data analysis using SQL, Excel, Python and related tools
- Manage large datasets related to infrastructure, environmental conditions, flow and rainfall monitoring
- Support project tracking, documentation, and reporting activities
- Identify data quality improvements and standardization opportunities
- Create visualizations and summaries for stakeholders
Skills
Education
Tools
Job description
The Metropolitan Sewer District posted a number of College Co-Op Job Postings for the Spring Semester beginning January 18, 2027. Please read through all Job Postings and apply for the position(s) you would like to be evaluated for and/or interviewed for as a Co-Op Student Intern. For more information about the different projects please contact jerrold.ware@cincinnati-oh.gov.
The priority deadline for applications is November 8, 2026. Applications submitted by this date will be reviewed by MSD hiring managers before the posting closes on November 20, 2026. If selected for an interview, students will be notified via email as early as the week of November 15, 2026. All applications are accepted through the posting close date.
If selected for an interview, you will be contacted via the email provided during the application process. All applicants should have availability for work scheduled 32 - 40 hours per week.
Applicants with student visa and OPT, CPT, and current valid EAD at time of hire, are welcome to apply.
Interns/Co-ops/Externs for the City of Cincinnati may be performing duties in any potential field within the City's structure. These fields may include office-level work/assignments, fieldwork, and/or civic services. The nature of the work will be based on areas of interest, degree programs, or organizational needs. Candidates should have the ability to multitask in a fast-paced environment.
Support the development and implementation of the SBU Risk Reduction program by collecting, organizing, analyzing, and visualizing infrastructure, environmental, and operational data that will inform risk-based decision making. The co‑op will contribute to the creation of sustainable tools, processes, and databases that improve the program's ability to identify, prioritize, track, and mitigate the risk of SBUs across the collection system.
The purpose of this co‑op assignment is to provide hands‑on experience in engineering data analysis, GIS applications, database management, and program development within a utility infrastructure environment. The student will develop technical and professional skills while working on real‑world challenges associated with risk reduction, asset management, and real‑time data monitoring.
The co‑op will learn how data supports engineering decisions and gain experience building analytical tools that improve organizational effectiveness and long‑term planning.
The co‑op will support the SBU Risk Reduction program and will assist in the development of systems and processes used to identify, evaluate, track, and communicate SBU risks.
- Collecting and organizing data from multiple internal and external sources
- Supporting development and maintenance of project databases
- Performing data analysis using Excel, SQL, Python, and other analytical tools
- Managing large datasets related to infrastructure, environmental conditions, flow monitoring, and rainfall monitoring
- Developing GIS‑based maps and dashboards using ArcGIS
- Supporting project tracking, documentation, and reporting activities
- Identifying opportunities to improve data quality, efficiency, and process standardization
- Creating visualizations and summaries to communicate results to technical and non‑technical stakeholders
- Learn and utilize ArcGIS for spatial data management and analysis
- Develop proficiency with SQL databases and querying techniques
- Apply advanced Excel skills for data manipulation and reporting
- Use Python scripting to automate repetitive tasks and perform data analysis
- Maintain data accuracy and consistency across multiple systems
- Produce maps, dashboards, reports, and other analytical deliverables
- Demonstrate initiative and willingness to learn new technical skills
- Work effectively in a fast‑paced, evolving environment
- Manage multiple assignments simultaneously
- Communicate findings clearly and professionally
- Collaborate across engineering, operations, environmental, and planning teams
- Seek opportunities to improve processes and efficiency
- Develop critical problem‑solving and analytical thinking skills
- Build confidence working with incomplete or evolving data
- Learn how engineering organizations use data to drive decision making
- Gain experience presenting technical information to a variety of audiences
The exact scope may evolve based on program needs and the student's skills; however, anticipated deliverables can include the following:
- Creation and maintenance of program datasets
- Development of standardized data collection templates
- Improvement of file organization and document control systems
- Data quality review and validation activities
- Development of ArcGIS maps and applications supporting risk identification
- Geospatial analysis of infrastructure, monitoring, and environmental data
- Creation of map products for engineering and management use
- SQL queries and database reporting tools
- Excel‑based tracking and analysis tools
- Python scripts for automation and data processing
- Monthly program metrics and status reports
- Data visualizations and dashboards
- Complete required company and department training
- Gain familiarity with the SBU Risk Reduction Program objectives
- Learn available data sources and current workflows
- Complete introductory ArcGIS, SQL, and data management activities
- Understand current file structures and reporting requirements
Milestone: Demonstrate understanding of program goals and independently complete basic data management and analysis tasks.
- Begin ownership of assigned datasets
- Develop SQL queries and Excel reporting tools
- Support GIS mapping activities
- Identify data quality gaps and improvement opportunities
Milestone: Successfully deliver first independent reporting or analysis project.
- Develop Python scripts or automated workflows
- Create GIS products supporting risk evaluations
- Recommend process improvements based on observations
- Present findings to program leadership
Milestone: Deliver at least one process improvement or automation solution.
- Complete major project assignment
- Finalize documentation and training materials
- Present accomplishments and recommendations
- Transfer knowledge and project status to team members
Milestone: Complete final presentation demonstrating contributions, lessons learned, and recommendations for future program development.
- Required
- Currently pursuing a Bachelor's degree in one of the following fields of study:
- Civil Engineering
- Environmental Engineering
- Mechanical Engineering
- Computer Science
- Data Analytics
- Geographic Information Systems (GIS)
- Engineering Technology
- Related technical discipline
- Currently pursuing a Bachelor's degree in one of the following fields of study:
- Preferred Skills
- Experience with ArcGIS or geographic information systems
- Coursework or experience in database management and SQL
- Experience using Microsoft Excel for data analysis
- Familiarity with Python or another programming language
- Understanding of data visualization techniques
- Strong organizational and analytical skills
- Experience working with large or complex datasets
- Desired Attributes
- Self-motivated and curious learner
- Strong attention to detail
- Comfortable working with ambiguous problems
- Effective communicator
- Able to independently investigate and solve problems
- Interested in data-driven engineering and infrastructure management
- Be a U.S. citizen, lawful permanent resident, or a non-citizen with proof of eligibility to work in the United States
- Individuals under eighteen will require a work permit
- Be enrolled in an accredited institution and have completed 2 semesters of undergraduate coursework
- Have a basic understanding of MS Office
- Submit a City job application for employment
- Pass a background check and drug screen
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
