IT Data Analyst (Operational Intelligence) - Austin Water

City of Austin•Austin, TX

1d•$68,660 - $85,830•Hybrid

About The Position

Austin Water has been committed to providing safe, reliable, high-quality, and affordable water services to its customers for over 100 years. Serving over 1,000,000 people across more than 548 square miles, Austin Water is a leader in sustainable infrastructure, advanced treatment technology, and environmental innovation. The IT Data Analyst role is responsible for identifying, capturing, analyzing, and managing City IT and department data. Through data conceptualization, modeling, and presentation, IT Data Analysts assist City leadership and departments in answering questions and solving problems. They also empower end-users to utilize data in their decision-making processes through education, innovative dashboards, and relevant data representation.

Requirements

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

Nice To Haves

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.

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.