A fully integrated modern data stack leveraging PostgreSQL for storage, dbt for transformation, Airbyte for data movement, and Looker Studio for dynamic visualizations.
An ELT pipeline integrating Airbyte, dbt, Dagster, and BigQuery for automated data extraction, transformation, and loading into BigQuery.
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.
A fully automated data pipeline for tracking and analyzing user growth, transactions, and referrals using dbt, PostgreSQL, and Power BI.
This contains some selected dashboards, visualization and reports built with business intelligence tools like Power BI, Tableau, Looker Studio etc.
This portfolio showcases the various DeFi projects I've worked and contributed to on the blockchain.
Hey, Cousin!
I'm Mustafa Idris, an Analytics Engineer who enjoys building robust data pipelines, designing scalable data models, and transforming raw data into actionable intelligence that drives growth. With a background in Accounting, I've expanded my skill set into the exciting world of Data, Analytics Engineering and Business intelligence, bridging the gap between numbers and strategy.
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, media and sports.
Programming: SQL, Python
Tools & frameworks: dbt, Airflow, Airbyte
Databases: PostgreSQL, MySQL
Cloud: GCP, Snowflake, AWS
BI/Visualization: Power BI, Looker
Onchain: Flipside, Dune
Others: CI/CD
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
And Why It’s the Key to Making Data Simple, Accessible and Useful.
A Guide to Avoiding Common Mistakes in Data Transformation and Modeling with dbt.
An Exploratory Analysis of Marvel Vs DC Rivalry using Microsoft Excel and Power BI.