TWDB - Water Supply & Strategy Analyst (Data Analyst II-III)

Job Description
Must meet agency inoffice 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

TEXAS WATER DEVELOPMENT BOARD'S MISSION
Leading the state's efforts in ensuring a secure water future for Texas.
WORKING AT THE TWDB
See why our work makes an impact !
Find out why the TWDB is a great place to work .
Make a positive difference for the state of Texas. We encourage you to apply for positions that match your qualifications.
The Texas Water Development Board (TWDB) offers a 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:
.
Please visit TWDB Career Page: for more information.
MILITARY EMPLOYMENT PREFERENCE
Veterans, Reservists or Guardsmen with an MOS or additional duties that fall in the fields of 25B Information Technology Specialist, 183X Intelligence Officer, 15AX Operations Analysis Officer, or other related fields pertaining to the minimum experience requirements may meet the minimum qualifications for this position and are highly encouraged to apply.
Additional Military Crosswalk information can be accessed at
GENERAL DESCRIPTION
Performs routine (journeylevel) to moderately complex (journeylevel) 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 supervisorapproved career development activities.
• May be required to operate a state or personal vehicle for business purposes.
• Performs other duties as assigned.

MINIMUM QUALIFICATIONS

• Graduation from an accredited fouryear college or university with a bachelor's degree in Planning, Resource and Environmental Studies, Geography, Public Administration, or a related field.
• Professional Experience:
  • Data Analyst II Two years of relevant data work experience.
  • Data Analyst III Three years of relevant data work experience.
• Relevant education and experience can be substituted for each other on a yearforyear basis.

PREFERRED QUALIFICATIONS

• Previous work experience with ESRI ArcGIS software.
• Previous work experience with data visualization using dashboards (Microsoft Power BI) or mapping tools (GIS).
• Experience querying data using Microsoft SQL Server Management Studio.
• Previous work experience with datarelated reports using software such as Microsoft Access, Microsoft SQL Server Reporting Services, or Microsoft Power BI.
• Previous work experience with data or technical support work.
• Previous work experience with data QA/QC and analysis work using Excel, R, Python, or other statistical tools.
• Experience working with regional and state water planning in Texas and/or water planningrelated data.
• Post graduate degree from an accredited fouryear college or university with major coursework in planning, Resource and Environmental Studies, Geography, Public Administration, or a related field.

KNOWLEDGE, SKILLS, AND ABILITIES (KSAs)

• Knowledge of local, state, and federal laws and regulations relevant to the Water Use and Planning Data Department.
• Knowledge of the principles and practices of public administration.
• Knowledge of research techniques, statistical methods and geographical concepts and their application to data analysis.
• Knowledge of relational databases and data management.
• Skills in using Microsoft Office programs such as Word, Excel, Access, and SQL.
• Skills in use of internet, email, word processing, spreadsheet, presentation, and database software.
• Skills in problem solving and data analysis.
• Skills with ESRI ArcGIS software.
• Skills in querying data using software such as Microsoft Access or SQL Server.
• Skills in building datarelated reports using software such as Microsoft Access, or Microsoft SQL Server Reporting Services or dashboards using Power BI.
• Skills in graphical, tabular, and geographical presentation of data.
• Skills in organizational, interpersonal, and oral and written communication skills.
• Ability to maintain the security or integrity of critical infrastructure within Texas.
• Ability to meet agency inoffice requirements.
• Ability to manage, manipulate, and analyze complex databases.
• Ability to schedule work to maintain regular progress on assignments 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 nonroutine 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 all customers 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 to perform activities such as retrieve/replace files in a large file system for boxes up to 30 lbs.
• Ability and willingness to travel 1% of the time, primarily within the State of Texas.
• Ability to operate a vehicle (state or personal) for state business and maintain a driver's license and driving record that complies with state and agency requirements.
• Ability to work shifts that may exceed 8 hours, including early mornings, nights, and weekends.
• Ability to train others.

REMARKS

• A copy of required academic transcripts and/or licensures and driving record must be submitted at the time of hire. Failure to provide required documentation will result in no further consideration for employment.
• Important Notice: Otherwise qualified candidates who are ultimately considered for potential employment with the Texas Water Development Board may be the subject of a request for any criminal history record information maintained by the Texas Department of Public Safety (DPS). Evidence of a criminal conviction or other relevant information obtained from the DPS shall not automatically disqualify an individual from employment with the Texas Water Development Board.

APPLICATIONS SUBMITTED THROUGH WORK IN TEXAS

• Work In Texas (WIT) applicants must complete the supplemental questions to be considered for the posting. To complete the supplemental questions please go to CAPPS Recruit to register or login and access your profile.

REFERENCE CHECKS

• Reference checks will be conducted on top candidate for the position and may include outreach to current and/or former supervisors. Reference checks for top candidates currently employed by the TWDB will include outreach to current supervisors.

CONSENT OF CRIMINAL HISTORY CHECKS

• All interviewed candidates must complete the HR101 Consent to Obtain Criminal History Record Information and the GA48 Consent form to obtain continuous criminal history and review forms once extended an offer to interview. The consent forms will be sent by Human Resources (HR) and retained with HR. Only candidates extended a conditional offer will have their criminal history checked in the Texas Department of Public Safety (DPS) system. Candidates who refuse to complete both consent forms will no longer be considered for the vacancy with the Texas Water Development Board. If adverse findings are found, candidates will be afforded 10 business days to provide a response prior to a final determination on hiring eligibility.

JOB LOCATION

• Candidate must be able to report to and work from the noted work location and comply with the agency's Return to Office (RTO) requirements.

EQUAL OPPORTUNITY

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

SELECTIVE SERVICE

• Males born on or after January 1, 1960, will be required to present proof of Selective Service registration on the first day of employment or proof of exemption from Selective Service registration requirement.

FINAL EMPLOYMENT OFFERS

• All offers of employment are contingent upon the candidate having legal authorization to work in the United States. Failure to present such authorization within the time specified by the U.S. Department of Labor will result in the offer being rescinded.

FOREIGN CREDENTIALS

• An evaluation of your coursework must be uploaded if you have obtained a degree(s) from a school outside of the United States; otherwise, you will not receive credit for degree progress and completion.

SPONSORSHIP

• Candidates must be eligible to work in the United States without requiring sponsorship.

STATE OF TEXAS APPLICATION

• Resumes will not be accepted in place of a completed State of Texas application unless indicated.

EVERIFY

• TWDB participates in EVerify! Information from each new employee's Form I9 will be provided to the Social Security Administration (SSA) and, if necessary, the Department of Homeland Security (DHS) to confirm work authorization.

EMPLOYMENT ATWILL

• Employment with the Texas Water Development Board (TWDB) is on an atwill basis.

AMERICANS WITH DISABILITIES ACT

• The TWDB is in compliance with the Americans with Disabilities Act and makes reasonable accommodations for applicants and employees with disabilities. If a reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits of employment, please contact the Human Resources Division for assistance at . Deaf and hard of hearing applicants may contact our office via Relay Texas at (TTY/TDD).

HEADQUARTER LOCATION AND CONTACT INFORMATION
Texas Water Development Board
Stephen F. Austin Building
1700 North Congress Avenue
Austin, Texas 78701

Phone: