Summary
Overview
Work History
Education
Skills
Certification
Work Availability
Timeline
Generic

Gabriel Ogunleye

Data Analyst
Ottawa,Ontario

Summary

Experienced data analyst professional equipped to drive impactful results. Skilled in data analysis, database management, dashboard building and data governance. Strong focus on team collaboration and adaptability to changing needs. Reliable and results-driven with a proven ability to translate complex datasets into actionable insights and strategies.

Overview

8
8
years of professional experience
1
1
Certification

Work History

Data Manager

Summit Learning Trust UK
01.2025 - Current
  • Led the MTRS project, automating HR training compliance reporting using Power Automate and Power Apps, and reduced manual follow-ups by 60%.
  • Conducted trend and competitor analysis, similar to retail analytics, to influence policy and budget planning.
  • Developed workforce planning dashboards in Power BI, tracking training expirations, participation, and compliance trends across 8 institutions.
  • Built SQL and Python pipelines for personnel data quality checks, improving reporting accuracy and reducing turnaround by 45%.
  • Collaborated with HR and governance stakeholders to define business rules and create audit-ready reporting frameworks.
  • Spearheaded enterprise data profiling, identifying and resolving quality gaps across 8 institutions; improved data accuracy by 45%.
  • Authored source-to-target mappings and metadata standards aligned with Microsoft Purview.
  • Built Power BI dashboards to identify and understand data trends to be leveraged in management’s strategic decision-making.
  • Trained governance and ops teams, improving data-handling consistency and compliance by 30%.
  • Collaborated with cross-functional teams to translate insights into actionable recommendations.
  • Trained team members in best practices for data handling, improving overall productivity and data integrity.
  • Collaborated with cross-functional teams to identify data requirements and ensure proper integration within the system.
  • Enhanced data accuracy by implementing robust data validation and quality control processes.
  • Streamlined data management workflows for increased efficiency and reduced processing time.
  • Provided expert guidance on regulatory compliance matters related to data storage, usage, and disposal.
  • Spearheaded initiatives to automate repetitive tasks, freeing up staff time for more value-added activities.

Business Administrator – Analytics

Swarco UK
05.2024 - 12.2024
  • Created executive-facing HR and finance performance dashboards using SQL and Power BI.
  • Automated monthly KPI reports, cutting report generation time by 50%.
  • Supported HR data validation and developed documentation for system upgrades and policy audits.
  • Created daily and monthly reporting workflows using Power Automate and SQL, enhancing decision-making at senior levels.
  • Assisted in interpreting financial KPIs and presented performance summaries to non-technical stakeholders.
  • Documented process controls and supported end-user testing across regulatory-facing outputs.

Customer Insight Specialist

The Adecco Group
02.2024 - 05.2024
  • Analysed large-scale customer datasets from Salesforce and exported transactional data for reporting using Python/Power Query.
  • Contributed to forecasting logic design for talent placement, producing executive insights used in strategy formulation.

Data Analyst

VFD Group PLC
11.2020 - 09.2022
  • Developed SQL and Python-based validation pipelines to detect and cleanse anomalies in financial datasets.
  • Collaborated with stakeholders to translate business rules into structured transformation logic.
  • Automated monthly health-check reports, reducing QC labour by 50%.
  • Improved alignment of cleaned datasets with audit-ready BI reporting environments.
  • Built pricing models and conducted time-series forecasting to support product strategy and pricing elasticity studies.
  • Designed SQL pipelines for KPI reporting and performance tracking across departments.
  • Produced ad hoc commercial reports for executive teams, highlighting product performance trends.

Business Intelligence Specialist

Access Bank PLC
10.2019 - 10.2020
  • Designed validation frameworks for structured imports (CSV/XML/SQL), ensuring compliance with governance standards.
  • Defined column-level quality thresholds and Power BI alert triggers.
  • Provided workforce data insights for internal audits and regulatory reviews.
  • Participated in UAT and deployment phases for HR analytics systems and automation upgrades.
  • Created customer and product performance dashboards using Power BI, driving improvements in sales campaigns.
  • Performed data discovery and cleansing to ensure data integrity across performance analytics systems.
  • Delivered insights that informed marketing, segmentation, and operational strategy.
  • Reduced manual data entry errors by automating routine tasks using SQL scripts and ETL tools.
  • Designed customized data collection models for specific visualization tasks.
  • Developed intelligence-sharing dashboards, providing company-wide access to collected data.
  • Designed customised data collection models for specific visualisation tasks. analyses, ensuring optimal return on investment.

Junior Data Analyst

Hamilton & George Limited
04.2017 - 09.2019
  • Streamlined reporting processes by automating routine tasks using Python and Excel macros.
  • Strengthened internal data governance practices by helping to develop and implement policies related to data storage, access, and retention.
  • Reduced manual processing time with automation scripts, allowing more focus on strategic initiatives within the department.
  • Increased efficiency in data extraction by utilising SQL queries for retrieving relevant information from databases.
  • Participated in project planning meetings, ensuring that data requirements were clearly defined and understood by all team members.
  • Improved forecasting accuracy through rigorous analysis of historical trends, incorporating external factors such as seasonality and market conditions into predictions.

Education

Master of Science - Business Analytics & Big Data

University of Dundee
United Kingdom
10.2023

Bachelor of Arts - History & International Studies

University of Ilorin
Nigeria
10.2016

Skills

  • SQL
  • Power BI
  • Python
  • GraphQL
  • Oracle
  • R
  • Power Automate
  • Tableau
  • DAX
  • Looker
  • Power Apps
  • Power Query
  • Azure Data Services
  • Macros / VBA
  • BigQuery
  • C
  • Databricks (In Progress)
  • PySpark (In Progress)
  • Snowflake
  • SQL proficiency
  • Statistical analysis
  • Data security
  • Data quality assurance
  • Data cleansing
  • Data modeling
  • NoSQL databases
  • R programming
  • Database administration
  • Agile methodology

Certification

Google Data Analyst Certificate – Coursera (In Progress)

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Work Type

Full TimeContract WorkGig WorkPart Time

Work Location

RemoteHybrid

Timeline

Data Manager

Summit Learning Trust UK
01.2025 - Current

Business Administrator – Analytics

Swarco UK
05.2024 - 12.2024

Customer Insight Specialist

The Adecco Group
02.2024 - 05.2024

Data Analyst

VFD Group PLC
11.2020 - 09.2022

Business Intelligence Specialist

Access Bank PLC
10.2019 - 10.2020

Junior Data Analyst

Hamilton & George Limited
04.2017 - 09.2019

Master of Science - Business Analytics & Big Data

University of Dundee

Bachelor of Arts - History & International Studies

University of Ilorin
Gabriel OgunleyeData Analyst