Efe Oroh

Logo

Data Analytics | BI Dashboards | Automation | Applied Economics

Contact: EfeogheneOroh@gmail.com

View My GitHub Profile

Data Analytics Specialist

Technical Skills: Power BI, SQL, R, Python, SAS, MATLAB

Data Analyst specializing in Data Visualization, Report Automation, and scalable data analysis workflows using Power BI, R, Python, and SQL.


Education

University of Alberta — Edmonton Alberta
Bachelor of Arts, Economics


Experience
Junior Economist @ Government of Alberta (May 2024 – Present)
Junior Economist @ Government of Canada (Jan 2024 – May 2024)
Data Science Intern @ Deloitte Consulting (May 2022 – Aug 2022)

Analytics Projects
Energy
R • Energy Market Analytics • Data Visualization

Analysis of Canada’s crude oil trade vulnerability examining tariffs, market access constraints, and reliance on U.S. imports.


R • Energy Infrastructure Analytics • Data Visualization

Analysis of Canada’s oil transportation infrastructure examining pipeline capacity, export routes, and production flows influencing Alberta royalty revenues.


R • Energy Systems Analytics • Data Visualization

Analysis of Canada’s electricity generation mix and emissions trends across provinces.


Real Estate Analytics
Power BI • Real Estate Analytics • Data Visualization

Interactive dashboard analyzing property performance, tenant trends, and operational metrics for real estate management decision-making.


R • Data Visualization • Analytics • Machine Learning

1st Place Winner and Cash Prize. Competition involving Masters+ and some Bachelors students tasked with analyzing City of Edmonton datasets to examine the impact of Covid-19 on Edmonton’s housing market. I led Section 5 — the core descriptive analysis, conducting large-scale exploratory analysis that identified the key structural changes in housing demand and price dynamics, which subsequently informed the predictive models built by the team.


Tableau • Data Visualization • Market Analysis • Storytelling

Interactive Tableau story analyzing global Airbnb market trends, pricing dynamics, geographic distribution, and listing behavior to uncover actionable insights for hosts and investors.


Music Analytics
Power BI • Data Visualization • Analytics

Interactive Power BI dashboard analyzing Spotify streaming performance and listening trends.


Automation
R • Automation • Data Analysis

Automated report generation for 18 industries processing 2M+ rows of data and generating multiple industry reports simultaneously.


Python • Web Scraping • Automation

Automated the extraction and cleaning of 1M+ rows of greenhouse gas emissions data used in a GHG analytics dashboard. The workflow fully automated the data refresh pipeline for a dashboard requiring annual updates, eliminating manual data collection and ensuring reproducible updates each reporting cycle.


Indigenous Statistics Data Pipeline Automation
R • Automation • Data Engineering

Automated the extraction and processing of 5M+ rows of Indigenous statistical data used in multiple recurring analytical reports.


Skills

Software Tools: Python, R, SQL, SAS, Tableau, Power BI, DAX, Statistics, Excel, Time Series, Databricks, Predictive Analytics, Prescriptive Analytics, A/B Testing, Data Analytics, Prompt Engineering, Jupyter Notebook