SAP LSMW and Data Migration Engineer at Sanctuary in Worcester, England, United Kingdom | GBP73,166-77,017 | Kablio

Role

Description

data extraction

data migration

data mapping

job optimization

data integrity

documentation

This role sits in Data Management Team as part of Technology which is responsible for delivering Technology capability within Sanctuary Group to ensure employees have access to the systems they need to perform their duties. This role reports into the Head of Data Engineering.

Performing data extraction from legacy systems and load into SAP environments (ECC, S/4HANA)
Designing and executing data migration strategies using LSMW and SDS tools
Developing and maintaining data mapping, transformation, and validation rules
Troubleshooting and optimizing migration jobs for performance and accuracy
Collaborating with functional teams to ensure data integrity and compliance with business requirements
Preparing technical documentation and provide knowledge transfer to internal teams

Requirements

sap ecc

s/4hana

lsmw

bods

sql

abap

SAP LSMW and Data Migration Engineer

Experience in data cleansing, validation, and reconciliation
Knowledge of SAP ECC and S/4HANA data structures
Strong proficiency in LSMW techniques (batch input, direct input, BAPI, IDoc)
Wellbeing support and tools
Excellent problem-solving and communication skills
Hands-on experience with SAP Data Services (BODS) for ETL processes
Familiarity with SQL, ABAP basics, and integration with external systems

Benefits

We provide homes and care for more than 250,000 people in England and Scotland. Our customers are at the heart of all we do. With around 14,000 colleagues, we foster a diverse and inclusive culture, and nurture and reward talent.

£73,166 - £77,017 per year plus Company car or car allowance

Employee recognition scheme
Employee platform to access your reward and wellbeing package online, find exclusive discounts, wellbeing resources and recognition tools
Role salary is £54,197 with an additional policy allowance of £18,969 per annum (rising to £57,050 with an additional policy allowance of £19,967 per annum after 12 months, subject to satisfactory performance)
25 days annual leave (rising to a maximum of 30 days) plus public holidays
A pension scheme with matching employer contributions from Sanctuary up to set limits
Voluntary health plans
Employee Volunteering scheme
Cycle to Work scheme
Employee discounts
Life Assurance
Employee Advice Service including counselling

Training + Development

Information not given or found

Interview process

Information not given or found

Visa Sponsorship

Information not given or found

Security clearance

Information not given or found

Company

Overview

Born in 1969

Year of establishment

The company originated in 1969 as the World of Property Housing Trust.

125,000 homes

Properties managed

The company builds, owns, and manages over 125,000 homes across various housing types.

100 care homes

Care facilities operated

Its care arm manages over 100 residential care homes and supported living units.

It builds, owns and manages roughly 125,000 homes, encompassing affordable rent, shared ownership, student and keyworker housing.
Its care arm runs over 100 residential care homes and supported living units, transforming lives through specialist services.
Financed via careful stewardship and not‑for‑profit reinvestment, Sanctuary reinvests every penny into community development.
Large-scale retrofit schemes, including multi‑million-pound EPC upgrades, showcase its commitment to enhancing residents’ homes.
Regeneration projects breathe new life into neighbourhoods, such as transforming Glasgow’s former Victoria Infirmary into homes.
Unusual in its breadth, it operates across housing, care, student living, supported and keyworker accommodation under one umbrella.
A strategic acquirer, recent additions include Cornwall Care, Swan Housing Association and Johnnie Johnson Housing.
Its scale grants access to grants and public funding, enabling ambitious schemes in England and Scotland.

Culture + Values

Inclusion is one of our core values.
We work together as one team to support our social purpose and put our customers at the heart of everything we do.
We value transparency and accountability in actions toward decarbonisation and sustainability.

Environment + Sustainability

2,700 Homes

Retrofitting Achievements

Improved energy efficiency by retrofitting homes to meet higher environmental standards.

£1.4M Investment

Community Investment

Allocated significant funds to support community initiatives and projects.

38% Reduction

Operational Emissions Cut

Achieved a substantial reduction in operational carbon emissions.

33% Target

Capital Goods Emissions

Aiming to significantly reduce emissions from capital goods by 2030.

Committed to achieving net zero carbon emissions by 2050
Target to reduce downstream leased assets emissions by 18% by 2030
Target to reduce employee commuting emissions by 20% by 2030
Extended carbon emissions reduced by 4% year-on-year (2022/23 to 2023/24)
Reduced personal debt by £774,900

Inclusion & Diversity

2024-2026 Inclusion Strategy

Inclusion for All Strategy

The company's Inclusion for All strategy focuses on understanding customers, attracting diverse talent, providing inclusive workplaces, and embedding an inclusive culture over the next three years.

Over 6% Disabled Staff

Disabled Employees Representation

More than 6% of the company's workforce identifies as disabled, reflecting its commitment to disability inclusion.

1,500 Employees Surveyed

Workplace Adjustments Review

The company conducted a survey to review workplace adjustments for disabled employees, involving over 1,500 employees and 400 managers.

5 Years of Gender Pay Gap Reporting

Gender Pay Gap Transparency

The company has publicly reported its gender pay gap for five consecutive years, highlighting the need to address the overrepresentation of women in lower-paid roles.

Inclusion, Diversity, Equality, Equity are the company's core values.
The company monitors all nine protected characteristics under the Equality Act 2010 for equality analysis.
The organization is a Disability Confident Employer and conducts self-assessments on recruiting and retaining disabled people.
Colleague networks include the Disability Network, PRISM (LGBTQIA+), REN (Race Equality), and Parent Network.
The gender pay gap is attributed to the overrepresentation of women in lower-paid roles.

