Data Analyst II

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 II Job Title: Data Analyst II Agency: Health & Human Services Comm Department: General Admin Posting Number: 18901 Closing Date: 09/13/2026 Posting Audience: Internal and External Occupational Category: Office and Administrative Support Salary Range: $4,263.16 - $6,779.25 Pay Frequency: MonthlySalary Group: TEXAS-B-20 Shift: Day Additional Shift: Days (First) Telework: Not Eligible for Telework Travel: Up to 20% Regular/Temporary: Regular Full Time/Part Time: Full time FLSA Exempt/Non-Exempt: Nonexempt Facility Location: Big Spring State Hospital Job Location City: BIG SPRING Job Location Address: 1901 N HIGHWAY 87 Other Locations: Big Spring MOS Codes: 0231,0239,0271,0291,2652,2659,6046,6049,8051,8825,8846,8850,14N,14NX,15AX,16KX,181X,182X,183X,1D7X1 1N0X1,1N1X1,1N4X1,1N7X1,255A,25B,26B,350F,350G,351L,351M,352N,35F,35G,35L,35M,514A,514B,5I0,5I1A 65FX,65WX,681X,682X,683X,781X,782X,783X,86P0,8K000,CT,CTR,CTT,CYB10,CYB11,CYB12,CYB13,CYB14,IS,ISM ISS,IT,ITS,SEI15,SEI23 Brief Job Description: Would you thrive in an environment where you learn and grow personally and professionally all while helping make a positive impact on people’s lives? Do you appreciate being around others like yourself who are dependable, trustworthy, hard workers who believe in the value of teamwork? HSCS is dedicated to building an atmosphere where employees feel valued and supported while providing specialized care for Texans in need. HSCS is comprised of ten psychiatric hospitals, two youth residential treatment facilities, and thirteen state supported living centers. Psychiatric hospitals are a hub of excellence for forensic mental health and complex psychiatric care, with all facilities accredited by The Joint Commission. They provide state-of-the-art treatment that is recovery-oriented and science-based. If providing hope and healing through compassionate, innovative, and individualized care interests you, we welcome your application for the position below. The Data Analyst II performs routine (journey-level) data analysis work. Work involves creating and running queries to generate data sets, analyzing the data, and producing reports and graphics based on that data. Activities include a mix of running routine reports, responding to ad hoc report requests, and developing new reports to address identified needs. Responsibilities include ongoing development and technical support of local databases plus training and support of the individuals throughout the hospital using them. Works under moderate supervision, with limited latitude for the use of initiative and independent judgment. Performs other duties as assigned. 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. This position may be eligible to earn additional pay for work performed on evenings, nights and/or weekends. Essential Job Functions (EJFs): 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. Creates and supports databases and related data collection systems that are used by customers throughout the hospital. Assures that these systems function smoothly and return accurate and reliable results that can be used for data analysis. Monitors use of these data systems to promote accuracy of data input by various users. Creates or adjusts queries to meet ongoing changes in customers’ data needs. Provides relevant analysis of results as needed and discards unnecessary information. Consults with internal and external customers to clarify their specific data needs and how those needs can best be met. Identifies existing reports that address ongoing data needs and ensures that customers can readily access those reports. Adjusts existing reports to better address existing needs. Creates new reports in response to newly identified needs. Conducts ad hoc data analysis in response to specific requests from Hospital Management, State Hospitals Central Administration, and department heads throughout the hospital. Runs production reports that involve some compilation of results on a daily, weekly, monthly, and quarterly basis. Interprets the results to identify outliers in the data from ongoing measures and places results into optimal format for presentation. Uses queries and reports to conduct audits or monitor for possible irregularities in how the electronic medical record and other databases are implemented. Assists in using the results of such analysis to provide training, modify procedures, or take other responsive action. Performs other duties as assigned. 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 and Abilities (KSAs): Knowledge of common statistical measures and their relevance to data analysis. Knowledge of the operation of electronic medical records and the specific types of information contained within them. Skills in managing data in relational database management systems, including the creation of queries, linking of tables, extraction of relevant data, and assessment of the accuracy and validity of data within such systems. Skills in the use of computers and common software programs used in data collection and analysis. Ability to compile, review, and analyze data from existing data systems and to create reports and presentation graphics based on the results. Ability to communicate with clinicians and department heads regarding their data needs. Ability to maintain accuracy and attention to detail. Ability to communicate effectively both orally and in writing. Registrations, Licensure Requirements or Certifications: None Initial Screening Criteria: 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 a related field. OR Four (4) years’ equivalent experience in one or more of the above fields. One year of experience in data analysis, research, and report design. One year of experience with database software programs. One year of experience creating queries and reports. Experience can be overlapping. Additional Information: Applicants must pass a fingerprint criminal background check, pre-employment drug screen, and registry checks including the Client Abuse/Neglect Reporting System (CANRS), Nurse Aid, Medication Aide and Employee Misconduct, List of Excluded Individuals/Entities (LEIE). Males between the ages of 18-25 must be registered with the Selective Service. All applicants must be at least 18 years of age to be considered for employment at a state-operated facility. Waco and Terrell Center for Youth applicants must be 21 years of age. Flexibility in work hours may be required for this position. The position may be required to work overtime and/or extended hours. Compliance with HHSC immunization policy and state hospital operating procedures related to immunizations is required. According to the Centers for Disease Control and Prevention, healthcare workers are considered to be at significant risk for acquiring or transmitting hepatitis B, measles, mumps, rubella, varicella (chicken pox), tetanus, diphtheria, pertussis (whooping cough), and influenza. All these diseases are vaccine preventable. As a result, state hospital policy requires employees be vaccinated according to their level of contact with individuals. In the event you choose to not be immunized for the influenza virus, you may be required to wear a mask and take other protective measures.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 View phone number on click.appcast.io. 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.