Data Analyst II

Job Description:

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. Learn About Our State Supported Living Centers

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 120 qualifying monthly payments. We also offer excellent health benefits , a lifetime monthly retirement annuity as well as 401(k) and 457 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.

Registration Or Licensure Requirements:

None

Required:

Initial Selection Criteria:

• High School diploma, GED or equivalent education.
  
  

Preferred:

• Technical school or college/university level coursework in data science, business analytics, computer science, computer information systems, management information systems, accounting, finance, mathematics, statistics, economics, or a related field is preferred.
  
  

Experience:

Required:

• Work experience with MS Access and Excel.
• Work experience in data analysis, research, and report design.
• Work experience in designing, developing, and maintaining queries and reports.
  
  

Preferred:

• Experience with MS SharePoint is preferred.
• Experience working with electronic health records is preferred.
  
  

Additional Information:

Salary Note: The salary offered will follow HHS starting salary guidelines which are typically made at or near the minimum of the salary range.

Applicants must pass a fingerprint criminal background check, pre-employment drug screen, and registry checks including the Client Abuse/Neglect Reporting System (CANRS), Nurse Aide, Medication Aide and Employee Misconduct and HHS OIG List of Excluded Individuals/Entities. Males between the ages of 18–25 must be registered with the Selective Service.

All State Supported Living Center employees are subject to random drug testing.

Flexibility in work hours may be required for this position. The position may be required to work overtime and/or extended hours.

All applicants must be at least 18 years of age to be considered for employment at a state-operated facility.

MOS Code:

Military occupation(s) that relate to the initial selection criteria and registration or licensure requirements for this position may include: 25B, 255A, 26B, CT, CTT, IT, ITS, 181X, 182X, 681X, 682X, 781X. 782X, CYB10, CYB11, ISM, 0671, 0679, 6046,6049, 0670, 8846, 8848, 0670, 8846, 8848, 3DOX2, 3DOX4.

All active-duty military, reservists, guardsmen, and veterans are encouraged to apply if qualified to fill this position. For additional information see the Texas State Auditor’s Military Crosswalk at http://www.hr.sao.state.tx.us/Compensation/JobDescriptions.aspx

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