Problems I have been brought in to fix.
Advisory engagements alongside my full-time roles. Clients are described rather than named.
- Problem
- Reporting was archaic and disconnected. The databases existed, but were poorly understood.
- What I did
- Diagnosed what data existed and where it lived.
- Set up Metabase as the core reporting tool.
- Worked with the backend engineers to build the pipeline from source systems to a reporting layer.
- Outcome
- Reporting infrastructure built from near zero.
- Problem
- Analytics ran on a legacy SAS platform, and the product team needed analytics it could work with.
- What I did
- Worked as data engineer, product analyst and analytics engineer.
- Built product analytics dashboards, then helped design a new data platform architecture.
- Migrated the SAS platform to BigQuery and dbt, with Looker for consumption, and owned the full dbt layer: staging, intermediate and marts.
- Outcome
- The legacy SAS platform replaced by BigQuery, dbt and Looker, with one analytics engineering layer behind the reporting.
- Problem
- Go-to-market and advertising data was fragmented across tools, and there was no defined data function.
- What I did
- Unified the go-to-market and advertising data across Stitch, Segment and BigQuery, with dashboards on top.
- Worked with the CPO to define the data function, a two-year roadmap and the key hires.
- Outcome
- A clear plan for the data function, which led to a conversation about joining full-time as Head of Data.
- Problem
- Sellers were not matching with the right buyers.
- What I did
- Ran a six-month, hands-on engagement diagnosing why matches were going wrong.
- Outcome
- Helped the CEO hire a Director of Analytics to own the roadmap.
I have also worked on engagements in agriculture, e-commerce, tourism and weather data.