Data chain of custody from Alderwick and TDG TPA through Example Insurance and Placefield Brokers to three reinsurers.

Connecting organisations through data

Automated cross-organisation data exchange, removing an estimated 16,200 manual steps a year.

Watch the demo

Company

Quantemplate
Insurance data automation

Role

Lead product designer, end to end

Team

Design, engineering, domain experts and customers

Timeframe

Several months as part of longer strategic programme


Problem

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

Quantemplate automated insurance data processing, but requesting, chasing and moving files still relied on email or cumbersome integrations.

Across 150 trading partners submitting monthly, we identified 18,000 manual steps a year. Our aim was to automate everything after the supplier’s upload.


Design decisions

Step 1Modelling the whole workflow

I mapped the journey from request to onward distribution, including late submissions, wrong files and validation failures. This showed what could be automated and where human judgement remained essential.


Step 2From Data Drop to Data Network

My first concept, Data Drop, offered an unauthenticated, one-time upload link. Mapping the workflow exposed its limits: links would still get lost in inboxes, resubmissions needed coordination, and partners had no shared activity record.

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: persistent connections between organisations, with authenticated users, schedules and submission history. It addressed the whole workflow and opened a path to a wider network.


Step 3Simple to submit, flexible to manage

Dropping the portal layer

Uploads as simple as a portal, with subsections for complex submissions

More

My product partner challenged my assumption that suppliers needed a separate portal. Walking through the journey together changed my view: a simple upload flow inside Feeds could introduce suppliers to the product while avoiding a separate experience to build and maintain.

Research showed that Premium and Claims data could arrive as separate tabs, files or submissions from different organisations, each needing its own pipeline logic.

I introduced subsections for these streams. Feed owners define them; submitters assign their uploads to the right one. Progressive disclosure guides users through each choice without presenting the whole configuration at once.

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.

Roles for humans and robots alike

A Robot User makes automation visible and auditable

More

Owners and managers configure Feeds; submitters upload data; viewers use it in pipelines. Automation needed its own identity so it could run without a person present and remain traceable.

I introduced the Robot User. It needs access to the source Feed and pipeline, plus permission to write the output dataset. Its runs are recorded in the history.

At setup, a “Share with Robot User” prompt identifies missing access, including dependent documents. Users without sharing rights can ask the document owner to grant it.

A 'Set up automation' reminder prompting the user to share the pipeline with the Robot User, listing Auto Run and Auto Export options alongside an Add button next to the Robot User row.
Missing automation permissions are surfaced at setup.

Step 4Automate everything after the upload

Trusted setup in under a minute

A partner connection starts with just their contact’s email

More

A contact’s email was enough to find their organisation or begin creating it. I proposed a logo.dev integration to fill in names and logos, reducing setup work and making requests recognisable.

Admins on both sides approve the connection, with events recorded in an admin panel. I worked through existing organisations, existing partners and different admin rights so each path stayed simple.

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.
The setup specification covers existing partners, new organisations and admin approval.

Reuse the schedule

Admins manage reusable schedules across Feeds. Research showed that partners often shared a reporting cadence but had different contract dates.

I made start and end dates properties of each Feed, so one contract could end without changing the schedule for others.

A Scheduling modal for a Feed: schedule name 'Monthly BDX', start and end date fields (end date optional), and frequency, request, deadline and reminder settings.
Shared schedules, with contract dates set independently for each Feed.

With a partner and schedule in place, users add subsections and start requesting data in under a minute.

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.

The full picture, at a glance

A live dashboard of every Feed replaces tracking in spreadsheets

More

I redesigned the Feed repository as a management dashboard. Managers can see what is complete, waiting for data or overdue, while configurable reminders chase outstanding submissions.

Visible pipeline connections show what each submission will trigger and what the automation is waiting for. Both partners retain an immutable, versioned record, with avatars and organisation domains identifying who submitted each file.

A submission record showing Premium and versioned Claims files with row counts, submitter avatars and dates, and a 'Submitted by / Submitted date' tooltip for one file.
A shared submission record preserves file versions, submitters and dates.

Connecting the whole data chain

Data passes on from one organisation to the next, with one shared record

More

Feeds support incoming data, outgoing distribution and onward sharing. An insurer can distribute to reinsurers; a broker can receive and pass on the original submission.

Each organisation connects its own pipelines while retaining a shared, auditable source record. This provides a foundation for automated data flows across the industry.

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.
The wider opportunity: connected data flows across insurers, brokers and reinsurers.

Explore the Feed use cases.


Watch the demo


Outcome

A foundation for networked data

Feeds has handled recurring production submissions for around 18 months, processing 3.4 million rows. Suppliers upload once; the remaining workflow runs automatically.

90% fewer manual steps

Annual manual steps per organisation

Before Feeds
18,000
With Feeds · supplier uploads the file
1,800
An estimated 16,200 manual steps avoided per year. Based on the typical workflow: 9 steps removed × 150 trading partners × 12 monthly submissions.

Adoption continues through in-app guidance and tutorials. Sharing validation results with suppliers extends the workflow into correction, giving partners another reason to switch.


Resources


Back to top