> Hello, World.

I'm Eghosa Osayame.

> _

4+ years building scalable ELT pipelines, dimensional data models, and BI solutions on Snowflake, Azure, AWS, and GCP — turning raw, multi-source data into stakeholder-ready assets.

View Projects Resume LinkedIn GitHub
01. Background

About Me

Analytics Engineer and Data Engineer with 4+ years of experience building scalable data pipelines, dimensional data models, and BI solutions across cloud-native platforms.

Currently at Data2Bots, I design layered ELT architectures — staging, intermediate, and mart layers — on Azure, AWS, and GCP, aligned with dbt best practices and powering downstream dashboards and executive reporting.

I have a strong bias toward data quality, documentation, and models that people actually trust. I bridge raw systems and business decision-making — and I care deeply about the last mile between a pipeline and an insight.

Eghosa Osayame
02. Tech Stack

Skills & Tools

Data Modelling & Transformation

Dimensional Modelling Star / Snowflake Schemas dbt-style Layered Transforms Staging → Intermediate → Mart SQL Views & Aggregations Data Normalisation

Cloud & Warehouses

Snowflake Azure (ADF, Synapse, Data Factory) AWS (S3, Glue, Redshift, Kinesis, Lambda) Google Cloud Microsoft Fabric OneLake PostgreSQL

ETL / ELT Pipelines

End-to-End Pipeline Design Structured Data Ingestion Semi-structured & Unstructured Python (pandas, NumPy) SQL-based ELT Pipeline Orchestration

BI & Visualisation

Power BI DAX Power Query Tableau Looker Studio Self-service Analytics Dashboard Design

Programming & Query

Advanced SQL CTEs & Window Functions Query Optimisation Python R Terraform Git / GitHub

Data Quality & Governance

Validation Frameworks QA Checks & Audits Multi-source Consistency Confluence Miro Lucidchart
03. Selected Work

All Projects

End-to-End Data Pipeline with Microsoft Fabric

Full pipeline: real-time ingestion, OneLake storage, Synapse transformations, Power BI reporting, and automated Teams alerts via Data Activator.

Data EngineeringPySparkMicrosoft FabricPower BI
View Case Study → Watch on YouTube ↗

Real-Time IoT Energy Monitoring System on AWS

24-hour AWS challenge: real-time streaming with IoT Core, Kinesis, Lambda, and Timestream. Terraform IaC and cost-optimized architecture.

AWSKinesisIoT CoreTerraform
View Case Study →

Adidas ETL — Excel to PostgreSQL

Config-driven Python ETL: extract from Excel, transform (dates, rounding), log the pipeline, load into PostgreSQL.

PythonPostgreSQLETLLogging
View Case Study →

Wealth Data ETL Pipeline (Python + SQLite)

End-to-end ETL extracting, transforming, and loading wealth data into SQLite with ipython-sql for in-notebook querying.

PythonSQLiteETLJupyter
View Case Study →

Northwind Traders Power BI Project

Full BI build on the classic Northwind dataset — relational data model, time intelligence DAX, and a Figma-prototyped executive dashboard.

Power BIDAXData ModelingFigma
View Case Study →

Teghs Company Sales Dashboard (Power BI)

Star schema data model, DAX measures (YTD, MoM growth, running totals), and executive-ready Power BI dashboard.

Power BIDAXStar Schema
View Case Study →

SQL Queries for Data Analysis

GitHub repo of SQL across PostgreSQL and MSSQL — cleaning, aggregations, CTEs, window functions, and data quality checks.

SQLPostgreSQLWindow FunctionsCTEs
View Case Study →

Chocolate Sales Power BI Dashboard

Power BI dashboard tracking chocolate sales by product, region, and salesperson with period-over-period DAX comparisons.

Power BIDAXPower Query
View Case Study →

U.S. Restaurant Data Analysis

Analyzed raw restaurant data across all 50 U.S. states. SQL + Excel for cleaning, Tableau for an interactive geographic dashboard.

