Tom Tailor

Migration and modernisation of the Redshift Data Warehouse with Data Vault 2.0

Starting point

  • Tom Tailor is a casual lifestyle brand from Hamburg and employs 2,950 people
  • No uniform business metrics due to manual processes
  • Complex data modeling and poor maintainability
  • Lack of unified data ETL pipelines
  • Potential for improvement in the connectivity of data sources.
  • Unnecessary database tables impair system overview and storage efficiency

Role in the project

  • Data Architect, AWS Infrastructure Expert, Data Engineer (ETL), Project Manager
  • Data modeling with Data Vault 2.0
  • Managing data from various sources with Glue, Lambda, and S3
  • Setting up a test environment to ensure seamless integration of changes

Features/Project outcome

  • Single-Point-of-Truth of business logic and KPIs
  • Improvement of data visualization and analysis through Graphomate integration in Tableau reports
  • Demand-driven rebuilding of the data model
  • Building an improved AWS infrastructure and implementing CI/CD pipelines
  • Integration of a new authorization concept
  • Reduction of manual effort through automation of the loading process

Customer benefits

  • Data-driven business decisions can be made more accurately
  • Improved data visualization and analysis leads to higher user satisfaction
  • Faster and more reliable releases
  • Improved security and access control through the integration of a new authorization concept
  • Higher scalability and flexibility in storing and organizing data
Lars Ritter | Senior Manager