Home
Portfolio
Company
Contact
Group M
Ongoing since 2023
Marketing and Advertising
United states
GroupM is a leading global media investment company that helps brands maximize the value of their marketing through data-driven strategies, media planning, and performance optimization. As part of WPP, GroupM partners with top-tier advertisers to deliver innovative media solutions across digital, TV, and emerging platforms, empowering businesses to reach their audiences effectively and efficiently.
Scalable, reliable, repeatable data workflows
Event-driven pipelines with Pub/Sub
KPI visualization for faster decisions
Tasks, sprints, documentation streamlined
Data Engineers
BI Developers
Cloud Automation Experts
Agile Project Coordinators
Contractual / Ticket-Based
Task Assignment via JIRA
Eliminating Data Gaps, Inefficient Reporting, and Weak Customer Understanding
Built robust pipelines using BigQuery, Airflow, Dataform workflows
Ensured seamless workflows via Pub/Sub, Cloud Functions
Learned Looker, Cloud Repos setup, dashboard creation
The project was executed as a series of discrete JIRA tickets, with deliverables split across ETL builds, automation tasks, and BI dashboarding. BigQuery served as the warehouse foundation, while Airflow and Dataform orchestrated and managed transformations. Cloud Functions and Pub/Sub supported scalable ingestion and real-time automation. JIRA workflows structured sprint deliverables, and Confluence housed documentation for repeatability and collaboration.
JIRA workflows structured sprint deliverables, and Confluence housed documentation for repeatability and collaboration.
Strategic questions addressed:
● How do we automate manual reports while ensuring data quality and timeliness?
● What workflow design ensures reusability and reliability in task-based execution?
● How can we enable real-time analytics through event-driven data ingestion?
● What collaborative setup supports repeatable success across sprint cycles?
Automated, Modular ETL and Dashboarding with Scalable Cloud Tooling
We implemented modular ETL pipelines using Airflow and Dataform to support incremental, test-covered processing.
Real-time pipeline triggering and event handling were achieved using Cloud Functions and Pub/Sub, enabling seamless automation. To deliver actionable insights, we developed interactive Looker dashboards tailored by region, team, and KPI.
Project transparency and alignment improved through structured task tracking in JIRA and standardized documentation in Confluence. Together, these efforts enabled a reliable, scalable data infrastructure supporting both operational efficiency and fast decision-making across stakeholder groups
reduction in manual reporting time
faster reporting via streamlined pipelines
savings in data operations cost
faster decisions using real-time dashboards
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)
