IT Data Analyst (Operational Intelligence) - Austin Water

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

Benefits offered by this job

Hybrid work arrangement

Professional development opportunities

Job summary

City of Austin's Austin Water department seeks an IT Data Analyst to identify, capture, analyze, and manage city data. You will empower leadership with dashboards and data representations to drive informed decisions. The role involves data profiling, data classification, and developing standards for data distribution and retention.

You will work hybrid, with responsibilities across data modeling, ETL concepts, and BI tools to turn insights into strategic actions.

Qualifications

• Bachelor's degree in a related field; two years of experience; additional experience may substitute education.
• Strong data analysis and problem-solving skills.
• Ability to communicate technical concepts clearly to non-technical stakeholders.

Responsibilities

• Catalog data sources and collaborate with IT to define data use and quality requirements.
• Design and explore data models; support reporting dashboards and ad hoc analyses.
• Profile data from internal and external sources and ensure data quality.
• Translate data insights into actionable business recommendations.

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:

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:

• 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:

• 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.

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.

Pay Range:

$68,660.00 - $85,830.00 Annually

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.

Closing Notice:

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 [phone] or Texas Relay by dialing 7-1-1.