
Henil Gadhiya
@henilgadhiya
I build automated data pipelines, scalable models, and BI dashboards that drive decisions.
What I'm looking for
At Air Canada, I engineered automated ETL pipelines using Dataiku, Snowflake, SQL, Python, and Power Query, improving processing efficiency by 50%. I also built Python automation frameworks that accelerated processing by 30% and reduced data quality issues by 90% through standardization and validation.
I designed 15+ Power BI dashboards for directors and managers, translating multi-source operational data into KPI tracking, projections, and timeline comparisons. My work spans star-schema modeling, multi-layered data warehouses, advanced SQL transformations, data lineage, and executive-facing reporting.
Across EPIC and Intelivita, I've supported ETL mapping, migration readiness, Tableau reporting, requirements gathering, and stakeholder workshops. I bring experience connecting business requirements to reliable data products through governance, documentation, QA/UAT, and ITIL-aligned operations.
Experience
Work history, roles, and key accomplishments
Reporting Analyst
Air Canada
Sep 2023 - Oct 2025 (2 years 1 month)
Engineered ETL pipelines achieving 50% improvement in data processing efficiency using Dataiku, Snowflake, SQL, Python, and Power Query. Designed and deployed 15+ interactive Power BI dashboards for KPI tracking.
Data Analyst
EPIC
Jul 2022 - Jul 2023 (1 year)
Analyzed ETL mapping logic for 50+ dimension tables and developed SQL queries in Snowflake to validate business rules. Built Tableau dashboards to visualize data lineage and monitor migration readiness.
Data Analyst
Intelivita
Dec 2019 - Feb 2021 (1 year 2 months)
Designed Tableau reports to visualize business workflows and track requirements completion. Collaborated with data warehouse team to evaluate ETL design implications and performed gap analysis.
Education
Degrees, certifications, and relevant coursework
Microsoft
Azure Data Fundamentals, Data Fundamentals
Azure Data Fundamentals certification in progress.
Conestoga College
Post-Graduate Diploma, Big Data Solutions and Architecture
2022 - 2022
Completed a post-graduate diploma in Big Data Solutions and Architecture.
Fanshawe College
Post-Graduate Diploma, Business Analysis
2021 - 2021
Completed a post-graduate diploma in Business Analysis.
Indus University
B.Tech, Computer Science and Engineering
2016 - 2020
Earned a Bachelor of Technology in Computer Science and Engineering.
Microsoft
Microsoft Certified: Power BI Data Analyst Associate, Data Analysis
Certified as a Power BI Data Analyst Associate.
IIBA
ECBA, Business Analysis
Earned the Entry Certificate in Business Analysis.
ITIL
ITIL v5 Foundation, IT Service Management
Certified in ITIL v5 Foundation.
Southern Alberta Institute of Technology
Microsoft Power Apps, Power Apps
Completed a certification in Microsoft Power Apps.
IBM
Data Visualization and Dashboards with Excel and Cognos, Data Visualization
Completed a certification in Data Visualization and Dashboards with Excel and Cognos.
Availability
Location
Authorized to work in
Salary expectations
Skills
Interested in hiring Henil?
You can contact Henil and 90k+ other talented remote workers on Himalayas.
Message HenilGet matched with your dream remote job
Sign up now and join over 250,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!
