The primary goal was to develop a bespoke solution following the client’s recent purchase of Looker to allow for scalability, PII data handling, a bespoke login portal for the internal teams to improve end user experience and training on the newly developed solution.

The client needed a bespoke data platform to enable them to handle large volumes of PII data while vigorously restricting access in accordance with GDPR legislation. This had to be secured from source, through to ingestion and the end reporting layer to protect and restrict this data at various stages of the data flow while maintaining secure access to those that needed it.

There was a lack of expertise within the internal teams around the technologies being used to help restrict this content and provide row-level security and a secure model.

There was an additional need to refine the end user experience within the business and improve the way in which they consumed data and reports while enforcing best-in-class governance throughout.