Articles

About Sanctuary

Careers at Sanctuary

Sanctuary Projects

Role

Description

data extraction

data migration

data mapping

job optimization

data integrity

documentation

Performing data extraction from legacy systems and load into SAP environments (ECC, S/4HANA)
Designing and executing data migration strategies using LSMW and SDS tools
Developing and maintaining data mapping, transformation, and validation rules
Troubleshooting and optimizing migration jobs for performance and accuracy
Collaborating with functional teams to ensure data integrity and compliance with business requirements
Preparing technical documentation and provide knowledge transfer to internal teams

Requirements

sap ecc

s/4hana

lsmw

bods

sql

abap

SAP LSMW and Data Migration Engineer

Experience in data cleansing, validation, and reconciliation
Knowledge of SAP ECC and S/4HANA data structures
Strong proficiency in LSMW techniques (batch input, direct input, BAPI, IDoc)
Wellbeing support and tools
Excellent problem-solving and communication skills
Hands-on experience with SAP Data Services (BODS) for ETL processes
Familiarity with SQL, ABAP basics, and integration with external systems

Benefits

£73,166 - £77,017 per year plus Company car or car allowance

Employee recognition scheme
Employee platform to access your reward and wellbeing package online, find exclusive discounts, wellbeing resources and recognition tools
Role salary is £54,197 with an additional policy allowance of £18,969 per annum (rising to £57,050 with an additional policy allowance of £19,967 per annum after 12 months, subject to satisfactory performance)
25 days annual leave (rising to a maximum of 30 days) plus public holidays
A pension scheme with matching employer contributions from Sanctuary up to set limits
Voluntary health plans
Employee Volunteering scheme
Cycle to Work scheme
Employee discounts
Life Assurance
Employee Advice Service including counselling

Training + Development

Information not given or found

Interview process

Information not given or found

Visa Sponsorship

Information not given or found

Security clearance

Information not given or found

Company

Overview

Born in 1969

Year of establishment

The company originated in 1969 as the World of Property Housing Trust.

125,000 homes

Properties managed

The company builds, owns, and manages over 125,000 homes across various housing types.

100 care homes

Care facilities operated

Its care arm manages over 100 residential care homes and supported living units.

It builds, owns and manages roughly 125,000 homes, encompassing affordable rent, shared ownership, student and keyworker housing.
Its care arm runs over 100 residential care homes and supported living units, transforming lives through specialist services.
Financed via careful stewardship and not‑for‑profit reinvestment, Sanctuary reinvests every penny into community development.
Large-scale retrofit schemes, including multi‑million-pound EPC upgrades, showcase its commitment to enhancing residents’ homes.
Regeneration projects breathe new life into neighbourhoods, such as transforming Glasgow’s former Victoria Infirmary into homes.
Unusual in its breadth, it operates across housing, care, student living, supported and keyworker accommodation under one umbrella.
A strategic acquirer, recent additions include Cornwall Care, Swan Housing Association and Johnnie Johnson Housing.
Its scale grants access to grants and public funding, enabling ambitious schemes in England and Scotland.

Culture + Values

Inclusion is one of our core values.
We work together as one team to support our social purpose and put our customers at the heart of everything we do.
We value transparency and accountability in actions toward decarbonisation and sustainability.

Environment + Sustainability

2,700 Homes

Retrofitting Achievements

Improved energy efficiency by retrofitting homes to meet higher environmental standards.

£1.4M Investment

Community Investment

Allocated significant funds to support community initiatives and projects.

38% Reduction

Operational Emissions Cut

Achieved a substantial reduction in operational carbon emissions.

33% Target

Capital Goods Emissions

Aiming to significantly reduce emissions from capital goods by 2030.

Committed to achieving net zero carbon emissions by 2050
Target to reduce downstream leased assets emissions by 18% by 2030
Target to reduce employee commuting emissions by 20% by 2030
Extended carbon emissions reduced by 4% year-on-year (2022/23 to 2023/24)
Reduced personal debt by £774,900

Inclusion & Diversity

2024-2026 Inclusion Strategy

Inclusion for All Strategy

The company's Inclusion for All strategy focuses on understanding customers, attracting diverse talent, providing inclusive workplaces, and embedding an inclusive culture over the next three years.

Over 6% Disabled Staff

Disabled Employees Representation

More than 6% of the company's workforce identifies as disabled, reflecting its commitment to disability inclusion.

1,500 Employees Surveyed

Workplace Adjustments Review

The company conducted a survey to review workplace adjustments for disabled employees, involving over 1,500 employees and 400 managers.

5 Years of Gender Pay Gap Reporting

Gender Pay Gap Transparency

The company has publicly reported its gender pay gap for five consecutive years, highlighting the need to address the overrepresentation of women in lower-paid roles.

Inclusion, Diversity, Equality, Equity are the company's core values.
The company monitors all nine protected characteristics under the Equality Act 2010 for equality analysis.
The organization is a Disability Confident Employer and conducts self-assessments on recruiting and retaining disabled people.
Colleague networks include the Disability Network, PRISM (LGBTQIA+), REN (Race Equality), and Parent Network.
The gender pay gap is attributed to the overrepresentation of women in lower-paid roles.

Articles

About Sanctuary

Careers at Sanctuary

Sanctuary Projects