COLLEGE CO-OP WASTEWATER COLLECTION (ASSET MANAGEMENT)

General Statement of Duties

The Metropolitan Sewer District posted a number of College Co-Op Job Postings for the Summer Semester beginning May 26, 2025. 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.

The Project plans are included in the Job Postings. For more information about the different projects please contact jerrold.ware@cincinnati-oh.gov.

The Priority Deadline for applications is March 10, 2025. Applications submitted by this date will be reviewed by MSD hiring managers before the posting closes on March 24, 2025. If selected for an interview, students will be notified via email as early as the week of March 10, 2025. 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.

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.

Minimum Qualifications (KSAs)

MSD WASTEWATER COLLECTION - ASSET MANAGEMENT

Mission:
To establish a partnership with colleges and universities, exposing as many students as possible to employment opportunities in the Wastewater Industry and to help them become experienced professionals in the next generation workforce.

Purpose:

• Data Analysis: Reviewing and interpreting data related to asset management to identify trends, anomalies, and areas for improvement.

• 
  Data Visualization: Creating charts, graphs, and other visual representations of data to make complex information more accessible and actionable for the team.

• 
  Reporting: Compiling findings into clear, concise reports that summarize key insights and recommendations for asset maintenance and improvement.

• 
  Collaborative Work: Working closely with team members to understand the context of the data and ensure accurate and meaningful analysis.

• 
  Learning and Development: Participating in training sessions and team meetings to enhance understanding of asset management practices and contribute to ongoing projects.

• Orientation (Week 1)
  
  
  • Introduction to the team and work environment
  • Overview of the Wastewater Collection Division and Asset Management Section
  • Training on relevant software tools and data analysis methods
  
  Needs Assessment (Week 2)
  
  
  • Review current asset data and management strategies
  • Identify key areas needing analysis and visualization
  • Develop a list of initial tasks and objectives in collaboration with the Project Sponsor
  
  Begin Project Work (Weeks 1-3)
  
  
  • Start initial data analysis and visualization tasks
  • Work with the Project Manager to create a detailed project plan, including specific goals, timelines, and deliverables
  • Tailor projects to align with the student’s interests and skills
  • Perform in-depth data analysis to identify trends, anomalies, and areas for improvement in asset management
  • Create detailed data visualizations (charts, graphs, etc.) to present findings
  • Develop reports summarizing key insights and recommendations
  • Investigate and propose solutions for identified issues or areas needing improvement
  • Regularly update the Project Manager on progress and refine project objectives as needed
  
  Mid-Term Review (Week 8)
  
  
  • Conduct a comprehensive review of the project schedule and progress
  • Adjust timelines and objectives to ensure alignment with project goals and the Project Manager’s expectations
  
  Prepare Final Documentation and Report Out (Weeks 15-16)
  
  
  • Finalize all data analysis, visualizations, and reports
  • Document all findings and recommendations thoroughly
  • Discuss with necessary parties to ensure smooth continuation of any unfinished work
  • Summarize and evaluate lessons learned, highlighting the student's contributions and experiences

• General Requirements:
  
  
  • Basic computer skills, including familiarity with Microsoft Word and Excel
  • Strong analytical and problem-solving skills
  • Ability to work independently and collaboratively within a team
  • Strong communication skills, both written and verbal
  • Attention to detail and a commitment to accuracy
  • Willingness to learn and adapt to new tools and techniques
  
  Preferred, but Not Required:
  
  
  • Familiarity with data analysis techniques and tools
  • Experience with data visualization software (e.g., Tableau, Power BI)
  • Interest in asset management and wastewater collection systems

Required Education and Experience

In order to qualify for the Intern/Co-op/Extern Program, a student must:

• 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
• Submit a City job application for employment
• Must pass a drug screen and background check

The below information is solely intended as a summary of the benefits available and is subject to change. Not all benefits listed are available for every position. Benefits can vary depending on applicable labor agreements and/or salary plan. For specific questions, contact the HR Contact indicated on the Job Posting.

