MARK OLAFARE

Senior Data Analyst
Lagos, NG.

About

Results-driven Senior Data Analyst with 6+ years of experience in payments, fintech, and digital products, adept at leveraging advanced analytics to drive growth and operational efficiency. Expertly translates complex data into actionable, product-shaping insights for senior stakeholders, with deep expertise in SQL, Python, Power BI, and Tableau. Proven ability to build scalable self-service analytics and foster cross-functional partnerships, making a significant impact on product development and business strategy.

Work

10Alytics
|

Senior Data Analytics Associate

Canada, Canada

Summary

Leads advanced data analytics initiatives, architecting robust self-service dashboards and conducting in-depth experimentation to drive significant operational and revenue improvements.

Highlights

Architected and maintained enterprise-grade self-service dashboards using Power BI & Tableau with advanced DAX, row-level security, and optimized data models, tracking over £5M+ in quarterly revenue across multiple business units.

Designed and analyzed A/B tests and post-launch experiments, building performance dashboards that contributed to a 15% reduction in operational costs with measurable ROI improvements.

Developed comprehensive KPI frameworks for acquisition, retention, churn, and revenue, translating complex business questions into actionable insights and establishing a single source of truth across product, marketing, and engineering teams.

Engineered scalable SQL pipelines and semantic layer models for BI reports, significantly improving data accuracy and reliability by 40% and ensuring consistent, trusted metrics across teams.

Led executive-level data storytelling, translating complex analytical outputs into board-ready reports that directly influenced product and growth strategy decisions.

Grupp
|

Power BI Developer – Payments & Settlements

Lagos, Lagos, Nigeria

Summary

Managed end-to-end analytics for payments reconciliation and settlement, developing KPI frameworks and engineering data pipelines to ensure high data integrity and drive operational efficiency.

Highlights

Owned end-to-end analytics for payments reconciliation and settlement monitoring across 29 banks and payment processors, driving an 80% reduction in issue resolution time through real-time visibility dashboards.

Designed KPI frameworks and anomaly detection workflows to track SLA adherence and settlement accuracy, identifying over #400M+ in revenue leakage and settlement inefficiencies within six months.

Engineered complex SQL transformations and data validation pipelines, ensuring high-integrity data for reports used by operations, finance, and executive stakeholders, enabling 100% SLA compliance through proactive monitoring.

Translated payments and settlement data into clear, executive-ready visuals that directly shaped product roadmap decisions, partner strategy, and process improvements, forming the core of a product analytics function.

Built multivariate variance analyses and performance trend models that informed critical business decisions regarding payment product optimization and partner prioritization.

Airtel Nigeria (Chathub)
|

Data & Reporting Analyst – Customer Experience

Lagos, Lagos, Nigeria

Summary

Developed interactive dashboards and conducted root-cause analyses to monitor customer engagement and service performance, translating insights into data-driven recommendations.

Highlights

Built interactive dashboards, enabling stakeholders to monitor customer engagement, service performance, and operational KPIs in a high-volume digital environment supporting millions of users.

Conducted root-cause analyses through drill-through reports, contributing to a 30% reduction in average call handling time and achieving measurable improvements in customer satisfaction scores.

Analyzed customer behavior and service trends to support product and operational improvements, translating findings into data-driven recommendations that directly informed feature prioritization.

Partnered with product and customer success teams to embed reporting into continuous improvement workflows, ensuring analytical insights translated into measurable business outcomes.

Education

Genius Business School

Diploma

Data Analytics (SQL, Power BI, Tableau, Excel)

Languages

English

Certificates

Microsoft Power BI Data Analyst Associate

Issued By

Microsoft

SQL Nanodegree

Issued By

Udacity

Data Analysis and Visualization

Issued By

3MTT

Skills

SQL & Data Engineering

Advanced SQL (CTES, Window Functions, Joins), ETL Pipelines, Data Modeling, PostgreSQL, MySQL, SQL Server.

Python & Statistics

Python, Pandas, SciPy, Predictive Modeling, Regression Analysis, Time Series Forecasting, Data Mining.

Experimentation

A/B Testing, Multivariate Testing, Experiment Design, Post-Launch Impact Analysis, Hypothesis Testing.

Visualization & BI

Tableau, Power BI, Looker, DAX, M Language, Self-Service Dashboards, KPI Frameworks.

Product Analytics

Acquisition & Retention Metrics, Churn Analysis, Revenue Analytics, Opportunity Sizing, Growth Analytics.

Collaboration & Process

Stakeholder Engagement, Agile/Jira, Report Automation, Data Storytelling, GDPR, Google Workspace.

Projects

Forecasting & Predictive Modeling for Customer Query Volumes

Summary

Built predictive models in Python (Pandas, SciPy) to forecast customer query volumes and identify demand patterns.

Revenue Leakage Detection - Payments Analytics

Summary

Applied statistical variance and anomaly detection techniques to payments data across 29 financial institutions.

Customer Issue Trend Analysis & Retention Impact

Summary

Conducted multi-region root-cause analysis of recurring customer issues using clustering and trend modeling.

A/B Testing Framework - Digital Product Experimentation

Summary

Designed and analyzed A/B experiments for digital product features, building dashboards to surface experiment results and statistical significance.