Consulting IT Financial Analyst

HCA-Healthcare; Nashville (TN); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Comprehensive benefits

Wellbeing support

Time away from work

401(k) match

Education support

Employee discounts

Job summary

HCA Healthcare, Inc. is seeking a Consulting IT Financial Analyst to own and automate data pipelines, reporting, and controls for a high-volume billing environment.

You will manage Power Query transformations, SQL data ingestion, and Power BI dashboards, supporting monthly billing and budget cycles with validation and auditability. Ideal candidates have a Bachelor’s degree, 7+ years in data/analytics, Advanced Excel and Power Query, and preferred Power BI experience.

Qualifications

• Bachelor’s degree is required.
• Minimum of 7 years of experience in data/reporting analytics, revenue operations, billing operations, or related.
• Advanced Excel and Power Query capability; experience with large datasets.
• Power BI experience preferred; ability to learn quickly.
• Demonstrated ability to apply data validation and controls.

Responsibilities

• Own repeatable datasets, controls, and reporting for a high-volume, multi-entity billing environment.
• Develop and maintain Power Query transformations and SQL data pipelines.
• Build automated reporting in Power BI and maintain dashboards.
• Serve as Budget System Super User during budget season and manage security and UAT.
• Produce validated billing-ready datasets, tie-outs, and exception outputs.
• Create budget calendar, directive files, and maintain changelogs for auditability.

Job description

Last year our HCA Healthcare colleagues invested over 156,000 hours volunteering in our communities. As a Consulting IT Financial Analyst with HCA Healthcare you can be a part of an organization that is devoted to giving back!

Job Summary and Qualifications

Position Summary

The Consulting Financial Analyst owns repeatable datasets, controls, and reporting that support a high-volume, multi-entity billing environment and the annual budget cycle. The primary focus is building and maintaining controlled data transformations (Power Query), automated reporting (Power BI), and validation controls that reduce manual Excel effort while improving accuracy and auditability. The role supports monthly billing execution by delivering billing-ready datasets, tie-outs, and exception outputs. During budget season, the role serves as a budget system super user and owns defined budget deliverables by workstream, executed to the published due-date timeline.

Major Responsibilities

• Automation leadership: owns the roadmap to reduce manual Excel processes; prioritize opportunities, design future-state workflows, and deliver measurable reductions in cycle time and error rates.
• Budget timeline ownership: manage and execute assigned budget deliverables by workstream (“Key Dates” high-level tasks) and ensure completion by defined due dates; maintain status reporting, dependencies, and documented outputs.
• Data pipeline ownership: build and maintain scalable Power Query transformations (and SQL where available) to ingest, clean, normalize, and refresh billing, budget, and allocation datasets from source files/systems.
• Data modeling: design governed datasets and data definitions; implement data dictionaries, lineage, and refresh schedules to enable consistent reporting across teams.
• Power BI ownership: develop and maintain Power BI dashboards and reporting packs; where needed, create semantic models and DAX measures to support driver-based analyses and drilldowns.
• Controls and auditability: implement reconciliation rules, variance thresholds, duplicate detection, and entity mapping validation; produce exception outputs, maintain an auditable change log, and support audit requests.
• Billing-ready datasets: produce validated billing-ready datasets and tie-outs (billed vs expected), manage an exception queue, and partner with stakeholders to resolve root causes of issues affecting billing accuracy.
• Budget System Super User (Budget season): manage security/access requests; coordinate and perform user acceptance testing (UAT) for system changes; validate outputs, document test evidence/signoffs, and partner with IT system owners to troubleshoot and resolve defects.
• Budget calendar and directive package: own creation/maintenance of the budget calendar and preparation of budget directive files/packages per the annual timeline; ensure deliverables are complete and stored in the designated repository.
• Metrics and driver file ownership: collect/receive system allocation metrics and corporate/system driver datasets; roll forward metric/driver files for prior-year comparisons; validate completeness, reasonableness, and trend breaks.
• Labor allocation datasets: extract/refresh Clarity-based labor allocation datasets; build and validate base labor files; implement repeatable refresh logic and controls; publish datasets for review/approval.
• Custom clinical rate support (as applicable): prepare and complete custom clinical rate calculations for the future year based on prior-year budget inputs and documented methodology; maintain calculation logic and validation checks.
• Budget analysis outputs: produce year-over-year (YOY) increase/decrease analyses and rollups with driver narratives; maintain repeatable templates and automated refresh logic for budget reporting.
• Cross-functional enablement: translating business rules into data requirements; document logic and processes; support adoption of new reporting/automation with clear guidance and training artifacts when needed.

Education & Experience Required

• Bachelor’s degree
• Minimum of 7 years of experience in data/reporting analytics, revenue operations, billing operations, financial operations, or a closely related role required.
• Advanced Excel and Power Query capability (or ability to learn quickly); demonstrated experience working with large datasets and building controlled, repeatable templates.
• Highly organized and self-driven; able to manage recurring deadlines and execute time-bound deliverables tied to an annual budget calendar and due-date schedule.
• Power BI experience creating automated recurring reporting (dashboards or standardized report outputs) preferred; ability to learn quickly if not yet expert. Preferred
• Demonstrated ability to apply data validation and controls (reconciliations, variance checks, exception handling)

Knowledge, Skills, Abilities, Behaviors:

• Data integrity orientation applies consistent checks, reconciliations, and exception handling to ensure reliable outputs. Required
• Automation mindset: continuously seeks practical ways to reduce manual effort and rework through repeatable transformations and standardized datasets. Required
• Execution discipline: meets deadlines with accurate, well-documented deliverables. Required
• Operational rigor: uses the due-date timeline to manage dependencies, status, and deliverable readiness across the budget workstreams. Required
• Systems partnership: coordinates testing and access processes effectively with IT system owners. Preferred

Benefits

HCA Healthcare, offers a total rewards package that supports the health, life, career and retirement of our colleagues. The available plans and programs include:

• Comprehensive benefitsfor medical, prescription drug, dental, vision, behavioral health and telemedicine services
• Wellbeing support,including free counseling and referral services
• Time away from workprograms for paid time off, paid family leave, long- and short-term disability coverage and leaves of absence
• Savings and retirement resources, including a 401(k) Plan with a 100% match on 3% to 9% of pay (based on years of service), Employee Stock Purchase Plan, flexible spending accounts, preferred banking partnerships, retirement readiness tools, rollover support and financial wellbeing counseling
• Education supportthrough tuition assistance, student loan assistance, certification support, dependent scholarships and a partnership with Galen College of Nursing
• Additional benefitsfor fertility and family building, adoption assistance, life insurance, supplemental health protection plans, auto and home insurance, legal counseling, identity theft protection and consumer discounts

Learn more about Employee Benefits

Note: Eligibility for benefits may vary by location.

HCA Healthcare has been recognized as one of the Worlds Most Ethical Companies® by the Ethisphere Institute more than ten times. In recent years, HCA Healthcare spent an estimated 3.7 billion in cost for the delivery of charitable care, uninsured discounts, and other uncompensated expenses.

There is so much good to do in the world and so many different ways to do it.
- Dr. Thomas Frist, Sr.
HCA Healthcare Co-Founder

We are an equal opportunity employer. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.