Lead Data Analyst

Texas Health & Human Services Commission•Austin, TX

2d•$6,378 - $10,786

About The Position

The Lead Data Analyst (Data Analyst V) performs highly complex data collection, research, reporting, and analysis to monitor, evaluate, and improve efficiencies for Texas State Hospitals. Under the direction of the Director of Data Analytics, the position gathers and analyzes data requirements; designs, implements, and maintains reports and processes; and develops back-end tables, data logic, and programming. The analyst reviews other analysts’ work, collaborates with hospital and agency staff and stakeholders, and participates in system design meetings to ensure new initiatives can collect and report required data. Familiarity with The Joint Commission Standards is required. The role prepares technical reports that present findings, alternatives, recommendations, and data-quality solutions, and interprets analytical results. Work is performed under limited supervision with moderate latitude for initiative and independent judgment. The position oversees databases and data collection systems; queries and loads data using SQL or other query languages; maintains security protocols for confidential data; and monitors reporting requirements. It loads, formats, automates, cleans, and prepares data from multiple sources for ongoing and ad hoc reports, performance dashboards, Tableau, and other visualization tools. It establishes data-quality metrics, identifies and addresses gaps and anomalies, recommends systematic improvements, and provides project updates. The analyst also coordinates with subject matter experts, supports legislative and other reporting requests, advises on analytic and data-management tools and standards, and mentors team members. The role is full-time, regular, exempt, and based in Austin, Texas. The listed shift is day shift, with flexibility, overtime, extended hours, or alternate schedules potentially required. Travel is up to 5%, and the position may be eligible for telework subject to agency policy, supervisor discretion, and business needs. Disaster response or continuity-of-operations duties may require an alternate shift pattern or location.

Requirements

Experience in data analysis, research, compilation, and/or reporting work.
Experience designing, developing, and maintaining queries and reports.
Knowledge of statistics, data-set analysis, queries, report writing and presentation, record keeping, and confidential-data security procedures.
Knowledge of data solutions, reporting methodologies, mathematics, and statistical report design.
Knowledge of, or strong aptitude to learn and interpret, State Hospital data.
Skill with 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 using Tableau, Excel, Oracle, SQL, Business Intelligence tools, and SAS.
Ability to perform complex analytical work, identify trends and concerns, and recommend improvements and areas of excellence.
Ability to solve complex data problems creatively, apply new technology, and perform detailed work accurately under stress while managing multiple projects and tight deadlines.
Ability to communicate clearly and effectively in writing and verbally, and present information to varied audiences.
Ability to exercise independent judgment and initiative.
Ability to work hours as needed to meet deadlines and mission-critical reporting requirements.
Ability to oversee and/or supervise others as necessary.
Ability to analyze, consolidate, and interpret complex data, procedures, and systems, and write or revise program code or prepare reports.
Must pass fingerprint criminal background, pre-employment drug screening, and applicable registry checks.
Must be at least 18 years old for employment at a state-operated facility; males ages 18–25 must be registered with Selective Service.
Must comply with HHSC immunization policy and State Hospital operating procedures related to immunizations.
A four-year degree from an accredited college or university with major coursework in a relevant field is preferred, not stated as required.

Nice To Haves

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.
Experience working with electronic health records is strongly preferred.
Experience working in a State Hospital is preferred.
Familiarity with The Joint Commission Standards.

Responsibilities

Oversee development and implementation of databases, data collection systems, and strategies to improve statistical efficiency and quality.
Compile, query, and load data using SQL or other query languages to support complex analyses.
Maintain security protocols for accessing, handling, protecting, and distributing confidential data.
Oversee State Hospital technical activities to ensure reporting requirements are met and participate in hospital information management, medical records, and governing body committees.
Monitor data quality; load data from varied sources; format and automate data feeds for ongoing and ad hoc reports, dashboards, and other reporting products.
Develop scripts or code to extract, compile, and present data or models, including with SQL and other programming languages.
Clean and prepare data for Tableau and other data visualization software; extract data for statewide performance indicators and other requested reports and analyses.
Ensure the accuracy of data included in reports.
Establish and update data-quality metrics, identify gaps, errors, anomalies, inconsistencies, and redundancies, and implement improvements to data quality and processes.
Recommend systematic changes to improve data collection and align data infrastructure with business needs; provide routine project and initiative updates.
Coordinate with subject matter experts to validate reporting tools, workflows, and procedures and improve data quality.
Help determine assignment scope, purpose, timelines, and expected outcomes; assist with cost estimates and budgets for technical initiatives.
Provide guidance on data-management and analytic tools, define and implement data and reporting standards, and offer technical direction to other areas.
Participate in legislative reviews and fulfill requested reports and other requests concerning State Hospital records and data.
Review other analysts’ work products, mentor team members, and collaborate with agency staff, stakeholders, and outside entities as needed.
Participate in system design meetings for new State Hospital initiatives to ensure applicable data can be collected and reported.
Prepare technical reports presenting findings, alternatives, recommendations, and solutions for monitoring and implementing data quality; analyze data and interpret results.
Perform other assigned duties, including supporting disaster response, recovery, or Continuity of Operations activation.