DAIV (Cost Report Based Rate Methodology Team)

TX-HHSC-DSHS-DFPS•Austin, TX

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

About The Position

The Data Analyst IV serves as a member of the Texas Health and Human Services Commission (HHSC) Provider Finance Department (PFD) Long-term Services and Supports (LTSS) team and performs data analysis work involving data research, evaluation, and reporting to support cost report-based rate reimbursement methodologies. The position entails complex (journey-level) data analysis and data research work that includes: collecting, querying, and analyzing financial and statistical data; interpreting data analysis results to identify trends and outliers; and consulting with internal and external stakeholders to ensure data collection and analysis support cost report-based rate methodologies. This position works under general supervision, with moderate latitude for the use of initiative and independent judgment.

Requirements

Graduation from a four-year college or university with major coursework in accounting, business administration, finance, economics, statistics, or a related field is required. Experience in Provider Finance or applicable organization may be substituted for education on a one-to-one basis.
At least two years of experience in reimbursement rate analysis, data analysis, financial analysis, Medicaid, cost reporting processes, or conducting complex cost analyses.
Knowledge of LTSS cost reporting and financial examination practices.
Knowledge of The Texas Legislative process.
Knowledge of Microsoft Word at an advanced level and the use of HHS accessible templates. (Use of Styles to format documents, Table Styles, HHS Reports tab to create and format reports, page and section breaks to format long documents with different page styles, embedding documents, and able to create accessible documents).
Knowledge of Microsoft Excel at an advanced level. (Set up footers, headers, align margins, sort and filter, conditional formatting, use of excel formulas, insert links, concatenation, able to convert to accessible Adobe Acrobat format).
Knowledge of database query development and Structured Query Language (SQL)
Strong analytical skills with the ability to collect, analyze, organize, and communicate significant amounts of complex information with attention to detail, accuracy, professionalism, and diplomacy.
Strong critical thinking skills with the ability to evaluate and implement effective alternative solutions.
Interpersonal relationships, teamwork, and establishing and maintaining effective working relationships with people at various levels of expertise.
Communicating clearly and concisely, both verbally and in writing with attention to detail.
Proficiency in Microsoft Office Suite products (MS Word, Excel, PowerPoint, Outlook, SharePoint, Visio, and others).
Proficiency in Structured Query Language (SQL)
Ability to perform and interpret numerical analyses to analyze, evaluate, and summarize financial and management records for accuracy and conformance to procedures, rules, and regulations.
Ability to collaborate and work well with others with professionalism and diplomacy.
Ability to exercise initiative, discretion, and good judgment.
Ability to work under limited supervision, exercise independent judgment, set priorities, meet deadlines and adapt to shifting technical and work environmental developments.
Ability to manage projects effectively and produce quality work within expected deadlines.
Ability to maintain accurate, detailed, and organized documentation of assignments and projects.

Responsibilities

Assists in the establishment and maintenance of rate models and cost reports and surveys.
Conducts analysis of financial and statistical data to support cost report-based reimbursement rate methodologies in accordance with Texas Administrative Code rules, program guidelines, and established processes and procedures.
Coordinates among teammates to analyze processes and develop process improvements.
Coordinates with internal colleagues and external stakeholders in the design and maintenance/updates of cost and financial compliance reports or surveys of Medicaid and non-Medicaid programs to inform data analysis and rate setting efforts.
Develops and implements data analysis using standard statistical tools, methods, and techniques.
Interprets data analysis results in identifying trends and outliers in the data set.
Assists in the design of special cost and statistical research and conducts data analysis to evaluate the feasibility and cost implications regarding payment rate structure options, new program initiatives or enhancements, special payment rate initiatives, and new regulations.
Assists in the preparation of recommendations and responses for proposed legislation and state or federal initiatives.
Assists in the preparation of reports, memos, Texas Administrative Code Rule amendments, State Plan amendments, waiver amendments, and other documentation to propose and implement new initiatives.
Communicates complex information to internal and external parties to provide, exchange, or verify information; answer inquiries; address issues; or resolve problems or complaints.
Interfaces with various contracted providers, provider representatives, client advocates, other agency staff, advisory committees, workgroups, attorneys, and other interested parties concerning data analysis issues affecting cost report-based reimbursement rate methodologies.
Performs other work as assigned required to maintain and support the office and HHSC operations.