Adhoc data engineering support.
Objective
Flexible Data Engineering Support whilst hiring.
Obstacle
Technical debt and non-optimised queries.
Outcome
Data sources centralised & queries optimised
Background
Sometimes, tackling a growing workload requires a little extra help. That was exactly the situation for the dating app Pure. As they set out to expand their data engineering team, they faced the immediate challenge of managing an increasing backlog of tasks. While searching for the right long-term hires, they needed interim support to keep operations running smoothly. That’s where 173tech stepped in…
Challenges
Flexibility: Pure required interim support to bridge resource gaps while searching for permanent hires. Our approach provided hands-on engineering expertise when they needed it most, without the overhead of hiring a full-time team.
Technical Debt: This project serves as a clear example of how technical debt can gradually build up over time. As we delved into Pure’s data infrastructure, we discovered that several existing models had significant overlap and were not optimised for performance. This redundancy not only increased complexity but also led to inefficiencies, such as longer query run times and unnecessary rework for the analytics team.
Solution
Efficiency: The lack of streamlined, well-structured models meant that analysts had to spend extra time cleaning and transforming data before deriving insights, slowing down decision-making processes. By addressing these inefficiencies, we helped Pure enhance the performance and maintainability of their data models, ultimately improving overall system efficiency.
Add More Data: To enhance Pure’s data infrastructure and provide a more comprehensive view of their business performance, we integrated several new data sources into their ecosystem. These included CardPay, which streamlined financial transaction data, and Huawei Revenue, enabling better tracking of revenue from Huawei’s ecosystem. On the marketing side, we connected Twitter Ads, Snapchat Ads, and VKontakte Ads, allowing Pure to consolidate their advertising performance data across multiple platforms.
The Proof Is In The Numbers...
£13k
8
10
Implementation
One Source Of Truth: By centralising financial and advertising sources, we helped improve reporting accuracy, enhance marketing attribution, and enable deeper insights into user acquisition and engagement. These integrations not only provided Pure with a more holistic view of their operations but also optimised their data workflows, reducing manual effort and improving decision-making across teams.
