IT Data Analyst (Operational Intelligence) - Austin Water

AustinTexas; Austin (TX); Hybrid; USD 69,000 - 86,000; Full time

Job summary

This position supports Austin Water's Operational Intelligence team by developing data products, validating data quality, and assisting with report and data model development. The role blends data analysis with business systems analyst functions to improve data processes and enable informed decision making.

The candidate will work on Power BI reports, dashboards, and semantic models, using SQL and data modeling skills to support enterprise data initiatives and deliver reliable information for

Qualifications

• Bachelor’s degree from an accredited college or university in a related field plus two years’ related experience.
• Experience may substitute for education for up to four years.
• Preferred experience developing Power BI reports, dashboards, and semantic models, including DAX and data modeling.

Responsibilities

• Catalog data sources and work with City IT partners to define data use requirements.
• Profile data from internal and external sources.
• Lead data classification and mining to assign data categories such as Open/Confidential.
• Design reporting dashboards to translate data into understandable formats.
• Perform initial data exploration (binning, pivoting, summarizing, correlations).
• Fulfill ad hoc reporting requests.
• Provide feedback on data distribution and retention standards.
• Analyze results with standard statistical tools and techniques.

Skills

Power BI reporting

SQL queries

Data analysis

Data visualization

DAX

Education

Bachelor’s degree in related field

Tools

Power BI

Job description

About This Position

ABOUT AUSTIN WATER:
For over 100 years, Austin Water has been committed to providing safe, reliable, high-quality, and affordable water services to our customers. Today, we serve over 1,000,000 people in the Austin metropolitan area, across more than 548 square miles. As one of the fastest-growing cities in the country, we’re not just keeping up—we’re leading the way with sustainable infrastructure, advanced treatment technology, and environmental innovation.
Austin Water consistently ranks among the best in the country when it comes to water quality. We also treat, return, and recycle wastewater in ways that protect environmental resources. Austin Water exceeds federal and state requirements for clean water and environmental compliance at our water and wastewater treatment plants.

Job Description:

IT Data Analyst

Purpose:

IT Data Analysts are responsible for identifying, capturing, analyzing, and managing City IT and department data. Through data conceptualization, modeling, and presentation, IT Data Analysts help City leadership and departments answer questions and solve pressing City problems. Additionally, IT Data Analysts empower end-users to use data in their decision-making processes through education, innovative dashboards, and relevant data representation.

Duties, Functions and Responsibilities:

Essential duties and functions, pursuant to the Americans with Disabilities Act, may include the following. Other related duties may be assigned.

• Catalogs existing data sources and work with City IT partners to understand requirements for data use, analysis and quality.

• Profiles data from internal and external sources.

• Participates and sometimes lead data classification and data‑mining to identify and assign data categories (e.g., Open, Confidential, Sensitive, HIPAA, etc.) to a data collection.

• Assists in designing reporting dashboards to translate data to an understandable format.

• Performs initial data exploration (binning, pivoting, summarizing and finding correlations).

• Fulfills ad hoc reporting requests.

• Provides feedback and recommendations regarding the creation of standards and patterns for data distribution and retention.

• Analyzes and interprets results using standard statistical tools and techniques.

• Contributes to management of central data stores and metadata to establish quality expectations.

• Contributes to development of services and solutions to drive decision‑making and action.

Responsibilities - Supervisor and/or Leadership Exercised:

None.

Knowledge, Skills, and Abilities:

Must possess required knowledge, skills, abilities, and experience and be able to explain and demonstrate, with or without reasonable accommodations, that the essential functions of the job can be performed.

• Knowledge of data integration tools, data management architectures such as Data Warehouse, Data Lake, Data Hub Management, data exploration techniques (binning, pivoting, summarizing and finding correlations).

• Knowledge of analytics, visualization and business intelligence tools.

• Knowledge of data structures, patterns and data models and related industry-standard methodologies.

• Knowledge of Source-to-Target Mapping, Extract-Transform-Load (ETL) processing and Change Data Capture (CDC) concepts.

• Knowledge of statistical software, database queries and programming languages (e.g., Java, C++, Scala, SQL, Hive, Python and R), XML, JSON and XSD’s.

• Knowledge of Big Data concepts, frameworks, products, tools, and data models and structures as well as database design tools (e.g., Visio, SQL, tec.)

