Data Analyst IV

TX-HHSC-DSHS-DFPS•Austin, TX

3d•$5,425 - $8,886•Hybrid

About The Position

The Data Analyst IV performs complex data analysis, statistical modeling, visualization, and reporting of results to support program, policy, and financial decision-making within Long-Term Services and Supports (LTSS) section of the Provider Finance Department (PFD). The role works under general supervision with moderate latitude for the use of initiative and independent judgment. The Data Analyst IV consults with internal Data Analysis & Calculations (DAC) team members and other teams within PFD to identify analytics needs, integrate diverse data sources, resolve data anomalies, and communicates findings in clear, actionable formats for technical and non-technical audiences.

Requirements

Graduation from an accredited four-year college or university.
At least 1 year of experience in data analysis, research, compilation, and/or reporting, related to public health or medical billing data (e.g., Medicaid, Medicare, service utilization and reimbursement, provider enrollment).
At least 3 years of experience with data analytics.
Knowledge of statistics, data set analysis, running queries, report writing, presenting findings, and record keeping, including security procedures for handling, protecting, and distributing confidential data.
Knowledge of data models, database design development, data mining, and segmentation techniques.
Skills in the use of a computer and applicable software, conducting data searches, evaluating and translating large amounts of data, and critical thinking.
Skill in analyzing problems and devising effective solutions.
Ability to compile, review, and analyze data, prepare reports, maintain accuracy and attention to detail, and communicate effectively.
Demonstrated ability to complete multi-step analytic projects.

Nice To Haves

Advanced skills with analytic tools and languages (e.g., SQL, Excel, SAS, Python, R, Tableau, or similar)
Knowledge of Texas Medicaid reimbursement policy/rules and experience with Health and Human Services data; strong analytical mindset when working with large government program data

Responsibilities

Performs Complex Data Analysis, Financial Modeling, & Visualization – 35%
Collects, integrates, queries, cleans, and analyzes large and complex data sets using standard and advanced languages and analytics software such as SQL, MS Excel, SAS, Python, or R.
Builds and maintains dashboards and visualizations to identify significant differences, patterns, and trends that inform decisions.
Supports complex calculations and financial modeling for rate methodology development, fiscal estimates, and utilization analyses.
Assists in cost report development.
Ensures Data Quality & Data Integrity Improvement – 20%
Assists in developing standards, usage guidelines, and procedures for data analysis tools and software.
Develops and implements data and reporting standards to improve consistency, repeatability, and auditability of analyses.
Establishes and maintains standard work procedures governing the appropriate use of data and reporting artifacts (templates, definitions, metadata).
Reviews the work of colleagues and members of other teams for accuracy, completeness, and conformance with standards, policies, and procedures.
Identifies data gaps, errors, anomalies, inconsistencies, and redundancies by analyzing the content, structure, and relationships within data.
Contributes to Internal and External Stakeholder Outreach and Communication Initiatives – 20%
Collaborates with program, policy, research, and cost report teams to respond to requests for information related to rates, services, providers, funding, and utilization.
Develops concise, comprehensive reports and presentations to interpret results, identify alternatives, and make and justify recommendations for internal and external stakeholders.
Participates in departmental learning initiatives, training and information-sharing sessions, and presents DAC analyses at departmental seminars.
Communicates data insights to internal and external stakeholders using clear language and appropriate visual formatting.
Facilitates Data Model Development and Automation– 10%
Assists in the development of data models and data management and analysis tools.
Evaluates data management and analysis tools and provides input on application and software adoption.
Facilitates automation and efficiency initiatives and recognizes opportunities for automation of standardized and ad hoc processes, projects, and reports.
Coordinates Tasks and Ensures Timely Project Completion – 10%
Coordinates analytic work and ensures work products meet deadlines and quality expectations.
Assists DAC manager in cross-team data analysis projects and ensures conformance to departmental needs, standards, and best practices.
Is available to answer questions and assist others when needed.
Other related work as assigned – 5%
Performs other related work as assigned in support of LTSS Provider Finance priorities.