ShalomKarunwi

Strategy and energy analyst, Nigeria's power sector

Trained as an architect, I now read a different kind of structure: why Nigeria's electricity sector works the way it does, and what the numbers say about how it could work better.

Shalom Karunwi Photo to add: files/portrait.jpg
62.7 N-PSMI baseline index I designed 24 episodes produced NIEP-SIP two chapters
ProjectShalom Karunwi, portfolio
Based inAbuja, Nigeria
SheetA-01 of A-07
Turn toA-02 Research
A-02

Research

Published analysis of Nigeria's electricity sector

Nigeria Power Sector Intelligence Report, Q1 2026

Nextier Power, October 2026. Sole author; designer of the index.

The first edition of the Nextier Nigeria Power Sector Market Index (N-PSMI), a weighted composite of generation, transmission, commercial and customer performance built entirely on public NERC data, with a fully published methodology.

Kaduna sharply accelerated meter deployment, yet its revenue recovery stayed at 37%. Metering is a precondition for commercial recovery, not a substitute for it.

Read the report

62.7of 100, Challenged band

Commercial viability
Grid and transmission
Customer service
Generation

Nigeria Power Sector Intelligence Report, H1 2025

Nextier Power

Commercial and operational performance across all 11 distribution companies, built as a full Power BI suite.

Collection tracks metering (r = 0.73), and losses held at 19 to 20% every month: structural, not cyclical.

Read the report

Why Is Nigeria Operating Two Grids?

Daily Times Nigeria, February 2025

Nigeria runs a second, illegal grid of bypassed meters and unbilled connections. With losses near 40%, honest customers and DisCos pay for it.

Read the article

Unlocking Nigeria's Power Sector Through the Decade of Gas

Nextier Power, July 2025. Co-authored with Noelle Okwedy.

Nigeria has Africa's largest gas reserves but uses barely a quarter at home. Until the power sector pays its bills, gas will keep going abroad.

Read the report

Waste-to-Energy Models: The Nigerian Landscape

Energy Insights newsletter

I also run quality assurance for every Energy Insights article before publication.

Read on LinkedIn

Policy and advisory contributions

  • National Integrated Electricity Policy Strategic Implementation PlanAuthored the Energy Transition goal and the Governance and Communications chapter, turning Paris Agreement commitments and the Electricity Act 2023 into phased action plans, milestones and accountable institutional roles. Delivered to the Federal Ministry of Power.
  • 20-year review of Nigeria's electricity sectorCo-developed for UKNIAF (FCDO), from EPSRA 2005 to the Electricity Act 2023, combining sector-wide data analysis with interviews of 12 senior stakeholders.
  • From Policy to Practice: Nigeria's green industrialisationCoordinating a 12-month engagement with the Federal Ministry of Environment and the National Council on Climate Change, including a field assessment of the Lekki Low-Carbon Demonstration Zone.
  • Power purchase agreement transparencyMonitoring framework and baseline mapping across Abia and Enugu states for the Energy for Growth Hub.
ProjectShalom Karunwi, portfolio
DrawingResearch
SheetA-02 of A-07
Turn toA-03 Technical work
A-03

Technical work

Things I built, mostly because I wanted to

Marketing attribution for a professional services platform

Hibarr, 2026

The client's data lived in six places, and anonymous website visits never connected to the customers they became. I built an identity bridge in PostgreSQL that resolved anonymous sessions to backend user records, then compared position-based and time-decay attribution models.

Delivered as a nine-page Power BI dashboard with a full data dictionary.

  • PostgreSQL
  • PostHog
  • Power BI
  • Attribution modelling

Gold in North America

2026 World Cup prediction system, independent

A full pipeline from raw match data to live probabilities: a Poisson model blending historical form with squad quality, run through 10,000 Monte Carlo simulations of the tournament.

The app tracked its own accuracy after every matchday, scoring itself on Brier score and correct outcomes, and ran through to the final. Across all 104 matches it called the correct outcome 64.4% of the time, with a Brier score of 0.536 against 0.67 for a random guess.

Open the app or read the code.

  • Python
  • dbt
  • BigQuery
  • Streamlit
  • Monte Carlo
Live app, running in this pageOpen larger

Instant payments survey dashboard

AfricaNenda Foundation, with the World Bank and UNECA, 2026

A dashboard for 2,279 respondents across 18 African countries, letting analysts cut results by gender, age, income, economic role and country. Multi-select survey answers were unpivoted into more than 15 related tables. A second wave followed.

  • Excel Power Pivot
  • Power Query
  • Data modelling

Guided projects

Where I learned the craft. All built by hand, before AI joined my workflow.

  • Gold in Qatar

    Python, BeautifulSoup, Poisson model, 2022

    Scraped every World Cup match from 1930 to 2018 and simulated the 2022 tournament. The model picked Brazil, with France second and Argentina third. Argentina won it, which I was happy to be wrong about. Gold in North America is its grown-up successor.

    Read the write-up
  • Alfredo's Pizzeria

    PostgreSQL, Power BI

    Normalised a delivery business's orders, inventory and staff data into a relational schema, then built dashboards for sales, stock and wages. Mozzarella made up almost a quarter of ingredient cost, and the most expensive pizza to make earned just $40 in the period.

    Read the write-up
  • AtliQ Technologies

    Excel, Power Query

    An HR attendance dashboard that cleans and absorbs each new month automatically through a custom Power Query function. Tuesdays in June averaged 96% attendance, the best day for company-wide events.

    Read the write-up
  • Big Love Coffee

    Excel: XLOOKUP, INDEX MATCH, pivot tables

    Four years of wholesale coffee sales across three countries in one interactive dashboard. The 2.5kg bag led sales, and four of the top five customers had no loyalty card.

    Read the write-up
  • Ivy Plant Inc.

    Power BI, DAX, Power Query

    Year-to-date against prior-year sales for a global plant seller, built on a DAX date table, with a profitability matrix that sorts accounts by sales and gross margin.

    Read the write-up

