The Managed Care Analyst II will provide analytical and technological support and development of systems and processes to aid managed care negotiations, financial management, compliance and monitoring to ensure achievement of established financial /strategic goals. This position is required to fully understand and apply all elements from the Contract Exhibit Reimbursement, and build and maintain those terms in the EPSI Contract Module. This position is also responsible to build and distribute both canned and ad-hoc reports in timely manner and to design meaningful summaries to aid in the decision process. This position reports to the Manager of Reimbursement and Managed Care Analytics

1. Performs Financial Modeling of Contracted Rates including What if and Sensitivities:
   • Implements complex financial modeling including different reimbursement terms grouped on a single model to assess revenue, profitability and contribution margin per service lines. Develops 'plug and play' spreadsheets for the End-user to enter several what if scenarios.
   • Develops revenue sensitivities to evaluate the net effect of the “what if” scenarios. Takes a lead role in developing rate proposals for negotiations and communicating financial terms with payers. Interacts with Negotiation team and payers to gain a thorough understanding of payer-specific coding, reimbursement system logic, and payment hierarchies.
2. Develops and Maintains EPSI Contract Module (Load, Audit, Modeling, and Reporting):
   • Develops and maintains EPSI contract management module. Ensures new contracts and contract updates are loaded in an accurate and timely fashion. Maintains integrity of system data. Tracks and verifies system data and load parameters. Prepares and distributes required reports on a timely basis to ensure maximum utilization of EPSI contract management capabilities. Researches and resolves contract management system configuration issues to ensure accurate contract loading.
   • Assesses ability to implement complex financial reimbursement models. Prepares and submits contract load briefs for complex arrangements and fee schedules. Identifies potential load issues and recommends corrections
3. Monitors Contract Performance by Payer, Product Lines and DRGs
   • Completes back-end audits on selected services/payers. Develops queries, templates and final reports to monitor Contract and Payer Performance. Makes recommendations for optimizing reimbursement.
4. Prepares and Distribute Standard and Ad-Hoc Reports
   • Prepares standard and ad hoc reports from EPSI and PCH Warehouse databases using MS Access, Excel, Crystal Reports, and other report writing tools. Assists other staff members with reporting needs. Take the lead role to introduce new metrics and Key Performance Indicators. Analyze results of reports and create meaningful summary level information.
5. Conduct special studies for Variance Analysis
   • Communicates hospital modeling logic to the Managed Care Team for reconciliation of variances in modeled reimbursement. Conducts special studies to analyze variances between actual and expected revenue by payer.
6. Determines root causes for miscellaneous issues related to reimbursement
   • Participates in special studies and/or projects involving financial analysis of payer reimbursement. Prepares reports of findings and makes recommendations as appropriate. Runs reimbursement variance reports; reviews and analyzes claims data for actual to expected payer reimbursement variance analysis and outlier payment audits; investigates under/overpayment in consultation with contracting and patient financial services personnel. Determines roots causes for various problems including contract loading issues, reimbursement and other system or contract interpretation errors.
7. Optimizes Managed Care tools as needed via design, testing, upgrades and support
   • Maintains department databases for data management and reporting of contract and/or provider information; tracks various departmental metrics using data downloads from
   • internal and external sources. Stays current in knowledge of contract management module techniques and technologies through active participation in primary system vendor training sessions and user groups.
8. Performs miscellaneous job related duties as requested.

To advance hope, healing and the best healthcare for children and their families

Phoenix Children's will be the leading pediatric health system in the Southwest, nationally recognized for exceptional care, innovative research and advanced medical education.

We realize this vision by:

• Offering the most comprehensive care across ages, communities and specialties
• Investing in innovative research, including emerging treatments, tools and technologies
• Advancing education and training to shape the next generation of clinical leaders
• Advocating for the health and well-being of children and families

• We place children and families at the center of all we do
• We deliver exceptional care, every day and in every way
• We collaborate with colleagues, partners and communities to amplify our impact
• We set the standards of pediatric healthcare today, and innovate for the future
• We are accountable for making the highest quality care accessible and affordable