Decision Support Services Senior Insights Analyst

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

Benefits offered by this job

Medical benefits

Dental and vision coverage

401(k) with match

Tuition assistance

Career development opportunities

Job summary

HCA Healthcare is seeking an experienced Decision Support Services Insights Analyst in Brentwood, TN. This fully onsite role focuses on transforming complex data into actionable insights, building robust BI solutions, and collaborating with stakeholders to support strategic decisions.

Ideal candidates bring 3–6 years in data analysis or BI, strong SQL and Excel skills, and experience with cloud data warehouses like BigQuery and Python.

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 Essbase/Cube data
• 1-3 years of professional experience with Gen AI/LLMs/Prompt Engineering
• Bachelor’s Degree required

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 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 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 and optimize complex SQL queries to extract data from large datasets
• Perform ETL/ELT processes to ensure data quality and availability
• Conduct in-depth data analysis using Excel with advanced functions and pivot tables
• Provide ad-hoc analytical support and contribute to month-end reporting
• Elicit and translate business requirements into technical specifications
• Work with cloud data warehouses, particularly BigQuery
• Develop Python scripts for data analysis and automation
• Apply Gen AI and prompt engineering to enhance insights

Skills

Data analysis

SQL

Excel

ETL/ELT

Gen AI/LLMs/Prompt Engineering

Essbase/Cube data

BI Tool Development

Healthcare data

Accounting/Finance data

Bachelor’s Degree

Education

Bachelor’s Degree

Tools

None

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

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 reviewing applications for our Decision Support Services Insights Analyst opening. Qualified candidates will be contacted for interviews.

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.