TWDB - 26-113: Water Supply & Strategy Analyst (Data Analyst II-III) at Texas Water Development Board — NeverHard

Job Description Only applicants who apply with a State of Texas application via the CAPPS online application system will be considered for this position. First time applicants will need to create an account in the CAPPS online application system at https://tinyurl.com/CAPPS-Explore-Jobs . Please visit our job opportunities page at https://tinyurl.com/How-to-Apply-in-CAPPS for more information about the Texas Water Development Board and answers to frequently asked questions. To view this position in greater detail, visit the CAPPS online application system . Texas Water Development Board’s Mission - Leading the state’s efforts in ensuring a secure water future for Texas. The Texas Water Development Board (TWDB) offers competitive compensation and benefits package including medical, dental, vision, 401(k), flexible spending, and flexible work alternatives so you can have a work/life balance! For more information about these benefits and more visit http://www.twdb.texas.gov/jobs/benefits.asp . The Texas Water Development Board does not discriminate on basis of race, color, national origin, sex, religion, sexual orientation, age, or disability in employment or provision of services, programs, or activities. **Must meet agency in-office requirements** ***Salary commensurate with experience and qualifications*** Salary Ranges: Data Analyst II: $5,000.00/month - $5,300.00/month*** Data Analyst III: $5,301.00/month - $5,870.00/month*** GENERAL DESCRIPTION Performs routine (journey-level) to moderately complex (journey-level) data analysis, and data research work. Work involves collecting, reviewing, analyzing, and furnishing water planning and water use data to regional water planning groups, the legislature, media, TWDB programs, and external stakeholders. Conducts QA/QC analyses, develops reports, thematic maps, visualizations, and interactive dashboards. Identifies innovative ways to improve, present, disseminate, and consume planning data. Assists with the development, administration, and maintenance of the Texas Water Service Boundary Viewer (TWSBV), regional and state water planning databases and associated online applications, and coordinates with Information Technology (IT) and program areas on future application development. Provides technical, GIS, mapping, and data support for regional and state water plans. Supports agency regional water planning staff. Develops and analyzes data content for regional water plans and the state water plan, and provides customer assistance to all users. Manages datasets and provides mapping solutions for regional and state water planning processes. May train others. Works under moderate to general supervision, with limited latitude for the use of initiative and independent judgment. Reports to the Manager of the Water Use and Planning Data (WUPD) Department. ESSENTIAL JOB FUNCTIONS Serves as the primary application administrator and program contact for the Texas Water Service Boundary (TWSB) Viewer, including application coordination, user support, annual rollover planning, and maintenance of user guidance materials. Reviews, updates, and maintains public water system (PWS) service area boundary data submitted by utilities for inclusion in the TWSB Viewer. Coordinates with the Public Utility Commission of Texas (PUC) and the Texas Commission on Environmental Quality (TCEQ) to collect and integrate Certificate of Convenience and Necessity (CCN) boundaries, district boundaries, water quality information, and water infrastructure information into the TWSB Viewer for use in the Drinking Water Infrastructure Needs Survey. Provides Geographic Information Systems (GIS) technical assistance to public users, editors, regional water planning groups, consultants, utilities, and other stakeholders regarding the TWSB Viewer, boundary updates, data submissions, and regional water planning data. Supports Water Supply and Strategy Analysis (WSSA) regional and state water planning activities by managing, reviewing, analyzing, and visualizing tabular and geographic data related to water use, water supply, water management strategies (WMS), project implementation, and other planning datasets. Performs quality assurance and quality control (QA/QC) reviews of regional and state water planning datasets to improve data integrity, consistency, effectiveness, and usefulness. Reviews and evaluates regional water use and planning data for contractual compliance and assists in reviewing regional water plans and state water plans. Responds to regional and state water planning data requests from the legislature, the Board, agency leadership, and other key stakeholders by querying databases, analyzing datasets, compiling reports, and preparing clear data summaries. Develops, tests, and supports regional water planning applications, Structured Query Language (SQL) queries, SQL Server Reporting Services (SSRS) reports, dashboards, maps, graphs, and other tools used to collect, analyze, visualize, and disseminate WSSA data. Develops innovative approaches to make WSSA data available to stakeholders through interactive dashboards, thematic maps, geographic illustrations, reports, and other visualization tools. Prepares and maintains written documentation, training materials, methodological guidance, data quality control requirements, and related materials for regional and state water planning data and the TWSB Viewer. Coordinates across TWDB programs to connect TWSB Viewer spatial data with Water Use Survey, Water Loss Audit, Water Conservation, Regional Water Planning, Regional Water Project Development, State Water Implementation Fund for Texas (SWIFT), and State Revolving Fund (SRF) program data. Identifies opportunities to improve WSSA business processes, data quality, spatial analysis, reporting, stakeholder access, and outreach through enhanced use of the TWSB Viewer and related planning data tools. Consults and collaborates with appropriate staff to define data specifications, analysis methods, reporting methods, outreach needs, and performance measures. Provides assistance to the Water Use Survey team and the WSSA team as needed. Maintains confidential and sensitive information. Ensures individual and team files, including electronic and hard copy records, are appropriately maintained and disposed of in accordance with the agency's records retention procedures and schedule. Maintains required certifications and licenses, completes mandatory training, and participates in supervisor-approved career development activities. May be required to operate a state or personal vehicle for business purposes. Performs other duties as assigned.