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.
***Salary commensurate with experience and qualifications***
General Description
Performs moderately complex (journey-level) consultative services and technical assistance work. Work involves entering, compiling, analyzing, and reporting on agency financial assistance programs and project information maintained within the agency-wide database, TxWISE. Works with cross-divisional, cross-office teams gathering and analyzing data and projects. Prepares all reports for the Flood Infrastructure Fund (FIF), Texas Infrastructure Resiliency Fund (TIRF), Quarterly State Agency Federal Funding (QSAFF), and any other flood-related financial assistance program. Prepares annual Texas Water Fund reports and associated reports and programs, including but not limited to the Rural Water Assistance Fund (RWAF) and the Water Loan Assistance Fund (WLAF). Initiates, assists, maintains, and leads enhancement projects for agency databases. May train others. Works under general supervision, with limited latitude for the use of initiative and independent judgment. Reports to the Manager of the Reporting Department.
Essential Job Functions
- Assists in developing and maintaining reports for TWDB financial assistance programs, thereby enabling the effective use of program funds.
- Responds to requests for information on an ad hoc basis for the public, the Office of Water Supply and Infrastructure, Executive level management, the Agency’s Board Members, or their respective staff.
- Prepares, analyzes and distributes information related to the Flood Infrastructure Fund (FIF), Texas Infrastructure Resiliency Fund (TIRF), Quarterly State Agency Federal Funding (QSAFF) and any other flood-related financial assistance programs for publication to the public, the State Legislature, and other state agencies.
- Prepares, analyzes, and distributes state performance measure information related to all agency financial assistance programs’ activities on a quarterly basis via an internal database.
- Prepares, analyzes, and distributes information related to the funding status of all active projects funded through the agency’s financial assistance programs.
- Works with other state agencies to evaluate request data, assign identification numbers, and produce any associated reports.
- Completes any other monthly, quarterly, biannual, and annual submissions of Federal and State reports covering the Agency’s various financial assistance programs and ensures accuracy of the information provided from delegated staff.
- Creates maps using ArcGIS Pro for quarterly Financial Assistance Summary.
- Collects, produces, and maintains supporting documentation and maintains standards of source documents.
- Updates and maintains all existing desktop procedures related to the reporting duties included in their performance plan.
- Assists with updating and maintaining electronic copies of TWDB policies, procedures, guidelines, checklists, forms, and reference materials for the Reporting Department.
- Assists with special projects as assigned.
- 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 position’s continuing education needs and requirements, including 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 Public/Business Administration, Management Information Systems, or a related field.
- One year of relevant work experience in data validation, database management, monitoring financial assistance programs, working in the water industry, and/or working with surveys, grants, government research, medical data entry, or statistics.
- Experience creating, organizing, merging, and editing PDF documents using Adobe Acrobat.
- Experience building tables and manipulating data using Microsoft Excel.
- Relevant education and experience can be substituted for each other on a year-for-year basis.
Preferred Qualifications
- Three years of relevant work experience in data collection and validation, database management, and maintaining multiple reports for multiple programs or projects.
- Experience using Microsoft Teams for collaboration, setting up meetings, and sharing files.
- Experience with SQL Server Management Studio or another data analysis tool used to build reports, relational databases, queries, and tables.
- Experience with ArcGIS Pro or other equivalent mapping skills.
- Certifications related to ArcGIS Pro.
- Previous state agency database experience.
Knowledge, Skills, and Abilities
- Knowledge of local, state, and federal laws and regulations relevant to the Reporting Department.
- Knowledge of the principles and practices of public administration.
- Knowledge of the structure and content of the English language, including the meaning and spelling of words, rules of composition, and grammar.
- Knowledge of financial systems, word processing, database querying, and spreadsheets.
- Knowledge of state and federal financial assistance and funding programs.
- Skills in using Microsoft Office programs such as Word, Excel, Access, SharePoint and OneNote.
- Skills in using the internet, email, word processing, spreadsheets, presentations, and database software.
- Skills in identifying complex problems and reviewing related information to develop and evaluate options and implement solutions.
- Ability to interact effectively with a wide variety of customers and stakeholders.
- Ability to analyze and interpret financial data.
- Ability to sit for extended periods.
- 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 sit/stand/move to perform activities such as retrieve/replace files in a large 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.
