IT Data Analyst (Operational Intelligence) - Austin Water

About This Position

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.

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.

 None.

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.

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

 None.

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

This position supports Austin Water’s Operational Intelligence team by developing data products, analyzing business needs, validating data quality, and assisting with report and data model development. The role combines data analysis with business systems analyst functions to help improve data processes, support enterprise data initiatives, and ensure reliable, accurate information for operational and strategic decision making.

$68,660.00 - $85,830.00 Annually

Waller Creek Center (625 E. 10th Street, Austin, 78701)

Monday - Friday 8:00 AM - 5:00 PM with some flexibility. Hybrid.

Additional hours as required to meet business needs.

• A detailed, complete employment application is required. It helps us to better evaluate your qualifications and will be used to determine salary if you are selected for this position.

• Provide each job title and accurate employment dates for all jobs included on the application.

• Your work history should include the duties you performed, any supervisory or lead responsibilities, and any equipment and computer software used.

• The City of Austin employment application is an official document; incomplete applications will not be considered.

• Your skills and competencies for this job will be assessed prior to being invited to interview. A 70% or above on all the assessments is required to be considered for the next step.

• Verification of your education (which may include high school graduation or GED, undergraduate and/or graduate degrees) will be required. You must provide proof of education from an accredited organization/institution.

• If you are in the military or a veteran, you will need to provide a copy of your DD-214 prior to confirming a start date.

• A criminal background investigation is required

• This position has been designated as critical for the City of Austin. Critical positions are necessary and vital and support activities that impact City or department operations. Work can be done while at a designated work site or while working at an alternate work location. Critical employees may be reassigned to another area to provide essential services to support any extraordinary situations or emergency conditions.

• All Austin Water employees are prohibited from accepting or engaging in any secondary employment that might conflict or interfere with an employee’s duty and responsibility to the Department.

• Austin Water will review all secondary employment.

• Employees are required to submit a Secondary Employment Application for review and approval upon being hired with Austin Water, as well as current Austin Water employees considering secondary employment.

This posting may be used to fill additional vacancies that occur within the department.

.

• Make a Difference: Join a team driving meaningful change in one of the fastest-growing cities in the nation.

• Value and Innovation: Work in an environment where employees are valued, and innovation thrives.

• Competitive Benefits: Enjoy a comprehensive compensation package that includes generous leave, work-life balance programs, and extensive benefits.

• Retirement Security: Plan for the future with the City of Austin Employees' Retirement System.

• Sustainable Transportation Options: Commute easily with access to public transit and bike-friendly infrastructure.

• Focus on Wellness: Stay healthy through wellness programs, on-site fitness centers, and mental health support.

• Career Growth: Advance your skills and expertise with professional development and leadership opportunities.

• Modern Workspaces: Work in innovative and sustainable environments that foster collaboration and inspiration.

.

EEO Statement for City of Austin:

The City of Austin will not discriminate against any applicant or employee based on race, creed, color, national origin, sex, gender identity, age, religion, veteran status, disability, or sexual orientation. In addition, the City will not discriminate in employment decisions on the basis of an individual's AIDS, AIDS Related Complex, or HIV status; nor will the City discriminate against individuals who are perceived to be at risk of HIV infection, or who associate with individuals who are believed to be at risk.

City of Austin is committed to compliance with the Americans with Disabilities Act. If you require reasonable accommodation during the application process or have a question regarding an essential job function, please call (512) 974-3210 or Texas Relay by dialing 7-1-1.