About the Role
Title: Data Analyst
Location:
TYLER, TX
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
Job Title: Program Specialist VI
Agency: Health & Human Services Comm
Department: UR Management Support
Posting Number: 535
Posting Audience: Internal and External
Occupational Category: Business and Financial Operations
Salary Group: TEXAS-B-23
Salary Range: $5,098.66 – $8,304.83
Shift: Day
Additional Shift:
Telework: Part-Time
Travel: Up to 5%
Regular/Temporary: Regular
Full Time/Part Time: Full time
FLSA Exempt/Non-Exempt: Exempt
Facility Location:
Job Location City: TYLER
Job Location Address: 3150 ROBERTSON RD
Other Locations: Tyler; Austin
MOS Codes:
16GX,60C0,611X,612X,63G0,641X,712X,86M0,86P0,88A0,88B0,8U000,OS,OSS,PERS,YN,YNS
Brief 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 (EJFs):
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 and Abilities (KSAs):
Knowledge of:
- Data Analysis Techniques: Understanding statistical analysis processes, data models, database design, and data mining techniques.
- Data Management Tools: Familiarity with data management software, such as SQL, Excel, Access, and data visualization tools like Tableau or Power BI.
- Data Privacy and Security: Awareness of state and federal regulations related to data protection, including confidentiality, handling, and distribution of sensitive information.
- Program Implementation and Evaluation: Understanding of program data management, implementation strategies, and evaluation processes.
Skills in:
- 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.
Ability to:
- 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.
Registrations, Licensure Requirements or Certifications:
N/A
Initial Screening 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.