Abubakar Aluko
Senior Data Analyst | BI Engineer
Lagos
Summary
Results-driven data and BI engineering enthusiast with extensive hands-on experience in data collection, analysis, and pipeline development within the e-commerce sector. Expertise in SQL for data querying and transformation, complemented by proficiency in building scalable ETL/ELT workflows using Azure Data Factory. Demonstrated ability to design and optimize data models and dashboards with Power BI, Bold BI, Metabase, and QlikView to provide actionable insights that drive business success. Committed to precision and problem-solving, consistently delivering high-impact analytics that support strategic decision-making and foster business growth.
Overview
9
9
years of professional experience
5
5
Certifications
Work History
Senior Data Analyst
OmniRetail Africa
12.2021 - Current
- Created interactive dashboards using data visualization tools, facilitating real-time insights for stakeholders and driving data-driven decisions.
- Utilized programming languages such as Python and SQL to perform data manipulation and analysis, streamlining analytical workflows.
- Assisted in the development of a centralized data repository to improve accessibility and collaboration among teams.
- Led data integration projects, ensuring seamless connectivity between various data sources and improving reporting accuracy.
- Developed stored procedures and integrate with Bold BI and Metabase reports
- Optimized database performance by fine-tuning SQL queries, indexing strategies, and schema designs.
Data Analyst || Data Engineer
Konga Online Shopping Limited
01.2020 - 12.2021
- Build data pipelines with Azure Data Factory and Synapse Pipelines for ETL & ELT data orchestration.
- Analyze and interpret trends in large data sets.
- Integrate voluminous data from multiple sources into the Data warehouse (Azure Synapse Analytics).
- Build dashboard, reports and visualization to aid management decision-making.
- Maintained existing ETL workflows and optimizing the Data warehouse.
- Report automation and improving data reliability, efficiency and quality.
Sales Data Analyst
Konga Online Shopping Limited
05.2018 - 12.2019
- Compile, analyze, and report sales performance to the head of department.
- Provide actionable insights to guide the sales and marketing teams.
- Review past sales data to determine trends in productivity.
- Assess market and competitors data to identify areas where the company can improve productivity.
Quality Assurance Analyst
Yudala Limited
01.2018 - 04.2018
- Evaluate call center calls through use of call recording system and CRM applications.
- Investigate customer complaints and non-conformance issues.
- Analyze data to identify areas for improvement in the quality system.
- Prepare reports to communicate results of quality inspection activities to management.
Online Order Fulfillment Executive
Yudala Limited
01.2017 - 01.2018
- Process high volume of daily orders placed online by customers, using Order Management System (OMS).
- Receive and ship orders within set time deadlines.
- Extensive knowledge on inventory to support the preparation of detailed online invoice.
- Liaise with logistic teams regarding customers’ orders and merchants returns.
Education
Masters Degree - Information Technology
University of Lagos
Lagos, Nigeria01.2018
Post-Graduate Diploma - Computer Science
Federal University of Agriculture
Abeokuta, Nigeria01.2014
Bachelor of Science - Computer Science
Olabisi Onabanjo University
Ijebu Igbo, Nigeria01.2009
Skills
Programming Languages: SQL (SQL Server, MySQL, PostgreSQL), Python
Data Visualization: Power BI, Qlikview, Metabase, Bold BI
Data Management & Modeling: Data Modeling, Data Cleaning, Data Transformation, Data Integration
Data Warehousing Platforms: Azure Synapse Analytics, Snowflake
ETL & Workflow Automation: Azure Data Factory, Data Pipelines, Automated Reporting, ETL Process Optimization
SQL optimization
Report automation
Certification
The Complete SQL Bootcamp
Timeline
Senior Data Analyst
OmniRetail Africa
12.2021 - Current
Data Analyst || Data Engineer
Konga Online Shopping Limited
01.2020 - 12.2021
Sales Data Analyst
Konga Online Shopping Limited
05.2018 - 12.2019
Quality Assurance Analyst
Yudala Limited
01.2018 - 04.2018
Online Order Fulfillment Executive
Yudala Limited
01.2017 - 01.2018
Post-Graduate Diploma - Computer Science
Federal University of Agriculture
Bachelor of Science - Computer Science
Olabisi Onabanjo University
Masters Degree - Information Technology
University of Lagos