29 Jan Client Story: How a retailer transformed it’s cloud enterprise data platform
Client Story: How a Retailer transformed it’s cloud enterprise data platform using Snowflake and DBT
THE CHALLENGE
The challenge for this major Australian retailer was to support the group digital business objectives of driving the membership loyalty program, modernising the online retailing web presence and leveraging an enterprise data platform for groupwide advanced insights and analytics.
OUR BRIEF
- Architect, design and build the group wide cloud data platform
- Design and build a data driven, flexible and low maintenance data management framework
- Incorporate the latest cloud automation and orchestration approaches
- Design for multiple ingestion approaches and cloud technologies
- Design and build the relevant data marts for end user consumption
OUR APPROACH
- Complete a comprehensive Snowflake solution architecture phase to support the business case, end user requirements and project roadmap for the enterprise data platform
- Worked closely with the business divisions to determine data ingestion and transformation patterns
- Incorporated modern security and data privacy practices into the platform
- Worked closely with the data science and advanced analytics teams to determine key use cases
KEY OUTCOMES
- Established an extremely robust, scalable and efficient platform to ingest disparate sources of customer data across multiple business divisions
- Introduced architectural best practices using Snowflake and DBT for ingestion, transformation and integration of data
- Enabled near real time ingestion of data incorporating modern automation and orchestration techniques
- Enabled cross business-division integration of data to support customer loyalty and personalisation business objectives
- Delivered on time and on budget