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

20-65 Flood Reporting Coordinator (Data Analyst I-III)

We offer a 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 these benefits and more visit: http://www.twdb.texas.gov/jobs/benefits.asp
*Only candidates who apply via email to (HR “at” TWDB.texas.gov) with an official State of Texas Application or through the WorkInTexas.com website will be considered for this position. View this position and apply at https://bit.ly/2AmcONn
Job Description Summary
Performs entry-level to moderately complex (journey-level) data analysis and data research work. Work involves conducting detailed analysis of and extensive research on data, providing results, and monitoring and implementing data quality standards. Works with cross-divisional, cross-office teams in data gathering and analysis projects, preparation of all reports for the Flood Infrastructure Fund, Texas Infrastructure Resiliency Fund, and any other flood-related financial assistance program. Work involves entering, compiling, analyzing, and reporting on TWDB’s financial assistance and project information maintained within TxWISE, the agency-wide database. Builds and maintains database queries and reports. Assists other sections of the Reporting Department in completing and implementing long-term projects. Initiates, assists, maintains and leads enhancement projects for agency databases. Trains, leads, and may prioritize the work of others. Works under close to general supervision, with minimal to limited latitude for the use of initiative and independent judgment. Reports to the Manager of the Reporting Department.
Essential Job Functions
  • Prepares, analyzes, and d istributes informational reports for the Flood Infrastructure Fund, the Texas Infrastructure Resiliency Fund, and any other flood-related financial assistance program.
  • 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, the agency's Board Members or their respective staff.
  • Maintains a library of data analysis tools, queries, and reports.
  • Assists with developing software applications or programming as a means for improvements in operational efficiencies.
  • 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.
  • 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.
  • Assist other sections of the Reporting Department in completing and implementing long-term projects.
  • 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 degree in Data Science, Business Analytics, Computer or Information Science, Statistics, Social or Political Science, Planning, Statistics, Mathematics, Engineering, Business, Finance, or other related fields.
  • DA-I: One year of work experience in data analysis, business analysis, auditing, finance, statistics, or a similarly related field.
  • DA-II: Three years of progressive work experience with data analysis, business analysis, auditing, finance, statistics, or a similarly related field.
  • DA-III: Five years or more years of progressive work experience with data analysis, business analysis, auditing, finance, statistics, or a similarly related field.
  • Previous experience with SQL Server Management Studio, or a similar software, building queries.
  • Relevant education and experience may be substituted on a year-for-year basis.
Preferred Qualifications
  • One to three years of progressive work experience with financial assistance programs, procurements, and/or grants within the water industry, engineering field, finance industry, a governmental agency, and/or another related industry.
  • Previous experience with Tableau, Power BI, or a similar data analytics software program.
  • Previous experience with SQL Server Reporting Services, or a similar software, building reports.
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 financial systems, word processing, database querying, and spreadsheets.
  • 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 programs such as Word, Excel, and Access.
  • Skills in use of internet, email, word processing, spreadsheet, 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 skills 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.
  • 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 drivers 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.
Please see complete job description at http://www.twdb.texas.gov/jobs/index.asp