Faisal RehmanAI ENGINEER
← All selected work

SHARE Mobility · Case study

The data foundation behind a mobility business.

A company-wide data warehouse and analytics platform built from scratch for SHARE Mobility’s internal teams and client companies.

My role
Built the warehouse and data platform; led infrastructure delivery
Period
2021–2022 and 2024–2025
Technology
Redshift · Matillion · Snowflake · Spark · S3 / Athena · QuickSight
99.9%Daily pipeline reliability
40+QuickSight dashboards
30 minutesData freshness SLA

The data problem

Operational and business data lived across separate systems. Internal teams and client companies needed consistent reporting, current data, and a reliable foundation for decisions.

What I built

I built the company-wide warehouse and analytics platform from scratch, starting with Redshift and Matillion and extending the data platform across Snowflake, Spark, and S3/Athena.

The work combined data integration, dimensional modeling, pipeline reliability, and standardized business metrics. Sources included mobility operations, vehicle telemetry, and business systems.

Operational sources→Data pipelines→Shared warehouse→Client & team analytics

I built 40+ QuickSight dashboards used by 5 internal teams and 60+ external client companies. The broader data platform also supported productized analytics.

Reliability and reach

The platform achieved 99.9% daily pipeline reliability with a 30-minute freshness SLA, and query latency decreased 35%.

Alongside the data work, I led infrastructure modernization and resolved 80+ security vulnerabilities, helping SHARE achieve SOC 2 certification and support enterprise requirements.

NEXT CASE STUDY

Rich vehicle routing. Real operating constraints.

Continue reading
07 WHAT’S NEXT

Hard problems.
Meaningful work.

I’m interested in teams bringing capable AI into the real world. Let’s talk about AI engineering, agent reliability, and products worth building.