about work blog

.Mustafa Idris.

Analytics Engineer

works.

Streamlined Analytics Pipeline: PostgreSQL -> dbt -> Airbyte -> Looker Studio

This repository showcases an end-to-end modern data stack implementation, enabling efficient data pipelines and interactive visualizations.

 dbt
 Airbyte
 PostgreSQL
 Looker Studio
 Docker

End-to-End ELT Pipeline with Airbyte, dbt, Dagster, and BigQuery

An ELT pipeline integrating Airbyte, dbt, Dagster, and BigQuery for automated data extraction, transformation, and loading into BigQuery.

 Airbyte
 dbt
 Dagster
 BigQuery
 Docker

Data Modeling with dbt Core and Snowflake

This project implements a complete data model for an e-commerce company using dbt Core and Snowflake. It transforms raw CSV data into a well-structured, analytics-ready model within two Snowflake databases: raw and analytics.

 dbt
 Snowflake
 Python
 Shell

Binance API Data Pipeline with Apache Airflow

This repository outlines an efficient data pipeline built with Apache Airflow and Python to effortlessly acquire, process, and store cryptocurrency data from the Binance API.

 Binance API
 Airflow
 Python
 EC2
 S3

Dashboards and Reports

This contains some selected dashboards, visualization and reports built with business intelligence tools like Power BI, Tableau, Looker Studio etc.

 Power BI
 Looker Studio
 Tableau

Onchain Analytics and Insights

This portfolio showcases the various DeFi projects I've worked and contributed to on the blockchain.

 Flipside
 Dune
 Bitquery

about.

about me

Hey, Cousin!

I'm Mustafa Idris, an Analytics Engineer passionate about building scalable data platforms, models and delivering actionable intelligence that drives business value. With a background in Accounting, I've expanded my skill set to dive headfirst into the exciting world of Data, Analytics Engineering and Business Intelligence.

When I'm not chasing data points and insights, you'll find me indulging in a world of hobbies that add a sprinkle of excitement to my life. My current interests span across tech, entertainment and sports.

skills

Programming: SQL, Python
Tools & frameworks: dbt, Airflow, Airbyte
Databases: PostgreSQL, MySQL
Cloud: GCP, AWS
BI/Visualization: Power BI, Looker
Onchain: Flipside, Dune
Others: CI/CD

experience

Presently: I'm deep in Analytics Engineering at Metrics DAO, uncovering insights from onchain data.
Previously: Developed scalable data infrastructure at RedRose, an innovative e-cash transfer solution for the humanitarian sector.
Prior to that: Built and optimized data pipelines at Kyshi, a neobank for Africans.
Initially: Converted data into actionable insights at The JJC App, a neighborhood app that connects people to SMEs in their location.

I'm currently listening to

Got a question, project or just looking to collaborate on something impactful?
Feel free to reach out at mustafaotaru@gmail.com

blog.

3 Common dbt Mistakes And How to Avoid Them.

A Guide to Avoiding Common Mistakes in Data Transformation and Modeling with dbt.

Analyzing Marvel Vs DC Rivalry: What Does The Data Say?

An Exploratory Analysis of Marvel Vs DC Rivalry using Microsoft Excel and Power BI.