IT Senior Financial Analyst

The Revenue Operations Data Analyst owns repeatable datasets, controls, and reporting that support a high-volume, multi-entity billing environment and the annual budget cycle. The role’s 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., * Budget timeline ownership: manage and execute assigned budget deliverables by workstream and ensure completion by the defined due dates; maintain status, dependencies, and documented outputs.

• Data pipeline ownership: build and maintain Power Query transformations to ingest, clean, normalize, and refresh billing, budget, and allocation datasets from source files/systems.
• BI/reporting ownership: develop and maintain Power BI reports/dashboards for billing status, exceptions, cycle time, and budget/driver trends; maintain refresh cadence and data definitions.
• Controls and auditability: implement reconciliation rules, variance thresholds, duplicate detection, and entity mapping validation; produce exception outputs and maintain an auditable change log.
• Billing-ready datasets: support monthly billing execution by producing validated billing-ready datasets and tie-outs (billed vs expected), and by maintaining supporting documentation and standardized templates.
• Budget System Super User (Budget season): manage budget tool security/access requests, coordinate and perform user acceptance testing (UAT) for system changes, validate outputs, document test results/sign-offs, and partner with the IT system owners to troubleshoot and resolve issues.
• Budget calendar and directive package: own creation/maintenance of the budget calendar and preparation of budget directive files/packages per the annual timeline (deliverable ownership; distribution may be coordinated with leadership as needed).
• Metrics and driver file management: own collection/receipt of system allocation metrics and corporate/system driver datasets; roll forward metric/driver files for prior-year comparisons; validate completeness and reasonableness.
• Labor allocation datasets: extract/refresh Clarity-based labor allocation datasets, build base labor files, and maintain repeatable refresh/validation routines.
• 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.
• Budget analysis outputs: produce year-over-year (YOY) increase/decrease analyses and rollups with driver summaries; maintain repeatable templates and refresh logic for budget reporting.
• Continuous improvement: identify and implement practical automation opportunities that reduce manual Excel steps and rework; partner with stakeholders to resolve upstream data issues.

• Relevant Bachelors Degree required
• Two or more 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 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.
• 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

Loan assistance, Tuition reimbursement, Employee stock purchase plan, Health insurance, 401(k) matching, Paid time off, Vision insurance, Dental insurance, 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 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

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.

“The great hospitals will always put the patient and the patient’s family first, and the really great institutions will provide care with warmth, compassion, and dignity for the individual.”- Dr. Thomas Frist, Sr.