Hello, I'm

Abdirahman Ali.

Senior Analytics Engineer. I build the infrastructure that turns raw data into decisions.

dbt Looker SQL Python Snowflake PostgreSQL

I'm a data professional with 5+ years of experience building analytics infrastructure at tech companies. My work spans the full stack: data modeling in dbt, warehouse design, and the pipelines connecting all of it.

Most of what I build ends up in the hands of non-technical teams. The goal is always the same: make it easy for people to answer their own questions, without filing a ticket and waiting a week.

Away from work, I'm deep in NBA statistics. Deep enough that I built a full data pipeline to analyze 70 years of player data. You can explore it below.

I'm also getting deeper into AI tooling. Looking to take on more projects with Claude Code and explore how it can be used to solve harder, more interesting problems.

Abdirahman Ali

NBA Analytics Pipeline

End-to-end data pipeline covering 70+ years of NBA history

View live →
abdirahman2ali.github.io/nba-dashboard
NBA Analytics Dashboard preview

Built a transformation pipeline processing NBA player statistics through a medallion architecture (staging, intermediate, marts). Handles multi-team trades and edge cases across every season since 1949. Calculates 15+ advanced metrics including True Shooting %, PER-36, and usage rates to produce analytics-ready datasets for downstream reporting.

dbt PostgreSQL Python

Daily Job Listings Digest

Automated job scraping and email digest via JSearch API

View on GitHub →

Built a Python automation that pulls fresh job listings daily from the JSearch API (RapidAPI), filters by location and role criteria, formats results into a styled HTML email with job title, company, location, salary range, and apply links, then sends the digest automatically via Gmail SMTP.

Python JSearch API Gmail SMTP

LookML Measures Explained: Count, Sum, Average, and Everything In Between

Read →

LookML Dimensions Explained: Types, Labels, Drill Fields, and Links

Read →

LookML Views: The Essential Building Blocks

Read →

Speed Up Your Looker Dashboards: Practical Tips for Performance

Read →
All articles on Medium →