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.

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.

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

None.

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