Job Information
HEALTH AND HUMAN SERVICES COMMISSION Data Analyst III in Austin, Texas
Job/Position DescriptionThe Data Analyst III in Hospital Provider Finance performs complex (journey-level) financial data analysis and data research assignments for the Provider Finance department in support of the development of reimbursement rates, supplemental payment programs, and financial analyses. Work involves conducting detailed analysis of data sets, including monitoring and ensuring data quality, loading data into databases from a variety of source formats, and automating data feeds to be used as input to performance dashboards and reports. Develops and delivers financial data solutions including the creation of dashboards and reports for large and complex agency programs. Works under general supervision, with limited latitude for the use of initiative and independent judgment. Attends work on a regular and predictable schedule in accordance with agency leave policy and performs other duties as assigned. Essential Job FunctionsEJF 1. Develops data-driven reports and analysis by using knowledge of Business Objects, HCRIS, Phoenix, or other databases. Assists in the maintenance of department data either through database maintenance, or development of data tools. Utilizes data visualization tools such as Tableau to assist with decision-making and to provide recommendations for future modifications to programs. Analyzes the data and advises key personnel about data irregularities on an ad hoc basis.EJF 2. Compiles, queries, loads and analyzes data points using query languages such as SQL from a variety of source formats to develop complex financial analyses. Provides data integrity by identifying data gaps, errors, anomalies, inconsistencies, and redundancies in the content, structure, and relationships within data, cleans and prunes data to discard irrelevant information. Coordinates with Texas Medicaid and Healthcare Partnership, managed care organizations, providers, and federal personnel to improve data quality. Designs and advises leadership staff regarding data collection needs and concerns; provides suggestions regarding systematic changes that will improve the collection of data. Assists in development of data standards.EJF 3. Consults with reimbursement rate analysts, program staff, and vendors to understand the business requirements that drive the analysis and design of reporting solutions that facilitate the development of reimbursement rates and the calculation of supplemental payments to providers. Uses subject matter knowledge of the data systems to support Senior Rate Analysts with selection of appropriate data sets.EJF 4. Actively contributes to the continuous improvement of department processes through ongoing initiatives including: solutions to automate, building efficiencies, and maintaining consistency across multiple data sources and by evaluating existing tools and applications. May assist with preparing and conducting presentations and reports to external stakeholders, workgroups, legislative staff and members. Will assist with preparing and conducting presentations and reports to executive staff.EJF 5. Will assist in the development of standards, usage guidelines, and procedures for data visualization tools, as appropriate. Will train others and assist with data integrity processes, data visualization tool usage, new techniques in data processing and analytics, and best practices; provides support for data visualization tool related questions, requests, and issues. Registrations, Licensure Requirements or CertificationsNAKnowledge Ski https://jobshrportal.hhsc.state.tx.us/ENG/CareerPortal/job_profile.cfm?szOrderID=609896 Copy the URL in the preceding sentence to an Internet Explorer browser to apply to the job directly through the Texas Health and Human Services Career Portal.