The City of Cincinnati offers its employees competitive salaries and a comprehensive benefit package designed to actively attract and retain quality employees' to add additional value to the City of Cincinnati's workforce. A summary of these benefits for full-time employment is listed below. This is a general listing of benefits for all employees and is not intended to be a comprehensive listing for all bargaining units.

The City offers a variety of training programs, ranging from job-specific skills such as computer and equipment instruction, to helping supervisors improve their management techniques.

Equal Employment Opportunity

The City of Cincinnati is dedicated to providing equal employment without regard to race, gender, age, color, religion, disability status, marital status, sexual orientation or transgendered status, or ethnic, national or Appalachian origin, or on the basis of any other category protected under federal, state and local laws.

Holidays

The City of Cincinnati has 11 paid holidays annually that include:

New Year's Day
Martin Luther King Day
President's Day
Memorial Day
Juneteenth
Independence Day
Labor Day
Veterans' Day
Thanksgiving Day
Day after Thanksgiving
Christmas

Health Insurance

The City of Cincinnati 80/20 offers 3 medical plans to all full time City of Cincinnati employees and eligible dependents: the 80/20 PPO medical plan, the HDHP medical plan with an HSA contribution, and a Health Reimbursement Arrangement for those enrolled on another non-city eligible group plan.

Eligible dependents include:

Legal Spouse or Equal Partner
Child (natural child, adopted child, and/or child who the group has determined is covered under a "Qualified Medical Child Support Order")
Step-child
Child for whom the employee or employee's spouse/equal partner is a legal guardian

Basic Life Insurance

A $50,000 Basic Life Insurance policy is paid for by the City for certain eligible employees. Full time employees not eligible for the City-paid basic life insurance policy are generally provided a similar benefit through their union group.

Supplemental Life, Long Term Disability, Accident & Critical Illness Insurance

Most full time City employees are eligible to participate in a supplemental life insurance program, a long term disability plan, and accident and critical illness insurance programs at their own expense. Premiums are determined by age, amount of coverage, and various additional factors.

Flexible Benefits Plans

Healthcare Flex Spending Account

City employees can participate in the Healthcare Flex Spending Account that can be used to pay out-of-pocket medical, prescription, dental, and vision care expenses for employees and family members.

Dependent Care Flex Spending Account

City employees can participate in a Dependent Care Flex Spending Account that can be used to pay work-related dependent care expenses. Participants can set aside money each year through pre-tax payroll deductions to pay for these expenses.

Transportation Expense Reimbursement Account

City employees can participate in a Transportation Expense Reimbursement Account (TERA) that can be used to reimburse expenses related to traveling to and from work. Participants can set-up a pre-tax payroll deduction up to an IRS regulated amount.

Healthy Lifestyles Program

City employees can voluntarily participate in a wellness incentive program that encourages and rewards employees and their spouses/equal partners for making positive choices for better health. The City of Cincinnati will contribute up to $300/year to a Health Reimbursement Account for each the employee and their spouse/equal partner for meeting specified program goals. These dollars can be used to offset qualified out-of-pocket medical expenses.

Integrated Health Reimbursement Arrangement (HRA)

This is a voluntary program that serves as an alternative healthcare option to traditional medical plans. If you have alternate group health coverage available to you through a spouse, equal partner, another job, or a non-city retirement plan, you may be eligible for this plan which reimburses you for the difference in premiums between the plans and your covered out of pocket expenses on the other plan.

Retirement Plan

The City provides a defined benefit pension plan for part-time and full-time employees. New hires and re-hired employees are required to participate in the City of Cincinnati's Retirement System (CRS), regardless of previous participation in an Ohio State pension system or any another state or federal pension system. CRS is funded by employer and employee contributions, and investment returns from plan assets. CRS provides retirement and health care benefits subject to eligibility requirements. The following groups are excluded from participation in CRS: Mayor and Members of City Council; Sworn Police & Fire; Police Recruits; and Rehired Ohio Police & Fire Retirees.

Deferred Compensation

As an Ohio government employer, the City offers employees the ability to participate in a 457(b) tax-deferred retirement savings plan. The City makes an annual match to your 457(b) of up to $750, or as otherwise specified in applicable regulations and union contracts.