Ibanga I.

Analytics Engineer | BigQuery, dbt, ELT, Looker Studio & Power BI

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. I'll help you identify where the data pipeline, business logic, or reporting layer is breaking down and the most practical way to fix it.