Water Utility Data Analyst & BI Specialist

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

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.