Water Utility Analyst

City of Goldsboro; Zeeland (MI); On-site; USD 83,000 - 104,000; Full time

Job summary

The City of Goldsboro seeks a data-focused analyst for its Water Utility. The role develops data products, conducts analyses, and supports financial planning to guide leadership decisions.

The position requires SQL/Python data analysis, Power BI dashboarding, and documentation of analytical methods. A Bachelor's in math or science is required, with experience in data modeling and reporting.

Qualifications

• Bachelor’s degree in math, science or related field, or equivalent experience.
• Knowledge of water utility operations and regulations.
• Experience with data analysis, data modeling and BI reporting.
• SQL and Python proficiency; ability to create BI dashboards.

Responsibilities

• Performs data analysis and data science across sources using SQL and Python.
• Develops datasets and dashboards in a ticket-driven work management system.
• Researches, develops and maintains automation solutions for data products.
• Authors and maintains BI reports and dashboards.
• Prepares and maintains documentation of analytical approaches and products.
• Conducts meetings and presentations to share findings.
• Acts as liaison for the Water Utility with cross-functional teams.
• Assists with project management for business improvements.

Skills

SQL

Python

Power BI

Data analysis

Data modeling

Business analysis

Process improvement

Requirements elicitation

Technical writing

Financial reporting

Education

Bachelor's degree in math/science

Job description

It’s fun to work in a company where people truly BELIEVE in what they’re doing!

We’re committed to bringing passion and customer focus to the business.

Under the direction of the Water Utility Support Manager, performs data analysis, develops data products, assists with business analysis, and assists with financial analysis related to the City’s Water Utility.

ESSENTIAL FUNCTIONS: Essential functions, as defined under the Americans with Disabilities Act, may include any of the following representative duties, knowledge, and skills. This is not a comprehensive listing of all functions and duties performed by incumbents of this class; employees may be assigned duties that are not listed below; reasonable accommodations will be made as required. The job description does not constitute an employment agreement and is subject to change at any time by the employer. Essential duties and responsibilities may include, but are not limited to, the following:

• Performs data analysis and data science activities across disparate sources using SQL and Python.

• Develops high-quality datasets, products, and deliverables in a ticket-driven work management system.

• Researches, develops and maintains automation solutions for custom data products.

• Authors and maintains business intelligence reports and dashboards.

• Prepares and maintains comprehensive documentation of analytical approaches and products.

• Conducts meetings and presentations to share ideas and findings.

• Acts as a liaison for the Water Utility with cross-functional team members and management.

• Assists with project management for business improvements.

• Advocates for and advises on data management best practices on projects and initiatives.

• Assists leadership with budget development and resource planning.

• Analyzes utility system performance and provides insights and data-driven decision-making tools to leadership.

• Prepares complex rate and financial reports and responds to requests for rate and financial information.

• Provides analytical support for all utility development activities that requests subsidies, cost sharing or other service agreements.

• Ensures accurate financial reporting by collaborating with the finance and accounting personnel.

• Serves in an advisory role in various internal and external meetings, including vendor/client negotiations on contracts.

• Plans and performs business analysis tasks.

MINIMUM QUALIFICATIONS:

Education, Training and Experience Guidelines

Bachelor’s degree from an accredited college or university with major coursework in math, science or related field OR Any combination of related experience or education to meet the minimum qualifications.

Knowledge of:

• Water utility operations, treatment, and supply

• Water treatment and transmission capital projects

• Impact fee development/tracking

• Regulations related to TCEQ and TWDB

• Cost-of-service / cost allocation methods

• Data analysis

• Data modeling

• Business analysis

• Process improvement techniques

Skill in:

• SQL

• Python

• Microsoft Power BI

• Requirements elicitation

• Technical writing

• Reading financial reports, manuals, inter and intra-office correspondence, and educational and leadership materials.

• Writing memos, reports, and letters.

• Understanding, interpreting, and preparing financial data, reports, and presentations.

• Independently solving complex analytical problems by analyzing information; developing logical conclusions and making recommendations.

LICENSES AND CERTIFICATION REQUIREMENTS

Valid Class “C” Texas driver’s license required. Out-of-state license holders must have a valid license and provide a three (3) year driving history.

PHYSICAL DEMANDS AND WORKING ENVIRONMENT

Standing, sitting, walking, lifting, carrying, pushing, pulling, reaching, handling, fine dexterity, kneeling, crouching, crawling, bending, twisting, climbing, balancing, vision, hearing, talking, use of foot controls.

Hiring Range: $83,382.52 - $104,457.60, annually.

Regular-Full time

If you like wild growth and working with happy, enthusiastic over-achievers, you’ll enjoy your career with us