Hello, I'm

Abdirahman Ali.

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

dbt Looker SQL Python Snowflake PostgreSQL
Abdirahman Ali

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-analytics
NBA Analytics Dashboard preview

A dbt pipeline processing 70+ years of NBA stats through staging, intermediate, and mart layers. Calculates 15+ advanced metrics including True Shooting %, PER-36, and usage rates.

dbt PostgreSQL Python

Toronto Parking Analytics

34.7M+ parking ticket records from 2006 to present

View live →
Top infractions — all time
Park — Prohibited Time8.2M tickets
Meter Expired5.7M tickets
Street Cleaning4.1M tickets

Ingests 34.7M+ Toronto parking tickets via the CKAN API into ClickHouse, transformed through a dbt medallion architecture with 19 tests.

dbt ClickHouse Python

Lead Pipeline

AI-powered B2B lead scoring and routing system

View on GitHub →
Pipeline stages
IngestWebhook / CSV
ScoreClaude API
Route & AlertHot leads

Modular lead pipeline: ingest via webhook or CSV, deduplicate, score with Claude AI, and route to reps. FastAPI backend with Neon Postgres and GitHub Actions automation.

Python FastAPI Claude API

Daily Job Listings Digest

Automated job scraping and email digest

View on GitHub →
Sample digest — March 4, 2026
Receptionist (Contract)~$19–$22/hr
Office AdministratorCompetitive
Administrative Assistant~$20–$25/hr

Daily job digest via JSearch API — filtered by role and location, formatted and sent 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 →