John J. Lawal

Product & Growth Data Architect | Africa’s Sovereign Data Solutions Architect

Abuja10000 NGN/hourMember since 5 May 2026

SQLPythonNumPyExcelTableauPower BIGitHypothesis TestingK-means ClusteringSPSSSmartPLSFakerBeta RegressionEGARCH ModelingEfficient Frontier

Hire their services

Request a quote with no obligation

data analystData ArchitectAdvanced SQLPython (Pandas, Scikit-learn)microsoft excelA/B Testing

About

Analytical and results-driven Data Analyst combining a solid foundation in Accounting & Finance with advanced technical execution in SQL, Python, and Business Intelligence. Proven track record of transforming complex datasets into actionable reporting systems that drive operational efficiency by 25-40%. Committed to supporting stakeholder decision-making through clear data storytelling and optimized dashboarding.

Experience

Founding Data Consultant at Crane JLA Consults (2024-11 – Present)

Spearheaded data analysis for 50+ diverse clients, automating reporting flows that resulted in cost savings of 15-30%. Translated complex statistical findings (SPSS, SmartPLS) into clear, non-technical insights for business stakeholders.
Developed Python scripts for automated data mining and synthetic data generation (using Faker and NumPy), streamlining data preparation workflows and ensuring 100% data integrity for simulation models.
Integrated UN and World Bank datasets to perform K-means clustering and demographic segmentation, correlating population shifts with social welfare adaptation metrics (Health Expenditure, Unemployment, and Inequality).

Freelance Data Analyst - Independent Consultant at Various Clients (2022-01 – Present)

Successfully delivered 30+ end-to-end data analysis gigs for international clients, utilizing a robust technical stack including Python, R, SQL, Excel, Power BI, and Tableau.
Designed and executed A/B testing frameworks for a digital News Blog to optimize user engagement; performed hypothesis testing and significance analysis in Python to drive a 15% increase in click-through rates.
Conducted sophisticated portfolio analysis and risk management (Efficient Frontier, Beta Regression, and EGARCH modeling) for multi-asset portfolios (e.g., Apple, Microsoft, JPMorgan), providing deep insights into volatility and return trade-offs.