Water Utility Analyst

Gfoat; Georgetown (TX); On-site; USD 83,000 - 104,000; Full time

Job summary

Gfoat is seeking a data analyst to perform data analysis, develop data products, and support the Water Utility with business and financial analysis. The role involves creating dashboards, documenting analytical approaches, and presenting findings to leadership.

Candidate will work with cross-functional teams, support budget development, and advocate best practices in data management for utility projects. Strong SQL, Python, and Power BI skills are essential.

Qualifications

• Bachelor's degree or equivalent in math, science, or related field.
• Strong data analysis, modeling, and business analysis skills.
• Experience with data products, dashboards, and documentation.

Responsibilities

• Perform data analysis and data science tasks across sources using SQL and Python.
• Develop datasets, products, and deliverables in ticket-driven systems.
• Prepare financial and rate-related reports and support leadership with budgets.

Skills

SQL

Python

Power BI

Requirements elicitation

Technical writing

Financial data interpretation

Education

Bachelor's degree in math/science or related field

Job description

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.