Water Utility Analyst

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

Job summary

Gulfshoresal in Georgetown, Texas seeks a data analyst to perform data analysis, build data products, and assist with financial analysis for the City’s Water Utility. You will develop automation for data products, create BI dashboards, and document analytical methods while partnering with cross-functional teams.

You will support budget planning, evaluate utility performance, and prepare complex rate and financial reports for leadership.

Qualifications

• Bachelor's degree in math, science or related field.
• Experience with data analysis and data modeling.
• Knowledge of water utility operations and regulations.
• Strong SQL and Python skills.
• Ability to read financial reports and prepare analyses.
• Experience creating BI reports and dashboards.

Responsibilities

• 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 data products.
• Authors and maintains business intelligence reports and dashboards.
• Prepares and maintains 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 teams and management.
• Assists with project management for business improvements.
• Advises on data management best practices on projects and initiatives.
• Assists leadership with budget development and resource planning.
• Analyzes utility system performance and provides data-driven decision tools.
• Prepares rate and financial reports and responds to requests for rate information.
• Provides analytical support for subsidy, cost sharing or service agreements.
• Ensures accurate financial reporting with finance and accounting personnel.

Skills

SQL

Python

Power BI

Requirements elicitation

Technical writing

Reading reports

Writing memos

Education

Bachelor's degree in math/science

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.