IT Data Analyst (Operational Intelligence) - Austin Water

austintexas; United States; On-site; USD 70,000 - 90,000; Full time

Job summary

Austin Water in Austin, TX is seeking an IT Data Analyst to identify, capture, analyze, and manage City IT data. You will help City leadership answer questions and make informed decisions through education, dashboards, and meaningful data representations.

You will profile data, classify data, design reporting dashboards, perform initial data exploration, and fulfill ad hoc requests. Collaboration with City partners and adherence to data standards are essential.

Qualifications

• Bachelor's degree in a related field with 2 years of experience; more experience may substitute.
• Knowledge of data integration and analytics tools, BI platforms, and data structures.
• Familiarity with data governance, security, and compliance requirements.

Responsibilities

• Catalogs existing data sources and works 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 data categories (e.g., Open, Confidential, Sensitive, HIPAA, etc.).
• 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.

Skills

SQL

Python

Data visualization

Big data concepts

Data modeling

Communication

ETL

Hive

R

Java

C++

Education

Bachelor's degree in a field related to the job

Tools

SQL

Python

Hive

R

Java

Excel

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 deve