You are viewing a preview of this job. Log in or register to view more details about this job.

TWDB - 25-03 - DWSRF Reporting Coordinator (Program Specialist III-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.

Salary ranges reflect the 9/1 legislative increase for state employees as of September 1.

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

Salary Ranges:

Program Specialist III - $4,020.33/monthly – $4,869.38/monthly***
Program Specialist IV - $4,870.00/monthly - $5,369.01/monthly***

Job Description Summary

Performs complex (journey-level) to highly complex (senior-level) consultative services and technical assistance work. Work involves coordinating the State's participation in the federal Drinking Water Infrastructure Needs Survey and Assessment (DWINSA), Drinking Water State Revolving Fund (DWSRF) and overseeing external coordination. Enters, compiles, analyzes, and reports on Texas Water Development Board’s (TWDB’s) financial assistance and project information maintained within TxWISE, the agency-wide database. Works with cross-divisional, cross-office teams in data gathering and analysis projects. Prepares information for Drinking Water Projects & Benefits (PBR) reporting and enters it into State and Federal database systems developed for that purpose. May train, lead, and/or prioritize the work of others. Works under general to limited supervision, with moderate latitude for the use of initiative and independent judgment. Reports to the Manager of the Reporting Department.

Essential Job Functions

Prepares information for Drinking Water Projects & Benefits Reporting (PBR) and Federal Financial Accountability and Transparency Act (FFATA) reporting and enters the information into state and federal systems developed for that purpose.
Assists other Program Administration staff to improve and coordinate reporting related to federal reporting, PBR and/or FFATA and develops and upgrades related documentation.
Undertakes quality control procedures and makes quarterly updates to public wastewater facilities data in the TxWISE database.
Prepares internal procedural documents and training materials for use by TWDB staff and the staff from other participating state agencies/contractors.
Prepares and contributes toward the creation of Annual Reports for the State Revolving Fund programs.
Responds to requests for information on an ad hoc basis for the Office of Water Supply and Infrastructure (WSI), Executive level management, the Agency’s Board Members, or their respective staff.
Manages the agency’s participation in the DWINSA from initial preparations through the final review phase by the Environmental Protection Agency (EPA), including the submission of DWINS information.
Preparing, and maintaining supporting documentation, and responding to EPA’s data modification requests.
Collects applicable data and documentation for the future DWINSA.
Assigns responsibilities to available and participating staff from the TWDB, Texas Commission on Environmental Quality (TCEQ), and other participating agencies.
Manages the submission of information, documentation for review and acceptance by EPA and its contractors.
Reviews and responds to data modifications by EPA and its contractors.
Researches and evaluates changes in Federal policies and procedures regarding DWINSA.
Assists Clean Water State Revolving Fund (CWSRF) counterparts on completing the CWNS, as necessary.
Updates and maintains all existing desktop procedures related to the reporting duties included in their performance plan.
Initiates, assists, and maintains enhancement projects for the Agency’s databases.
Works with cross-divisional teams to complete updates/upgrades to the agency’s databases.
Completes monthly, quarterly, biannual, and annual submission of federal and state reports covering the agency’s various financial assistance programs and ensures accuracy of the information provided from delegated staff.
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.
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 Public Administration, Planning, Engineering, Business, Finance, or other related fields.
Work Experience:
- Program Specialist III: Three years of relevant work experience with 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.
- Program Specialist IV: Four years of relevant work experience with data validation, database management, developing and/or monitoring financial assistance programs, working in the water industry, and/or working with surveys, grants, government research, medical data entry, or statistics.
Relevant education and experience can be substituted for each other on a year-for-year basis.

Preferred Qualifications

More than five years of progressive work experience with data validation and/or database management.
Experience with Microsoft Access building queries, tables, relational databases, and reports.
Intermediate level of experience or above with Microsoft Excel building tables, using pivot tables, VLOOKUP and manipulating data.
Advanced level of experience with Microsoft Word comparing and merging documents, track changes, formatting, creating templates, and formatting tables.
Experience with SQL Server Management Studio (SSMS) or another data analysis tool building and modifying relational databases, queries, and tables.
Experience with SQL Server Reporting Services (SSRS), Power BI, Tableau, or another data analysis tool building and modifying reports and/or data visualizations.

Knowledge, Skills, and Abilities (KSAs)

Knowledge of local, state, and federal laws and regulations relevant to the Program Administration & Reporting Division.
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 state and federal funding programs.
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 identifying complex problems and reviewing related information to develop and evaluate options and implement solutions.
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 work effectively in a dependable, organized and productive manner in order to plan and arrange workload to meet scheduled deadlines.
Ability to work as a team member and leader in a courteous and effective manner.
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 days that may exceed 8 hours, including early mornings, nights, and weekends.
Ability to train others.