• Profile source platforms and document data inventories, ownership, lineage, quality risks, retention constraints and extraction approaches.
• Design source-to-target mappings and transformation rules for customer, account, contract, product, tariff, premise or supply point, meter, read or usage, bill, payment, balance, debt, interaction and reference data.
• Build parameterised ETL/ELT pipelines for extraction, cleansing, standardisation, transformation, validation, loading and replay.
• Implement data-quality controls for completeness, validity, uniqueness, referential integrity, effective dating, sequencing and cross-domain consistency.
• Create reconciliation frameworks using record counts, control totals, financial balances, sampled journeys and exception reports across source, staging, target and downstream systems.
• Partner with Business Analysts and utility SMEs to define remediation rules, ownership and acceptable tolerances for legacy-data issues.
• Support iterative migration rehearsals, defect analysis, reprocessing, performance tuning and evidence-based readiness decisions.
• Engineer cutover loads, delta or change-data capture approaches, freeze-window controls, rollback support and restartable processing.
• Protect personally identifiable and financial data through least-privilege access, encryption, masking, secure transfer, audit logging and controlled retention.
• Expose actionable pipeline metrics, logs, s and exception queues so failures can be diagnosed and recovered within the cutover window.
• Support operational and analytical integrations to data platforms, reporting services and downstream consumers without compromising the system-of-record controls.
• Document mappings, code, runbooks, reconciliation evidence, known exceptions and support procedures; transition ownership to production teams.