Case Study | Quantemplate Feeds

Connecting organisations through data

Infrastructure to automate data exchange, laying the foundation for a connected network.

Product strategySystems thinkingProcess design


Role

Lead product designer, end to end

Team

Design, engineering, domain experts and customers

Timeframe

Several months as part of longer strategic programme / 2022


Key points
  • Project reframes an upload portal as a cross-company network
  • Automates an entire manual workflow, with Feeds set up in under one minute
  • Adapts to any shape of data, across files, formats and organisations
  • Spans submissions, scheduling, org creation, authentication and admin tooling
A chain-of-custody view in Feeds: two partner organisations supplying premium, payment, claims and loss-adjustment data into an insurer, which passes it on to a broker and three reinsurers downstream, with each card showing who last used the data and where it flows.
Feeds keeps the chain of custody for every dataset: which organisation supplied it, who has used it, and where it flows downstream.

Summary

I led the design of Feeds, a new Quantemplate workspace for securely requesting, receiving, processing and distributing data between organisations.

By mapping the complete workflow, I reframed an initial upload-portal concept as a persistent system, spanning submissions, automation, permissions and operational oversight. Feeds accommodate complex insurance data exchanges while creating the foundation for a broader connected-data strategy.

Thumbnail for the YouTube video ‘Learn how to automate data exchange with Quantemplate Feeds’ Learn how to automate data exchange with Quantemplate Feeds A quick guide to Feeds concepts and an overview of the interface. Watch on YouTube

Problem

We’d automated the data processing, but not the process

Insurance companies depend on regular submissions from brokers, managing general agents, third-party administrators and other partners. Our data transformation pipelines did a good job of mapping and harmonising this data, but the parts outside Quantemplate were process bottlenecks.

Email was manual and difficult to audit, while FTP and API integrations were unwieldy. Moreover, keeping track of what was in or overdue every month was a significant timesink.

Even on the happy path, we identified five manual steps to request data and another five to bring it into and out of Quantemplate.

Across an average of 150 trading partners, repeated monthly, that amounted to 18,000 manual steps a year.
Diagram of a typical MGA data pipeline: manual upload to network storage, an automated import-to-output pipeline including Map Column Headers, then a manual step to push output to the client database via API. Annotated version of the Data Repo and pipeline diagram, with yellow sticky notes flagging open questions and trade-offs at each stage: partner data visibility and permissions, input selector categorisation, additive versus replacing submissions, and notification requirements.
2022 analysis of the typical Quantemplate workflow, identifying the manual bottlenecks — then an annotated version flagging the trade-offs and open questions on the way to straight-through processing.

Approach

Modelling the whole workflow

I mapped every touchpoint from the initial request through submission, processing, validation, correction and onward distribution. For each stage we considered the unhappy paths and dead ends: late or incomplete submissions, incorrect files, resubmissions and validation failures.

The map identified every manual step that could be automated, every notification that needed to be sent and every point where human judgement was still required.

It became the basis for the submission lifecycle, schedules, statuses, reminders, version history and pipeline triggers.

Swimlane diagram of the submission lifecycle spanning Carrier and MGA roles, from period open through upload, parsing, validation and carrier pipeline review, to period close, with pink notification steps, grey decision points and yellow manual touchpoints.
Submission lifecycle analysis showing notification steps (pink), automated decision points and manual touchpoints (yellow).

Key decisions

From Data Drop to Data Network

My initial concept, Data Drop, was a lightweight portal with an unauthenticated, one-time upload link. It would have been a quick win, but mapping its workflow revealed that it would move the email problem further down the chain: links buried in inboxes, no persistent activity record and resubmissions still needing coordination.

The Data Drop would have been a quick win but an incomplete solution.
Mockup of the Data Drop secure data transfer concept: a card showing transfer from and to organisations, submission type, period, due date, a worksheet selector with checkboxes, and a submit button.
The data drop concept we never shipped.

I proposed Feeds instead: a whole new area in the product with authenticated users, separate organisations and persistent relationships between partners. This was a larger product increment, but one that addressed the whole workflow, making persistent connections between organisations and opening a path to a broader network strategy.

Diagram showing a Data originator org with a Feed Out mirroring data to a Data consumer org's Feed In, fed by API, pipeline and manual upload sources on each side, with an upload portal shown as a separate concept still under consideration.
Architecting the relationship between organisation feeds. Every Feed In corresponds to a Feed Out in the partner org. At this point I was still considering the ‘upload portal’ as a layer in the workflow. It was descoped when the walkthrough revealed it to be superfluous.

Flexibility for complex submissions

When we spoke with users and looked at their existing Quantemplate workflows, we could see that a submission was rarely uniform: Premium and Claims might arrive as separate tabs, files, or from different organisations, each needing different pipeline logic.

I introduced subsections to represent these distinct streams within one submission. Feed owners define subsections, and submitters assign uploads to the appropriate one. Using the wayfinding principle of progressive disclosure, the interface walks them through the process, step-by-step.

