Learn Data Skills

Connor Macdonald


Columbia Business School


My Portfolio Highlights

My New Course

Introduction to Python

My New Project

Dr. Semmelweis and the Discovery of Handwashing

My New Track

Associate Data Analyst in SQL (previously Data Analyst in SQL)

Passionate problem-solver, leveraging data to drive impactful solutions.

My Work

Take a look at my latest work.


Introduction to SQL


Intermediate SQL


Introduction to Python

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

thredUP | Jun 2022 - Aug 2022

Data Science Intern

- Conducted A/B testing of sales data in SQL and PySpark to assess the profitability and effectiveness of thredUP’s loyalty program increasing customer engagement 43% and profit per buyer 2% - Built cluster model predicting customer LTV. Implemented by PMM increasing promotional targeting of high value customers - Presented LTV model and business insights to non-technical and C-Suite audiences with visuals created in matplotlib & seaborn - Built KPI and North Star Metric data flows in SQL, Looker, and Python to evaluate business impact of new loyalty product - Collaborated on cross-functional team of PMs, PMMs, and engineers by informing promotional strategy through analysis of customer buying behavior and translated large datasets into actionable insights for team
Show More

Columbia Business School | Aug 2021 - Present

MBA Candidate


Auditor General of Canda | Jun 2018 - Aug 2021



Employment and Social Development Canada (ESDC) | Sep 2017 - Jun 2018

Policy Analyst


Statistics Canada | May 2016 - Dec 2016

Data Analyst, Intern

As an Intern at Statistics Canada, I quickly learned a new database coding language and used large financial data sets to code fixed capital stock into Canada's quarterly GDP statistics. Key Achievements: - Utilized Excel, SQL, and FAME to calculate fixed capital stock for quarterly GDP using large structured financial datasets (hundreds of thousands of rows) - Wrote ETL script for cleaning, loading, and analyzing data that saved 15+ hours of manual tasks per month - Wrangled data and creatively resolved gaps through coding and problem solving such as estimating amount spent on bridges in Quebec based on historical analysis and comparables when no data was available - Developed training manual explaining economic depreciation model used to code fixed capital stock in quarterly GDP

My Education

Take a look at my formal education

Master of Business Administration - MBA, Data Science & Strategy in Data ScienceColumbia Business School | 2023
Master of Public Administration - MPA, Public Policy & Economics in EconomicsCarleton University | 2017
Bachelor of Arts - BA, History in HistoryTyndale University | 2015

About Me

MBA candidate at Columbia Business School focusing on the intersection fo Data Science & Business. Graduating May 2023 and looking for full-time employment in the US (OPT Stem Eligible).

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free