Data Analyst IV

Performs highly complex (journey-level) data analysis, data research work, data transformation, and development of reporting tools within the Performance Management Analytics System (PMAS) project, which aims to integrate new and existing HHSC program data to enhance and inform decision-making. The position reports to the Director of the Performance Visualization Team, a team responsible for leveraging these data to build visualization for performance monitoring and reporting purposes. The data analyst will become an essential member of the PMAS sprint team, collaborating with other Office of Data, Analytics, and Performance (DAP) teams, as well as PMAS IT teams. Responsibilities include planning, developing, implementing, and advancing the transformation of data into actionable information to help strengthen the programs that support the citizens of Texas. The data analyst works under limited supervision, with moderate latitude for the use of initiative and independent judgment. Essential Job Functions:

40% Data Analysis: Work involves conducting detailed analysis of data, including applying statistical techniques; developing proof of concept mockups to ensure data quality; and converting raw data into database table structures from a variety of source formats. Compiles and manipulates data points using SQL, Python, or other languages from a variety of source formats, to support complex analyses of program area data sets, such as Medicaid and CHIP. Cleans and prepares data to produce datasets required for data visualization software products.

30% Data Quality/Integrity: Provides suggestions regarding systematic changes that will improve the efficiency and quality of data analysis processes. Assesses data quality by identifying any missing, erroneous, incongruent, or duplicate data in data sets used by the unit. Coordinates with other internal groups within DAP or other areas to improve data quality. Consults and provides requirements for the improvement of data collection systems and the methods used to perform data analytics. Recommend the selection of data management tools. Define, develop, and implement data and reporting standards.

20% Visualization: Determines the most effective method to address a given data request, construct performance measures, or implement visualizations to monitor various service trends. Interprets business requirements to be used as input to performance measure visualizations and reports for large and complex agency programs.

10% Customer Focus and Communication: The analyst engages with a variety of stakeholders across the agency to build strong relationships and to find creative solutions to analytic projects. Utilizes communication skills to gather the information necessary from customers to assess and address their needs. Explains tool development in clear and non-scientific language as necessary to ensure that customers can leverage the information in decision-making. Coordinates with program subject matter experts and leadership to ensure accuracy in the final products. Knowledge Skills Abilities:

Knowledge of data visualization development, including data model creation, advanced calculations, and interactive visualizations.

Knowledge of relational databases and database design.

Knowledge of custom SQL Table/View creation with multi-level join conditions.

Knowledge in writing queries to extract data, joining data, and loading data using SQL/PSQL.

Knowledge of Cloud usage for visualization development.

Knowledge of performance management and continuous quality improvement processes.

Knowledge of Agile Scrum Methodology.

Knowledge of Tableau AI tools.

Knowledge of Tableau or other visualization software.

Knowledge of statistics and analyzing data sets; running queries, report writing, and presenting findings; and record keeping, including security procedures for handling, protecting, and distributing confidential data.

Skill in creating graphical user interfaces, mockups, prototypes, and design documents.

Skill in critical thinking and problem-solving.

Skill preferred in using SAS, SPSS, Python or other statistical software.

Skill in using EXCEL or other spreadsheet software.

Skill in graphical, tabular and geographical presentation of data.

Ability to translate complex data into user-friendly information.

Ability to identify problems, evaluate alternatives, and implement effective solutions.

Ability to build, establish, and maintain effective working relationships and coalitions.

Ability to plan, organize, and conduct data analytic projects and prepare reports.

Ability to develop and interpret statistical data charts, maps, and tables. Registration or Licensure Requirements:

N/A Initial Selection Criteria:

Four-year college degree in Computer Information Systems, Computer Science, Social Science, or related degree required.

Master's degree or higher preferred.

Five years or more work and experience with data acquisition, data collection, management, analyses, and visualization of health and human services-related data and/or large datasets preferred.

Additional Information:

Attends work on a regular and predictable schedule in accordance with agency leave policy and performs other duties as assigned. Mentors internal staff, trains and assists others. Any applicants within the state may be considered for employment working remotely. Criminal Background Check and/or Finger Print Check may be requested. MOS Code:

N/A

HHS agencies use E-Verify. You must bring your I-9 documentation with you on your first day of work.

I-9 Form - Click here to download the I-9 form.

In compliance with the Americans with Disabilities Act (ADA), HHS agencies will provide reasonable accommodation during the hiring and selection process for qualified individuals with a disability. If you need assistance completing the on-line application, contact the HHS Employee Service Center at 1-888-894-4747. If you are contacted for an interview and need accommodation to participate in the interview process, please notify the person scheduling the interview.

Top 10 Tips for Success when Applying to Jobs at HHSC and DSHS