Data Analyst V

Texas Health & Human Services Commission•Austin, TX

8d•$6,378 - $10,786•Hybrid

About The Position

The Data Analyst V works in Regulatory Specialty Data and Analytics (RSDA), a division within the Office of Data, Analytics, and Performance. RSDA provides analysis, data visualization, and reporting to support HHSC agencies’ operational and decision-making needs, as well as data for public information requests, audits, grants, studies, and data-sharing projects. The unit conducts quality assurance reviews of data released outside the agency and develops online data mart reports and supporting tables and elements. Under the supervision of the RSDA PMA Manager, this senior-level analyst performs complex data collection, research, reporting, and analysis to monitor, evaluate, and improve PMA efficiency. The role gathers and analyzes requirements; designs, implements, and maintains reports and processes; develops back-end tables, reporting logic, and program code; and reviews and validates work products. The analyst collaborates with RSDA and other HHSC staff, program staff, division managers, other analysts, and, as needed, other agencies and outside entities. The position may prepare diagrams and logic flowcharts, participate in system design meetings, and work under limited supervision with moderate latitude for initiative and independent judgment. The role oversees data infrastructure and security, data quality and integrity, reporting standards, and technical improvements. It produces concise technical reports with findings, alternatives, recommendations, and solutions for monitoring and improving data quality. It also guides data management tool selection and develops software or programming for statistical modeling, data analysis, and graphic analysis. The position is based in Austin, is eligible for telework, and may be eligible for a hybrid schedule, subject to agency policy, supervisor discretion, and business needs.

Requirements

Graduation from an accredited four-year college or university with major coursework in data science, business analytics, computer science, computer information systems, management information systems, accounting, finance, mathematics, statistics, economics, or a related field; experience and education may substitute for one another, up to four years.
Experience in data analysis, compilation, and/or reporting work.
Experience with Oracle, SQL Developer, Toad, or other database development tools.
Knowledge of statistics, data-set analysis, queries, report writing, presenting findings, and record keeping, including procedures for confidential data.
Understanding of and demonstrated skill in relational databases and data processing practices and theory.
Skill in researching and troubleshooting data issues, solving complex problems, report development and automation, and complex analysis, including identifying trends and recommending improvements.
Skill using software such as SQL, SQLPlus, PL/SQL, Tableau, Excel, TOAD, Oracle, SQL Developer, business intelligence tools, Python, R, and/or SAS.
Ability to work hours as needed to meet deadlines and support mission-critical reporting requirements.
Ability to communicate clearly and effectively in writing and verbally, and present information to varied audiences.
Ability to exercise independent judgment and initiative.
Ability to analyze, consolidate, and interpret complex data, procedures, and systems, and write or revise program code as required.
Comprehension of data solutions, reporting methodologies, mathematics, and statistical report design.
Ability to creatively solve complex data problems, apply new technology, produce accurate detailed work under stressful conditions, and manage multiple projects and tight deadlines.

Nice To Haves

Experience with data and applications related to the development of CCR/PI program reports and visualizations is preferred.
Knowledge of, or strong aptitude to learn, CCL and FCL data.

Responsibilities

Oversee development and implementation of databases, data collection systems, and other strategies to improve statistical efficiency and quality.
Compile, query, and load data using SQL and other query languages to support complex analyses.
Maintain security protocols for confidential data, including access, handling, protection, and distribution.
Oversee RSDA technical activities to meet Foster Care Litigation reporting requirements.
Monitor data quality and load data from varied sources; format and automate data feeds for ongoing and ad hoc reports, dashboards, and other products.
Develop scripts or code to extract, compile, and present data or models using programming languages such as SQL.
Clean and prepare data for Tableau and other visualization software; extract data from multiple sources and verify report accuracy.
Establish and update data quality metrics; identify data gaps, errors, anomalies, inconsistencies, and redundancies; recommend and implement process improvements.
Recommend systematic changes to improve data collection and align data infrastructure with business needs, and provide routine project updates.
Explain data processes and management, determine assignment scope and timelines, help develop technical initiative cost estimates and budgets, and coordinate with program subject matter experts to ensure reporting accuracy and improve data quality.
Provide technical guidance to other areas and mentor team members.
Produce concise technical reports presenting findings, alternatives, process-improvement recommendations, and solutions for monitoring and implementing data quality.
Guide selection of data management tools and develop standards, usage guidelines, procedures, and data and reporting standards.
Develop data quality measures, analyze results, and implement changes to improve quality.
Develop software applications or programming for statistical modeling, data analysis, and graphic analysis.
Gather and analyze reporting requirements; design, implement, and maintain reports and processes; develop and modify programming logic and supporting back-end tables.
Review and validate analysts’ work products and collaborate with agency staff and outside entities as needed.
Participate in system design meetings to ensure new initiatives can report applicable data.