Data Analyst II

Job Description : Data Analyst II

Data Analyst II

Come work in an environment where we truly value and respect those we serve and believe in the mission that all people can achieve a higher level of wellness and independence.

The state supported living centers serve people with intellectual and developmental disabilities who are medically fragile or who have behavioral problems.

The centers provide campus-based direct services and supports at 13 centers located throughout the state.

The state of Texas offers many benefits to employees. HHSC is a qualifying organization for the Federal Public Service Loan Forgiveness Program, which forgives the remaining balance on college student Direct Loans after making qualifying monthly payments.

We also offer excellent health benefits, a lifetime monthly retirement annuityas well as (k) and Programs under the Employees Retirement System of Texas.

If you are looking for a place to work where you can establish a career that is filled with purpose, this is the job for you!

The Quality Improvement Data Analyst performs routine to moderately complex data analysis work which supports a planned and systematic approach to monitoring, analyzing, and continually improving the quality of care and services provided to individuals served at the SSLC.

Develops and maintains databases and reports using software tools including but not limited to MS Access, MS Excel, and SQL.

Ensures the integrity, security and accessibility of the SSLC’s databases, data, and reports. Develops, and / or assists in the development, maintenance and presentation of management tools and department trend reports for quality assurance and improvement initiatives.

Develops and implements database procedures to collect and track data pertinent to SSLC quality assurance and improvement.

Uses relational database management systems, including the development of queries, and report development software to gather, review, and analyze data or assist others in doing so.

Conducts complex and detailed analysis of and extensive research on data and reporting results. Monitors data and identifies potential trends within reports that will be addressed by specific program staff.

Ensures program staff can easily use the data pulled from the databases. Responds to ad hoc data requests. Serves as a SSLC liaison with state office data analysts.

Collaborates effectively with others including members of the Quality Assurance / Quality Improvement (QA / QI) Council to ensure opportunities for collection and analysis of data are maximized.

The position works under general supervision with limited latitude for the use of initiative and independent judgment in work activities.

Essential Job Functions :

Attends work on a regular basis and may be required to work a specific shift schedule or, at times, even a rotating schedule, extended shift and / or overtime in accordance with agency leave policy and performs other duties as assigned.

May serve in an on-call status on a rotating schedule as required to meet operational needs of the facility.

Develops and maintains databases and reports using software tools including but not limited to MS Access, MS Excel, and SQL Maintains a relational database system and spreadsheets to track and trend quality of care data.

Designs and maintains administrative reports using data from an electronic health record and internal monitoring tools and databases.

Creates and updates reports from data entered into the electronic health record.

Executes the procedures necessary to save, retrieve, and recover databases from hardware and software failures. Works within the backend of software applications to review queries and resolve operational problems.

Develops and implements database procedures to collect and track data with sufficient particularity to identify trends, among, within and / or regarding program areas, living units, work shifts, protections / supports / services, areas of care, staff members and / or individuals receiving services and supports.

Ensures the integrity, security and accessibility of the SSLC’s databases, data and reports. Develops and implements tools to track the accuracy and integrity of data reporting.

Establishes processes for analyzing and validating data used to calculate outcome measures. Conducts frequent audits using reports to verify information entered into the electronic health record is accurate.

Reconciles data reports, identifying data gaps, errors, irregularities, variances, inconsistencies and redundancies in the information gathered.

Provides guidance to SSLC staff in the collection, review, and validation of electronic health data required for tracking and trending performance improvement efforts and service monitoring.

Oversees, develops, and / or assists in the development and presentation of trend reports. Writes queries to access data for analysis and reporting.

Works with interdisciplinary teams to research and correct data issues. Assists in identifying and interpreting data patterns and trends.

Ensures program staff can easily use the information pulled from the databases. Troubleshoots with facility staff on entering data correctly into a system.

Provides support for programs across the SSLCs in data or training on reporting, explaining information extracted.

Responds to ad hoc data requests from program staff and state-office. Collects data for information requests. Requests Integrated Resident Information System (IRIS) access for staff and resets IRIS passwords as assigned.

Acts as a liaison with state office data analysts and HHSC IT.

Collaborates effectively with others including members of the Quality Assurance / Quality Improvement (QA / QI) Council to ensure opportunities for collection and analysis of data are maximized.

Develops, and / or assists in the development, maintenance and presentation of management tools and department trend reports for quality assurance and improvement initiatives such as Corrective Action Plans (CAPs) or Quality Improvement Plans (QIPs).

Other duties as assigned include but are not limited to actively participating and / or serving in a supporting role to meet the agency’s obligations for disaster response and / or recovery or Continuity of Operations (COOP) activation.

Such participation may require an alternate shift pattern assignment and / or location. Knowledge Skills Abilities :

Knowledge, or ability to gain knowledge, of agency programs, policies, and service delivery processes.

Strong working knowledge of Microsoft Access and Microsoft Excel, including how to write formulas.

Skill managing data in a relational database management system, including the development of queries, and report development software.

Skill in the use of computers and applicable software in conducting data searches and data cleaning.

Skill in the proficient use of MS Excel including formulas.

Skill in complex problem solving and critical thinking.

Ability to gather, review, and analyze data for trends.

Ability to distill large collections of data into an easily readable format that can be tracked and trended.

Ability to maintain accuracy and attention to detail.

Ability to prioritize work and meet deadlines.

Ability to communicate effectively both orally and in writing.

Ability and willingness to learn new systems, such as SharePoint.

Ability and willingness to be a team player and work well with a variety of stakeholders.