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