Physician Compensation Analyst

Gillette Children's•Saint Paul, MN

28d•$43,922 - $65,988

About The Position

Gillette Children's is seeking a part-time (0.5 FTE) Physician Compensation Analyst to join our Revenue Cycle team. This role is the primary analytical partner for Gillette’s performance-based compensation program, dedicated to owning back-end wRVU calculations, RVU crosswalks, and compensation impact modeling. The position reports to Revenue Cycle Management and collaborates with various departments including Physician Compensation, Specialty Services, Coding, Chargemaster, Providers, and the Medical Staff Office.

Requirements

Bachelor's degree in Health Administration, Finance, Data/Business Analytics, Statistics, or related field; or equivalent experience
2+ years' experience in healthcare data analysis, revenue cycle analytics, medical coding/billing data, or provider compensation analytics
Experience working with productivity or performance-based data in a medical group, hospital, or health system
Working knowledge of CPT/HCPCS coding, wRVU methodology, and the Medicare Physician Fee Schedule sufficient to build and maintain crosswalk tables
Advanced Microsoft Excel skills; comfort building repeatable, auditable calculations and models
Demonstrated ability to reconcile data across multiple source systems (PM, billing, coding, HR/comp) and identify and resolve discrepancies
Comfort modeling “what-if” compensation scenarios (e.g., comparing pay under two different plan structures) with clear, defensible assumptions
Ability to interpret and translate technical data findings for non-analyst audiences, including HR, finance, and physician leaders
Ability to partner effectively with HR, the Physician Compensation Program Specialist, the Medical Staff Office, Coding, and IT/Analytics

Nice To Haves

Master's degree in Business Administration, Health Administration, Data Analytics, or related field
Experience with EMR systems such as Oracle Health (Cerner)
Prior experience supporting a compensation model conversion (e.g., salary-to-productivity, plan redesign) in a healthcare setting
Coding credential (CPC, CCS, or similar)
Experience with SQL and/or BI tools (Power BI, Tableau)
Exposure to MGMA benchmarking tools (DataDive, Physician Fee Schedule Tool) or similar survey data

Responsibilities

Pull, reconcile, and maintain CPT/HCPCS code volume and mix data.
Build and maintain the CPT-to-wRVU crosswalk table, updating for annual CMS Physician Fee Schedule changes.
Calculate provider- and specialty-level wRVUs and maintain historical trend data for seasonality and mix shifts.
Model the productivity and compensation impact of RVU or coding changes (e.g., CMS efficiency adjustments, specialty mix shifts) by provider, specialty, and site.
Produce scenario comparisons (e.g., hold-harmless/shadow RVUs, adjusted dollar-per-wRVU, adjusted thresholds) for leadership review.
Run periodic “shadow vs. actual” tracking so variance can be explained before it surprises a provider or a budget.
Build and maintain the underlying performance and productivity reports that the Physician Compensation Program Specialist delivers to physicians, ensuring calculation accuracy and clarity before physician-facing use.
Build and maintain recurring productivity/compensation dashboards (Excel and/or Power BI).
Support annual budget and compensation-planning cycles with forecasts and year-over-year comparisons.
Validate consistency of provider-level RVU and compensation data across coding, billing, and comp/HR systems; investigate and resolve discrepancies at the source.
Document modeling methodology and assumptions so results are reproducible and auditable.
Participate in relevant salary/productivity survey data submissions (e.g., MGMA DataDive) from a data-preparation standpoint.
Act as the data resource for the Physician Compensation Program Specialist and Medical Staff Office on physician compensation data questions.
Coordinate with Gillette's enterprise Data Analytics/IT department as needed for source-system data access, extracts, and infrastructure — this role owns the physician compensation modeling itself.
Builds effective relationships across the organization to accomplish the work and focus on patients/customers more effectively.
Demonstrates resilience in a changing environment. Leads and supports others to adapt and remain effective within ongoing change.
Is willing to become a champion for new projects or programs, representing them so that others will support them.
Recovers from setbacks and finds alternative ways to accomplish objectives.