Jason Gill

Analyzed 5M+ customer and transaction records using SQL to identify sales trends, customer behavior, and operational performance. Built interactive Power BI dashboards tracking KPIs including revenue, customer retention, conversion rates, and regional performance. Wrote complex SQL queries using joins, CTEs, aggregations, and window functions to extract and transform data for recurring business reports.

Data Science Intern at Appalachian Data Solutions (2026-05 – 2026-08)

• Analyzed 5M+ customer and transaction records using SQL to identify sales trends, customer behavior, and operational performance.
• Built interactive Power BI dashboards tracking KPIs including revenue, customer retention, conversion rates, and regional performance.
• Wrote complex SQL queries using joins, CTEs, aggregations, and window functions to extract and transform data for recurring business reports.
• Automated data cleaning and reporting workflows with Python and SQL, reducing manual reporting time by 35%.
• Investigated performance trends and data anomalies, translating findings into actionable recommendations for business and operations teams.
• Presented dashboard insights and monthly performance reports to analytics and business stakeholders.

Bachelor of Applied Science in Data Science – Simon Fraser University (2023-09)