TWDB - 26-94: Sr. Data Analyst (Data Analyst III) at Texas Water Development Board (TWDB) | Texas | Rezi

TWDB - 26-94: Sr. Data Analyst (Data Analyst III) at Texas Water Development Board (TWDB)

TWDB - 26-94: Sr. Data Analyst (Data Analyst III)

Texas Water Development Board (TWDB) · Texas

1 weeks ago

TWDB - 26-94: Sr. Data Analyst (Data Analyst III)

Texas Water Development Board (TWDB) · Texas

12 days ago
Resume preview

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

Performs moderately complex (journey-level) data analysis and data research work. 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. Oversees and 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. 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.

Responsibilities

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

Requirements

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

Skills

  • SQL-based programs
  • Data analytic software
  • SQL Server Management
  • Microsoft Power BI
  • Microsoft Power Apps
  • ArcGIS Pro
  • Snowflake
  • Python
  • SQL
  • Machine learning processes
  • Predictive analytics
  • Automation
  • SQL Server Reporting Services
  • Microsoft Office Word
  • Microsoft Office Excel
  • Microsoft Office Access
  • Internet
  • Email
  • Presentation software
  • Database software
  • Microsoft Teams
  • Microsoft Project
  • Microsoft Planner
  • Organization software applications
  • Interpersonal communications
  • Work schedules
  • Work schedules
  • Mature, objective decisions
  • Work environment changes
  • Routine and non-routine work assignments
  • Policies, procedures, and regulations
  • Prompt, courteous, and accurate assistance
  • Clear and concise communication
  • Team environment
  • Lead and prioritize work
  • Numerical details
  • Financial data
  • Multiple tasks
  • Retrieve/replace files
  • Operate a vehicle
  • Train others

Location

  • Austin, Texas

Work Type

  • In-office requirements
  • Hybrid

Experience Level

  • Journey-level
  • One (1) year of relevant work experience
  • One (1) year of experience working with water infrastructure financing programs
  • One (1) year of experience as a Data Analyst
  • One year of progressive work experience

Education Level

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

Salary/Compensations

  • USD 6344.00 - USD 6344.00 - monthly

Benefits

  • Medical
  • Dental
  • Vision
  • 401(k)
  • Flexible spending
  • Flexible work alternatives

About the Company

  • The mission of the Texas Water Development Board (TWDB) is to lead the state's efforts in ensuring a secure water future for Texas and its citizens.
  • Our mission is a vital part of Texas' overall vision and the state's mission and goals that relate to maintaining the viability of the state's natural resources, health, and economic development.
  • To accomplish our goals of planning for the state's water resources and providing affordable water and wastewater services, the TWDB provides water planning, data collection and dissemination, financial assistance, and technical assistance services to the citizens of Texas.
  • The tremendous population growth that the state continues to experience and the recurrent threat of severe drought only intensify the need for the TWDB to accomplish its goals in an effective and efficient manner.
  • Texas Water Development Board’s Mission - Leading the state’s efforts in ensuring a secure water future for Texas.

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.