Sr. Analyst, Managed Care

Responsibilities

• Complete financial impact analysis of all contract activity, including modeling of contract financial terms, developing proposals, and recommending areas for revenue improvement.
• Monitor financial performance of current contracts including consideration of methodology and fee changes due to payor or source updates (CMS, Medicaid, etc.).
• Extract, validate, and manipulate large datasets utilizing programming skills such as SQL, SAS, or Python.
• Strategic financial analytics to include financial managed care impacts/forecasts related to increased services, new technology, or expanding service area.
• Present analytic findings with clear and concise work products in Excel, Tableau, and Power BI.
• Collaborate with Finance and Managed Care leadership to inform financial forecasts with year-over-year impacts of all contractual changes.

Requirements

• Bachelor’s degree (or higher) in Statistics, Mathematics, Engineering, Finance, Health Administration, or other closely related fields.
• 4+ years of experience in healthcare analytics role.
• 3+ years of experience with SQL or other similar programming language to include creating, editing, and executing code to successfully manipulate and extract large datasets.
• 4+ years of experience in demonstrated ability to present data and analytic observations through impactful visual storytelling.
• Advanced proficiency in Excel including extensive experience in the use of complex formulas and pivots.

Preferred Skills

• Experience utilizing professional or facility claims data.
• Experience with managed care contract terms.
• Exposure to CMS professional payment methodology (i.e. CMS MPFS).
• Experience in creating and optimizing Tableau dashboards for effective storytelling.