• Skill in data modeling, database and data management, SQL coding, program languages, data warehousing, and relational databases skills.

• Skill in data analysis, data visualization, data mining, reporting, and data integrity skills.

• Ability to clearly communicate technical concepts with customers to increase their understanding of their operations.

• Ability to engage in opportunities to see the big picture and make decisions based on strategy and value delivered.

• Ability to articulate and solve problems or answer questions with data.

• Ability to consider and incorporate the implications of analysis into recommendations for business decisions.

• Ability to gather, assemble, correlate, and analyze facts.

• Ability to identify data trends as well as isolated events.

• Ability to turn data insights into recommendations for both clients and internal stakeholders based on context.

• Ability to adhere to required compliance to all change management policies and procedures.

• Ability to adhere to required compliance to all information security policies and procedures.

Minimum Qualifications:

• Graduation with a Bachelor’s degree from an accredited college or university with major course work in a field related to the job plus two (2) years’ related experience.

• Experience may substitute for education for up to (4) years.

Licenses and Certifications Required:

None.

Preferred Experience:

• Experience developing Power BI reports, dashboards, and semantic models, including DAX and data modeling skills.

• Advanced SQL experience, including query optimization, validation, and troubleshooting across complex relational databases.

• Experience performing business analysis activities such as requirements gathering, workflow mapping, and user story development.

• Prior experience conducting functional testing, QA, and data validation for reports, data pipelines, and data marts.

• Experience working in an enterprise data environment involving ETL processes, data warehouse architecture, or data engineering workflows.

Notes to Candidate:

Position Overview:

This position supports Austin Water’s Operational Intelligence team by developing data products, analyzing business needs, validating data quality, and assisting with report and data model development. The role combines data analysis with business systems analyst functions to help improve data processes, support enterprise data initiatives, and ensure reliable, accurate information for operational and strategic decision making.

Pay Range:

$68,660.00 - $85,830.00 Annually

Position(s) will be filled at the following location:

Waller Creek Center (625 E. 10th Street, Austin, 78701)

Days and Hours:

Monday - Friday 8:00 AM - 5:00 PM with some flexibility. Hybrid.

Additional hours as required to meet business needs.

Benefits:

Working with Austin Water provides a number of health and welfare benefits, such as medical, paid leave time, a great retirement plan, training opportunities and more – click HERE for more information.

Critical Employee:

• This position has been designated as critical for the City of Austin. Critical positions are necessary and vital and support activities that impact City or department operations. Work can be done while at a designated work site or while working at an alternate work location. Critical employees may be reassigned to another area to provide essential services to support any extraordinary situations or emergency conditions.

Secondary Employment:

• All Austin Water employees are prohibited from accepting or engaging in any secondary employment that might conflict or interfere with an employee’s duty and responsibility to the Department.

• Austin Water will review all secondary employment.

• Employees are required to submit a Secondary Employment Application for review and approval upon being hired with Austin Water, as well as current Austin Water employees considering secondary employment.

90-day Provision:

This posting may be used to fill additional vacancies that occur within the department.

All Austin Water worksite locations are tobacco‑free. Use of tobacco products and/or e‑cigarettes is not permitted on any AW worksite – including construction sites, parking lots, garages or in any personal vehicle located on the premises.

Please note this posting may close any time after 7 days.

.

JOIN THE CITY OF AUSTIN TEAM

At the City of Austin, we are more than just an employer—we are a vibrant community dedicated to shaping one of the nation's most dynamic and innovative cities. As we strive to fulfill our commitment as public servants, it is important that we ground our efforts in a set of guiding principles – Empathy, Ethics, Excellence, Engagement, and Equity – that anchor our delivery of services that significantly impact the lives of Austinites. Joining the City of Austin means embarking on a purposeful career, contributing to the community, and being part of a forward‑thinking organization that values every employee.

What Makes the City of Austin Special?

• Make a Difference: Join a team driving meaningful change in one of the fastest‑growing cities in the nation.

• Value and Innovation: Work in an environment where employees are valued, and innovation thrives.

• Competitive Benefits: Enjoy a comprehensive compensation package that includes generous leave, work‑life balance programs, and extensive benefits.

• Retirement Security: Plan for the future with the City of Austin Employees' Retirement System.

• Sustainable Transportation Options: Comm