A leading superannuation administration platform provider was managing multiple active fund transitions simultaneously — and recognised that each engagement was being approached without a consistent, documented methodology. Without a repeatable framework, the risks of inconsistent data quality, unclear role boundaries, and ad-hoc reconciliation processes would compound as the transition pipeline grew.
Desda was engaged to design and deliver a fit-for-purpose ETL data migration framework — a comprehensive strategy covering migration approach, party responsibilities, reconciliation design, data quality management, data security, trial load structure, and governance. The engagement also included a high-level assessment of existing in-flight transitions, identifying risks and recommending course corrections. The resulting framework became the operational baseline for all subsequent fund administration transitions on the platform.
The Challenge
The platform provider was onboarding new superannuation fund clients at pace — each requiring a complete data migration from the fund's incumbent administrator into the target platform. But the ETL process for each transition was being designed from scratch, relying on institutional knowledge rather than a documented, repeatable methodology. This created risk in several areas:
- No consistent approach to source-to-target mapping across different incumbent systems and entity models.
- Reconciliation frameworks designed ad-hoc per engagement, with no standard for what constituted sufficient evidence of data accuracy.
- Data quality management varying in rigour between projects, with inconsistent treatment of exceptions.
- Role and responsibility ambiguity between the platform provider, the fund trustee, and the incumbent administrator.
- Trial load sequencing and exit criteria not standardised, making it difficult to assess readiness for go-live across concurrent transitions.
Alongside this, several transitions were already in flight — carrying risks inherited from earlier, less structured approaches. These needed to be assessed and, where possible, course-corrected without disrupting delivery timelines.
Our Approach
Desda approached the engagement in two parallel streams: framework design (the primary deliverable) and in-flight transition assessment (the immediate priority). Both streams were conducted through structured workshops and interviews with business and technical SMEs across the platform provider's data, operations, and engineering teams.
What the Framework Covers
The Data Migration Strategy framework designed by Desda spans the full ETLR lifecycle — from the moment the incumbent administrator begins extracting source data through to reconciliation sign-off and go-live. Key components include:
- Migration approach — load model options (Big Bang, Incremental Pre-load, Post-load) with selection criteria for different transition profiles
- Responsibilities — RACI covering data mapping, transformation, extraction, loading, reconciliation, and trial coordination across all parties
- Reconciliation design — structured reconciliation at each ETLR stage, from source receipting through to target system verification
- Data quality management — issue identification, triage, treatment plans, and sign-off process across completeness, accuracy, validity, and consistency dimensions
- Data security — masking and obfuscation rules for non-production environments, access controls, and audit trail requirements
- Trial load structure — staged trials with defined scope, exit criteria, and progress reporting, culminating in a dress rehearsal and go-live
- Historical data considerations — take-on date logic, member eligibility rules, and archive strategy for out-of-scope historical data
- Data operations — archive and destruction standards for source data post-migration
Outcomes
The framework was adopted as the standard operating approach for all fund administration transitions on the platform. It resolved the inconsistency and ad-hoc nature of earlier approaches — providing a documented, agreed methodology that all parties (fund trustees, incumbent administrators, and the platform provider's own teams) could work from.
The in-flight transition assessments identified and surfaced risks that had not been formally registered, enabling corrective action before they impacted delivery. The framework was applied directly to subsequent transitions — including a major education sector fund migration of ~112,000 members in early 2025, which Desda also co-authored the transition-specific strategy for.
"The framework gave us a repeatable, consistent methodology we could apply across every transition — instead of rebuilding from scratch each time. That was the goal, and Desda delivered it."
— Client feedback
Why Desda
This engagement required something beyond execution capability — it required the experience and perspective to design a methodology that would work across diverse fund transitions, incumbent systems, and team structures. Desda's depth in superannuation data migrations, combined with an independent advisory lens, made us the right partner to both design the framework and assess the gaps in existing in-flight work.
- Independent advisory perspective on methodology and risk
- Deep experience across fund administration, ETLR, and reconciliation design
- Ability to span strategy and hands-on execution within the same engagement
- Cross-sector knowledge of incumbent systems, data models, and transition risks