about work blog

.Mustafa Idris.

Data & 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 Data Pipeline for Financial Data on AWS

This comprehensive end-to-end data engineering project leverages AWS services to seamlessly integrate, process, and analyze financial data from the Polygon API.

 Polygon API
 Airflow
 S3
 AWS Glue
 Athena
 Redshift

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

On-Chain 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, a Data Analytics Engineer passionate about building scalable data platforms and delivering actionable intelligence that drives business value. With a background in Accounting, I've traded my calculator for a keyboard, diving headfirst into the exciting world of Data, Business Intelligence and Analytics Engineering.

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: Python, SQL
Tools & frameworks: dbt, Airflow, Airbyte, Spark, Kafka
Warehousing: Bigquery, Snowflake, Redshift
Databases: PostgreSQL, MySQL
Cloud: GCP, AWS
BI/Visualization: Power BI, Metabase, Tableau, Looker
On-Chain: Flipside, Dune
Others: Terraform, Docker, CI/CD

experience

Presently: I'm deep in Analytics Engineering at Metrics DAO, uncovering insights from on-chain 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.