About myPOS
myPOS is an innovative fintech company serving small and medium-sized business clients across Europe. It provides easy and convenient in-store, online, and on-the-go payment solutions for over 150,000 businesses. For its innovations in the payments industry, myPOS has won numerous prestigious awards, including the B2B Innovation Award from FinTech Breakthrough in 2021.
Benefits + Metrics
- 200+ reports generated automatically
- 40% of merchants onboarded without manual intervention
Overview
myPOS—a startup offering payment solutions to small- and medium-sized businesses—was experiencing rapid growth, with continued expansion on the horizon. However, the organization’s fragmented legacy architecture had reached its scalability limit. Without a centralized data platform, myPOS departments couldn’t self-serve the data they needed, and much of the reporting relied heavily on manual processes. To reach its next stage of growth, myPOS partnered with Carbon60 and implemented a modern data lakehouse architecture. Within months, myPOS had completely transformed its approach to data usage, laying a foundation for advanced analytics. The collaboration with Carbon60 resulted in data democratization, improved insights, and automated reporting.
Opportunity
Limited Data Access and Manual Reporting Slow Down Insights
When Abdenour Bezzouh joined as Chief Technology Officer (CTO) at myPOS, the company was scaling rapidly but faced the typical growing pains of a fast-moving startup. Monolithic systems dominated the technical architecture, which lacked a data platform and agile practices. “Our system wasn’t running as efficiently as we wanted it to, and because we didn’t have a unified data platform, all our departments relied on a centralized team for reporting,” Bezzouh said.
This setup slowed down the time to insights and prevented business units such as sales, finance, and marketing from making timely, data-driven decisions. Additionally, myPOS used its production database to manage reporting. “Ideally, our production database would be dedicated to processing transactions associated with our customer-facing product, and we’d run reporting on a separate platform where it could get the power it needs for deep insights,” Bezzouh said.
One particular report, known as the breakfast report (business overview), was delivered to the myPOS leadership team every morning to inform them about all financial transactions performed the previous day. However, with 150 different dashboard views showing everything from acquisition to issuance, preparing the breakfast report took several hours to complete. This report, along with roughly 200 others, involved a team of eight running SQL queries against the production database, manually aggregating and transforming the data, then importing it into Excel. “We were creating reports by hand, and it was painful,” Bezzouh said. “The breakfast report in particular is very complex, and it’s crucial for understanding the health of the business.”
As the CTO, Bezzouh knew how a unified data platform would transform the architecture of myPOS and set the stage for future growth. But he needed a partner to make it happen. Having worked with Carbon60 at a previous organization, Bezzouh reached out again.
Solution
An Architecture Shift to a Unified Data Lakehouse
Together, Carbon60 and the myPOS team developed a three-phased plan to implement a data lakehouse architecture, integrate its CRM solution, HubSpot, and extend functionality to enable user access and governance.
To kick off the engagement, Bezzouh started with the breakfast report. “We knew that if we could migrate that report, we could do everything else,” Bezzouh said. As a first step, Carbon60 worked with myPOS to establish the data foundation. They built change data capture pipelines using Google Datastream to move data from on-premises systems to BigQuery. The data is then cleaned and transformed with PySpark, then aggregated so it’s ready for queries and visualization in Power BI. After finalizing the architecture, Carbon60 delivered an initial version of the breakfast report (complete business overview) a month later, and the team finalized it shortly thereafter.
For phase two, Carbon60 focused on integrating the lakehouse with HubSpot to better support myPOS sellers. Historically, the sales team focused on the number of myPOS devices (or terminals) sold and lacked visibility into the total payment volume (TPV) of customers. “We wanted our sellers to better understand which of our merchants were spending a lot with us so they could prioritize their sales motions,” Bezzouh said. However, the challenge was calculating TPV. It’s an aggregated metric that spans thousands of merchants and changes by the minute. With the data lakehouse, it was possible to keep up. The team added TPV and other metrics to HubSpot, providing sellers with the insights they needed to identify high-value merchants.
“Now, instead of just selling devices, we can measure and act on the actual business impact of our merchants.”
— Abdenour Bezzouh, CTO, myPOS
In the third phase, Carbon60 focused on democratizing access to data in the lakehouse. Instead of relying on a centralized team to handle all reporting, anyone with basic reporting skills can find the data they need and visualize key metrics. Carbon60 made this possible by defining clear ownership of data domains, implementing access controls, and establishing guardrails to ensure data quality and compliance. The goal is to provide reliable data that allows users to explore insights independently, without risking data sprawl or misuse.
Outcome
New Efficiencies and Automation Free up Staff
Since partnering with Carbon60, the myPOS team has found new ways to operate more efficiently. Before, a team of eight people spent weeks developing reports. But today, the data lakehouse automatically generates them every night, freeing up time and resources. Additionally, onboarding new merchants was previously a manual process that was time-consuming for both staff and merchants.
Now, 40 percent of merchants are onboarded automatically, and 60 percent are onboarded the same day with minimal assistance. Across departments, myPOS staff have better visibility into key metrics, including transactions, sales, merchants, and more.
Beyond efficiencies, Carbon60 also helped train myPOS engineers so they can continue to make improvements to the new architecture once the engagement ends. “In the beginning, Carbon60 was driving the car and we were just the passengers,” Bezzouh said. “Now we’re co-driving, and later on we’ll be the ones at the wheel. This is particularly important because we’re a fast-growing team that didn’t always possess certain skillsets. Carbon60 understands that while you use them to start, you also want to build your internal team to grow in the long term.”
With the new data platform in place, myPOS has begun looking at ways to incorporate machine learning (ML) to uncover new insights. Specifically, Bezzouh’s team has been developing an ML model with Advent to predict merchant churn more accurately. The model would use sentiment data and a merchant’s interaction history to pinpoint indicators of churn.
“The team understands that while you use them to start, you also want to build your internal team to grow in the long term.”
— Abdenour Bezzouh, CTO, myPOS
Ready to modernize your data infrastructure?
Contact us to explore how Carbon60 can help your organization unlock data insights, streamline operations, and accelerate growth — just like we did for myPOS.
