Overview

Loop's team focuses on using AI to centralize freight, parcel, and financial data for clients to inform decisions + provide meaningful insights. Their team was searching for a tool to support their customer-facing engineering department with a growing client base.

The challenge

As the Loop team continue to scale their customer base, handling a high volume of diverse customer data formats (EDI, CSV, Excel) became increasingly difficult from a time perspective. The integrations team relied on a manual transformation process that required customer-facing engineers to analyze files, map columns, and create custom transformation matrices for each new client. This approach introduced inefficiencies and significantly slowed down onboarding for prospective customers.

“This would help us avoid having to manually make these transformations that eat into other dev time for current customers that are paying for onboarding,” Luke, a member of the implementation team, shared.

The Solution: implementing bem to scale data transformation

• From weeks to days for new clients: Since using bem, Loop has been able to onboard clients faster and more efficiently. The streamlined transformation process allows them to quickly prototype data pipelines, ensuring accurate and contextual data output. Instead of waiting weeks, potential customers can now see their data within Loop’s platform in just days.

• Reduced manual work for the team: "This is a whole bunch of manual work we no longer have to do. We just have to maintain the one instance that is transforming everything," shared Casey from the Loop team. Engineers from their team no longer need to manually write transformation scripts for every new client, freeing up time for other high-priority tasks.

• Future-proofed data transformation: A single, scalable transformation pipeline ensures that Loop can easily handle new customers without disrupting existing workflows.

Scaling with bem

The integration of bem has been a significant improvement for Loop’s data transformation strategy. By automating previously manual processes, the company has significantly improved onboarding velocity, enhanced scalability, and provided a seamless experience for both existing and potential clients. Moving forward, our bem team looks forward to supporting the Loop team with efficient and reliable data integrations for their logistics and supply chain customers.