Data migration · Data engineering · Data governance · BI solutions · BI development

We turn fragmented systems into data your organisation can trust.

Intellis is a specialist data migration, data engineering and BI solutions consultancy, trusted by NHS Organisations and large private-sector groups to lead system discovery, ERP, EPR & CRM migrations and governance - from Trust mergers to enterprise-wide ERP rollouts.

See our work Get in touch
163systems audited in a single Trust discovery
64legal entities migrated onto one ERP
15+years combined delivery experience
System discovery
163systems audited for ODS usage
Careflow
ICE
CRIS
Winpath
eRS
Spread
Entity migration
FinanceMigrated
HRMigrated
PayrollIn progress
ReportingMigrated
99.4%
reconciled post-migration
Delivered for
Bristol NHS Foundation Trust NHS England Macquarie Group Imperial College Health Partners Open Health Group
What we do

Data problems rarely stay inside one discipline

Intellis covers the full path from "what have we actually got" to "here's a dashboard the board can trust" - so nothing gets lost in a handover between specialists.

Migration & discovery

We map complex, undocumented system landscapes before a merger or platform move, so migration scope is based on evidence, not guesswork.

Engineering & governance

Automated ETL, clean data models and validation frameworks built to hold up to audit long after go-live.

Business intelligence

Dashboards and reporting frameworks in Tableau and Power BI that give leadership real visibility into the business.

View all services →
What we do

Five capabilities, one practice

Most data problems don't stay inside one discipline. Intellis covers the full path from "what have we actually got" to "here's a dashboard the board can trust" - so nothing gets lost in a handover between specialists.

01

Data migration & systems discovery

Full landscape audits before a merger, replatform or ERP move - establishing what systems exist, how they're integrated, and what actually needs to migrate.

02

Data engineering & ETL

Automated ETL pipelines, data models and cleansing logic that move data out of legacy systems and spreadsheets into a structure the business can rely on.

03

Data governance & quality assurance

Validation, testing and reconciliation aligned to statutory and organisational standards, so migrated data holds up to scrutiny after go-live.

04

Business intelligence & reporting

Dashboards and reporting frameworks in Tableau and Power BI that translate complex data into the indicators leadership actually needs to see.

05

Stakeholder & programme engagement

Running discovery sessions and workshops across system owners, suppliers and directors - and documenting it clearly enough that it outlasts the project.

Technical toolkit

Platforms we work in day to day

Databases & platforms

SQL Server 2008R2 / 2012 / 2016 T-SQL MySQL SAP Business Objects

ETL & integration

SSIS Talend Diver BI API integration VBA (Visual Basic) Mirth Connect HL7 FHIR API

BI & reporting

Tableau Power BI Power Query QlikView SSRS SSAS Workday Reporting
How a project runs

The same method, whatever the sector

Whether it's an NHS Trust merger or a private equity roll-up, the sequence holds: understand what's there before you touch it, then migrate, govern and hand over - not just switch it on and leave.

STEP 01

Discover

System and stakeholder discovery across the full landscape - including the systems nobody's documented, and the people who actually know how they work.

STEP 02

Profile & map

Profiling data volume, quality, duplication and dependencies, then mapping systems, integrations and reference data from old to new.

STEP 03

Migrate & engineer

Building the ETL, transformation rules and data models that move data cleanly into the new system - with cleansing and deduplication built in, not bolted on.

STEP 04

Govern & validate

Testing and reconciliation against record counts, referential integrity and business rules, so what lands in the new system is provably correct.

STEP 05

Report & embed

Dashboards, documentation and training handed to your team, so visibility into the data doesn't leave when the project does.

Recent work

Two projects, one inside the NHS and one outside it

A look at the range of what Intellis takes on - a national-body-facing NHS discovery, and a private-sector ERP migration running across dozens of legal entities.

Getting ODS data right ahead of a Trust merger

Engagement: ODS Data Migration
April 2026 – Present

Bristol NHS Foundation Trust - merger of North Bristol NHS Trust and University Hospitals Bristol and Weston NHS Foundation Trust

Our team was engaged three months ahead of the merger, because nobody yet had a clear answer to a basic question: which systems actually used ODS (Organisation Data Service) codes, how those codes got there in the first place, and how they fed statutory and operational reporting. Getting that answered before the two Trusts came together, rather than after, was the point.

That meant going system by system - 163 in total - to establish whether ODS was configured directly, arriving through integration, or both, then following it out to 15 external NHS Spine services including SDS, PDS and e-RS. Much of this depended on people rather than documentation: where a system owner didn't hold the detail, we tracked down whoever did, or dug it out independently through suppliers and interface specs.

The output was a full system inventory and data flow map that hadn't existed before, plus a mapping of 161 external reports from old ODS codes to new. Off the back of it, 195 new ODS codes are now reconciled and in active use, with the Trust reporting accurately to national bodies such as NHS England and HCAI.

163internal systems audited for ODS usage
15external NHS Spine services reviewed
~100stakeholders engaged across the merged Trust
195new ODS codes created and reconciled

Migrating 64 legal entities onto Workday

Engagement: Enterprise Data Migration & Reporting
January 2024 – March 2026

Panda Recycling (Macquarie Group) - HR, Finance & Payroll migration onto Workday

Private sector, and moving in the opposite direction: the group was acquiring companies throughout the project, so scope wasn't fixed at the start. It settled at 64 legal entities, each needing its HR, Finance and Payroll data migrated.

We led the data side - profiling the legacy landscape of databases, applications and spreadsheets for volume, quality and duplication, then building the mapping and transformation logic alongside a team of specialist contractors, field by field. We built the ETL using SQL and Diver Workbench, with cleansing, deduplication and validation built in, and rebuilt the affected Power BI reporting once legacy systems were decommissioned so nothing was lost in the transition.

Just as much of the job was making sure the right people were in the room: cataloguing every report and dashboard dependent on the legacy systems, and working with the Test Case Manager and Cutover Lead so the business could trust what was migrated before go-live.

64legal entities migrated onto Workday
3domains moved - HR, Finance & Payroll
1end-to-end ETL built in SQL & Diver Workbench
0reports lost in the legacy decommission
Get in touch

Tell us what's not adding up in your data.

Whether it's a Trust merger, an ERP migration or a reporting suite nobody quite trusts any more - we're happy to talk it through, no obligation, and can usually give you a straight answer on scope within a call.

Phone +44 7305 958313
Email intellisdsltd@gmail.com
Coverage Worldwide - on-site & remote
Send a message

Prefer to write it down?

Give us a few details on what you're looking to solve and we'll come back to you within one working day.