safari connect analytics
by Eugine Ndire
$9
Clean messy Kenyan transport booking data and run PostgreSQL analytics for revenue, routes, and drivers.
1
0
I am a Data Analytics Engineer. I extract data from raw CSVs and APIs, flatten the JSON responses into tables and transform features into their correct datatypes. I load the data into Database engines like PostgreSQL, then ingest them into warehouses as Bronzes custom schemas overlaying the medallion architecture infrastructure. I use dbt to build the staging, marts and rpts models that are then visualized using Looker. Operational bottlenecks and data qualiity checks are deployed using CI/CD pipelines and dbt tests. I am looking forward to working with teams.