Ibanga I.

I build reliable analytics platforms on BigQuery and dbt, turning fragmented data into trusted, decision-ready reporting.

I specialise in marketing, ecommerce, and revenue analytics, helping teams automate reporting, unify cross-channel data, improve attribution, and accurately measure ROAS.

Core stack: BigQuery, dbt, SQL, GA4, Google Ads, Meta Ads, Shopify, Fivetran, Python, Power BI, and Looker Studio.

SELECTED RESULTS

▪ Ecommerce brand: Replaced spreadsheet reporting with a BigQuery + dbt pipeline and Power BI dashboards. Reporting dropped from days to hours while the client scaled to $2M+/month in paid media with reliable ROAS tracking.
▪ US marketing agency: Consolidated 40+ ad accounts into one warehouse and implemented attribution models. Enabled weekly client reporting that reduced billing disputes and improved upsell conversations.
▪ Lead-gen company: Built a GA4 + server-side measurement pipeline and Looker Studio dashboards. Improved conversion tracking accuracy and identified duplicate conversions that were distorting campaign performance.

WHAT I BUILD

▪ Analytics engineering: SQL, dbt models, testing, documentation, and reusable KPI definitions
▪ Data warehouses: BigQuery architecture, data modelling, partitioning, and cost optimisation
▪ ELT pipelines: Fivetran, custom Python ingestion, APIs, Cloud Functions, and Cloud Run
▪ Marketing measurement: GA4, server-side events, attribution, ROAS, CAC, CPA, LTV, and conversion analysis
▪ BI & dashboards: Power BI and Looker Studio for executive, marketing, ecommerce, and operational reporting
▪ Integrations: Google Ads, Meta Ads, Shopify, Amazon Ads/SP-API, HubSpot, Salesforce, Klaviyo, Stripe, TikTok Ads, LinkedIn Ads, Microsoft Ads, and more

HOW I WORK

I start with the business decisions your reporting needs to support, then trace each KPI back to its source.

From there, I design the warehouse and data models, build and test the pipelines, define consistent business logic, and create the reporting layer. You get working deliverables throughout the project, plus documentation and a clean handover.

I bring 10+ years of analytics experience and have built 100+ dashboards across marketing, ecommerce, operations, and executive reporting.

LET'S TALK

Tell me what you're trying to measure, where your data currently lives, and what you don't trust about your reporting.