Essentially building an ETL protocol using Stitch data, BigQuery as DWH to pull our data from our backend (Mongo, Firebase) and unify metrics cross the organization. From here, we segmented & scrubed the data based on a strict transformation system in SQL to ensure we had metric consistency cross all departs, segmented this into seperate data-sets and built two inlooks into our data. One for Operational Teams, one for Finance Team & Investors.

Key parts of the project:

Unifying data using ETL cross Mongo & Firebase

Building multiple transformation layers in BigQuery to compute relevant metrics

Push data to relevant visualization/export tools (Looker / Metabase/CSV export)

Built dashboards to visualize data in each respective tool

Company: Packaly.com | Sustainable logistics provider

BigQuery, Data Architecture, Data Management, Data Pipelines, Data Visualization, ETL, Looker, Mobile Analytics, MongoDB, Analytics, Google Cloud / GCP, SQL