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 Kingdom10.2023
Bachelor of Arts - History & International Studies
University of Ilorin
Nigeria10.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 TimeWork Location
RemoteHybridTimeline
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
Similar Profiles
Bianca CozmaBianca Cozma
Administrative & Finance Assistant at Summit Trust International SAAdministrative & Finance Assistant at Summit Trust International SA
Sarah RoushSarah Roush
Disabilities and Mental Health Specialist at SUMMIT Early LearningDisabilities and Mental Health Specialist at SUMMIT Early Learning
Steven MullenSteven Mullen
Lead Teacher at Summit Early Learning CenterLead Teacher at Summit Early Learning Center
NIRANJAN VASUDEVAN PRADEEPNIRANJAN VASUDEVAN PRADEEP
LINE COOK at LEVY RESTAURANTLINE COOK at LEVY RESTAURANT
Savreetpal Singh BasraSavreetpal Singh Basra
Food Server at Osmow's ShawarmaFood Server at Osmow's Shawarma