Personal details

Blosher B. - Remote data engineer

Blosher B.

Based in: 🇨🇦 Canada
Timezone: Pacific Time (US & Canada) (UTC-7)

Summary

Data engineer with significant experience designing end-to-end solutions from ETL pipelines, APIs, PySpark notebooks, databases, and other software products. I am highly dedicated and driven to exceed management expectations. I am seeking an opportunity to showcase my skills and solve data challenges.

Work Experience

Analytics Engineer
Hamilton Village Health Centre | Mar 2024 - Present
Python
SQL
Analytics
Microsoft Power BI
Airflow
RESTful API

· Work with key stakeholders to design a data strategy that aligns with business objectives.

· Create data pipelines in Airflow to consolidate data from multiple sources into a centralized cloud DW.

· Create ETL processes to transform and clean data into denormalized tables in Power BI.

· Use data to provide actionable insights and KPIs for management to optimize business operations.

Data Engineer
Govt of Canada - Canada School of Public Service (CSPS) | Sep 2021 - Nov 2023
Python
Apache Spark
Data analytics
Microsoft Power BI
Data Modelling
Data Pipelines
Azure Data Factory
Azure synapse analytics

· Successfully migrated to an Azure Synapse Analytics DW to improve performance, functionality, and costs.

· Researched and designed a new data model based on Kimbell best-practices that combined multiple data sources, eliminated data silos across the organization, and simplified the report creation process.

· Developed data pipelines in Azure Data Factory to orchestrate the ETL process, conduct data quality testing via SQL scripts, and log all metadata for trouble-shooting and compliance purposes.

· Used CI/CD tools & Git in Azure DevOps to publish code following agile software development principles.

Education

Universite de Montreal
Master's degree・Data Science
Sep 2018 - Apr 2021
University of British Columbia
Bachelor's degree・Science
Sep 2010 - Apr 2015

Personal Projects

Analyzing Airbnb data with DBT & SnowflakeIconOpenNewWindows
2024
SQL
Snowflake
DBT
- create end-to-end pipeline using DBT
Django CRM ApplicationIconOpenNewWindows
2024
Python
Django
- create a backend CRM appplication using the django framework

Certifications & Awards

Snowflake SnowPro Core Certification
Snowflake
Azure Power BI Analyst Associate (PL-300)
Microsoft