Author Image

Hi, I am Zach

Zach Renwick

Analytics Engineer

I am a passionate data professional with extensive SQL, data modeling and data visualization skills. I make videos on YouTube exploring data tools and blog about data and analytics topics

Skills

Experiences

1
Analytics Engineering with dbt (course/bootcamp)
co:rise

Nov 2021 - Dec 2021, Remote

co:rise accelerates your professional growth through live, small group courses created and taught by top experts.

Responsibilities:
  • Designed and developed a mock data warehouse using dbt and PostgreSQL
  • Utilized jinja SQL templating
  • Created automated lineage graphs and docs for our data model project

Power BI Developer (contract role)
West Fraser

Jul 2021 - Present, Vancouver, BC / Remote

West Fraser is one of the largest lumber companies in the world.

Responsibilities:
  • led reporting migration from existing internal reporting tool to Power BI Premium
  • led training sessions for end users on Power BI development and end use
  • created high-level architecture planning documents to plan out Power BI central dataset use in organization
2

3
Power BI Developer (contract role)
lululemon

Aug 2020 - Jun 2021, Vancouver, BC / Remote

lululemon is one of the world’s leading athleisure brands.

Responsibilities:
  • Utilized Power BI and Snowflake data warehouse to transform data into enterprise-grade business intelligence and analytics solutions.
  • Development work at lululemon was focused on creating data models and dashboards for the e-commerce team (sales, web and inventory analytics)
  • Developed a global e-commerce sales and visits semantic model to replace an existing on-premises Qlikview reporting solution
  • Developed a near real-time e-commerce sales dashboard, which enabled up-to-the-hour sales insights
  • Delivered an Omni order fulfillment report, which highlighted orders not meeting delivery and pickup SLAs

BI Developer
Best Buy Canada

Sep 2019 - Aug 2020, Vancouver, BC / Remote

Best Buy Canada’s mission is to enrich the lives of customers through technology.

Responsibilities:
  • Supported the digital intelligence and eCommerce teams with reports, dashboards and analysis of web and business data.
  • Developed data pipelines with Python
  • Supported ongoing delivery of automated reports via SSRS, Power BI and Adobe Analytics
  • Conveyed insights to users quickly and effectively using data visualizations and tables
  • Supported analysts on digital intelligence team with data they need to conduct ad-hoc analysis
  • Raised the eCommerce department overall analytic IQ through formal training, workshops, insights meetings and presentations to senior leadership
4

Recent Posts