Home
Portfolio
Company
Contact
Dr Barbara Strum
9 Months
Fashion and lifestyle
Europe and UAE
%201.png)
.png)
Dr. Barbara Sturm is a globally renowned skincare brand that blends cutting-edge science with luxury wellness. Known for its anti-inflammatory approach and high-performance products, the company operates multiple e-commerce websites and beauty SPAs worldwide. It offers a range of skincare solutions rooted in molecular science, catering to clients seeking personalized, clinical-grade beauty and wellness treatments.
Cloud-Based Data Warehouse Integration
Automated ETL and Workflow Orchestration
Interactive BI Dashboards
Agile Project Collaboration Environment
Data Engineers
BI Analysts
Cloud Infrastructure Specialists
Agile Project Managers
9-Month Fixed-Term Contract
Eliminating Data Gaps, Inefficient Reporting, and Weak Customer Understanding
Varying formats and fragmented sources across SPAs and websites.
.png)
Needed seamless configuration of Airflow, Dataproc, and Looker Studio
.png)
Required flexibility and adaptability during the 9-month window.
The team designed a unified analytics environment using BigQuery as the data core. Airflow orchestrated job scheduling, while Dataproc processed high-volume datasets. A Google Cloud Functions layer supported automation, and dashboards were developed in Looker Studio using agile delivery to track KPIs. Project collaboration was maintained through JIRA and Confluence, ensuring visibility.
Project collaboration was maintained through JIRA and Confluence, ensuring visibility and agile delivery.
Strategic questions that informed execution:
● How do we centralize digital and in-store data for unified reporting?
● What workflow automation reduces time-to-insight?
● How can we future-proof the analytics layer for business scale?
● What tools support agile delivery without sacrificing technical depth?
End-to-End Data Pipeline With Scalable Insights and Team Alignment
The project involved a robust warehouse design and data modeling strategy using BigQuery to seamlessly accommodate both historical and real-time data from multiple channels.
ETL orchestration was managed through Airflow and Dataproc, enabling scheduled ingestion and transformation jobs capable of handling high data volume and velocity. For business intelligence, Looker Studio was used to deliver interactive, multi-dimensional dashboards segmented by location, service type, and time, providing actionable insights.
To ensure alignment across engineering, BI teams, and stakeholders, collaboration was streamlined using JIRA and Confluence, fostering transparency and cross-functional coordination throughout the project lifecycle.
Reduction in manual data handling and reporting overhead
Cost savings from automation and optimized resource allocation
Faster decision-making enabled by real-time, accessible dashboards
Improvement in cross-team collaboration through unified workflows and tools
DataRopes.ai is a global technology partner which delivers end to end services like data engineering, data analysis, data science and AI & ML
Reviewed on
150 E B St Lbby # 1810
1106 A, 11th floor, Haly Tower,
Sector R DHA Phase 2, Lahore
DataRopes.ai is a global technology partner which delivers end to end services like data engineering, data analysis, data science and AI & ML.
Reviewed on
Address
150 E B St Lbby # 1810
1106 A, 11th floor, Haly Tower,
Sector R DHA Phase 2, Lahore
© DataRopes 2025. All rights reserved
.png)
.png)
