Struggling with data processing inefficiencies, Dermalogica collaborated with Toptal to migrate more than 150 workflows to SQL Server Integration Services (SSIS).
Challenge: Dermalogica wanted to streamline its data processing capabilities and reduce delays and inaccuracies in data delivery by migrating from Alteryx to a new ETL infrastructure. These inefficiencies hindered timely decision-making and increased costs.
Solution: Toptal implemented a tailored ETL architecture strategy, replacing more than 150 Alteryx workflows with SSIS to refine processes, reduce licensing costs, and simplify ongoing maintenance. Collaborating closely with Dermalogica, Toptal ensured seamless integration and enhanced reporting accuracy.
Outcome: By reducing Alteryx licensing costs, Dermalogica achieved significant savings while improving performance. The new system is easy to maintain and supports growth with its enhanced design. The data migration enabled timely, accurate sales reporting, empowering Dermalogica’s leadership with actionable insights.