24-92 - Water Data Analyst (Data Analyst IV)

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.com/CAPPS-Login in the CAPPS online application system at https://tinyurl.com/CAPPS-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) 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 our employee 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. 

General Description

Performs complex (journey-level) data analysis and data research work. Work involves management, analysis, reporting, and visualization of data for the division. Works with and utilizes the Loss, Use, and Conservation (LUC) application, Desalination Database, irrigation water use estimates, and other associated reports and databases. May train others. Works under general supervision, with moderate latitude for the use of initiative and independent judgment. Reports to the Director of the Conservation and Innovative Water Technologies Division. 

Essential Job Functions

• Serves as the data lead for the division and a data liaison across departments within and outside of the division.
• Collects, queries, and analyzes data, and summarizes findings in reports.
• Develops maps, graphs, and other tools to visualize data from the division and state water plan.
• Works with division to identify needs and develop data products or enhancements to existing applications and databases.
• Develops and implements quality control procedures and monitors data quality assurance.
• Documents procedures regarding data sets and applications.
• Uses Microsoft Access, Geographic Information Systems (GIS), Power BI, and Google Analytics to manage, analyze, and visualize data.
• Trains staff and assists in the use of data applications and systems.
• Tests, troubleshoots, and assists in the resolution of problems relating to data applications.
• Analyzes, plans, and tests enhancements to applications as the business area liaison to the Information Technology Division.
• Develops, reviews, and analyzes system requirements specifications for software development.
• Researches and provides written and verbal responses to public, inter-agency, and intra-agency inquiries.
• Conducts presentations on data at public meetings, workshops, seminars, and conferences.
• 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 agency’s 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. 

Minimum Qualifications

• Graduation from an accredited four-year college or university with a bachelor’s degree in Engineering, Water/Natural Resources, Sustainability, Environmental Science, Geology, Hydrogeology, Information Technology, Geographic Information Systems, Data Science or related field.
• Four years of work experience in data research, querying, compilation, reviewing, analysis, reporting, managing, and/or visualization.
• Relevant education and experience can be substituted on a year-for-year basis.

Preferred Qualifications

• Graduate degree from an accredited four-year college or university with a master’s or doctorate degree in Engineering, Water/Natural Resources, Sustainability, Environmental Science, Geology, Hydrogeology, Information Technology, Geographic Information Systems, Data Science or related field.
• Familiarity with water resources of Texas.
• Familiarity with water conservation, both municipal and agricultural, and alternative water supplies such as aquifer storage and recovery, desalination, and reuse.
• Experience with Microsoft Access, SQL Server, or other relational databases.
• Experience with ArcGIS applications including Spatial Analyst, ArcPy, and Model Builder.
• Experience with Power BI or other similar tools.
• Experience with Google Analytics, HTML, Dreamweaver, or Cascade Management System.

Knowledge, Skills, and Abilities

• Knowledge of local, state, and federal laws and regulations relevant to the Conservation and Innovative Water Technologies Division. 
   
• Knowledge of the principles and practices of public administration.
   
• Knowledge of relational database concepts, techniques, and analysis.
   
• Knowledge of Geographic Information System concepts, techniques, and analysis.
   
• Knowledge of statistics and analyzing datasets.
• Knowledge of running queries.
• Knowledge report writing, and presenting findings. 
• Knowledge of data models, database design development, data mining, and segmentation techniques.
• Knowledge of record keeping, including security procedures for handling, protecting, and distributing confidential data.
   
• Skills in using Microsoft Office programs such as Word, Excel, and Access.
   
• Skills in use of internet, email, word processing, spreadsheet, presentation, and database software.
   
• Skills in scientific data management, analysis, testing, and quality assurance.
   
• Skills in the use of a computer and applicable software, in analyzing problems and devising effective solutions, in conducting data searches, in evaluating and translating large amounts of data, and in critical thinking.
   
• Skills in using Geographic Information Systems and computer programming.
   
• Skills in using SQL and SQL Server Reporting Services and editing SQL queries and stored procedures.
   
• Skills in using Power BI or other similar tools.
   
• Skills in using Google Analytics, HTML, Dreamweaver, and Cascade Management System.
   
• Ability to collaborate with staff across different departments to achieve goals and objectives.
• Ability to schedule work to maintain regular progress on assignments and meet deadlines.
• Ability to compile, review, and analyze data; to prepare reports; to maintain accuracy and attention to detail; to communicate effectively; and to provide guidance to others.
• 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 to perform activities such as retrieve/replace files in a large file system for boxes up to 30 lbs.
   
• Ability and willingness to travel 10% 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.