Specialising in bridging the gap between raw data infrastructure and production-grade business intelligence. I build reliable and scalable data solutions that power enterprise analytics. By applying engineering best practices to data transformation and modelling, I create downstream data environments that are efficient, governed and trusted by business stakeholders.
Hi, I'm Tess Ogamba 👋🏾
Analytics Engineer
Core Analytics toolkit
SQL • dbt • Microsoft Fabric • Power BI • DAX • Snowflake • Tableau • Python • Data Modelling • ETL • Data quality
Case Management BI & Reporting Pipeline
Production data pipeline for 3M+ records, combining SQL, Power Query transformation, dimensional modelling, DAX, data-quality controls and PBI dashboards to deliver reliable operational and performance reporting. Reduced annual reporting turnaround by over 50%, moving core preparation from multiple weeks to a matter of days.
Retail Customer & Sales Analytics
Built a tested retail data pipeline in dbt Cloud and Snowflake, transforming raw customer, order and payment data into dimensional models for customer and sales analysis in Tableau.
Financial Performance Analytics
Analysed 23 financial metrics across 12 public companies using BigQuery and reusable SQL models, with data-quality tests and an interactive Looker Studio dashboard covering growth, profitability and financial risk.
Selected data and analytics work. Full code on GitHub.
Featured Analytics Projects
Frameworks & Publications
A Data & Analytics Audit Framework for Nonprofits
A practical 23-page framework for assessing data maturity, governance, data quality and analytics capability, with a structured roadmap for implementation and improvement.
Expertise
Analytics Engineering & Data Modelling
Designing scalable data transformation layers, dimensional models, data-quality controls and reusable analytical datasets using SQL, dbt and modern data platforms.
Building reliable reporting and analytical solutions that turn complex data into clear insight, from automated self-service dashboards to broader data synthesis.
Commercial & Customer Analytics
Business Intelligence & Reporting
Analysing acquisition, engagement, customer behaviour, revenue and performance trends to diagnose blockers and identify the factors driving growth and commercial value.
About Tess Ogamba
I’m a UK-based Analytics Engineer specialising in bridging the gap between raw data infrastructure and production-grade business intelligence. I build reliable and scalable data solutions that power enterprise analytics. By applying engineering best practices to data transformation and modelling, I create downstream data environments that are efficient, governed and trusted by business stakeholders.
My technical focus centres on the modern enterprise data stack, backed by hands-on implementation experience and verified expertise as a Microsoft Certified: Fabric Analytics Engineer Associate (DP-600).
Core Technical Stack
◦ Data Transformation & Modelling: SQL, dbt, PySpark, Dataflow Gen2
◦ Platform Architecture: Microsoft Fabric, Medallion Lakehouse architecture, Delta Lake, Data Warehousing
◦ Semantic Layer & BI: Power BI, advanced DAX, Direct Lake
◦ Engineering Rigour: Git, CI/CD deployment pipelines, data quality and governance
What I bring to a data team
◦ Microsoft Fabric Implementation: Designing end-to-end Fabric environments supporting ingestion, transformation, semantic modelling and business intelligence.
◦ Code-First Rigour: Experience developing structured SQL and PySpark transformations alongside low-code tools.
◦ Performance Engineering: A strong focus on transformation and refresh performance, scalable star schemas and the reverse-engineering of complex EAV source systems with large datasets.
◦ Business Alignment: Seven years of analytical and commercial experience, enabling me to connect engineering decisions with reporting needs and business outcomes.
From the Blog
Practical articles on analytics engineering, business intelligence, data quality, reporting, commercial analytics and better decision-making.