IT Data Analyst (Operational Intelligence) - Austin Water
Core
Identify, capture, analyze, and manage City IT and department data to help leadership solve problems and empower end-users with dashboards.
Role type
Data Analyst (Operational Intelligence)
Builds
Operational intelligence dashboards, data models, and reporting solutions for City departments.
Domain
Municipal utilities / Water services / Data Analytics
Deliverable
dashboards & analysis
Required skills
Data modeling, SQL coding, Data warehousing, Data analysis, Data visualization, Data mining, Statistical analysis, Database design, ETL concepts
Preferred skills
Power BI development (DAX), Query optimization, Business analysis, Functional testing, Enterprise data environment experience
Technologies
SQL, Python, R, Java, C++, Scala, Hive, Power BI, Visio, XML, JSON, XSD
Responsibilities
Catalog data sources and define requirements, Profile data from internal/external sources, Design reporting dashboards, Perform initial data exploration, Fulfill ad hoc reporting requests, Contribute to central data store management
Seniority
Mid-level, hands-on IC
