Decision Support Services Insights Analyst

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

Benefits offered by this job

Comprehensive benefits

Wellbeing support

Time away from work

401(k) plan with match

Job summary

HCA Healthcare is seeking a Decision Support Services Insights Analyst to transform complex data into actionable insights across the organization, with a focus on Patient Financial and Cost Accounting data. Strong SQL, Excel, BI development, and cloud data warehouse experience are required.

Collaborate with stakeholders, manage multiple analytics projects, build dashboards, and apply Gen AI techniques to enhance insights, in a fully onsite role at the HCA Healthpark office in Brentwood, TN.

Qualifications

• 3-6 years of professional relevant experience in data analysis or business intelligence.
• 4 years of experience in BI Tool Development.
• 4 years of experience with SQL.
• 5 years of experience with Excel.
• 1-3 years of experience with ETL/ELT processes.
• 2-3 years of combined experience in Accounting/Finance or Healthcare Data.
• 1-3 years of experience with Gen AI/LLMs/Prompt Engineering preferred.

Responsibilities

• Lead the development and maintenance of robust BI solutions from back-end data modelling to front-end visualizations.
• Collaborate with business stakeholders to understand requirements and deliver data-driven insights.
• Manage and prioritize multiple analytical projects and ad-hoc requests.
• Have subject-matter expertise in Patient Financial and Cost Accounting data.
• Educate users on Patient Financial data and BI tools.
• Drive data analysis initiatives to support strategic planning and operational improvements.
• Design, develop, and maintain dashboards, reports, and data models.
• Write, optimize, and execute complex SQL queries on large datasets.
• Perform ETL/ELT processes to ensure data quality and availability.
• Conduct in-depth data analysis using Excel (advanced functions, pivot tables).
• Provide ad-hoc analytical support and month-end reporting.
• Translate business requirements into technical specifications for data/reporting solutions.
• Work with cloud data warehouses, particularly BigQuery.
• Develop Python scripts for data analysis/automation.
• Apply Gen AI/LLMs and prompt engineering to enhance insights.

Skills

BI tool development

SQL

Excel

ETL/ELT

Gen AI/LLMs/Prompt engineering

Education

Bachelor’s Degree

Tools

BigQuery

Python

Job description

Location: This position is fully onsite at HCA Healthpark office in Brentwood, TN

Schedule: Monday-Friday, daytime hours (around 9am-5pm)

Last year our HCA Healthcare colleagues invested over 156,000 hours volunteering in our communities. As a Decision Support Services Insights Analyst with TriStar Health you can be a part of an organization that is devoted to giving back!

Job Summary and Qualifications

The Decision Support Services (DSS) Insights Analyst will be responsible for transforming complex data into actionable insights and supporting strategic decision-making across the organization. The ideal candidate will possess a strong background in BI tool development, advanced SQL, and Excel, with experience in large datasets and cloud data warehouses. This position requires a proactive individual who can work directly with stakeholders, manage competing priorities, and contribute to both ad-hoc and recurring analytical needs, leveraging domain expertise in finance, accounting, or healthcare.

What you will do in this role:

• Lead the development and maintenance of robust Business Intelligence (BI) solutions from back-end data modelling to front-end visualizations.

• Collaborate directly with business stakeholders to understand requirements and deliver impactful data-driven insights.

• Manage and prioritize multiple analytical projects and ad-hoc requests in a dynamic environment.

• Have subject-matter expertise in Patient Financial and Cost Accounting data

• Educate users on the Patient Financial data owned by the Reporting, Benchmarking, and Analytics department and on departmental Patient Financial BI tools

• Drive data analysis initiatives to support strategic planning and operational improvements, often working with disparate data and ambiguous problems

• Design, develop, and maintain interactive dashboards, reports, and data models using various BI tools.

• Write, optimize, and execute complex SQL queries utilizing intermediate to intermediate functions (e.g., complex joins, subqueries, table creation) to extract and manipulate data from large datasets.

• Perform data extraction, transformation, and loading (ETL/ELT) processes to ensure data quality and availability.

• Conduct in-depth data analysis using Excel, including advanced functions, pivot tables, and data visualization.

• Provide ad-hoc analytical support and contribute to month-end reporting and analysis.

• Elicit, document, and translate business requirements into technical specifications for data and reporting solutions.

• Work extensively with cloud data warehouses, particularly BigQuery, for data storage and analysis.

• Develop and implement Python scripts for data analysis, automation, or integration.

• Apply Gen AI, LLMs, and prompt engineering techniques to enhance data analysis and insight generation.

What qualifications you will need:

• 3-6 years of professional relevant experience in data analysis or business intelligence required.

• 4 years of experience in BI Tool Development required.

• 4 years of experience with SQL required.

• 5 years of experience with Excel required.

• 1-3 years of experience with ETL/ELT processes required.

• 2-3 years of combined experience in Accounting/Finance or Healthcare Data required.

• 1-3 years of experience with Essbase/Cube data preferred.

• 1-3 years of professional experience with Gen AI/LLMs/Prompt Engineering preferred.

• Bachelor’s Degree required.

Benefits

TriStar Health 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 (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

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.