Intern - Utility Finance Data Analyst - Water & Sewer

Job Description

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 Greeley’s 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 multi-family 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 self-motivated 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: 15-40 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 1-2 days per week is possible.

Minimum Requirements

Experience, Knowledge, and Skills:

• Valid, unrestricted driver’s 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 bachelor’s degree (four-year 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 problem-solving attitude, and enthusiasm for the work performed
• Ability to self-start 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 self-motivated 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 And Physical 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 Greeley provides 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 barrier-free 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: HR@Greeleygov.com .

Conditions of Employment: Candidates must successfully complete all pre-employment screenings and employment eligibility verification. Pre-employment 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 pre-employment screenings, please visit our career page HERE.