TWDB - 25-44 - Data Services Analyst (Data Analyst 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 commensurate with experience and qualifications Job Description SummaryThe Texas Water Development Board is a data driven agency with highly motivated and engaged employees. Our agency’s mission is to lead the state’s efforts in ensuring a secure water future for Texas. We are currently seeking a talented Data Services Analyst to join our Data Services Department. The Data Services Analyst will deliver quality reporting and business intelligence solutions to the agency and assist client teams with drawing insights to make informed, data driven decisions. Performs complex (journey-level) data analysis and data research work. Work involves engaging in all phases of the data management lifecycle, gathering and analyzing requirements, researching, collecting, processing, storing and securing, using, sharing and communicating, archiving, reusing and repurposing data. May train others. Works under general supervision, with moderate latitude for the use of initiative and independent judgment. Reports to the Manager of the Data Services Department.Essential Job FunctionsPerforms computational analysis using Snowflake, Python, MS SQL Server and Power BI.Extracts and analyzes data from specific applications, systems and/or databases to create reports and provide recommendations based on the analysis of the data.Works directly with the user community and business analysts to define and document data requirements for data integration and business intelligence applications.Leads data and analytics solutions life cycle management from requirements elicitation, design, ETL development, testing, deployment and support.Creates data flow diagrams, processed models and integrated models across functional areas and platforms.Works with key stakeholders on implementing data APIs for data collection and delivery.Leads quality control initiatives and databases audits.Resolves data problems, and analyzes system changes for quality assurance.Demonstrates effective communication and presentation skills to diversified audiences technical to business stakeholders.Contributes to the Data Governance program.Investigates and resolves data issues across platforms and applications, including discrepancies of definition, format and function.Identifies data gaps, errors, anomalies, inconsistencies, and redundancies by analyzing the content, structure, and relationships within data.Coordinates the analysis of program policies and procedures to determine their effect on automated systems and system functional areas.Identifies opportunities for improving business processes through automation and assists in the preparation of proposals to develop new systems.Implements efficient defect management, root cause analysis, and resolution processes.Assists in setting technical direction for the team and analyzes data using standard statistical tools, methods, and techniques.Constructs stored procedures and performance optimization techniques.Assists in defining, developing, and implementing data standards.Develops systems and strategies that optimize efficiency and quality for M/L, AI algorithms.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.