IT Data Analyst (Operational Intelligence) - Austin Water

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.

When completing the City of Austin employment application:

• A detailed, complete employment application is required. It helps us to better evaluate your qualifications and will be used to determine salary if you are selected for this position.

• Provide each job title and accurate employment dates for all jobs included on the application.

• Your work history should include the duties you performed, any supervisory or lead responsibilities, and any equipment and computer software used.

• The City of Austin employment application is an official document; incomplete applications will not be considered.

• A résumé is required but will not substitute for a complete employment application. Incomplete applications will not be considered.

• A cover letter is also required. In the cover letter candidates should describe, in concise detail, their interest in this position and highlight any prior experience that is relevant to this position.

If you are selected to interview:

• Your skills and competencies for this job will be assessed prior to being invited to interview. A 70% or above on all the assessments is required to be considered for the next step.

If you are selected as a top candidate:

• Verification of your education (which may include high school graduation or GED, undergraduate and/or graduate degrees) will be required. You must provide proof of education from an accredited organization/institution.

• If you are in the military or a veteran, you will need to provide a copy of your DD-214 prior to confirming a start date.

• A criminal background investigation is required

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: Commute easily with access to public transit and bike-friendly infrastructure.

• Focus on Wellness: Stay healthy through wellness programs, on-site fitness centers, and mental health support.

• Career Growth: Advance your skills and expertise with professional development and leadership opportunities.

• Modern Workspaces: Work in innovative and sustainable environments that foster collaboration and inspiration.

 

By joining us, you become part of a community that values its people and is committed to making Austin the most thriving and resilient city in the country.

.

EEO Statement for City of Austin:

The City of Austin will not discriminate against any applicant or employee based on race, creed, color, national origin, sex, gender identity, age, religion, veteran status, disability, or sexual orientation. In addition, the City will not discriminate in employment decisions on the basis of an individual's AIDS, AIDS Related Complex, or HIV status; nor will the City discriminate against individuals who are perceived to be at risk of HIV infection, or who associate with individuals who are believed to be at risk.

City of Austin is committed to compliance with the Americans with Disabilities Act. If you require reasonable accommodation during the application process or have a question regarding an essential job function, please call (512) 974-3210 or Texas Relay by dialing 7-1-1.