I am Jaspreet Goraya, a data analyst with 7+ years of experience designing and delivering interactive dashboards, enterprise reporting, and data-driven insights. I excel at translating complex business requirements into scalable BI solutions using Power BI, Python, SQL, Tableau, and Azure, with experience in healthcare and P&C insurance. I thrive in cross-functional teams, automate repetitive reporting with Python and Power Platform, and help stakeholders make data-driven decisions. I am a collaborative communicator who bridges business and technical perspectives to drive strategic outcomes and enable self-serve analytics. I enjoy turning data into actionable insights, delivering accurate dashboards, training users for self-service reporting, and continuously improving data quality and governance in enterprise environments.

Jaspreet Goraya

I am Jaspreet Goraya, a data analyst with 7+ years of experience designing and delivering interactive dashboards, enterprise reporting, and data-driven insights. I excel at translating complex business requirements into scalable BI solutions using Power BI, Python, SQL, Tableau, and Azure, with experience in healthcare and P&C insurance. I thrive in cross-functional teams, automate repetitive reporting with Python and Power Platform, and help stakeholders make data-driven decisions. I am a collaborative communicator who bridges business and technical perspectives to drive strategic outcomes and enable self-serve analytics. I enjoy turning data into actionable insights, delivering accurate dashboards, training users for self-service reporting, and continuously improving data quality and governance in enterprise environments.

Available to hire

I am Jaspreet Goraya, a data analyst with 7+ years of experience designing and delivering interactive dashboards, enterprise reporting, and data-driven insights. I excel at translating complex business requirements into scalable BI solutions using Power BI, Python, SQL, Tableau, and Azure, with experience in healthcare and P&C insurance. I thrive in cross-functional teams, automate repetitive reporting with Python and Power Platform, and help stakeholders make data-driven decisions. I am a collaborative communicator who bridges business and technical perspectives to drive strategic outcomes and enable self-serve analytics.

I enjoy turning data into actionable insights, delivering accurate dashboards, training users for self-service reporting, and continuously improving data quality and governance in enterprise environments.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Intermediate
See more

Work Experience

Data Analyst at Ministry of Long-Term Care
December 1, 2024 - Present
Analyzed large healthcare datasets to identify trends, patterns, and actionable insights supporting operational and policy decisions. Designed, developed, and maintained interactive Power BI dashboards and reports to monitor healthcare performance metrics including staffing levels, resident outcomes, and regulatory compliance. Automated repetitive reporting processes using Python and Power Automate, reducing manual effort and improving efficiency. Translated business and regulatory requirements into technical Power BI specifications, collaborating with stakeholders to define KPIs, metrics, and reporting standards. Implemented complex DAX calculations for dynamic KPIs, trend analysis, and conditional logic to enhance analytical depth and interactivity. Delivered daily, weekly, and monthly reporting to leadership and operational teams with high accuracy, consistency, and timely insights. Provided end-user training and ongoing Power BI support to improve adoption.
Data Analyst at Chick-fil-A
October 1, 2023 - December 1, 2024
Gathered business requirements and translated them into actionable BI solutions, dashboards, and visual insights. Analyzed operational datasets to identify process improvement opportunities, trends, and performance gaps. Developed and maintained Power BI dashboards and operational reports to support finance, marketing, and operations teams. Delivered recurring daily, weekly, and monthly performance reports, ensuring alignment with business KPIs and goals. Collaborated cross-functionally with stakeholders to define KPIs, metrics, and reporting requirements. Provided Power BI training and reporting support to non-technical users, improving data-driven decision-making.
Data Analyst at HCL Canada
February 1, 2021 - July 1, 2023
Designed and deployed interactive Power BI dashboards for executive reporting and KPI monitoring. Built and optimized semantic data models and DAX measures to improve performance and scalability. Developed and optimized SQL queries and ETL processes to ensure accurate and reliable reporting. Integrated Power BI with Azure SQL Database and Azure Data Factory for enterprise-scale analytics. Collaborated with data owners and business stakeholders to ensure data accuracy, governance, and compliance.
Data Analyst Intern at HCL Canada
July 1, 2020 - December 1, 2020
Assisted in developing and maintaining Power BI reports and dashboards for business users. Worked closely with senior data analysts to build semantic data models, enhancing data accuracy and accessibility. Wrote SQL queries to extract, transform, and analyze data for operational insights. Supported ad-hoc analysis requests and UAT activities, delivering quick and reliable insights.
Junior Web Developer (Part-Time) at Design2Web IT Inc
August 1, 2019 - January 1, 2020
Tested and validated programs to enhance applications and improve performance. Website development work focused on WordPress. Translated business requirements into technical requirements. WordPress frameworks included Visual Composer and Element. Performed product data entry on Amazon Canada.
QA Analyst at Capgemini
March 1, 2017 - April 1, 2019
Automated data validation and regression testing across P&C insurance policy, claims, and billing modules using SQL and Python, ensuring end-to-end data accuracy. Designed and executed Selenium-Python automation scripts to validate web and backend workflows for policy issuance, renewals, endorsements, and claims processing. Developed SQL-based automation to verify premium calculations, loss reserves, and regulatory reporting accuracy. Built reusable automation frameworks in Azure DevOps, improving test execution efficiency by 25% and enhancing release reliability. Conducted functional and integration testing between core insurance systems and external data sources. Collaborated with business analysts and actuaries to design UAT validation scripts, accelerating approval timelines for production releases.

Education

Post baccalaureate certification in Data Analysis at University of the Fraser Valley
January 1, 2020 - January 16, 2026
Bachelor of Science in Information Technology at University of Mumbai
January 1, 2016 - January 16, 2026

Qualifications

Microsoft Power BI Data Analyst
January 11, 2030 - January 16, 2026
Google Data Analytics Professional Certificate
January 11, 2030 - January 16, 2026
Python for Data Analysis
January 11, 2030 - January 16, 2026
ISTQB Foundation Level
January 11, 2030 - January 16, 2026
SCRUMstudy Agile Master Certified (SAMC)
January 11, 2030 - January 16, 2026

Industry Experience

Healthcare, Financial Services, Professional Services, Software & Internet