Zach Renwick

Data & analytics engineer with extensive SQL, data visualization and data modeling skills. I help people (and machines) make better decisions by creating insightful and actionable datasets, powering dashboards and predictive digital experiences.

I also love being active: riding bikes, strength training, and playing pickleball.

Projects

Experience

Senior Analytics Engineer @ Aritzia

Jul 2022 - Present | Vancouver, CA

Senior engineer within analytics community of practice focused on building digital analytics data infrastructure and reverse ETL data activation capabilities. Key accomplishments:

• designed and developed a clickstream web analytics data mart which enabled full customer lifecycle insights, from initial ad click to website visit to sales and returns analysis
• integrated Google Analytics Universal Analytics data with Google Analytics 4 to enable YoY traffic analysis
• developed dataset which powered digital fit predictor tool, generating more accurate product recommendations and additional sales revenue
• mentored other analytics engineers and data analysts on SQL, GitHub and dataform best practices

Power BI Developer @ West Fraser

Jul 2021 - Jul 2022 | Vancouver, CA

Contract consulting position focused on migrating enterprise business intellgience suite from Oracle BI to Power BI Premium. Key accomplishments:

• migrated existing legacy reporting suite onto Power BI Premium by creating centralized datasets and self serve tools
• conducted teach outs to data team on Power BI modeling best practices and self serve use cases
• reduced key Power BI dataset refresh times

Power BI Developer @ lululemon

Aug 2022 - Jul 2021 | Vancouver, CA

Contract Power BI consulting role focused on migrating business intellgience suite from Qlik to Power BI Premium. Key accomplishments:

• migrated existing North America eCommerce sales reporting suite onto Power BI Premium
• partnered with eCommerce finance department to establish self serve reporting datasets

BI Developer @ Best Buy Canada

Sep 2019 - Aug 2020 | Vancouver, CA

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

Volunteer Work

Building Committee Member | Capilano Students' Union
2021 - Present
Alumni board member helping alma mater students' union build a new SUB on campus