🤹 SKILLS 🤹
SQL
7+ years experience with:
– Database design and advanced querying.
– Experienced in many platforms including BigQuery, MySQL, SQL Server, SQLite, and MS Access including GoogleSQL, PostgreSQL, T-SQL.
– Relational algebra and entity-relationship diagrams.
Python
5+ years experience in:
– Importing, manipulating, cleaning, analyzing, and visualizing datasets.
– Environments such as Colab, Jupyter Notebooks, and PySpark.
– Packages including numpy, pandas, scikit-learn
– Visualization packages, including matplotlib and seaborn.
– Completed many tutorials on datacamp and codecademy
R
5+ years of experience with:
– Importing, manipulating, cleaning, analyzing, and visualizing datasets.
– Analytics packages such as dplyr, tidyverse,
– Data visualization packages such as ggplot2, ggvis, lattice, and plotly
– Interactive packages such as shiny, rbokeh, and flexdashboard
– Completed many tutorials on datacamp and codecademy
Spreadsheets
10+ years experience:
– Advanced formulas, VBA, macros, and external data connections
– Pivot tables, charts, slicers, and other reporting/dashboard functions
– Google Sheets, Excel, Open Office Calc
Data Visualization
7+ years of experience in:
– Building dynamic and intuitive reports and dashboards tailored to stakeholders and non-technical audiences
– Platforms including Looker, Looker Studio, Tableau, Power BI
– Python and R visualization packages
💼 EXPERIENCE 💼
Manager, Online Grocery Product Information
Loblaw Digital – Toronto, ON, Canada
December 2024 – Present
Senior Analyst, Online Grocery Product Information
Loblaw Digital – Toronto, ON, Canada
October 2022 – December 2024
● Created dashboards and reports to drive sales conversion and improve search performance.
● Extracted, cleaned, and analyzed product, transaction, and customer data in order to answer questions and derive insights.
● Maintained an active catalog of 100k products to comply with business rules and compliance requirements.
● Utilized numerous platforms including Google Cloud Platform, SAP, Qlik, Teradata, PowerBI, and Microstrategy
● Supported numerous teams and presented complex analysis to stakeholders
Senior Data Analyst
Mindshape Creative Brand Marketing – Oakville, ON, Canada
September 2018 – October 2022
● Developed databases, and data pipelines using MS Access, Excel, SQL Server and WebFocus.
● Created individualized tools, reports and metrics based on business insights tailored to client specifications.
● Revamped business processes for data and reporting to improve visualizations, reduce colleague toil, and minimize expenses.
🎓 EDUCATION 🎓
Toronto Metropolitan University
Certificate in Data Analytics, Big Data, and Predictive Analytics
Intensive four-month program for full-time students at the G. Raymond Chang School of Continuing Education, followed by an independent research project.
Technical Training Provided Included:
Languages: R, SQL, NoSQL, Regular Expression, XML, SPSS
Database Systems: SAS, MySQL, SQLite, SQLSolutions, MongoDB, MS Access
Machine Learning Software: Weka, IBM Watson
Visualization Systems: Tableau, ggplot2
Analytics Tools: Hadoop HDFS, Hadoop MapReduce, Hive, Pig, Spark
O/S: Windows, Linux, Ubuntu, Unix
Jonathan Gruber-Benaich 