Tess Ogamba
Data Analyst | Business Intelligence | Commercial Analytics
Tech stack:
SQL • Power BI • dbt • Snowflake • BigQuery • Python • Tableau • Data Studio • Claude
Featured Analytics Projects
Selected data and analytics work. Full code on GitHub.
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.
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 of experience applying statistical, operational and commercial analytics to solve complex business problems. I design reporting systems, build data models, develop automated dashboards and translate complex data into actionable insights that support better decision-making.
My background spans 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, my focus is on delivering solutions that create measurable business impact.