Data Analyst IV

Job/Position DescriptionPerforms 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 Functions40% 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.Registrations, Licensure Requirements or CertificationsN/AKnowledge Skills AbilitiesKnowledge 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 https://jobshrportal.hhsc.state.tx.us/ENG/CareerPortal/job_profile.cfm?szOrderID=608354 Copy the URL in the preceding sentence to an Internet Explorer browser to apply to the job directly through the Texas Health and Human Services Career Portal.