20-18 DWINS Reporting Coordinator (Program Specialist I-IV)

Performs routine (journey-level) or 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) and the Clean Watersheds Needs Survey (CWNS). Work involves entering, compiling, analyzing, and reporting on Texas Water Development Board’s (TWDB’s) financial assistance and project information maintained within TxWISE, the agency-wide database. Work 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 moderate to general supervision, with limited to moderate latitude for the use of initiative and independent judgment. Reports to the Manager of the Reporting Department.

·       Manages the Agency's participation in the DWINSA from initial preparations through the final review phase by Environmental Protection Agency (EPA). 

·       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 the DWINSA. 

·       Prepares internal procedural documents and training materials for use by TWDB staff and the staff from other participating state agencies/contractors.

·       Collects applicable data and documentation for the next DWINSA.

·       Assists Clean Water State Revolving Fund (CWSRF) counterparts on completing the CWNS as necessary.

·       Undertakes quality control procedures and make quarterly updates to Public Water Supply Systems data in the TxWISE database.

·       Responds to requests for information on an ad hoc basis for the Office of Water Supply and Infrastructure, Executive level management, the Agency’s Board Members or their respective staff.

·       Prepares information for Drinking Water Projects & Benefits Reporting (PBR) and Federal Financial Accountability and Transparency Act (FFATA) reporting; enters the information into state and federal systems developed for that purpose. 

·       Assists other Program Administration staff to improve and coordinate reporting related to PBR and/or FFATA; develops and upgrades related documentation.

·       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; 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.         

·       Graduation from an accredited four-year college or university with a degree in Public Administration, Planning, Engineering, Business, Finance, or other related fields.

·       PS-I: No previous work experience required.

·       PS-II: One to two years of progressive work experience in developing and/or monitoring financial assistance programs, working in the water industry, and/or working with surveys, grants, government research, or statistics.

·       PS-III: Five years of progressive work experience in developing and/or monitoring financial assistance programs, working in the water industry, and/or working with surveys, grants, government research, or statistics.

·       PS-IV: More than five years of progressive work experience in developing and/or monitoring financial assistance programs, working in the water industry, and/or working with surveys, grants, government research, or statistics.

Preferred Qualifications

·       Experience with Microsoft Excel building tables and manipulating data.

·       Relevant education and experience may be substituted on a year-for-year basis.

·       Experience with Microsoft Access building queries, tables, relational databases, and reports.

·       Experience with SQL Server Management Studio building relational databases, queries, and tables.

·       Experience with SQL Server Reporting Services or another Data Analysis tool building reports and/or data visualizations.

 

 Knowledge, Skills, and Abilities (KSAs)

·       Knowledge of local, state, and federal laws and regulations relevant to the Reporting Department; and 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 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 with no physical limitations or aids 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 days that may exceed 8 hours, including early mornings, nights, and weekends.

·       Ability to train others.

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