Data Analyst IV

TX-HHSC-DSHS-DFPS•Austin, TX

2d•$5,425 - $7,156•Hybrid

About The Position

Under the supervision of the Performance Monitoring and Analytics Manager, the Data Analyst IV performs complex (journey-level) data collection and research, reporting, and analysis to monitor, evaluate, and increase efficiencies for Foster Care Litigation (FCL) activities and initiatives for Child Care Licensing (CCL), within the Health and Human Services Commission (HHSC). The Data Analyst works with the program areas to explore different aspects of a system (people, policy, and processes) to determine why particular areas are performing well or have opportunities for improvement. The position acts as a liaison between RSDA and stakeholders. The Data Analyst crafts concise, comprehensive technical and non-technical reports to present and interpret data, identify alternatives, to make recommendations for process improvement, and to develop solutions to monitor and implement data quality. The Data Analyst will provide guidance to colleagues and is a contributor in a complex and crucial data analytic environment. This position works under general supervision and has moderate latitude for use of initiative and independent judgment.

Requirements

Knowledge of data analysis techniques and best practices.
Knowledge of, or strong aptitude to learn, CCL and Foster Care Litigation data.
Knowledge of data quality and integrity processes.
Knowledge of the principles, practices and techniques of database and application design, development and structure.
Knowledge of record keeping, including security procedures for handling, protecting, and distributing confidential data.
Knowledge of and experience with reporting and visualization tools.
Skill in complex analytic work, identifying trends, concerns, recommending opportunities for improvement as well as areas of excellence.
Skill in using SAS and other query languages.
Skill in using Extract, Transform and Load tools.
Skill in communicating to both technical and non-technical audiences.
Ability to work on a team, and to be flexible and creative with data demands.
Ability to plan, organize and conduct data analytic projects.
Ability to develop and interpret data charts, maps, and tables.
Ability to interpret and publish data analytic findings.
Ability to exercise independent judgment and show initiative.
Ability to maintain detailed and organized documentation of data analytic projects.
Ability to prepare concise reports.
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 in data analysis, compilation, and/or reporting work.

Nice To Haves

Experience with Oracle, SQL Developer, Toad, or other database development tools preferred but not required.

Responsibilities

Work involves conducting detailed analysis of data sets, including monitoring and ensuring data quality, to be used as input for performance dashboards and reports.
Compiles, queries, and loads data points using SQL and other query languages, into databases, from a variety of source formats, to support complex analyses.
Cleans and prepares data, as necessary, to produce data required for data visualization software products and develops dashboards as a result.
Assists in the development and implementation of effective analytic techniques and review methodologies for evaluating and monitoring activities and initiatives related to CCL Foster Care Litigation.
Prepares comprehensive standard and ad-hoc reports, including court-ordered reports and other reports for internal and external audiences.
Extracts multiple report products.
Develops report mock-ups and drafts for discussion and approval.
Ensures accuracy of data included in reports.
Utilizes strong communication skills to explain CCL business processes and to negotiate for information and resources needed to ensure successful Foster Care Litigation initiatives.
Act as a liaison to other areas to ensure resources are aligned with CCL Foster Care Litigation and DAP department priorities and data analytic needs.
Coordinates with Program subject matter experts to ensure accuracy of reporting tools, workflows, and reporting procedures.
Establishes and updates data quality metrics, recommending and implementing improvements to data quality associated with processes.
Ensures data integrity by identifying data gaps, errors, anomalies, inconsistencies, and redundancies in the content, structure, and relationships within data; coordinates with stakeholders to improve data quality.
Provides suggestions regarding systematic changes that will improve the collection of data and align data infrastructure with business needs.
Provides routine updates on the status of projects and initiatives.
Consults and provides requirements for the development and implementation of databases, data collection systems, data analytics and other strategies to optimize statistical efficiency and quality.
Assists in the evaluation of RSDA analytic activities to ensure Program reporting requirements are met.