about.

Hey, Cousin!

I'm Mustafa Idris. I work with data, business, and strategy — building the systems and analytics that turn information into something stakeholders can actually act on.

I started in Accounting, but data pulled me further upstream: from reading the numbers to understanding where they come from, what they mean, and what they can tell you about where a business should go next.

Outside of work, I'm interested in media, sports, and building things.

skills

SQL, Python, dbt, Airflow, Airbyte, n8n, PostgreSQL, GCP, Snowflake, Power BI, Looker, Dune, DHIS2, ODK.

experience

Presently: Senior Analytics Engineer at Laguna Labs (Index.fun, Sayso) building analytics solutions for structured investment products.

Previously: RedRose , Kyshi , and The JJC App .

I'm currently listening to

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

work.

Streamlined Analytics Pipeline Using PostgreSQL, dbt, Airbyte and Looker Studio

A fully integrated modern data stack leveraging PostgreSQL for storage, dbt for transformation, Airbyte for data movement and Looker Studio for dynamic visualizations.

dbt Airbyte PostgreSQL Looker Studio Docker

Code Dashboard

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

Code

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

Code

dbt-Powered Pipeline for Users Engagement, Transactions Pattern & Growth

A fully automated data pipeline for tracking and analyzing user growth, transactions and referrals using dbt, PostgreSQL, and Power BI.

PostgreSQL dbt Python Power BI

Code

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

View

Onchain Analytics and Insights

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

Flipside Dune Bitquery

View

blog.

What the Heck is a Semantic Layer?

And Why It's the Key to Making Data Simple, Accessible and Useful.

Read here

3 Common dbt Mistakes And How to Avoid Them.

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

Read here

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

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

Read here