Analysis

Power BI and DAX, Python, SQL, Excel with Power Pivot and Power Query, Tableau, SPSS, R.

Data engineering

dbt, BigQuery, PostgreSQL, Streamlit, and Python automation on the Microsoft Graph API.

Methods

Composite index design, Poisson and Monte Carlo models, attribution modelling, monitoring and evaluation frameworks.

ProjectShalom Karunwi, portfolio
DrawingTechnical work
SheetA-03 of A-07
Turn toA-04 Presentations
A-04

Presentations

Decks I designed and wrote

Seven decks, four slides each, in presentation order. Click any slide to view it full size.

Logos, client names and commercial figures removed.

Nigeria's Gas Paradox

Workshop presentation, April 2026

Why abundant gas hasn't become reliable power.

Clean Cooking Market Analysis

Strategy deck for a development partner

Market, technology and investment pathways for clean cooking.

Solar and Battery Lease-to-Own

Client briefing, May 2026

Replacing round-the-clock diesel with solar and storage.

Solar-as-a-Service Launch

Consumer product deck

Selling solar on subscription to households.

Grid Modernisation Study

Proposal deck for a climate funder

Readying Nigeria's grid for large-scale renewables.

How Africa Works

Book discussion deck, Joe Studwell

Why some economies develop and others stall.

The Great Escape

Book discussion deck, Angus Deaton

Progress, and who it leaves behind.

ProjectShalom Karunwi, portfolio
DrawingPresentations
SheetA-04 of A-07
Turn toA-05 Speaking
A-05

Speaking and media

Panels, workshops and the podcast I produce

  1. Shalom Karunwi presenting the digital and tradable services synthesis at Nextier DevFest 2026, Abuja Photo to add: files/events/devfest-2026.jpg

    The System Problem: Digital and Tradable Services

    Nextier Development Festival 2026, Abuja

    Wrote the briefing note, brought together the panel of operators, investors and policymakers, covered the session and presented its synthesis to the festival. The room overturned the brief's own framing: national positioning and trust, not capital, came out as the first constraint to unlock, with capital ranked near last.

  2. Shalom Karunwi on the panel at the 121st Power Dialogue, Abuja Photo to add: files/events/power-dialogue.jpg

    Powering the Next Generation: Youth, Innovation and Nigeria's Energy Transition

    121st Power Dialogue, The Electricity Hub, Abuja

    Panellist alongside speakers from UNDP Nigeria, Genesis Energy Group and Niveo Technology, on jobs, skills, financing and youth participation in the transition.

    Watch my part of the session, from 16:14

  3. Shalom presenting at the NIEP-SIP stakeholder workshop Photo to add: files/events/niep-sip-workshop.jpg

    National Integrated Electricity Policy Strategic Implementation Plan

    Stakeholder workshop, Federal Ministry of Power

    Presented the energy transition and governance components of the plan to a workshop attended by the Minister of Power.

  4. Shalom in a working session at the NRGI validation workshop Photo to add: files/events/nrgi-workshop.jpg

    The Gas-to-Power Paradox

    NRGI Validation Workshop, Abuja

    Presented at the validation workshop for NRGI's work on gas-to-power in Nigeria.

Connecting the Dots

A Nextier podcast hosted by Emeka Okpukpara that brings policymakers, investors and energy leaders into evidence-based conversation on Africa's energy future. As executive producer and editor, I run it end to end: guest research, concept and script, set, edit, motion graphics and distribution.

24full episodes produced, video and audio

Full playlist, plays hereOpen on YouTube
ProjectShalom Karunwi, portfolio
DrawingSpeaking and media
SheetA-05 of A-07
Turn toA-06 About
A-06

About

From buildings to systems

Architecture taught me to read space, structure and constraint, and the relationship between a design and how people actually live inside it. I was always more interested in what drove the decisions than in the decisions themselves.

That curiosity took me to data, and data took me to energy. At Nextier Power I work across the electricity value chain, from generation and grid performance to distribution reform, tariff policy and transition planning, and I try to turn regulatory data into findings a decision-maker can act on.

Outside work, I build things for the pleasure of building them. Nigeria's infrastructure problems are ones I care about personally, not just professionally, and I think the country's energy transition is ultimately a story about people.

Shalom Karunwi on a site visit, in discussion with an engineer Photo to add: files/about.jpg
  1. ArchitectureObafemi Awolowo University, 2018 to 2023
  2. Quality assuranceTest IO, from 2023
  3. Junior data analystNOIPolls, 2023 to 2024
  4. Data analystNextier Power, 2024 to 2025
  5. Energy research, policy and data analystNextier Power, 2026 to now

Certifications

  • Data Analytics Professional CertificateGoogle, 2022
  • Data Analyst NanodegreeUdacity, 2023
ProjectShalom Karunwi, portfolio
DrawingAbout
SheetA-06 of A-07
Turn toA-07 Contact
A-07

Contact

Research, roles and collaboration

Working on a problem in Nigeria's energy or infrastructure sector?

I'm glad to talk about research, roles or collaboration. Email is the fastest way to reach me.

Email me
ProjectShalom Karunwi, portfolio
DrawingContact
SheetA-07 of A-07
Back toA-01 Home