Texas Health and Human Services Commission
Data Analyst IV
Texas Health and Human Services Commission, Austin, Texas, us, 78716
Join the Texas Health and Human Services Commission (HHSC) and be part of a team committed to creating a positive impact in the lives of fellow Texans. At HHSC, your contributions matter, and we support you at each stage of your life and work journey. Our comprehensive benefits package includes 100% paid employee health insurance for full-time eligible employees, a defined benefit pension plan, generous time off benefits, numerous opportunities for career advancement and more. Explore more details on the Benefits of Working at HHS webpage.
Functional Title:
Data Analyst IV
Job Title:
Data Analyst IV
Agency:
Health & Human Services Comm
Department:
Medicaid/CHIP Data Analytics
Posting Number:
1602 Closing Date:
01/12/2025 Posting Audience:
Internal and External Occupational Category:
Computer and Mathematical Salary Group:
TEXAS-B-24 Salary Range:
$5,425.33 - $7,155.75 Shift:
Day
Additional Shift:
Telework:
Full-Time
Travel:
Up to 5%
Regular/Temporary:
Regular
Full Time/Part Time:
Full time
FLSA Exempt/Non-Exempt:
Exempt
Facility Location:
Job Location City:
AUSTIN
Job Location Address:
4601 W GUADALUPE ST
Other Locations:
MOS Codes:
0231,0239,0271,0291,2652,2659,6046,6049,8051,8825,8846,8848,8850,14N,14NX,15AX,16KX,181X,182X,183X
1N0X1,1N1X1,1N4X1,1N7X1,255A,25B,26B,2R0X1,350F,350G,351L,351M,352N,35F,35G,35L,35M,3D0X1,3D0X2
3D0X4,5I0,65FX,65WX,681X,682X,683X,781X,782X,783X,86P0,8K000,CT,CTN,CTT,CYB10,CYB11,CYB12,CYB13
CYB14,IS,ISM,ISS,IT,ITS,SEI15
Brief Job Description:
The Data Analyst IV is selected by and reports to the Manager of the Medicaid CHIP Data Analytics (MCDA) Performance, Monitoring, and Analytics (PMA) Team within the Office of Data, Analytics, and Performance (DAP). The position provides key research and analytical and reporting functions for the MCDA PMA Team to support the identification of anomalies relating to clients, providers, service utilization, payment methodologies, and compliance with Medicaid/CHIP contract requirements. The position performs highly advanced Medicaid/CHIP program research activities under minimal direction with extensive latitude for the use of initiative and independent judgment. The position plans and/or conducts highly advanced program evaluation on the agency's Medicaid/CHIP programs; coordinates project design, planning, statistical analysis, visualizations, and/or reporting; and writes advanced scripts and code for computer-based statistics applications. The position provides consultation and assistance to MCDA, DAP, and Medicaid/CHIP staff in developing methods and strategies for more effective reporting of Medicaid related data and analyses, including developing and monitoring performance measures and applying statistical sampling methods. The position also prepares a variety of reports, studies, data sets, or other deliverables containing analyses of Medicaid services data, methods, procedures, and relevant sources to the administration and understanding of Medicaid/CHIP program and issues.
Essential Job Functions (EJFs):
EJF (30%) 1. Designs, develops, and maintains MCDA reports and responds to ad hoc requests using tools and Medicaid CHIP data to monitor the administration of Medicaid and CHIP services. Prepares and reviews a variety of written, oral, and graphical deliverables containing analysis of Medicaid/CHIP data, methods, procedures, and relevant sources to the Medicaid/CHIP administration and policy analysis to provide data analytics, data trends, and improve the Division's contract management.
EJF (30%) 2. Compiles, queries, and loads data using SQL and other query languages, into databases from a variety of source formats. Writes advanced scripts for statistical applications and applies statistical sampling methods. Provides data integrity by identifying data gaps, errors, anomalies, inconsistencies, and redundancies in the content, structure, and relationships within data; cleans and prepares data, as necessary.
EJF (20%) 3. Consults with data analysts, program staff, and executives to understand the business requirements that drive the analysis and design of the routine and ad hoc reporting solutions. Coordinates project design and planning for projects. Collaborates with data analysts, program staff, and executives to analyze and interpret data patterns, analyze data trends and anomalies, understand correlations between data sets, gauge progress toward targets, review contract compliance and performance measures, provide recommendations for key research findings, and conduct program evaluation using Medicaid CHIP data.
EJF (10%) 4. Actively contributes to the continuous improvement of department processes through ongoing initiatives, including: solutions to automate, building efficiencies, monitoring and maintaining consistency across multiple reports. Trains others and serves as subject matter expert on data integrity processes, interpreting visual data, new techniques in data processing and analytics, and best practices; provides support for analytical questions, requests, and issues.
EJF (10%) 5. Assists with preparing and conducting presentations of MCDA dashboards and reports. Drives the selection of analytical tools, the development of standards, usage guidelines, and procedures for those tools; and assist with analytical tool system administration monitoring and upgrades.
Knowledge, Skills, And Abilities Required (KSAs):
Knowledge of local, state, and federal laws and regulations.
Knowledge of programs and services provided by HHS agencies. Knowledge of patient level health and demographic data (e.g., Census, Vital, Medicaid, and CHIP data).
Knowledge of data systems and applications used by HHS agencies.
Knowledge of data analysis techniques. Knowledge of scientific research methods, statistical techniques, mathematics, geographical concepts and their application to data analytics.
Skill in using SAS, SPSS, SQL, ACCESS, Business Objects or other statistical and database management software.
Knowledge of database design, querying and reporting tools.
Skill in interpreting and explaining visual data.
Skill in communicating with all levels of staff with varying degrees of technical knowledge.
Ability to establish and maintain effective working relationships with all levels of staff.
Ability to prepare concise reports.
Ability to plan, organize, and conduct data analytic projects.
Ability to work in a team and to communicate effectively.
Ability to develop and interpret statistical 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 communicate effectively and professionally both orally and in writing.
Ability to provide excellent customer service and demonstrate diplomacy in dealings with others.
Licensure, Certification, or Registration Required:
N/A
Initial Screening Criteria:
Bachelor's degree, equivalent, or higher degree in epidemiology, statistics, public health, data science, social or natural sciences, or other discipline which requires data management and analysis skills.
At least two years full time or equivalent experience with acquisition, collection, management, analysis, and presentation of large data sets.
Additional full time or equivalent work experience as described above may substitute for education on a year by year basis.
Up to one year of full time or equivalent work experience as a subject matter expert in Texas Medicaid or CHIP eligibility, enrollment, benefits, programs, or policy may substitute for data experience.
Preferred but not required: More than the minimum education or work experience in one of the above fields, certification in data analysis tools including but not limited to SAS, SQL, or Tableau, or experience with health or human service data.
Additional Information:
Incomplete applications will not be considered, even if a resume is included.
Duties and Responsibilities section for each job must include specific examples of projects that demonstrate experience in the above-referenced knowledge and skills. Do not copy and paste from a job description.
Jobs with missing hours per week, start date, or end date will not be counted towards the minimum required experience in this posting. Degrees that are missing school name, degree type, and major field(s) of study will not be counted toward the educational requirement.
This position is eligible for telework within Texas. Telework eligibility depends on job performance, agency business needs, and policy.
Outside employment and long-term volunteer work are subject to review for potential conflict of interest.
Review our Tips for Success when applying for jobs at DFPS, DSHS and HHSC.
Active Duty, Military, Reservists, Guardsmen, and Veterans :
Military occupation(s) that relate to the initial selection criteria and registration or licensure requirements for this position may include, but not limited to those listed in this posting. All active-duty military, reservists, guardsmen, and veterans are encouraged to apply if qualified to fill this position. For more information please see the Texas State Auditor's Job Descriptions, Military Crosswalk and Military Crosswalk Guide at Texas State Auditor's Office - Job Descriptions.
ADA Accommodations:
In compliance with the Americans with Disabilities Act (ADA), HHSC and DSHS 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.
Pre-Employment Checks and Work Eligibility:
Depending on the program area and position requirements, applicants selected for hire may be required to pass background and other due diligence checks.
HHSC uses E-Verify. You must bring your I-9 documentation with you on your first day of work. Download the I-9 Form
Functional Title:
Data Analyst IV
Job Title:
Data Analyst IV
Agency:
Health & Human Services Comm
Department:
Medicaid/CHIP Data Analytics
Posting Number:
1602 Closing Date:
01/12/2025 Posting Audience:
Internal and External Occupational Category:
Computer and Mathematical Salary Group:
TEXAS-B-24 Salary Range:
$5,425.33 - $7,155.75 Shift:
Day
Additional Shift:
Telework:
Full-Time
Travel:
Up to 5%
Regular/Temporary:
Regular
Full Time/Part Time:
Full time
FLSA Exempt/Non-Exempt:
Exempt
Facility Location:
Job Location City:
AUSTIN
Job Location Address:
4601 W GUADALUPE ST
Other Locations:
MOS Codes:
0231,0239,0271,0291,2652,2659,6046,6049,8051,8825,8846,8848,8850,14N,14NX,15AX,16KX,181X,182X,183X
1N0X1,1N1X1,1N4X1,1N7X1,255A,25B,26B,2R0X1,350F,350G,351L,351M,352N,35F,35G,35L,35M,3D0X1,3D0X2
3D0X4,5I0,65FX,65WX,681X,682X,683X,781X,782X,783X,86P0,8K000,CT,CTN,CTT,CYB10,CYB11,CYB12,CYB13
CYB14,IS,ISM,ISS,IT,ITS,SEI15
Brief Job Description:
The Data Analyst IV is selected by and reports to the Manager of the Medicaid CHIP Data Analytics (MCDA) Performance, Monitoring, and Analytics (PMA) Team within the Office of Data, Analytics, and Performance (DAP). The position provides key research and analytical and reporting functions for the MCDA PMA Team to support the identification of anomalies relating to clients, providers, service utilization, payment methodologies, and compliance with Medicaid/CHIP contract requirements. The position performs highly advanced Medicaid/CHIP program research activities under minimal direction with extensive latitude for the use of initiative and independent judgment. The position plans and/or conducts highly advanced program evaluation on the agency's Medicaid/CHIP programs; coordinates project design, planning, statistical analysis, visualizations, and/or reporting; and writes advanced scripts and code for computer-based statistics applications. The position provides consultation and assistance to MCDA, DAP, and Medicaid/CHIP staff in developing methods and strategies for more effective reporting of Medicaid related data and analyses, including developing and monitoring performance measures and applying statistical sampling methods. The position also prepares a variety of reports, studies, data sets, or other deliverables containing analyses of Medicaid services data, methods, procedures, and relevant sources to the administration and understanding of Medicaid/CHIP program and issues.
Essential Job Functions (EJFs):
EJF (30%) 1. Designs, develops, and maintains MCDA reports and responds to ad hoc requests using tools and Medicaid CHIP data to monitor the administration of Medicaid and CHIP services. Prepares and reviews a variety of written, oral, and graphical deliverables containing analysis of Medicaid/CHIP data, methods, procedures, and relevant sources to the Medicaid/CHIP administration and policy analysis to provide data analytics, data trends, and improve the Division's contract management.
EJF (30%) 2. Compiles, queries, and loads data using SQL and other query languages, into databases from a variety of source formats. Writes advanced scripts for statistical applications and applies statistical sampling methods. Provides data integrity by identifying data gaps, errors, anomalies, inconsistencies, and redundancies in the content, structure, and relationships within data; cleans and prepares data, as necessary.
EJF (20%) 3. Consults with data analysts, program staff, and executives to understand the business requirements that drive the analysis and design of the routine and ad hoc reporting solutions. Coordinates project design and planning for projects. Collaborates with data analysts, program staff, and executives to analyze and interpret data patterns, analyze data trends and anomalies, understand correlations between data sets, gauge progress toward targets, review contract compliance and performance measures, provide recommendations for key research findings, and conduct program evaluation using Medicaid CHIP data.
EJF (10%) 4. Actively contributes to the continuous improvement of department processes through ongoing initiatives, including: solutions to automate, building efficiencies, monitoring and maintaining consistency across multiple reports. Trains others and serves as subject matter expert on data integrity processes, interpreting visual data, new techniques in data processing and analytics, and best practices; provides support for analytical questions, requests, and issues.
EJF (10%) 5. Assists with preparing and conducting presentations of MCDA dashboards and reports. Drives the selection of analytical tools, the development of standards, usage guidelines, and procedures for those tools; and assist with analytical tool system administration monitoring and upgrades.
Knowledge, Skills, And Abilities Required (KSAs):
Knowledge of local, state, and federal laws and regulations.
Knowledge of programs and services provided by HHS agencies. Knowledge of patient level health and demographic data (e.g., Census, Vital, Medicaid, and CHIP data).
Knowledge of data systems and applications used by HHS agencies.
Knowledge of data analysis techniques. Knowledge of scientific research methods, statistical techniques, mathematics, geographical concepts and their application to data analytics.
Skill in using SAS, SPSS, SQL, ACCESS, Business Objects or other statistical and database management software.
Knowledge of database design, querying and reporting tools.
Skill in interpreting and explaining visual data.
Skill in communicating with all levels of staff with varying degrees of technical knowledge.
Ability to establish and maintain effective working relationships with all levels of staff.
Ability to prepare concise reports.
Ability to plan, organize, and conduct data analytic projects.
Ability to work in a team and to communicate effectively.
Ability to develop and interpret statistical 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 communicate effectively and professionally both orally and in writing.
Ability to provide excellent customer service and demonstrate diplomacy in dealings with others.
Licensure, Certification, or Registration Required:
N/A
Initial Screening Criteria:
Bachelor's degree, equivalent, or higher degree in epidemiology, statistics, public health, data science, social or natural sciences, or other discipline which requires data management and analysis skills.
At least two years full time or equivalent experience with acquisition, collection, management, analysis, and presentation of large data sets.
Additional full time or equivalent work experience as described above may substitute for education on a year by year basis.
Up to one year of full time or equivalent work experience as a subject matter expert in Texas Medicaid or CHIP eligibility, enrollment, benefits, programs, or policy may substitute for data experience.
Preferred but not required: More than the minimum education or work experience in one of the above fields, certification in data analysis tools including but not limited to SAS, SQL, or Tableau, or experience with health or human service data.
Additional Information:
Incomplete applications will not be considered, even if a resume is included.
Duties and Responsibilities section for each job must include specific examples of projects that demonstrate experience in the above-referenced knowledge and skills. Do not copy and paste from a job description.
Jobs with missing hours per week, start date, or end date will not be counted towards the minimum required experience in this posting. Degrees that are missing school name, degree type, and major field(s) of study will not be counted toward the educational requirement.
This position is eligible for telework within Texas. Telework eligibility depends on job performance, agency business needs, and policy.
Outside employment and long-term volunteer work are subject to review for potential conflict of interest.
Review our Tips for Success when applying for jobs at DFPS, DSHS and HHSC.
Active Duty, Military, Reservists, Guardsmen, and Veterans :
Military occupation(s) that relate to the initial selection criteria and registration or licensure requirements for this position may include, but not limited to those listed in this posting. All active-duty military, reservists, guardsmen, and veterans are encouraged to apply if qualified to fill this position. For more information please see the Texas State Auditor's Job Descriptions, Military Crosswalk and Military Crosswalk Guide at Texas State Auditor's Office - Job Descriptions.
ADA Accommodations:
In compliance with the Americans with Disabilities Act (ADA), HHSC and DSHS 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.
Pre-Employment Checks and Work Eligibility:
Depending on the program area and position requirements, applicants selected for hire may be required to pass background and other due diligence checks.
HHSC uses E-Verify. You must bring your I-9 documentation with you on your first day of work. Download the I-9 Form