Decision Support Services Insights Analyst

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 Tri Star Health you can be a part of an organization that is devoted to giving back!

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.

• 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 Big Query, 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.

• 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.

Tri Star 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,…