Performance Data Analyst

TX-HHSC-DSHS-DFPS • Austin, TX

2d • Hybrid

About The Position

Under the direction of the Director of Performance Analysis the Performance Data Analyst performs complex (journey-level) data analysis and data research work to support the Performance Management and Analytics System (PMAS), which aims to integrate and transform HHSC program data to help monitor program performance and enhance data-driven decision-making. Work involves maintaining positive internal and external stakeholder relationships; providing consultative services and technical assistance to program staff; using SQL and other tools to develop performance measures and proof-of-concept calculations; gathering, tracking and reporting performance data; analyzing data to identify patterns and forecast performance; assessing data quality and suitability for use in analytics; and identifying gaps, errors, and inconsistencies using data analysis best practices. Works under general supervision of the Director and the Analytics Lead Team Member(s), with moderate latitude for the use of initiative and independent judgment.

Requirements

• Graduation from an accredited four-year college or university preferred. Related work experience may be substituted for educational requirement on a year-for-year basis.
• At least 2 years of experience in using SQL queries or Python to describe datasets, identify data quality issues, outliers, and other features.
• At least 2 years of experience in performing business or program performance analysis, data collection, and data analysis required.
• Knowledge of Texas Health and Human Services Commission's programs and functions, and Medicaid system in Texas.
• Knowledge of State and federal legislative processes.
• Knowledge of Project Management frameworks and Agile methodologies.
• Knowledge of Record keeping, including security procedures for handling, protecting, and distributing confidential data.
• Knowledge of Database structures and data models.
• Knowledge of Database environments (Snowflake, Oracle, Databricks).
• Knowledge of Data analysis best practices.
• Skill in Build queries and analyze data using standard statistical tools (SQL, Python, Excel), applications, platforms (especially Snowflake), methods, and techniques.
• Skill in Joining database tables, creating calculated fields, CTEs, and window functions.
• Skill in Summarizing complex technical information, evaluating alternatives, and developing creative and workable solutions.
• Skill in Identifying and defining key performance indicators and measures.
• Skill in Communicating complex information clearly for a variety of audiences (verbal and written).
• Skill in Managing personal workload, including multiple and competing priorities.
• Ability to Review and understand business and system requirements, analyze performance data, and develop statistical data charts, maps, and tables.
• Ability to Exercise sound judgment in making critical decisions and communicate effectively.
• Ability to Use data analytics tools (SQL, Python, Excel).
• Ability to Optimize data for use in visualization platforms (especially Tableau).
• Ability to Collaborate with multiple teams, work with people under pressure, resolve conflicts, and establish and maintain effective working relationships.

Responsibilities

• Provides technical assistance to programs seeking to establish targeted, high-level metrics capable of effectively measuring and communicating program performance as well as overall HHS system performance.
• Analyzes data from multiple sources to identify patterns and underlying causes to changes in data and trends.
• Performs research and develops reports, summaries, and presentation materials for a variety of audiences.
• Coordinates User Acceptance Testing (UAT), including developing test scripts, test documents, and testing of new system functionality in various test environments, and ensuring approval of the final products.
• Attends work on a regular and predictable schedule in accordance with agency leave policy and performs other duties as assigned.

Benefits

• comprehensive benefits package includes 100% paid employee health insurance for full-time eligible employees
• defined benefit pension plan
• generous time off benefits
• numerous opportunities for career advancement

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level