Michael Zhang
Toronto, ON ·
michael100824@gmail.com
Scan contact card
Big Data Engineer @ data.ai (previously known as App Annie)
A data guy.
A cavadoole owner.
Welcome to my personal website. Click here for my latest resume.
Certifications
Socialization
Skills
Programming Languages
- Python
- SQL
- Java
- VBA
Data Eng & Database
- Matillion
- DBT
- Docker
- Snowflake
- Airflow
- PostgreSQL
- MySQL
Big Data & Cloud
- AWS
- Hadoop
- PySpark
- Hive
Others
- Bash
- CI/CD
- GIT
- Docker
- Jira
- Looker
Experience
Technical Blogger
Xiaohongshu (小红书)
- Shared my knowledge and experiences about data engineering/ science
- 300+ followers and growing
Aug 2022 - Present
Big Data Engineer
data.ai (previously known as App Annie)
- Designed, developed, and maintained data pipelines to ETL from various sources into a centralized data warehouse using Python, Airflow and Databricks
- Collaborated with cross-functional teams to design and implement data models and ETL processes for new data sources
- Implemented data quality checks and monitoring systems to ensure the accuracy and reliability of data
- Developed and maintained data documentation and data dictionaries to improve the efficiency of the data team
Jan 2022 - Present
Data Engineer
NielsenIQ
- Created and managed data ingestion and processing workflows using Matillion, Snowflake, DBT and Airflow
- Automated report generation for clients using Amazon Redshift and Snowflake with Python and SQL
- Conducted data analysis and provided insights to support business decisions using tools like Tableau and Looker
Jul 2021 - Jan 2021
Technical Analyst
Canadian Tire Corp
- Created automated and scheduled ETL pipeline using Python for daily data updates
- Conducted data analysis on large datasets using SQL and Python to support business decision-making processes
- Built analytics tools that utilize the data pipeline to provide actionable insights into inventory, sales and other key business performance metrics and present in Power BI
May 2019 - Jul 2021
Data Analyst
Analyticsmart
- Designed and implemented a web-scraping ETL pipeline to scape product information from BC liquor Store website
- Analyzed large, complex data sets using SQL, Python, and Excel to identify trends and patterns in customer behavior, sales performance, and marketing effectiveness
- Developed and maintained data models to support business forecasting, predictive modeling, and scenario planning
Feb 2019 - Apr 2019
Business Analyst (PEY)
Canadian Tire Corp
- Created and maintained Access databases and Excel tools using VBA to reduce manual work
- Collaborated with cross-functional teams to identify business opportunities and created data-driven recommendations to improve business outcomes
- High Five Award (excellent employee award) winner at August 2016
Sep 2015 - Aug 2016
Education
University of Toronto
Master of Engineering
Industrial Engineering
2017 - 2018
University of Toronto
Bachelor of Applied Science in Engineering Science
Engineering Science - Infrastrucutre
2012 - 2017
Suon International Academy
Ontario High School Diploma
2011 - 2012
Wait! There's more..
See all Blogs for more examples!