Health & Human Services Comm
Data Analyst
Health & Human Services Comm, Tyler, Texas, United States, 75701
Job Description:The Program Specialist VI (PS VI) serves as a Data Analyst and reports to the Operations Data Analyst Manager with the Managed Care Utilization Review (MCUR) department. The Data Analyst plays a pivotal role in overseeing the technical aspects of the MCUR Medicaid programs. This position involves monitoring and developing review tools, training staff, analyzing MCUR data, and ensuring compliance with Medicaid requirements. The Data Analyst will also act as a liaison with internal and external stakeholders and contribute to the development of reports and methodologies that enhance the effectiveness of the MCUR program.
MCUR offers flexible work arrangements, including a hybrid schedule for those in Austin, Texas, and remote work for candidates residing elsewhere in Texas. Note that candidates who qualify to work remotely will need to travel to the office as per business needs.
Essential Job Functions:Data Collection, Management, and Integration: Collect, clean, and organize data from various sources, ensuring its accuracy and integrity. Develop and maintain databases, address data quality issues, and implement solutions to resolve inconsistencies. Oversee data integration and develop ETL (Extract, Transform, Load) processes to ensure comprehensive and consistent data availability. 35%
Reporting and Visualization: Create and maintain dashboards, reports, and interactive visualizations to effectively communicate data insights to stakeholders. Ensure that reports and visualizations translate complex data into understandable, actionable information and meet business requirements. 20%
Statistical Analysis and Modeling: Perform statistical analyses to identify trends, patterns, and correlations within data sets. Develop and apply predictive models and algorithms to forecast future trends and outcomes. Use advanced analytics techniques to generate actionable insights that support strategic decision-making. 15%
Data Integrity, Security, and Cross-Departmental Support: Ensure data integrity and security by implementing best practices for data handling and protection. Monitor data access and maintain compliance with data protection regulations. Collaborate with various departments to understand their data needs, provide analytical support, and offer training on data tools and techniques. Identify opportunities for process improvement and implement data-driven solutions to enhance business operations. 15%
Sample Selection and Analysis: Assist in selecting or coordinating appropriate samples for analysis based on project objectives and requirements. Ensure that sample selection is statistically representative of the larger dataset. Analyze sample data to validate findings and provide insights that can be generalized to the entire dataset. 10%
Other Duties as Assigned: Perform additional tasks and responsibilities as assigned by management. This may include participating in special projects, assisting with organizational initiatives, or addressing emerging business needs that require data analysis expertise. 5%
Knowledge Skills Abilities:Knowledge of Data Analysis Techniques: Understanding statistical analysis processes, data models, database design, and data mining techniques.•Knowledge of Data Management Tools: Familiarity with data management software, such as SQL, Excel, Access, and data visualization tools like Tableau or Power BI.•Knowledge of Data Privacy and Security: Awareness of state and federal regulations related to data protection, including confidentiality, handling, and distribution of sensitive information.•Knowledge of Program Implementation and Evaluation: Understanding of program data management, implementation strategies, and evaluation processes.
Skills:
•Proficiency in Data Analysis Tools: Skill in using formulas and manipulating large databases in Excel, Access, or other spreadsheet software. Ability to design and develop data models and reporting functions.•Data Visualization and Reporting: Expertise in graphical and tabular presentation of data, including designing dashboards and reports using Tableau or Power BI.•Effective Communication: Strong verbal and written communication skills, including the ability to clearly explain complex data findings and methodologies to both technical and non-technical audiences.•Workflow and Data Reporting Development: Skill in designing and developing workflow and data reporting functions using SharePoint or similar tools.•Project and Time Management: Ability to manage multiple priorities, work under time constraints, and demonstrate initiative. Skill in organizing and completing research projects efficiently.•Adaptability and Continuous Learning: Demonstrated ability to adapt to new technologies, methodologies, and business requirements. Strong willingness to learn and stay updated with emerging trends and tools.•Receptiveness to feedback and coaching for ongoing professional growth
Abilities:
•Collaborative Work: Ability to work effectively with cross-departmental teams and diverse groups, communicating and collaborating to achieve common goals.•Task Prioritization: Ability to prioritize tasks, handle competing demands, and manage workload effectively.•Statistical Interpretation: Ability to develop, interpret, and present statistical data charts and tables. Proficiency in interpreting and applying research findings to support decision-making.•Research and Analysis: Capability to plan, organize, and conduct research projects. Ability to oversee and guide the research process, from planning to completion, ensuring accuracy and thoroughness in reporting.•Independent Work and Decision Making: Ability to work independently, make sound decisions, and exercise good judgement to ensure project timelines are met while maintaining high standards of accuracy.•Time Management and Attention to Detail: Capability to manage time effectively, meet deadlines, and maintain meticulous attention to detail in all aspects of data analysis and reporting.
Registration or Licensure Requirements:None.
Initial Selection Criteria:Experience in data analysis, research, compilation, and/or reporting work. 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 Associate's degree plus a minimum of two years' work experience in a related field.•Two years of experience in data analysis, including working with large data sets and statistical tools.
•Experience in data management and analysis tools such as SQL, Excel, and data visualization software (e.g., Tableau, Power BI).
•Experience with interpreting complex data and generating actionable insights.
•Experience with programming languages such as Python or R is preferred.
•Experience with Power Platform suite preferred.
•Experience with the Texas Medicaid managed care preferred.
Additional Information:
MOS Code:11Z, 18Z, 18Z, 35Z, 74D, 47A-47S, 120X, 121X, 123X, HRM13, 0377, 0577, 0691, 0911, 931
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
MCUR offers flexible work arrangements, including a hybrid schedule for those in Austin, Texas, and remote work for candidates residing elsewhere in Texas. Note that candidates who qualify to work remotely will need to travel to the office as per business needs.
Essential Job Functions:Data Collection, Management, and Integration: Collect, clean, and organize data from various sources, ensuring its accuracy and integrity. Develop and maintain databases, address data quality issues, and implement solutions to resolve inconsistencies. Oversee data integration and develop ETL (Extract, Transform, Load) processes to ensure comprehensive and consistent data availability. 35%
Reporting and Visualization: Create and maintain dashboards, reports, and interactive visualizations to effectively communicate data insights to stakeholders. Ensure that reports and visualizations translate complex data into understandable, actionable information and meet business requirements. 20%
Statistical Analysis and Modeling: Perform statistical analyses to identify trends, patterns, and correlations within data sets. Develop and apply predictive models and algorithms to forecast future trends and outcomes. Use advanced analytics techniques to generate actionable insights that support strategic decision-making. 15%
Data Integrity, Security, and Cross-Departmental Support: Ensure data integrity and security by implementing best practices for data handling and protection. Monitor data access and maintain compliance with data protection regulations. Collaborate with various departments to understand their data needs, provide analytical support, and offer training on data tools and techniques. Identify opportunities for process improvement and implement data-driven solutions to enhance business operations. 15%
Sample Selection and Analysis: Assist in selecting or coordinating appropriate samples for analysis based on project objectives and requirements. Ensure that sample selection is statistically representative of the larger dataset. Analyze sample data to validate findings and provide insights that can be generalized to the entire dataset. 10%
Other Duties as Assigned: Perform additional tasks and responsibilities as assigned by management. This may include participating in special projects, assisting with organizational initiatives, or addressing emerging business needs that require data analysis expertise. 5%
Knowledge Skills Abilities:Knowledge of Data Analysis Techniques: Understanding statistical analysis processes, data models, database design, and data mining techniques.•Knowledge of Data Management Tools: Familiarity with data management software, such as SQL, Excel, Access, and data visualization tools like Tableau or Power BI.•Knowledge of Data Privacy and Security: Awareness of state and federal regulations related to data protection, including confidentiality, handling, and distribution of sensitive information.•Knowledge of Program Implementation and Evaluation: Understanding of program data management, implementation strategies, and evaluation processes.
Skills:
•Proficiency in Data Analysis Tools: Skill in using formulas and manipulating large databases in Excel, Access, or other spreadsheet software. Ability to design and develop data models and reporting functions.•Data Visualization and Reporting: Expertise in graphical and tabular presentation of data, including designing dashboards and reports using Tableau or Power BI.•Effective Communication: Strong verbal and written communication skills, including the ability to clearly explain complex data findings and methodologies to both technical and non-technical audiences.•Workflow and Data Reporting Development: Skill in designing and developing workflow and data reporting functions using SharePoint or similar tools.•Project and Time Management: Ability to manage multiple priorities, work under time constraints, and demonstrate initiative. Skill in organizing and completing research projects efficiently.•Adaptability and Continuous Learning: Demonstrated ability to adapt to new technologies, methodologies, and business requirements. Strong willingness to learn and stay updated with emerging trends and tools.•Receptiveness to feedback and coaching for ongoing professional growth
Abilities:
•Collaborative Work: Ability to work effectively with cross-departmental teams and diverse groups, communicating and collaborating to achieve common goals.•Task Prioritization: Ability to prioritize tasks, handle competing demands, and manage workload effectively.•Statistical Interpretation: Ability to develop, interpret, and present statistical data charts and tables. Proficiency in interpreting and applying research findings to support decision-making.•Research and Analysis: Capability to plan, organize, and conduct research projects. Ability to oversee and guide the research process, from planning to completion, ensuring accuracy and thoroughness in reporting.•Independent Work and Decision Making: Ability to work independently, make sound decisions, and exercise good judgement to ensure project timelines are met while maintaining high standards of accuracy.•Time Management and Attention to Detail: Capability to manage time effectively, meet deadlines, and maintain meticulous attention to detail in all aspects of data analysis and reporting.
Registration or Licensure Requirements:None.
Initial Selection Criteria:Experience in data analysis, research, compilation, and/or reporting work. 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 Associate's degree plus a minimum of two years' work experience in a related field.•Two years of experience in data analysis, including working with large data sets and statistical tools.
•Experience in data management and analysis tools such as SQL, Excel, and data visualization software (e.g., Tableau, Power BI).
•Experience with interpreting complex data and generating actionable insights.
•Experience with programming languages such as Python or R is preferred.
•Experience with Power Platform suite preferred.
•Experience with the Texas Medicaid managed care preferred.
Additional Information:
MOS Code:11Z, 18Z, 18Z, 35Z, 74D, 47A-47S, 120X, 121X, 123X, HRM13, 0377, 0577, 0691, 0911, 931
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