Carter Smith
Nashville
Summary
Insightful Business Intelligence Analyst known for productive and efficient task completion. Specialize in data visualization, statistical analysis, and predictive modeling to support strategic decisions. Excel in problem-solving, critical thinking, and communication, leveraging these soft skills to effectively interpret data and convey complex findings in understandable terms.
Overview
2
2
years of professional experience
Work History
Business Intelligence Analyst
HCA Healthcare
Nashville
10.2025 - Current
- Acts as a SQL and PBI Consultant across teams within the Reporting and Analytics Department by assisting with complex scripts, tool questions and product deployments.
- Develop complex SQL queries from the EDW, and extract, clean, and transform diverse non-standard sources to build data models enabling the generation of PBI and Excel reports.
- Developed and maintained interactive dashboards using BI tools, enabling stakeholders to access real-time performance metrics.
- Collaborated with cross-functional teams to gather requirements, ensuring alignment on data reporting and visualization standards.
Associate Business Analyst
HCA Healthcare
Nashville
08.2024 - 10.2025
- Developed and launched multiple, initial dashboards using SQL, PBI, and Exel to allow a new line of business access into key operational metrics.
- Collaborated with cross-functional teams to gather requirements and develop solutions, improving stakeholder engagement and project outcomes.
- Coordinated with IT teams to ensure smooth deployment of new technologies into production environments.
- Was responsible for converting 25+ products into new syntax when the department changed to using Google Cloud Platform’s BigQuery
Reporting and Analytics Intern
HCA Healthcare
Nashville
06.2024 - 08.2024
- Implemented processes for tracking customer engagement metrics across multiple channels.
- Collaborated with stakeholders to define KPIs for measuring success.
- Assisted in creating automated reports using SQL, Power BI.
- Optimized existing ETL processes, resulting in more efficient data integration and enhanced performance of BI tools.
Education
Strategy Analyst -
Strategy
12.2024 - 01.2025
Bachelor of Science - Microbiology
Middle Tennessee State University
Murfreesboro, TNSkills
- SQL programming
- Microsoft PBi
- Microsoft Power Query
- Strategy
- Business Analytics
- Healthcare Data
- Stakeholder Collaboration
- KPI dashboards
Timeline
Business Intelligence Analyst
HCA Healthcare
10.2025 - Current
Strategy Analyst -
Strategy
12.2024 - 01.2025
Associate Business Analyst
HCA Healthcare
08.2024 - 10.2025
Reporting and Analytics Intern
HCA Healthcare
06.2024 - 08.2024
Bachelor of Science - Microbiology
Middle Tennessee State University