Tess Ogamba
Data Analyst | Business Intelligence | Commercial Analytics
Tech stack:
SQL • Power BI • dbt • Snowflake • BigQuery • Python • Tableau • Data Studio • Claude
Case management analytics pipeline
End-to-end pipeline on a live case management database: SQL layer across 1M+ rows, cleaned staging layer, star schema model and 60+ DAX measures behind executive dashboards.
Retail analytics: dbt and Snowflake
Raw data to business-ready marts with a star schema model, documented lineage and 18 automated data quality tests.
Retail sales dashboard: tableau
Interactive sales dashboard on the dbt pipeline: revenue trends, customer lifetime value, order status and payment mix.
Financial analytics: BigQuery
Staging views and five analytical models covering revenue growth, margins, CAGR and risk across 12 public companies, 2009 to 2023.
Financial dashboard: Data Studio (formerly Looker Studio)
Interactive dashboard connected to BigQuery: CAGR rankings, margins, year-on-year growth and risk indicators, with company and year filters.
Selected data and analytics work. Full code on GitHub.
Featured Analytics Projects
What I Do: My Expertise
Business Intelligence
I design and build reporting systems, interactive dashboards and KPI frameworks that transform complex data into actionable insights. From dimensional data models to executive reporting, I build solutions that help leaders monitor performance and make informed decisions.
I optimise customer acquisition funnels, onboarding journeys, and multi-channel growth initiatives. Through conversion analysis, cohort tracking, and experimentation, I help businesses turn customer/user behaviour data into measurable revenue and audience reach.
Data Analytics
Growth Analytics
I analyse operational and commercial data to identify trends, improve processes and support better decision-making. My work focuses on translating complex datasets into practical recommendations that create measurable business impact.
About Tess Ogamba
I’m a Data Analyst with a BSc in Biostatistics and seven years' experience applying statistical, operational and commercial analytics to solve business problems. I design reporting systems, build data models, develop automated dashboards and translate complex data into meaningful insights that support better decision-making.
My background is in research, enterprise analytics and entrepreneurship, giving me a practical understanding of how data influences business performance, operations and customer behaviour. Whether improving reporting pipelines, analysing performance or designing analytics frameworks, I focus on delivering solutions that create measurable business impact.