Data Mapping & Integration Analyst

Data Mapping & Integration Analyst

Posted 2 weeks ago by SF Technology Solutions

£72 Per hour
Outside
Hybrid
Birmingham, England, United Kingdom

Summary: The Data Mapping & Integration Analyst role involves modernizing a customer options/configurator platform by focusing on data design and mapping. The position requires collaboration between business, application development, and data functions to ensure a solid data architecture. The analyst will analyze current data structures, define a new data model, and produce documentation for ongoing reference. This is a hands-on role that emphasizes data integrity and consistency throughout the project lifecycle.

Key Responsibilities:

  • Analyse and document as-is data structures (JSON, SQL) from the legacy configurator application.
  • Design and define the to-be data model, capturing key entities, relationships, and integration points.
  • Develop and maintain detailed source-to-target mappings to guide migration and system build.
  • Collaborate with developers, solution architects, and business SMEs to ensure alignment between functional and data requirements.
  • Identify and resolve data consistency and lineage issues early in the project lifecycle.
  • Produce clear documentation, data dictionaries, ERDs, and mapping artefacts, for ongoing reference.

Key Skills:

  • Proven experience delivering data mapping, migration, or application rebuild projects.
  • Skilled in SQL (for profiling and validation) and comfortable working with JSON or semi-structured data.
  • Strong background in data modelling, logical/physical design and entity relationship mapping.
  • Excellent communication skills, able to translate between technical and business teams.
  • Experience with ERP, CPQ, or product/pricing systems (retail, manufacturing, construction, or utilities preferred).
  • Understanding of integration and data flow between operational and analytical systems.

Salary (Rate): £72.00/hr

City: Birmingham

Country: United Kingdom

Working Arrangements: hybrid

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

Our client, , is rebuilding a major customer options/configurator platform, the system that lets buyers choose upgrades and finishes for their new products. The current platform works well on the front end but suffers from a complex, inconsistent data structure at the back end. This project will modernise that platform from the ground up ensuring data is structured correctly, flows seamlessly into core business systems, and supports future analytics.

The Role

SF Technology is supporting the search for a Data Mapping & Integration Analyst to sit between the business, the application development team, and the data function. This is not a developer role, it’s a hands-on data design and mapping position, focused on how data is captured, structured, and shared across systems. You’ll unpick the current state, define the to-be data model, and ensure the rebuild is grounded in solid data architecture from day one.

Key Responsibilities

  • Analyse and document as-is data structures (JSON, SQL) from the legacy configurator application.
  • Design and define the to-be data model, capturing key entities, relationships, and integration points.
  • Develop and maintain detailed source-to-target mappings to guide migration and system build.
  • Collaborate with developers, solution architects, and business SMEs to ensure alignment between functional and data requirements.
  • Identify and resolve data consistency and lineage issues early in the project lifecycle.
  • Produce clear documentation, data dictionaries, ERDs, and mapping artefacts, for ongoing reference.

Ideal Experience

  • Proven experience delivering data mapping, migration, or application rebuild projects.
  • Skilled in SQL (for profiling and validation) and comfortable working with JSON or semi-structured data.
  • Strong background in data modelling, logical/physical design and entity relationship mapping.
  • Excellent communication skills, able to translate between technical and business teams.
  • Experience with ERP, CPQ, or product/pricing systems (retail, manufacturing, construction, or utilities preferred).
  • Understanding of integration and data flow between operational and analytical systems.

Contract Details

Day Rate: £510 per day

IR35 Status: Outside IR35

Duration: 6–12 months

Location: Hybrid – Midlands