Decision Support Services Senior Insights Analyst

Tristar Health; Brentwood (MD); On-site; USD 85,000 - 120,000; Full time

Benefits offered by this job

Comprehensive benefits

Wellbeing support

Time away from work

Savings and retirement resources

Education support

Additional benefits

Job summary

TriStar Health is seeking a DSS Insights Analyst to transform complex data into actionable insights and support strategic decision-making. You will develop BI solutions, write complex SQL, and leverage Excel and cloud data warehouses like BigQuery to analyze data across Patient Financial and Cost Accounting domains.

The role requires collaboration with stakeholders, handling multiple projects, and applying AI/LLM techniques to enhance analysis.

Qualifications

• Bachelor's Degree required.
• 3-6 years of professional experience in data analysis or BI required.
• 4 years of BI Tool Development experience required.
• 4 years of SQL experience required.
• 5 years of Excel experience required.
• 1-3 years of ETL/ELT experience required.
• 2-3 years in Accounting/Finance or Healthcare data preferred.
• 1-3 years 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 multiple analytical projects and ad-hoc requests in a dynamic environment.
• Develop 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 operations.
• Design, develop, and maintain dashboards, reports, and data models using BI tools.
• Write and optimize complex SQL queries for large datasets.
• Perform ETL/ELT processes to ensure data quality and availability.
• Conduct in-depth data analysis using Excel (advanced functions, pivot tables, visuals).
• Provide ad-hoc analytical support and contribute to month-end reporting.

Skills

BI Tool Development

SQL

Excel

ETL/ELT

Gen AI/LLMs/Prompt Engineering

Python

Data analysis

Education

Bachelor's Degree

Tools

BigQuery

Essbase/Cube

Python

Excel

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 benefitsfor medical, prescription drug, dental, vision, behavioral health and telemedicine services
• Wellbeing support,including free counseling and referral services
• Time away from workprograms 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 supportthrough tuition assistance, student loan assistance, certification support, dependent scholarships and a partnership with Galen College of Nursing
• Additional benefitsfor 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 Worlds 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.

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.