Grant Botley

Dashboard Development & Business Intelligence SQL & Data Engineering (Snowflake) KPI Development & Business Impact

• Developed end-to-end partner-facing BI solutions by writing advanced SQL in Snowflake and delivering KPI-driven dashboards in Power BI and Excel
• Built automated reporting pipelines via ODBC connections, enabling scalable and refreshable performance monitoring
• Designed and standardized KPI frameworks that aligned partner performance metrics with strategic company goals
• Translated complex datasets into executive-ready insights that drove operational and financial decision-making
• Designed and delivered partner-facing dashboards in Power BI and Excel to track KPIs aligned with organizational growth and operational goals
• Translated complex business requirements into intuitive visualizations that improved partner transparency and performance accountability
• Built leadership and partner facing scorecards highlighting trend analysis, performance benchmarks, and actionable insights
• Wrote advanced SQL queries in Snowflake to extract, transform, and aggregate large healthcare/operational datasets
• Developed optimized queries using CTEs, joins, and aggregations to support performance reporting
• Validated and reconciled datasets to ensure data accuracy and consistency across reporting layers
• Created reusable query logic to standardize KPI definitions across partner reporting
• Defined and operationalized KPIs that directly supported company objectives (performance improvement, revenue growth, operational efficiency)
• Delivered actionable insights to external partners, influencing performance strategy and operational decision-making
• Partnered cross-functionally with operations, finance, and leadership teams to refine reporting metrics

• Manage and execute data analysis reports from HUB system to display the value of the model and work
• Extrapolate and edit data from the system to visualize the HUB work that is being done to address the social determinants of health in the community
• Lead on all data requests from community partners, managed care organizations, grantors and more
• Leverage HUB data to establish QI goals for community health workers and their agencies to ensure that the HUB model is being executed to the highest level of quality
• Act as internship coordinator to train, onboard and oversee all incoming interns
• Serve as point of contact for community health workers and supervisors regarding concerns/questions
• Work collaboratively with HUB team to maintain day to day operations within the HUB

• Review and check HUB IT Platform documentation for completeness
• Manage client data
• Assist with the processing of enrollments into the Pathways Program
• Process IT Platform documentation for the purposes of program continuation or discharge (i.e., processing client discharges and client transfers)
• Create monthly reports to update care coordination site supervisors on staff's productivity
• Contact CHWs regarding Platform documentation (clarification, confirmation, etc.)

• Greeted visitors and patients upon arrival, offered assistance and answered questions to build rapport and retention
• Oversaw fast-paced front desk operations and patients needs at busy facility.
• Work in Cohesion with other faculty members to care for and transport patients around the hospital.
• Guide patients to locations throughout hospital