TWDB - 25-72 Water Planning Data Analyst Data Analyst III

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 https://tinyurl/CAPPSLogin in the CAPPS online application system at https://tinyurl/CAPPSJobs. Please visit our job opportunities page at https://tinyurl/HowtoApplyinCAPPS 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 Boards Mission  Leading the states 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 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. 

***Salary commensurate with experience and qualifications***

Job Description Summary

Performs moderately complex (journeylevel) data analysis and research work to support regional and state water planning. Work involves collecting reviewing analyzing and furnishing water planning data to regional water planning groups the legislature media and other internal programs and external public stakeholders. Assists with the development and maintenance of the regional and state water planning database and the associated online applications used to collect data from regional water planning groups and disseminate data. Develops reports and dashboards assists in developing new ways to analyze present and consume planning data. Develops data content for the regional water plans supports the agency regional water planning staff and develops and analyzes data to support development of the state water plan. Works under general supervision with limited latitude for the use of initiative and independent judgment. Reports to the Manager of the Water Use & Planning Data Department. 

Essential Job Functions

• Assists in the management of the regional and state water planning data.
• Assists with developing and testing regional water planning applications and maintaining training and guidance materials.
• Provides technical assistance for regional water planning groups and consultants in their effort to submit water supply and Water Management Strategy (WMS) data.
• Performs quality assurance/quality control review of data sets to improve the integrity effectiveness and usefulness of the water planning data.
• Assists in reviewing and evaluating regional water use and planning data for contractual compliance.
• Responds to regional and state water planning data requests from the legislature the Board and other key stakeholders by analyzing data sets and querying existing databases.
• Designs queries and compiles reports using regional water planning data.
• Prepares and maintains written documentation related to regional and state water planning data.
• Develops innovative approaches to analyzing presenting and making data available to stakeholders.
• Assists in reviewing regional water plans and state water plans.
• Conducts data analysis and develops visualization of state water plan data and WMS implementation data by creating maps dashboards and other visualizations tools.
• Consults and collaborates with appropriate staff to define data specifications analyses and data reporting methods
• Prepares performance measures.
• Participates in Supervisorapproved Career Development Plan activities including the establishment of employee goals and identification of jobrelated training opportunities as discussed with Supervisor.
• 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.

Qualifications :

Minimum Qualifications

• Graduation from an accredited fouryear college or university with a bachelors degree in Planning Resource and Environmental Studies Geography Public Administration or a related field.
• Three years of relevant work experience in data analysis.
• Relevant education and experience can be substituted for each other on a yearforyear basis.

Preferred Qualifications:

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

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 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 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 ontime 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 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 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 shifts that may exceed 8 hours including early mornings nights and weekends.
• Ability to train others.
• Ability to manage manipulate and analyze complex databases.
• Ability to schedule work to maintain regular progress on assignments and meet deadlines.

Additional Information :

All interested candidates should apply with a State of Texas application via the CAPPS online application system. First time applicants will need to create an account https://tinyurl/CAPPSLogin in the CAPPS online application system https://tinyurl/CAPPSJobs. Please visit our job opportunities page https://tinyurl/HowtoApplyinCAPPS 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 Stephen F. Austin Building

1700 North Congress Ave. Room 670 Austin Texas 78701

Please contact Human Resources for accommodation requests.

Phone:

Email: HR(AT)

Remote Work :

No

Employment Type :

Fulltime