Data Migration Developer - Financial Services - Mortgages & Property

Data Migration Developer - Financial Services - Mortgages & Property

Posted 3 days ago by Rothstein Recruitment Ltd

Apply
Negotiable
Undetermined
Undetermined
London, UK
Apply
Bank Reconciliations Business Intelligence Reporting Data Analysis Data Integration Data Migration External Auditing Extract Transform Load (ETL) Finance Financial Services General Ledger Informatica Life Cycle Planning Mapping Software Mortgage Loans Power BI Profiling (Computer Programming) Reconciliation Sampling (Statistics) Software Development SQL (Programming Language) Stakeholder Engagement Stakeholder Management Transformation Rules Verification And Validation Window Function

Summary: The Data Migration Developer role focuses on supporting a large-scale transformation of a Mortgage & Property platform by mapping, cleansing, migrating, and reconciling complex data. The ideal candidate will possess hands-on data expertise and strong domain knowledge in the mortgage lifecycle and property valuations. This position requires collaboration across various teams to ensure successful data integration and migration. The role emphasizes delivering controlled and auditable migrations with a focus on stakeholder engagement and regulatory compliance.

Key Responsibilities:

  • Expert-level SQL for joins, window functions, DQ checks, and reconciliation queries.
  • Exposure to ETL tooling (SSIS, ADF, Informatica); advanced Excel/Power BI.
  • Produce detailed data-mapping specifications, data dictionaries, and sample datasets.
  • Catalogue and design interfaces (API, ETL, file-based) for all downstream systems.
  • Define message/file contracts, ownership, frequency, and cutover approach.
  • Prove E2E integrations (SIT/UAT) with control totals, idempotency, retry logic, and back-out plans.
  • Deliver operational artefacts - schedules, monitoring/alerting, runbooks, and data-replay procedures.
  • Collaborate with Product, BAs, SMEs, Engineers, and Vendor partners.
  • Facilitate workshops to capture business rules and translate them into testable data logic.
  • Communicate clearly and confidently with technical and non-technical audiences.
  • Work across the full mortgage life cycle: origination servicing arrears redemption.
  • Handle property data touchpoints such as valuations, collateral, and lease data.
  • Familiar with mortgage-servicing platforms such as Horizon or comparable systems.
  • Define and execute source-to-target mappings, transformation rules, and lineage.
  • Manage trial loads, defect triage, and dress-rehearsal cutovers.
  • Evidence reconciliations = 90% accuracy with business sign-off.
  • Understand GL/postings and balance-check mechanisms.
  • Achieve day-one parity for operational, regulatory, and finance MI.
  • Design and implement control totals, exception reports, and audit trails.
  • Working knowledge of FCA/MCOB standards.
  • Apply GDPR, retention, and secure-handling practices.
  • Draft DPIA inputs and evidence compliance for all data extracts.
  • Manage personal RAID items, operate within sprints/timeboxes.
  • Maintain clear documentation and seamless BAU handover.
  • Self-starting, proactive delivery under minimal oversight.

Key Skills:

  • 5+ years' experience in large-scale data migrations (banking/financial-services).
  • Mortgage & property domain fluency.
  • Strong SQL and ETL tooling (SSIS/ADF/Informatica).
  • Demonstrable reconciliation and audit-control design.
  • Proven ability to engage vendors and manage cross-functional workshops.

Salary (Rate): undetermined

City: London

Country: UK

Working Arrangements: undetermined

IR35 Status: undetermined

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

Data Migration Developer - Financial Services - Mortgages & Property

We're seeking an experienced Data Migration & Integration Analyst to support a large-scale Mortgage & Property platform transformation. The role will work across product, SME, vendor, and engineering teams to map, cleanse, migrate, and reconcile complex mortgage and property data into a new strategic platform (eg Horizon or equivalent).

The ideal candidate combines hands-on data expertise (SQL, ETL, profiling, reconciliation) with strong domain knowledge (mortgage life cycle, property valuations/collateral) and a proven record of delivering controlled, auditable migrations.

Core Responsibilities

Data Analysis & Profiling (18%)

  • Expert-level SQL for joins, window functions, DQ checks, and reconciliation queries.
  • Exposure to ETL tooling ( SSIS, ADF, Informatica ); advanced Excel/Power BI.
  • Produce detailed data-mapping specifications, data dictionaries, and sample datasets

Downstream Integration (15%)

  • Catalogue and design interfaces (API, ETL, file-based) for all downstream systems.
  • Define message/file contracts, ownership, frequency, and cutover approach.
  • Prove E2E integrations (SIT/UAT) with control totals, idempotency, retry logic, and back-out plans.
  • Deliver operational artefacts - schedules, monitoring/alerting, runbooks, and data-replay procedures.

Stakeholder Engagement (10%)

  • Collaborate with Product, BAs, SMEs, Engineers, and Vendor partners.
  • Facilitate workshops to capture business rules and translate them into testable data logic.
  • Communicate clearly and confidently with technical and non-technical audiences.

Mortgage & Property Domain (15%)

  • Work across the full mortgage life cycle: origination servicing arrears redemption.
  • Handle property data touchpoints such as valuations, collateral, and lease data.
  • Familiar with mortgage-servicing platforms such as Horizon or comparable systems.

Migration Delivery (20%)

  • Define and execute source-to-target mappings, transformation rules, and lineage .
  • Manage trial loads, defect triage, and dress-rehearsal cutovers.
  • Evidence reconciliations = 90 % accuracy with business sign-off.

Controls, MI & Reconciliations (12%)

  • Understand GL/postings and balance-check mechanisms.
  • Achieve day-one parity for operational, regulatory, and finance MI.
  • Design and implement control totals, exception reports, and audit trails.

Regulatory & Governance (5%)

  • Working knowledge of FCA/MCOB standards.
  • Apply GDPR, retention, and secure-handling practices.
  • Draft DPIA inputs and evidence compliance for all data extracts.

Delivery Discipline (5%)

  • Manage personal RAID items, operate within sprints/timeboxes.
  • Maintain clear documentation and seamless BAU handover.
  • Self-starting, proactive delivery under minimal oversight.

Required Experience

  • 5 + years' experience in large-scale data migrations (banking/financial-services).
  • Mortgage & property domain fluency.
  • Strong SQL and ETL tooling (SSIS/ADF/Informatica).
  • Demonstrable reconciliation and audit-control design.
  • Proven ability to engage vendors and manage cross-functional workshops.

Desirable

  • Prior exposure to Horizon or equivalent mortgage-servicing platforms.
  • Experience with Power BI reporting for MI parity validation.
  • Understanding of GL interfaces, finance postings, and regulatory reporting, SSRS, SSIS ETL BI Business Intelligence
Apply
Similar Jobs
Loading data...