Lead Data Analyst

Under the direction of the Director of Data Analytics, the Data Analyst V performs highly complex (senior level) data collection, research, reporting, and analysis to monitor, evaluate, and increase efficiencies for Texas State Hospitals (SH). Work involves gathering and analyzing data requirements, report design and implementation, and ongoing maintenance of existing reports and processes. Position requires being familiar with The Joint Commission Standards. The analyst will work with other SH staff as well as other HHSC staff to develop back-end tables and logic to drive reporting; create original programming logic and evaluate and/or modify existing programs to take into account changes in requirements; and will review work products developed by other analysts. The analyst will interact with agency program staff, division staff, other analysts and stakeholders to ensure data requirements are met and that all work products are appropriately reviewed and validated. The analyst will prepare diagrams and logic flowcharts for detailed coding and for the documentation of programming work and may interact with staff from other agencies and outside entities as required to facilitate data collaboration, obtain required work products, or for consultation. The analyst will participate in system design meetings for new SH initiatives to ensure the ability for SHs to collect and report applicable data. This position will produce concise, comprehensive technical reports to present findings, identify alternatives, and make recommendations for process improvement, and outline solutions to monitor and implement data quality. This position will analyze the data and interpret results of the analysis. Works under limited supervision, with moderate latitude for the use of initiative and independent judgment.

Performs other duties as assigned. Other duties as assigned include 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. Essential Job Functions (EJFs):

Attends work on a regular basis and may be asked 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.

Oversees the development and implementation of databases, data collection systems, and other strategies to optimize statistical efficiency and quality. Compiles, queries, and loads data using SQL or other query languages into databases to support complex analyses. Maintains security protocols for confidential data as it relates to accessing, handling, protecting, and distributing. Oversees the SH technical activities to ensure reporting requirements are met. Participates in the hospital information management committee/medical records committee/ governing body. 30%

Monitors and ensures data quality, loading data into databases from a variety of sources, as well as formatting and automating data feeds, to be used as input for ongoing and ad-hoc reporting, performance dashboards, and other reports. Develops scripts or code to extract, compile, and present data or models using computer programming languages such as SQL. Cleans and prepares data, as necessary, to produce data required for Tableau and other data visualization software. Extracts data from multiple sources for multiple report products, such as National Association of State Mental Health Program Directors Research Institute (NRI) statewide performance indicators, and various ad hoc requests for reports and analysis related to SH records and data. Ensures the accuracy of data included in reports. 30%

Establishes and updates data quality metrics and recommends and implements improvements to data quality with processes. Ensures data integrity by identifying gaps, errors, and anomalies, inconsistencies, and redundancies in the content, structure, and relationships within the data and implementing needed improvements for data quality and processes. Provides suggestions for systematic changes that will improve the collection of data and align data infrastructure with business needs. Provides routine updates on the status of projects and initiatives. 25%

Knowledge of statistics and analyzing data sets; running queries, report Coordination: Customer service focused. Utilizes strong communication skills to explain data processes and data management to negotiate information and resources needed to ensure successful initiatives. Determines the scope, purpose, timeline, and expected outcomes of assignments. Helps develop cost estimates and budgets for technical SH initiatives. Coordinates with Program Subject Matter Experts (SME’s) to ensure accuracy of reporting tools, workflows, reporting procedures and to improve data quality. Provides guidance related to the selection and use of preferred data management and analytic tools; defines, develops, and implements data and reporting standards. Provides guidance and direction to other areas needing technical expertise. Participates in legislative review process, requested reports, and other requests as it relates to SH records and data. Mentors team members. 10%

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. (5%)

Knowledge of statistics and analyzing data sets; running queries, report writing, and presenting findings; and record keeping, including security procedures for handling, protecting, and distributing confidential data.

Knowledge of data solutions, reporting methodologies, math, and statistical report design.

Knowledge of or strong aptitude to learn and interpret SH data.

Skill in relational databases, data processing practices, and theory.

Skill in researching and troubleshooting data issues and solving complex problems.

Skill in report development and automation.

Skill in using software such as Tableau, Excel, Oracle, SQL, Business Intelligence tools and SAS.

Skill in complex analytic work, identifying trends and concerns, and recommending opportunities for improvement as well as areas of excellence.

Ability to creatively solve complex data problems, apply new technology, and perform detailed work accurately under stressful conditions while managing multiple projects and tight deadlines.

Ability to present information to a variety of audiences verbally and in writing and to communicate clearly, concisely, effectively, and timely.

Ability to exercise independent judgment and show initiative.

Ability to work hours as needed to meet defined deadlines and support the agency’s mission-critical reporting requirements.

Ability to oversee and/or supervise the work of others as necessary.

Ability to analyze, consolidate, and interpret complex data, procedures, and systems and to write or revise program code or prepare reports as required., 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 is preferred;

Experience in data analysis, research, compilation, and/or reporting work.

Experience in designing, developing, and maintaining queries and reports.

Experience working with electronic health records is strongly preferred.

Experience working in a State Hospital is preferred. 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.

Pulled from the full job description

• Health insurance
• Pension plan
• Opportunities for advancement

Full job description

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.