Only candidates who apply via email to (HR “at” TWDB.texas.gov) with an official State of Texas Application or through the WorkInTexas.com website will be considered for this position. View this position and apply at https://tinyurl.com/y8baskh8.
The Texas Water Development Board (TWDB) endorses telecommuting and hybrid workplace plans, in addition to other flexible work alternatives. We offer competitive compensation and benefits package including medical, dental, vision, 401(k), flexible spending, and flexible work hours 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.
*Salary commensurate with experience and qualifications
Job Description Summary
Performs moderately complex (journey-level) data analysis and geographic information system (GIS) work including, water use and planning data QA/QC, analyses and research, data visualization, application development and technical assistance. Work involves administering the web-based Texas Water Service Boundary (TWSB) Viewer application, planning and coordinating activities with Information Technology (IT) and other program areas for future application development, providing GIS and data services and customers assistance to internal and external users; writing technical reports; developing innovative ways to improve and disseminate water use and planning data by developing thematic maps and interactive dashboards; serving as the divisions GIS leading expert managing datasets and providing data assistance and mapping solutions for the regional and state water planning processes. May train others. Works under 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 application administrator of the TWSB Viewer application.
- Develops and manages the plan for annual application rollover activities and timeline.
- Provides GIS technical assistance to public users and editors of the TWSB Viewer application through answering phone calls and emails.
- Reviews, updates, and maintains up-to-date public water system (PWS) service area boundaries submitted by utilities and maintains and updates the user guide and help document for the TWSB Viewer.
- Coordinates with Public Utility Commission (PUC) and Texas Commission of Environment Quality (TCEQ) to collect Certificate of Convenience and Necessity (CCN) and district boundaries, water quality and water infrastructure information to be integrated into the TWSB Viewer to be used for Drinking Water Infrastructure Need Survey.
- Analyzes tabular and geographic data associated with water use, water supply, water management strategies and other related data for regional statewide water planning.
- Serves as an inter-program coordinator to develop a process to connect the TWSB Viewer special data with various reports developed by Water Use Survey, Water Audit, Water Conservation, and Regional Water Project Development and to project need and implementation data from State Water Implementation Fund for Texas (SWIFT) and State Revolving Fund (SRF) programs.
- Assists in the identification of outreach needs for the PWSs with Program Administration & Reporting Departments Outreach Team.
- Consults and collaborates with appropriate staff in various program areas in WUPD to identify additional functionalities to improve their business process and data quality through the TWSB Viewer including funding eligibility analysis and data reporting at various spatial resolution.
- Performs water use and planning data QA/QC, analyses, and visualization, application development and technical assistance.
- Serves as a divisions GIS leading expert managing GIS datasets and providing technical assistance and mapping solutions for the regional and state water planning processes and provide technical assistance and review for the regional and state water planning processes including the iSWP.
- Performs spatial analysis to review PWS population estimates and growth using the Census and Landscan data and develops methods to improve annual population estimates for PWSs.
- Conducts spatial review to validate water use survey facility locations to assist with the water use survey QA/QC.
- Develops and manages the divisions GIS data collection to be used by multiple program areas within Water Supply Planning (WSP).
- Creates and develops innovative ways to disseminate the departments data using interactive dashboards, thematic maps, graphs and other geographic illustration of historical water use estimates and regional and state water planning data for internal and external stakeholders.
- Conducts research and data analysis associated with water use and population changes for public water systems.
- Assists in developing the departments data quality control requirements and methodological documentation and in conducting various data checks.
- Provides assistance to the Water Use Survey team and Water Supply and Strategy Analysis team as needed.
- Maintains confidential and sensitive information.
- Ensures individual and team files (electronic and hard versions) are appropriately maintained and timely disposed of in accordance with the agencys records retention procedures and schedule.
- Maintains required certifications and licenses and meets the continuing education needs and requirements of the position to include, attending mandatory training courses.
- May be required to operate a state or personal vehicle for business purposes.
- Performs other duties as assigned.
- Graduation from an accredited four-year college or university with a bachelors degree in Planning, Resource and Environmental Studies, Geography, Public Administration, GIS, Computer Science, Engineering, or related field.
- Four years of work experience with relational database or data analysis work
- Two years of work experience with GIS.
- Relevant education and experience can be substituted on a year-for-year basis.
- Graduate degree from an accredited college or university with major course work in Planning, Resource and Environmental Studies, Geography, Public Administration, Geographic Information Systems, Computer Science, Engineering, or related field.
- Experience with relational databases, including querying, reviewing, and reporting data.
- Experience developing data dashboard using Tableau or Power BI.
- Experience querying data using Microsoft SQL Server Management Studio or Microsoft Access.
- Experience in regional and state water planning in Texas and/or water use or water projection data.
Knowledge, Skills, and Abilities
- Knowledge of local, state, and federal laws and regulations relevant to Water Supply & Infrastructure Office / Water Supply Planning Division; and of the principles and practices of public administration.
- Knowledge of research techniques and geographical concepts and their application to data analysis.
- Knowledge of relational databases and skill with data management including editing, querying, and generating of reports and graphs.
- Skills in Microsoft Office programs such as Word, Excel and Access.
- Skills in use of internet, email, word processing, spreadsheet, presentation, and database software.
- Skills in solving complex data problems.
- Skills in building data-related reports using software such as Microsoft Access, Crystal Reports, or Microsoft SQL Server Reporting Services.
- Skills in graphical, tabular and geographical presentation of data.
- Skills in Tableau or Power BI.
- Skills with ESRI ArcGIS software, including ArcGIS Online
- Skills in organizational, interpersonal and oral and written communication skills.
- Skills in preparing and writing technical reviews and reports.
- Ability to work efficiently in a dependable, organized and productive manner to be able to manage multiple tasks and meet deadlines.
- Ability to adhere to work schedules, follow procedures with respect to leave and submit accurate timesheets by prescribed deadlines.
- Ability to make mature, objective decisions and identify areas of potential problems.
- Ability to perform effectively and willingly when changes occur in scope and nature of the work and work environment.
- Ability to perform routine and non-routine work assignments accurately and on-time with little or no supervision.
- Ability to perform assigned duties and improve work habits and/or output.
- Ability to complete assigned work, on time, neatly and with infrequent errors.
- Ability to interpret policies, procedures, and regulations.
- Ability to provide prompt, courteous and accurate assistance and clear and concise communication to internal and external stakeholders both verbally and in writing.
- Ability to work and cooperate with others in a team environment.
- Ability to manage multiple tasks.
- Ability to stand/sit/move with no physical limitations or aids to perform activities such as retrieve/replace files in a large file system for boxes up to 30 lbs.
- Ability and willingness to travel 5% of the time, primarily within the State of Texas.
- Ability to operate a vehicle (state or personal) for state business and maintain a drivers license and driving record that complies with state and agency requirements.
- Ability to work days that may exceed 8 hours, including early mornings, nights, and weekends.
- Ability to train others.