Data Analyst V

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.

Brief Job Description:

Data Analyst V (DA V) position performs work for the Provider Finance Department under supervision of the Manager of Fees, Data, and Research.  The DA V serves as team lead for the Acute Care Data and Research team. This position performs highly complex (senior-level) data collection, reporting, and analysis to monitor, evaluate, and increase efficiencies for Acute Care.  The DA V defines, develops, and implements data standards, data quality measures, analyzes data quality results, and implements necessary changes to ensure data quality improvement.  This position also oversees, plans, directs, monitors, and guides others in the use of key analytic functions relating to the Data and Research team within Acute Care.  The DA V works under minimal supervision, with extensive latitude for the use of initiative and independent judgment.

Essential Job Functions (EJFs):

Attends work on a regular and predictable schedule in accordance with agency leave policy and performs other duties as assigned.

Data Analysis and Visualization – Compiles, queries, and loads data points using SQL, and other query languages, into databases from a variety of source formats to support complex analyses. Cleans and prepares data, as necessary, for access to other analysts in their work products as well as data visualization.  Provides guidance and mentorship on data use and best practices to analysts throughout the department. (25% )

Data Quality – Establishes and updates data quality metrics, recommending and implementing improvements to data quality associated with processes. Ensures data integrity by identifying data gaps, errors, anomalies, inconsistencies, and redundancies in the content, structure, and relationships within data; coordinates with stakeholders to improve data quality. Interprets results to identify significant differences in data. Identifies and interprets data patterns and trends and assesses data quality. (25%)

Reporting – Oversees development of high-quality written projects and reports; guides the selection of data management tools, the development of standards, usage guidelines, and procedures for those tools to be used by the rest of the team. Defines, develops, and implements data standards. Coordinates with others who collect, organize, analyze, and prepare materials in response to requests for information and reports specific to the data. Prepares concise, comprehensive technical reports to present and interpret data; makes recommendations on revisions to data collection methodologies. Develops software applications or programming to use for financial analysis, statistical modeling, and graphic analysis. (20%)

Coordination – Utilizes strong communication skills to explain PFD and Acute Care business processes and negotiate for information and resources needed to ensure successful Program initiatives. Consults with internal and external stakeholders regarding Acute Care data needs and requests. Coordinates with Program subject matter experts to ensure accuracy of reporting tools, workflows and reporting procedures. (10%)

Process Improvement – Provides feedback regarding systematic changes to improve data collection and align data infrastructure with business needs.  Makes recommendation to improve efficiency and quality of data and reporting processes. Provides routine updates on the status of projects and initiatives. (10%)

Infrastructure Support – Oversees, plans, directs and monitors key analytic functions relating to the day-to-day activities of the Acute Care Services team.  Performs quality assurance and serve as a subject matter expert on data integrity, extraction, and compilation. (5%)

Performs other work as assigned or required to maintain and support the office and HHSC operations. (5%)

Knowledge, Skills and Abilities (KSAs):

Knowledge of:

1. Advanced Microsoft Office (Excel, Word, PowerPoint), business objects, TMHP Software, claims processing engines, SQL, R, SAS, Python.
2. Data analysis, statistics, data visualization, medical claims data, methods of funding, program rules, Medicare, and Medicaid.
3. Texas legislative process.
4. Principles of leadership and how to effectively interact with various leadership styles.
5. Data quality and integrity processes.
6. Process improvement or quality assurance systems

Skill in:

1. Managing multiple and competing priorities.
2. Identifying problems, evaluating alternatives, and implementing solutions.
3. Communication and public speaking.
4. Working collaboratively and cooperatively with diverse groups.

Ability to:

1. Interpret data and develop effective operating procedures.
2. Work with large datasets efficiently.
3. Organize and present information effectively, both orally and in writing to technical and non-technical audiences.
4. Establish goals and objectives.
5. Train and provide constructive feedback to staff.
6. Lead in an environment of change.
7. Plan, assign, and evaluate the work of others and build effective work teams.
8. Effectively motivate and provide direction to staff.
9. Establish effective working relationships with staff at all levels of an organization, agencies, providers, and stakeholders.

Registrations, Licensure Requirements or Certifications:

 N/A

Initial Screening Criteria:

Graduation from an accredited four-year college or university with a bachelor’s degree in social science; business, including accounting and statistics; mathematics; physics; economics; health-related field; political science; or other closely related field. Education and work experience can be substituted for one another on a year-for-year basis.  Experience with Medicaid and/or healthcare finance preferred.  Experience with SQL-based data querying software preferred.

Additional Information:

N/A

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

Telework Disclaimer:

This position may be eligible for telework.  Please note, all HHS positions are subject to state and agency telework policies in addition to the discretion of the direct supervisor and business needs.