Data Analyst, Operational Intelligence & Dashboards

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

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.