Data Analyst IV

Role Description The Texas Health and Human Services Commission (HHSC) seeks highly qualified candidates to fill the Data Analyst IV position within the Access & Eligibility Services (AES) Department Eligibility Operations Integrity Support Services (ISS). The Data Analyst IV serves as lead subject matter expert on data integrity, extraction, and compilation of data for both internal and external customers/stakeholders. This includes consulting with customers to identify user needs. Performs complex (journey-level) detailed data analysis and data research. Responsible for data quality assurance including implementing and updating databases, data collection systems, data analytics, and other strategies to ensure statistical efficacy. Analyzes content, structure, and relationships within data to identify and interpret patterns and trends. Identifies gaps, errors, anomalies, and redundancies to make justifiable recommendations for data revisions. Prepares concise and comprehensive data reports for HHS stakeholders and leadership. While leveraging statistical techniques, develops proof of concept mockups to ensure data quality; converts raw data into database table structures from a variety of source formats. Interprets business requirements for performance measure visualizations and reports for large and complex agency programs. Assists in developing software applications and/or programming to track ISS statistical data. Mentors internal staff and may train others. Works under general supervision, with moderate latitude for the use of initiative and independent judgment. Qualifications Graduation from an accredited four-year college or university with major course work in computer science or a related field is preferred. Relevant experience in data analytics, data cleaning, statistical analysis, and computer programming may be substituted for education on a year-to-year basis. Excellent written communications as observed by detail and completeness of information provided on the state application. Experience making presentations to small and large groups preferred. Experience developing policies and procedures preferred. Experience supervising eligibility staff and/or investigators preferred. Experience in data review and analysis required. Experience with Special Query Language (SQL) required. Experience developing interactive dashboards or reports using data visualization tools (e.g., Power BI, Tableau, or equivalent) required. Experience connecting data visualization tools to SQL or tabular data sources required. Experience writing Python scripts for data extraction, transformation, or automation required. Experience using Python libraries for data analysis required. Experience in leading and mentoring staff preferred. Current experience in SNAP, Medicaid policy and procedures are preferred. Current experience in TANF program preferred. Training or experience in project management practices and the project life cycle preferred. Experience performing multiple tasks with conflicting deadlines in a timely manner required. Application indicates the willingness to work beyond normal work hours of 8AM-5PM Monday through Friday as needed/required. Experience using computer software such as Microsoft Word, Excel, and Outlook required. Application indicates the willingness to travel 10% of the time required. Requirements Knowledge of relational databases and database design. Knowledge of scientific research methods, statistical techniques, mathematics, geographical concepts and their application to data analytics. Knowledge preferred of local, state and federal laws and regulations relevant to program areas. Comprehension of fraud prevention and fraud detection for SNAP, TANF, CHIP and Medicaid Programs preferred. Knowledge of computer programming principles, spreadsheet macros, and database design. Skill preferred in data visualization development, including data model creation, advanced calculations, and interactive visualizations. Skill in performing queries, extracting and joining data, and loading data using SQL and/or other query languages. Skill in working with streaming data and unstructured data from multiple data sources. Skill in creating graphical user interfaces, mockups, prototypes, and design documents. Skill in critical thinking and problem solving. Skill in optimizing the user experience. Skill preferred in using visualization preparation software. Skill preferred in using 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 implement and use new technology and work processes to enhance decision-making. Ability to build, establish, and maintain effective working relationships and coalitions. Ability to plan, organize, and conduct data analytic projects. Ability to develop and interpret statistical data charts, maps, and tables. Benefits 100% paid employee health insurance for full-time eligible employees. A defined benefit pension plan. Generous time off benefits. Numerous opportunities for career advancement.