TWDB 26-94 Sr. 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 in the CAPPS online application system at Please visit our job opportunities page at 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. 

**Must meet agency in-office requirements**

GENERAL DESCRIPTION

Performs moderately complex (journey-level) data analysis and data research work. Works under general supervision with limited latitude for the use of initiative and independent judgment. Design and build tools for data collection extraction and analysis using SQL-based programs and other data analytic software. Responds to requests for information on an ad hoc basis for the public the Office of Water Supply and Infrastructure executive-level management and the agencys Board members or their respective staff. Oversees and maintain a library of data analysis tools queries databases and reports for the division. Spearheads the development of software applications or programming to drive significant improvements in operational efficiencies. Provides guidance and knowledge sharing to junior team data analysts on best practices data tools and software and institutional knowledge regarding data use and products. Makes recommendations for tools applications techniques and processes that would benefit the teams goals projects and products. Assist other Program Administration & Reporting staff to improve and coordinate long-term projects; develop and upgrade related documentation. Develops and monitors team product metrics to monitor usage and success. Updates and maintains all existing desktop procedures related to the reporting duties included in their performance plan. Initiates assists and works with cross-divisional teams to complete updates/upgrades for the agencys databases. Provides strategic support and advice to other sections of the Technical Systems Oversight Department in completing and implementing long-term projects. Collects produces and maintains supporting documentation and maintain standards of source documents. 

ESSENTIAL JOB FUNCTIONS

• Designs and builds tools for data collection extraction and analysis using SQL-based programs and other data analytic software.

• Responds to requests for information on an ad hoc basis for the public the Office of Water Supply and Infrastructure executive-level management and the agencys Board members or their respective staff.

• Maintains a library of data analysis tools queries databases and reports for the division.

• Spearheads the development of software applications or programming to drive significant improvements in operational efficiencies.

• Provides guidance and knowledge sharing to junior team data analysts on best practices data tools and software and institutional knowledge regarding data use and products.

• Makes recommendations for tools applications techniques and processes that would benefit the teams goals projects and products.

• Assists other Program Administration & Reporting staff to improve and coordinate long-term projects; develops and upgrades related documentation.

• Develops and monitors team product metrics to monitor usage and success.

• Updates and maintains all existing desktop procedures related to the reporting duties included in their performance plan.

• Initiates assists and works with cross-divisional teams to complete updates/upgrades for the agencys databases.

• Provides strategic support and advice to other sections of the Technical Systems Oversight Department in completing and implementing long-term projects.

• Collects produces and maintains supporting documentation and maintains standards of source documents.

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

• As Senior Data Analyst reviews and maintains data analyst staff processes and documented procedures for consistency across the team and accuracy.

• 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 four-year college or university with a degree in Data Science Business Analytics Computer/Information Science Statistics Social/Political Science Planning Mathematics Engineering Industrial Engineering Business Finance or other related fields.

• One (1) year of relevant work experience related to data analysis business analysis or a similarly related field.

• One (1) year of experience working with water infrastructure financing programs and developing and managing technical tools and products that utilize project and funding data within the water resources industry.

• One (1) year of experience of relevant work experience as a Data Analyst with SQL Server Management. 

• Experience with Microsoft Power BI building data reporting tools.

• Microsoft Power Apps development skills.

• Experience using ArcGIS Pro to oversee GIS tools and visualizations.

• Experience using Snowflake for enhanced data management analytics and integration with Python SQL and Power BI.

• Experience developing machine learning processes and tools for predictive analytics and automation.

• Ability to physically commute to the TWDB office in Austin Texas on a weekly basis.

PREFERRED QUALIFICATIONS

• One year of progressive work experience using SQL Server Reporting Services or similar software to build reports.

• One year of progressive work experience using Microsoft Power BI or similar software building data reporting tools.

• One year of progressive work experience building Microsoft Power Apps tools and applications.

• One year of progressive work experience using ArcGIS pro to build GIS tools and visualizations.

KNOWLEDGE SKILLS AND ABILITIES (KSAs)

• Knowledge of local state and federal laws and regulations relevant to the Technical Systems Oversight Department. 

• Knowledge of the principles and practices of public administration.

• Knowledge of financial systems.

• Knowledge of the structure and content of the English language including the meaning and spelling of words rules of composition and grammar.

• Knowledge of state and federal financial assistance programs.

• Skills in using Microsoft Office Word Excel and Access.

• Skills in the use of internet email presentation and database software.

• Skills in using Microsoft Teams Project Planner and other organization software applications.

• Skills in identifying complex problems and reviewing related information to develop and evaluate options and implement solutions.

• Skills in interpersonal communications and the ability to interact effectively with a wide variety of customers and stakeholders.

• 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 and with infrequent errors.

• Ability to perform assigned duties and improve work habits and/or output.

• 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 lead and prioritize the work of others.

• Ability to work accurately with numerical details in a fast-paced high-volume setting.

• Ability to analyze and interpret financial data.

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

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 in the CAPPS online application system Please visit our job opportunities page 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 :

Full-time