IT Data Analyst Senior (Reserved for Austin Water Employees Only)

Minimum Qualifications
Education and/or Equivalent Experience:

• Graduation with a Bachelor’s degree from an accredited college or university with major course work in a field related to the job plus four (4) years of experience.
• Experience may substitute for education for up to (4) years.

Licenses or Certifications:

• None.

Notes to Applicants
Position Overview:
GIS Services within IT Services in the Austin Water (AW) department at the City of Austin is hiring an IT Data Analyst Senior responsible for GIS data visualizations, data quality, process improvement, and data transformation. This position will work in a GIS team focused on customer service and operational support for a Water Utility. The IT Data Analyst Senior should have advanced GIS technical skills to be a technical leader in the transition to the Utility Network Data Model for water, wastewater, and reuse networks.

Working with Austin Water provides a number of benefits including medical, paid leave time, a great retirement plan, training opportunities and more! Click HERE for more information.

When completing the City of Austin employment application:

• Please be sure to detail on the application all previous employment that you wish to be considered as part of your qualifications.
• 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. Be sure to provide job title and employment dates for all jobs you wish to be considered.
• A resume is required, but will not substitute for a complete employment application. Incomplete applications will not be considered. Please include contact information from previous employers.

If you are selected as a top candidate:

• 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 and proof of your professional licenses or certifications.
• 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.

Secondary Employment:

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

Effective October 1, 2014, all Austin Water worksite locations are tobacco-free. Use of tobacco products and/or e-cigarettes is not permitted on any AW worksite - including construction sites, parking lot, garage or in any personal vehicle located on the premises.
Pay Range
$37.63 - $47.98 per hour
Hours
8:00 a.m. - 5:00 p.m., flexible hours
Telework 80%, or once a week.
Job Close Date 11/06/2024 Type of Posting Departmental Only Department Austin Water Utility Regular/Temporary Regular Grant Funded or Pooled Position Not Applicable Category Professional Location 625 E. 10th St., Austin, TX 78701 Preferred Qualifications
Preferred Experience:

• Familiarity with a Water Utility Geometric Network or Utility Network
• Experience working in a GIS team environment following and creating standards for workflows and processes
• Experience with relational databases in a multiple user environment
• Experience with data models and spatial Extract, transform, and load ( ETL )

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.


Designs, creates, and maintains relational databases and data systems. Collaborates with City IT analysts to identify data issues and prioritize improvements. Informs solution design and improvements to meet data quality goals. Leads and oversees data classification and data-mining activities to enable more accurate analysis. Determines necessary actions required to generate and publishes open data on the City’s open data portal. Creates data visualizations and reports to present to audiences using presentation tools. Creates standards and patterns for data distribution and retention. Implements statistical models to identify and reveal trends, patterns, and relationships in data to provide guidance to others for decision making processes. Enables access to City and external data sources. Suggests analytics opportunities and best practices. Contributes to management of central data stores and metadata to establish quality expectations. Identifies opportunities to increase data quality, including automation and data entry procedural training. Creates and implements techniques for data collection, accuracy and management.

Responsibilities - Supervisor and/or Leadership Exercised:

• May provide leadership, work assignments, evaluation, training, and guidance to others.

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, and 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, and tools.
• Knowledge of 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, data warehousing, reporting, data warehousing, relational databases, and data integrity skills.
• Skill in data analysis, data visualization, data mining, reporting, and data integrity skills.
• Ability to clearly communicate technical concepts with clients to increase their understanding of their operations.
• Ability to consider and incorporate the implications of analysis into recommendations for business decisions.
• Ability to see the big picture and make decisions based on strategy and value delivered.
• 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.

Criminal Background Investigation This position does not require a Criminal Background Investigation EEO/ADA
The 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.

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.
Information For City Employees: If you are an employee within the department, are in good standing and meet both the minimum and preferred qualifications, then you will receive an initial interview.

Supplemental Questions

Required fields are indicated with an asterisk (*).
* This position requires graduation with a Bachelor’s degree from an accredited college or university with major course work in a field related to the job plus four (4) years of experience. Experience may substitute for education for up to (4) years. Do you meet these minimum qualifications?

• Yes
• No

* Are you currently an Austin Water Utility employee?

• Yes
• No

* How many years of experience do you have with a utility or production GIS environment?

• None
• Less than one (1) year
• One (1) to two (2) years
• Three (3) to four (4) years
• Five (5) or more years

* How many years of experience do you have with ArcGIS Online?

• None
• Less than one (1) year
• One (1) to two (2) years
• Three (3) to four (4) years
• Five (5) or more years

* How many years of experience do you have with the Geometric Network or Utility Network data model?

• None
• Less than one (1) year
• One (1) to two (2) years
• Three (3) to four (4) years
• Five (5) or more years

* How many years of experience do you have with ETL processes?

• None
• Less than one (1) year
• One (1) to two (2) years
• Three (3) to four (4) years
• Five (5) or more years

* Were you referred to this opportunity by an Austin Water employee? If yes, please provide employee’s full name.
(Open Ended Question)
* Will you require sponsorship for employment visa status (e.g., H1B visa) either now or in the future?

• Yes
• No

Optional & Required Documents

Required Documents Resume Optional Documents

• 

• City of Austin

Show more