TWDB - 26-94 - Sr. Data Analyst (Data Analyst III)
Job Description
**Must meet agency in-office requirements**
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.
http://www.twdb.texas.gov/jobs/benefits.asp.
Please visit TWDB Career Page: http://www.twdb.texas.gov/jobs/ for more information.
MILITARY EMPLOYMENT PREFERENCE
Veterans, Reservists or Guardsmen with an MOS or additional duties that fall in the fields of SEI15 Enterprise Policy, Planning, Budget, and Management, 0203 Ground Intelligence Officer, 8U000 Unit Deployment Manager, 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
https://hr.sao.texas.gov/Compensation/MilitaryCrosswalk/MOSC_ProgramManagement.pdf
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 agency’s 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 team’s 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 agency’s 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 agency’s 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 team’s 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 agency’s 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 agency’s 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.
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 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 HR-101 - Consent to Obtain Criminal History Record Information and the GA-48 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.
E-VERIFY
- TWDB participates in E-Verify! Information from each new employee’s Form I-9 will be provided to the Social Security Administration (SSA) and, if necessary, the Department of Homeland Security (DHS) to confirm work authorization.
EMPLOYMENT AT-WILL
- Employment with the Texas Water Development Board (TWDB) is on an at-will 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 (512) 475-2142. Deaf and hard of hearing applicants may contact our office via Relay Texas at 1-800-735-2989 (TTY/TDD).
HEADQUARTER LOCATION AND CONTACT INFORMATION
Texas Water Development Board
Stephen F. Austin Building
1700 North Congress Avenue
Austin, Texas 78701
[email protected]
Phone: (512) 475-2142