Using wayfinding principles, I navigated users through the process of assigning their data to the right subsection.
Thumbnail for the YouTube video ‘Feeds 5: Submitting and receiving data’ Feeds 5: Submitting and receiving data Uploading data to a Feed to send to a partner organisation, using subsections to separate Premium and Claims data. Watch on YouTube

Roles for humans and robots alike

I modelled permission levels around the way our clients divided responsibility. Owners and managers needed to configure Feeds, connect with partners and oversee the process. Submitters only needed access when it was time to upload data, while read-only users needed visibility to use Feeds data in pipelines.

I introduced the concept of a ‘Robot User’ to surface automation capabilities across the platform and make them auditable.

Looking at our permissions model, I realised that we needed a way to run automations without a user present, and have those runs tracked in the history. When the Robot User has access to a Feed, they can take the data from it, run a pipeline they have access to and output it to a dataset they’ve been given write permission on.

Feed sharing panel listing who has access: TDG TPA with 9 members as Submitter, Robot User as Can view, Martina Brito as Manager, and Tom de Gay as Owner.
Sharing a Feed. Owner, Manager, Submitter and view-only roles sit alongside the Robot User, enabling automations across the platform.

Implementation

Trusted setup in under a minute

Initiating a partner connection required just their contact’s email. We used the domain to find their organisation or begin creating it. I researched and proposed a logo.dev integration to populate organisation names and logos automatically, reducing setup effort and making requests more recognisable. Admins on each side approve the connection, with all events tracked in a new admin panel.

A lot of complexity behind the scenes, enabling simplicity in the product.
Design specification board mapping every path through the add-partners workflow: adding internal submitters, connecting to an existing partner, adding a new partner, setup via a Feed In or Feed Out, setup statuses and review settings.
Design specification for the ‘Add partners’ workflow. Did the partner already exist on the system? Were they already connected to this? Was the user an admin?

Admins can also create reusable schedules to centrally manage request frequency. Research revealed that feeds often shared a cadence but followed different contract dates. I made start and end dates properties of a Feed, rather than a schedule, allowing requests to stop at contract end without affecting other feeds using the same schedule.

All that’s required to set up a new Feed is to add subsections, search for a partner and connect an existing schedule. In under one minute you can be requesting data from your trading partners.

Thumbnail for the YouTube video ‘Feeds 2: Set up a feed’ Feeds 2: Set up a feed How to set up a Feed, add subsections and connect a schedule. Watch on YouTube

The full picture, at a glance

Both parties retain an immutable, versioned record of submitted data. User avatars and organisation domains identify the people and companies behind submissions, building trust.

I redesigned the Feed repository as a management dashboard, showing which Feeds are complete, waiting for data or overdue; this real-time view of inventory replaces manual tracking in spreadsheets. Configurable reminders chase outstanding submissions automatically.

Visible connections between Feeds and pipelines help managers understand what each submission will trigger and what the automation is still waiting for.

Your Feeds dashboard listing partner feeds with status badges (Draft, Overdue, Resubmission, Complete), owners, submission counts and a filterable sidebar for feed status, type and tags.
Feeds repo: I reimagined the document storage as a management dashboard.

Connecting the whole data chain

Feeds support incoming data, outgoing distribution and onward sharing. An insurer can distribute data to reinsurers, while a broker can receive and pass on the original submission. Each organisation can connect its own processing pipelines while retaining a shared, auditable source record. This uniquely allows us to surface the full data Chain of Custody.

Thumbnail for the YouTube video ‘Data Chain of Custody’ Data Chain of Custody How insurers, MGAs, TPAs, brokers and reinsurers exchange bordereaux data through Quantemplate’s network, with a transparent, permanent view of where data came from, how it was processed and who it was shared with. Watch on YouTube
The Feeds lay the architectural groundwork for the big vision: automated data flows across the industry.

We mapped out further Use Cases on this support page.

Diagram showing data flowing from MGAs and Carriers who are Quantemplate clients, through to free-user Carriers and Reinsurers, illustrating how submissions and pushes propagate across the network regardless of client status.
Potential to flow data seamlessly across the insurance industry.

Outcome

A foundation for networked data

Feeds have been running production data for approximately 18 months, processing recurring monthly submissions and 3.4 million rows to date. For the client running it, this removes nearly all of the manual steps identified in the original workflow mapping, for true ‘straight-through processing’. The one step that remains, the initial upload, is performed directly by the data supplier.

Bringing further partners onto Feeds is an ongoing project: in-app guidance and comprehensive tutorials have driven initial uptake, and upcoming features to share validation reports and suggest corrections should make the value of switching more visible.

Feeds expanded Quantemplate from a product for automating processes within an organisation, towards infrastructure connecting them.

This opens the door to Network Intelligence, where data mappings, transformations and corrections are crowdsourced.


Resources

Back to top