Analyst-Financial

Ascension•Carmel, IN

10d•$65,713 - $91,600•Hybrid

About The Position

This role supports Finance Managers and Directors across 4 hospitals, actively participating in the month-end close cycle. It involves driving recurring reporting cadences, monitoring premium pay, conducting profitability analyses, tracking labor productivity, and reviewing healthcare costs and provider contracts to identify cost-saving opportunities. The position also requires querying, cleaning, and manipulating large historical datasets to build, publish, and maintain interactive dashboards in Tableau and Power BI for executive and operational decision support. The analyst will serve as a consultative financial partner to non-financial stakeholders, translating complex quantitative findings into clear insights, and participating in daily hospital safety huddles.

Requirements

High School diploma equivalency with 2 years of cumulative experience OR Associate's degree/Bachelor's degree OR 4 years of applicable cumulative job specific experience required.
Advanced Excel proficiency (XLOOKUP, INDEX/MATCH, complex pivot tables).
Experience querying databases in Oracle.
Strong background in data modeling and manipulation.
Proven track record of creating, publishing, and managing end-to-end reports and dashboards within Tableau and Power BI.
Must live in Carmel, Fishers, Kokomo, or Anderson, Indiana.

Nice To Haves

Accountant preferred.
Licensure required relevant to state in which work is performed.
Prior exposure to hospital operations, healthcare cost structures, labor productivity, and premium pay dynamics.

Responsibilities

Support Finance Managers and Directors across 4 hospitals, actively participating in the month-end close cycle (days 1–5) by extracting data, running Oracle queries, and loading budget spreads.
Drive recurring reporting cadences, including bi-weekly premium pay monitoring, standard profitability analyses, labor productivity tracking, and healthcare cost/provider contract reviews to identify cost-saving opportunities.
Query, clean, and manipulate large historical datasets to build, publish, and maintain interactive dashboards in Tableau and Power BI for executive and operational decision support.
Translate complex quantitative findings into clear insights, serving as a consultative financial partner to non-financial stakeholders and participating in daily 9:00 AM hospital safety huddles.