Consulting IT Financial Analyst

HCA Healthcare•Nashville, TN

About The Position

The Consulting IT Financial Analyst owns repeatable datasets, controls, and reporting that support a high-volume, multi-entity billing environment and the annual budget cycle. The role focuses on building and maintaining controlled data transformations using Power Query, automated reporting with Power BI, and validation controls that reduce manual Excel work while improving accuracy and auditability. It supports monthly billing execution through billing-ready datasets, tie-outs, and exception outputs. During budget season, the analyst serves as a budget system super user and owns defined workstream deliverables in accordance with the published due-date timeline. The analyst leads efforts to automate manual processes, manages assigned budget deliverables and related dependencies, and builds scalable data pipelines for billing, budget, and allocation datasets. The role designs governed datasets and data definitions, maintains Power BI dashboards and reporting packs, and implements reconciliation, variance, duplicate-detection, and entity-mapping controls. It also produces validated billing datasets and tie-outs, manages billing exceptions, and partners with stakeholders to resolve root causes. During budget season, responsibilities include managing system access requests, coordinating user acceptance testing, validating outputs and documenting evidence, maintaining the budget calendar and directive packages, and preparing and validating allocation metrics, labor allocation datasets, clinical rate calculations where applicable, and year-over-year budget analyses. The analyst documents business rules and processes and supports adoption of reporting and automation through guidance and training materials when needed.

Requirements

Bachelor’s degree.
At least 7 years of experience in data/reporting analytics, revenue operations, billing operations, financial operations, or a closely related role.
Advanced Excel and Power Query capability, or the ability to learn quickly.
Demonstrated experience working with large datasets and building controlled, repeatable templates.
Highly organized and self-driven, with the ability to manage recurring deadlines and time-bound deliverables tied to an annual budget calendar and due-date schedule.
Data integrity orientation, applying consistent checks, reconciliations, and exception handling to ensure reliable outputs.
Automation mindset, continuously seeking practical ways to reduce manual effort and rework through repeatable transformations and standardized datasets.
Execution discipline, meeting deadlines with accurate, well-documented deliverables.
Operational rigor in using due-date timelines to manage dependencies, status, and deliverable readiness across budget workstreams.

Nice To Haves

Experience creating automated recurring reporting in Power BI, such as dashboards or standardized report outputs; ability to learn quickly if not yet expert.
Demonstrated ability to apply data validation and controls, including reconciliations, variance checks, and exception handling.
Ability to coordinate testing and access processes effectively with IT system owners.

Responsibilities

Own the roadmap for reducing manual Excel processes by prioritizing automation opportunities, designing future-state workflows, and delivering measurable reductions in cycle time and error rates.
Manage and execute assigned budget deliverables by workstream, meet defined due dates, and maintain status reporting, dependencies, and documented outputs.
Build and maintain scalable Power Query transformations and, where available, SQL workflows to ingest, clean, normalize, and refresh billing, budget, and allocation datasets.
Design governed datasets and data definitions; maintain data dictionaries, lineage, and refresh schedules.
Develop and maintain Power BI dashboards and reporting packs, including semantic models and DAX measures when needed.
Implement reconciliation rules, variance thresholds, duplicate detection, and entity mapping validation; produce exception outputs, maintain an auditable change log, and support audit requests.
Produce validated billing-ready datasets and billed-versus-expected tie-outs, manage an exception queue, and partner with stakeholders to resolve billing accuracy issues.
During budget season, manage budget-system security and access requests; coordinate and perform user acceptance testing, validate outputs, document test evidence and signoffs, and work with IT system owners to resolve defects.
Create and maintain the budget calendar and prepare budget directive files and packages according to the annual timeline; ensure deliverables are complete and stored in the designated repository.
Collect or receive system allocation metrics and corporate/system driver datasets; roll forward metric and driver files for prior-year comparisons and validate completeness, reasonableness, and trend breaks.
Extract and refresh Clarity-based labor allocation datasets, build and validate base labor files, implement repeatable refresh logic and controls, and publish datasets for review and approval.
Where applicable, prepare future-year custom clinical rate calculations using prior-year budget inputs and documented methodology, and maintain calculation logic and validation checks.
Produce year-over-year increase/decrease analyses and rollups with driver narratives, maintaining repeatable templates and automated refresh logic.
Translate business rules into data requirements, document logic and processes, and support adoption of reporting and automation with guidance and training artifacts when needed.

Benefits

Comprehensive medical, prescription drug, dental, vision, behavioral health, and telemedicine benefits.
Wellbeing support, including free counseling and referral services.
Paid time off and paid family leave.
Long- and short-term disability coverage and leaves of absence.
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.
Tuition assistance, student loan assistance, certification support, dependent scholarships, and a partnership with Galen College of Nursing.
Fertility and family-building benefits and adoption assistance.
Life insurance and supplemental health protection plans.
Auto and home insurance, legal counseling, identity theft protection, and consumer discounts.