SQLExcelTableau
View Case Study →

Malaria Data Analysis (2007–2017)

Cleaned and visualized 10 years of African malaria data. Tableau choropleth maps, trend analysis, and a full PDF report.

SQLTableauPublic Health
View Case Study →

500+ Data Visualizations — Mustard Insights

500+ visuals across healthcare, football, entertainment, and global issues — with a focus on African data stories.

Power BIFigmaAdobe Illustrator
View Case Study →

Tableau Dashboards Across Key Sectors

Collection of Tableau dashboards covering hospital performance, malaria incidence, and healthcare resource allocation — prototyped in Figma.

TableauFigmaHealthcare
View Case Study →
04. Career

Experience

Nov 2025 — Present Current

Analytics / Data Engineer

Data2Bots — Abuja, Nigeria

Designing and implementing scalable ELT pipelines on Azure, AWS, and Google Cloud, transforming multi-source structured, semi-structured, and unstructured datasets into analytics-ready layers. Building layered data models (staging → intermediate → mart) aligned with dbt best practices, powering downstream BI dashboards and executive reporting. Leading data quality initiatives including validation frameworks, transformation audits, and standardisation processes across Snowflake-style cloud warehouses.

AzureAWSGCPSnowflakeELTData ModellingSQLPython
Mar 2025 — Oct 2025

Database Engineer & BI Officer

Havosoft

Designed and maintained ETL pipelines integrating data from diverse sources, enforcing quality standards for analytics-ready datasets. Built interactive dashboards and performance reports in Power BI and Tableau, delivering real-time insights for executive decision-making. Modelled and analysed large, complex datasets to drive strategic initiatives; partnered with developers, product managers, and executives to align data models with business needs.

ETLPower BITableauData ModellingSQL
Sep 2024 — Feb 2025

Data Analyst Instructor (Remote)

Poshem Technologies

Taught beginner-to-intermediate SQL and data modelling to a pan-African audience, covering real-world transformation, BI reporting, and analytics best practices. Developed structured course materials emphasising practical data pipeline design and analytical thinking.

SQLData ModellingBI Reporting
Apr 2024 — Feb 2025

Data Science Instructor

Abuja Data School

Delivered training on Python, SQL, R, and Power BI with emphasis on data cleaning, transformation, and dashboard development. Guided learners through end-to-end data pipeline projects and introduced cloud environments and scalable analytics tooling.

PythonSQLRPower BI
Nov 2021 — Apr 2024

Data Analyst (Remote)

Mustard Insights

Extracted, cleaned, and modelled large datasets using SQL and Python. Built automated dashboards in Power BI and Tableau to communicate business insights. Conducted market research and predictive modelling to support strategic decisions across economic, corporate, investment, and health sectors.

SQLPythonPower BITableau
Apr 2021 — Feb 2022

Graduate Intern — NYSC

National Agency for the Control of AIDS (NACA)

Supported data collection, cleaning, and visualisation for public health programs. Developed dashboards to track HIV campaign performance and participated in prevention programming and conferences.

SQLTableauExcelPublic Health
05. Credentials

Certifications

Microsoft

Azure Administrator Associate

Verify ↗
Microsoft

Fabric Analytics Engineer Associate

Verify ↗
Microsoft

Azure Data Engineer Associate

Verify ↗
Microsoft

Fabric Data Engineer Associate

Verify ↗
AWS

AWS Certified Cloud Practitioner

Verify ↗
Google

Google Data Analytics Certificate

Verify ↗
CNCF

Kubernetes & Cloud Native Associate (KCNA)

Verify ↗
06. Education

Education

2016 — 2020

BSc Biochemistry

Landmark University, Kwara State

07. Get In Touch

Let's Build Something.

Open to data engineering roles, analytics engineering positions, and interesting collaborations. Let's talk.

eghosa.osayame@yahoo.com LinkedIn GitHub