Intern - Utility Finance Data Analyst - Water Sewer

The City of Greeley Water & Sewer Department is seeking an intern who is interested in providing financial forecasting support to the Utility Finance team for a growing dynamic community. With the Water and Sewer Utility Finance team you will work with other dedicated employees to enhance Greeleys long term financial planning helping to ensure that needed infrastructure and other improvements to the Water and Sewer systems can be paid for. The Utility Finance team uses data collected on customer water use wastewater production and numerous external sources to forecast future needs. Ensuring that both expense and revenue forecasts are as accurate as possible while accounting for the unknown is key to planning the future for the city. The Utility Finance intern will support this forecasting by working to ensure the data needed is collected and collated appropriately analyzing that data to seek long term trends in customer demands and quantifying the underlying variability. The team aims in 2025 and 2026 to make significant improvements in the forecasting of multifamily account demands by improving the quality of data available and exploring various approaches to the forecasting effort. On the expenditure side of the problem the team needs an accurate evaluation of the marginal cost of producing water and treating wastewater for the city to help department leadership understand the impact that changes in customer use will have on expenditures. Duties include exploring a variety of internal and external data sources using data analysis software such as R or Python to collate and analyze that data and preparing reports in Excel for communicating the data to stakeholders and leaders. The position requires a selfmotivated candidate who can work independently is familiar with data analysis software and Excel and can evaluate data sources. Some driving may be required as part of the data collection effort.

Scheduled Hours: 1540 hours per week during regularly scheduled business hours
Potential Duration: May 2025 August 2025 with the possibility of extension.

Both hours and duration are flexible. Work from home 12 days per week is possible.

Experience Knowledge and Skills:

Minimum Requirements:

• Valid unrestricted drivers license with at least two 2 years of driving history with a clean record in order to drive for the City
• High school diploma or equivalent
• Associates degree or currently enrolled in an economics finance statistics or other data intensive related degree program at an accredited university with one to two years of undergraduate coursework completed
• Experience using Microsoft Excel
• Experience with either R or Python

OR

• A combination of related education experience certifications and licenses that will result in a candidate successfully performing the essential functions of the job may be considered by the hiring authority

Preferred Requirements:

• Currently enrolled in an economics finance statistics or other data intensive related degree at an accredited university as a junior senior or extended senior
• OR completion of a bachelors degree (fouryear degree) from an accredited college or university in an economics finance statistics or other data intensive or a closely related field
• Experience with advanced Excel features is preferred
• Previous experience working on engineering projects within a municipality utility or engineering firm
  

Knowledge Skills and Abilities:

• Collaboration skills including the ability to work with others from different areas and backgrounds to reach a common goal
• Computer skills including the ability to utilize Microsoft Office programs (i.e. Word Excel PowerPoint Outlook etc. and learn and experiment with new software and systems
• Interpersonal skills including the ability to facilitate interaction communication and teamwork between others
• Oral written and listening communication skills including the ability to accurately interpret what others are saying and convey messages information concepts and details accurately and clearly
• Organizational skills including the ability to set and meet goals and deadlines manage appointments create schedules coordinate and facilitate meetings and make decisions
• Ability to work under pressure manage multiple concurrent and competing tasks and responsibilities and adapt to changing priorities while maintaining personal effectiveness
• Ability to prioritize work meet deadlines and stay on task when completing special projects and daily assignments
• Ability to work independently with minimal supervision and reliable professional judgment as well as collaboratively with a team to achieve desired results
• Ability to maintain a strong work ethic positive problemsolving attitude and enthusiasm for the work performed
• Ability to selfstart and take initiative in completing daily tasks and special projects
• Ability to focus on activities that have the greatest impact on meeting work commitments
• Ability to establish and maintain partnerships with a variety of internal and external constituencies
• Ability to communicate and work effectively with individuals from diverse backgrounds cultures and ages
• Ability to adapt to evolving project needs
• Ability to learn additional programming in R or Python
• Strong attention to detail and ability to methodically manage repetitive tasks and data
• Ability to document procedures and findings for replication.
• Ability to be selfmotivated to investigate data sources identify patterns and understand the bigger picture
• Ability to proficiently digest understand and analyze large amounts of data

Essential Functions (Duties and Responsibilities):

• Prepare lists spreadsheets and reports to communicate and track project tasks
• Data management evaluating fields in customer data
• Use R or Python to collate analyze and export data
• Researching properties records.
• Document Standard Operating Procedures to facilitate quality control
• Assist with underlying goal of improving forecasts of customer demands and department expenses
• Utilize other data sources as necessary including Weld County Data and other resources for data retrieval and comparison
• Folder and file management
• Complete reports for stakeholders and department leadership

Work Environment andPhysical Requirements:

• Some travel within Greeley may be necessary to evaluate data.
• The essential functions of this job require occasional balancing bending/stooping carrying/lifting light to heavy objects and standing; frequent climbing stairs
• Close visual acuity required to perform an activity such as: preparing and analyzing data/figures; transcribing; viewing a computer terminal; extensive reading of printed materials and graphs
• Visual acuity required for close vision distance vision color vision peripheral vision depth perception and ability to adjust focus
• Visual acuity required to operate motor vehicles
• Visual acuity is required to determine the accuracy neatness and thoroughness of the work assigned or to make general observations of facilities or structures for inspection purposes
• Work independently and collaboratively and attend meetings
• Exposure to standard office conditions with minimal adverse environmental elements
• While performing the duties of this job the employee is regularly required to sit; use hands to finger handle or feel; reach with hands and arms; and talk or hear
• Manual dexterity sufficient to accurately input retrieve and verify work assignments
  

EOE Statement:The City of Greeleyprovides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race color religion age sex national origin disability status genetics protected veteran status sexual orientation gender identity or expression or any other characteristic protected by federal state or local laws.

This policy applies to all terms and conditions of employment including recruiting hiring placement promotion termination layoff recall transfer leaves of absence compensation and training.

ADA Statement: We are committed to an inclusive and barrierfree search process. We provide accommodations for applicants requesting accommodation through the search process such as alternative formats of this posting. Individuals with disabilities in need of accommodations throughout the search process should contact the ADA Coordinator at: .

Conditions of Employment: Candidates must successfully complete all preemployment screenings and employment eligibility verification. Preemployment screenings include a drug test a background and national sex offender search a motor vehicle record search and for some positions a physical demands evaluation. For more information about City policies and practices during the recruitment process including but not limited to EOE Reasonable Accommodation and preemployment screenings please visit our career pageHERE.