Decision Support Services Senior 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 Senior 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) Sr 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 Senior Insights Analyst opening. Qualified candidates will be contacted for interviews. Submit your application and help us raise the bar in patient care!

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.