Lead Data Engineer

Sanctuary is one of the UK’s leading providers of housing, care and community services. With around 13,000 employees, we maintain a culture where diversity is valued and talent is nurtured and rewarded.

Lead Data Engineer

Worcester based with a balance of home and office working

£70,967 – £74,702 per year

35 hours per week – Monday to Friday

We are seeking a Lead Data Engineer to join our team based in Worcester. This job sits within 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.

The role of Lead Data Engineer will include:

• Engaging and collaborating with business stakeholders across all levels of the organisation to create and maintain conceptual, logical, and physical data models for Sanctuary Group’s analytical data
• Producing and maintaining metadata (including relationships, calculation logic etc.) and documentation to accompany data models using data modelling tools
• Managing delivery of data analysis projects, gathering business requirements from service users, converting them into functional specifications and liaising with third party contractors to agree the scope, benefits and delivery of proposed solutions across multiple systems
• Integrate SAP Datasphere with SAP BW and BW bridge development to support various data and analytics initiatives
• Utilise best practice architecture and design principles to create analytical data models
• Reviewing and updating support & operations documentation where required
• Participating in production support role during key activity periods when required month-end, quarter-end, year-end etc
• Ensuring the consistency of master data between related systems
• Reviewing & improving existing master data interfaces to eliminate master data issues in SAP ECC, BW, BPC and any downstream systems

Skills and experiences:

• Degree, management qualification or relevant professional qualification
• Diploma in Business Analysis or knowledge and ability at an equivalent level
• SAP Analytics tools (e.g. SAP Application Associate – SAP Analytics Cloud (SAC), Data Warehouse Cloud (DWC)) certified or equivalent experience
• Recent experience of undertaking a similar role
• Substantial experience of analysing, diagnosing and resolving data integration issues
• Extensive knowledge of SAP BW, ECC, S/4 and SAC and its data structures
• Expertise in S/4HANA Analytics, including CDS Views Development, SAP HANA Cloud, or HANA 2.0, and SAP BW/4HANA.
• Design and develop analytical models using Graphical/SQL View.
• Ability to design and implement complex dataflows.
• Experience working on mixed modeling with BW and HANA native modeling.
• Experience in the integration of SAP and non-SAP data sources (Federated, Replication).
• Strong understanding of data governance principles and practices

Why work for us?

One of the UK’s leading providers of housing, care and commercial services, Sanctuary employs more than 14,000 people and manages over 116,000 units of accommodation throughout England and Scotland, including general rented, retirement living, supported housing, student and key worker accommodation and care homes. Sanctuary also provides a range of other services including maintenance, care and telecare, all of which are delivered by our dedicated employees who are completely committed to customer service.  

Our Benefits    

As part of our commitment to making Sanctuary a great place to work, where your wellbeing is of genuine importance, we have developed an attractive employment package. The package recognises your contribution, supports your physical, mental and financial health and gives you the flexibility to tailor your employee benefits by offering:

• 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
• Life Assurance
• Employee Volunteering scheme
• Employee Advice Service including counselling
• Cycle to Work scheme
• Voluntary health plans  
• Employee discounts
• Wellbeing support and tools
• Employee recognition scheme
• Employee platform to access your reward and wellbeing package online, find exclusive discounts, wellbeing resources and recognition tools
• Employee Networks, with a shared interest in inclusion, and who provide invaluable support to colleagues
• Role salary is £53,134 with an additional policy allowance of £17,832 per annum (rising to £55,931 with an additional policy allowance of £18,770 per annum after 12 months, subject to satisfactory performance)

To view the job profile please click here

Closing Date: 6 October 2024

We reserve the right depending on application numbers to close or extend the closing dates for positions; we would therefore recommend an early application.

For an insight into what it’s like to work for us, take a look at our company page on Linkedin

Inclusion is one of our core values. Our goal is to be a diverse, inclusive organisation where our people thrive and meet our customers’ needs with fairness and empathy. We know having a range of ideas and opinions makes a difference.  We encourage and welcome applications from people from diverse backgrounds to support this mission.  We will make adjustments throughout your application process, in line with Sanctuary’s commitment to our Disability Confident employer status.

Building Equality and Diversity

Sanctuary Group encourages and welcomes applications from people from diverse backgrounds to support our commitment to offering an inclusive environment for our employees and customers. 
We work closely with the Home Office in order to prevent unlawful working.
Sanctuary Group is a trading name of Sanctuary Housing Association, an exempt charity.