Healthcare Contract Financial Modeling Consultant - Mosaic Clinically Integrated Network

Henry Ford Hospital
  • Detroit, MI
    30+ days ago

    Job Description

    GENERAL SUMMARY:

    Assisting the Manager of Contract Modeling with onboarding new employees and coaching and mentoring analysts with contract variances, simulations or contract build issues.

    PRINCIPLE DUTIES AND RESPONSIBILITIES:

    • Performs quarterly contract reviews to ensure models are calculating accurate expected reimbursement. Prepares summary reports with corrective action plans.
    • Leads projects/initiatives requiring contract modeling and proposes recommendations for solutions and feedback to leadership.
    • Coaches and mentors Analysts and assist with troubleshooting contract variances.
    • Researches and resolves discrepancies between expected reimbursement and actual payments.
    • Reviews Analyst contract modeling simulations for accuracy and provide feedback on opportunities for improvement.
    • Independently create contract modeling simulations to evaluate reimbursement rate proposals to support the contract negotiations.
    • Escalates payer contract non-compliance issues to contract administrators.
    • Assists with payment validation requests.
    • Executes EPSI and basic SQL reporting for ad hoc requests.
    • Migrates team's updates to Production via Data courier.
    • Responsible for assisting Reimbursement with monthly accruals estimates.

    EDUCATION/EXPERIENCE REQUIRED:

    • Bachelors Degree in Accounting, Finance, or a related field required. Masters Degree preferred.
    • Minimum 10 years of experience in healthcare industry.
    • Minimum five (5) years of experience in Payer Contract modeling.
    • Experienced in building HB an PB contract models.
    • Advanced excel skills: pivot table, VLOOKUP preferred.
    • Excellent oral and written communication and presentation skills.
    • Excellent organizational skills and ability to manage multiple projects simultaneously.
    • Excellent interpersonal skills and ability to develop effective working relationship with both internal and external customers.
    • Proficient in Microsoft Word, Excel, and PowerPoint.
    • Willing to maintain flexible hours to support projects and workgroups.

    Based on the needs of the Department this role will be supporting, this opportunity a best fit for someone with the following:

    • Advanced critical thinking and reasoning skills.
    • Self-Starter and ability to clearly document and communicate assumptions and processes.
    • Strong stakeholder engagement/ reporting skills.
    • Professional Rate Development experience.
    • Advanced Excel and actuarial/financial modeling & Data visualization.
    • Comprehensive knowledge of VBC analytics, trend analysis and KPI development (ACO model mechanics a plus).
    • Tableau/Power BI/Power Query, claims data interpretation.
    • Experience working with contract modeling systems (e.g., Epic contract modeling) across different types of payor arrangements.
    • SQL, SAS or Python/R, data engineering - big data skills.
    • Workflow mapping, data validation, feedback analysis experience.
    • Ability to independently build, validate, and interpret complex financial simulations to support contract negotiations, amendments, and performance forecasting.
    • Project Management Experience a plus.
    • Contract analysis, stakeholder mapping, CRM tracking.

    Additional Information

    • Organization: Corporate Services
    • Department: HF CIN
    • Shift: Day Job
    • Union Code: Not Applicable

    Numbers & Facts

    LocationDetroit, MI

    Skills

    • Accountingunmatched
    • Actuarial Skillsunmatched
    • Analysis Skillsunmatched
    • Big Dataunmatched
    • Coachingunmatched
    • Communication Skillsunmatched
    • Contract Analysisunmatched
    • Contract Creationunmatched
    • Contract Managementunmatched
    • Contract Negotiationunmatched
    • Contract Reviewunmatched
    • Corrective Actionunmatched
    • Customer Relationship Management (CRM)unmatched
    • Data Mappingunmatched
    • Data Modelingunmatched
    • Data Qualityunmatched
    • Data Visualizationunmatched
    • Financeunmatched
    • Financial Modelingunmatched
    • Financial Planningunmatched
    • Forecastingunmatched
    • Healthcareunmatched
    • Identify Issuesunmatched
    • Interpersonal Skillsunmatched
    • Leadershipunmatched
    • Mentoringunmatched
    • Microsoft Excelunmatched
    • Microsoft PowerPointunmatched
    • Microsoft Wordunmatched
    • Model Reviewunmatched
    • Multitaskingunmatched
    • Network Integrationunmatched
    • Onboardingunmatched
    • Organizational Skillsunmatched
    • Performance Metricsunmatched
    • Pivot Tablesunmatched
    • Power BIunmatched
    • Presentation/Verbal Skillsunmatched
    • Problem Solving Skillsunmatched
    • Project/Program Managementunmatched
    • Python Programming/Scripting Languageunmatched
    • R Programming Languageunmatched
    • Reimbursementunmatched
    • Reporting Skillsunmatched
    • SQL (Structured Query Language)unmatched
    • Software Engineeringunmatched
    • Tableauunmatched
    • Trend Analysisunmatched
    • Vlookupsunmatched
    • Writing Skillsunmatched

    Be found by employers

    5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

    Level up your application

    Professional resume templates

    Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

    Free resume templates

    Free resume builder

    Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

    Free resume builder