Consulting IT Financial Analyst

HCA Healthcare, Inc.; Nashville (TN); On-site; USD 85,000 - 120,000; Full time

Benefits offered by this job

Medical, prescription drug, dental, 1

Wellbeing support

Paid time off & family leave

401(k) with 100% match on 3% to 9%

Tuition assistance

Employee discounts

Job summary

HCA Healthcare, Inc. in Nashville is seeking a Consulting IT Financial Analyst to own data pipelines, automated reporting, and budget cycle support.

You will build Power Query transformations, maintain dashboards in Power BI, and implement validation controls to improve accuracy and auditability in a high-volume environment. The role focuses on billing-ready datasets, tie-outs, and driver-based analyses, with responsibilities spanning budget deliverables, security testing, and collaboration with

Qualifications

• Bachelor’s degree is required.
• 7+ years of experience in data/reporting analytics, revenue operations, billing operations, or related roles.

Responsibilities

• Automation leadership: reduce manual Excel processes and deliver measurable reductions.
• Budget timeline ownership: manage and complete budget deliverables by due dates.
• Data pipeline ownership: build/maintain Power Query transformations and SQL where available.
• Data modeling: design governed datasets and data definitions with data dictionaries.
• Power BI ownership: develop/deliver dashboards and reporting packs; create models and DAX measures.
• Controls and auditability: implement reconciliation rules and exception outputs; maintain an auditable change log.
• Billing-ready datasets: produce validated datasets and tie-outs; address root causes with stakeholders.
• Budget System Super User: manage security/access requests and perform UAT; collaborate with IT to troubleshoot defects.
• Budget calendar: maintain budget calendar and directive files; ensure completeness and storage in repository.
• Metrics and driver file ownership: collect and validate allocation metrics; validate reasonableness.
• Labor allocation datasets: refresh Clarity-based labor datasets; publish datasets for review.
• Custom clinical rate support: calculate rates for future year based on methodology; maintain validation checks.
• Budget analysis outputs: provide YOY analyses and driver narratives with automated refresh templates.
• Cross-functional enablement: translate business rules into data requirements; train users.

Skills

Advanced Excel

Power Query

Power BI

Data validation

SQL

Budgeting

Data analysis

Education

Bachelor’s degree

Tools

Power Query

Power BI

SQL

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

• Comprehensive benefits for medical, prescription drug, dental, vision, behavioral health and telemedicine services
• Wellbeing support, including free counseling and referral services
• Time away from work programs 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 support through tuition assistance, student loan assistance, certification support, dependent scholarships and a partnership with Galen College of Nursing
• Additional benefits for 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 (https://careers.hcahealthcare.com/pages/employee-benefits-and-rewards)

Note: Eligibility for benefits may vary by location.

HCA Healthcare has been recognized as one of the World's 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

Be a part of an organization that invests in you!

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.