DAIV (Cost Report Based Rate Methodology Team)

About the Role

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.

Essential Job Functions

• Performs Data Analysis Functions (30%): 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.
• Report and Survey Development and Analysis (25%): 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.
• Evaluates and Implements New Initiatives (20%): 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.
• Stakeholder and Staff Communication (20%): 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.
• Other Duties as Assigned (5%): Performs other work as assigned required to maintain and support the office and HHSC operations.

Knowledge, Skills, and Abilities

• LTSS cost reporting and financial examination practices
• The Texas Legislative process
• 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)
• 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
• Microsoft Office Suite products (MS Word, Excel, PowerPoint, Outlook, SharePoint, Visio, and others)
• 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

Qualifications

• 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.

Pay

$5,425.33 - $8,886.16 per month

Schedule

Day shift; Full time; Eligible for telework; Travel up to 5%

Benefits

Comprehensive benefits package includes 100% paid employee health insurance for full-time eligible employees, a defined benefit pension plan, generous time off benefits, and numerous opportunities for career advancement.