SAP BW Data Engineer

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.

The role of Data Engineer will include:

• Define and execute the data engineering initiatives within the Data Strategy aligned with corporate goals and regulatory requirements. Lead the development of scalable, secure and efficient data pipelines and integration patterns across SAP and non SAP systems
• Manage the full ETL Lifecycle: data ingestion, transformation and loading of data into SAP and Analytics platforms. Ensure robust data movement between operational systems and the BI and Analytics serving layer, including SAP BW/4HANA, Datasphere and SAP Analytics Cloud. Design and implement batch and real-time data pipelines using modern tools and frameworks
• Ensure data engineering solutions are compliant with data governance, security and privacy standards. Drive adoption of DataOps practices including CI/CD, monitoring and automated testing of pipelines
• Support the modelling, design and optimisation of data stores across platforms
• Develop data pipelines and solutions that include data capture and data flow/transformation to integrate data from multiple systems and make it easily available for analysis
• Ensure data pipelines and analytics workloads are proactively monitored for uptime, compliance, governance and quality and alerts that are managed and remediated when there is an issue
• Partner with Data Governance, Data Architecure, Data Enablement, BI and business teams to fully understand data requirements and build fit-for-purpose solutions. Represent Data Engineering in forums such as CAB, Technical Advisory Board and Architecture Review Board. Support Data Governance initiatives by providing documentation of source-to-target mappings

Skills and experiences:

• Diploma in Business Analysis or knowledge and ability at an equivalent level
• SAP Analytics tools (e.g. SAP Application Associate - SAP Analytics Cloud (SAC), Datasphere) 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?

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.

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 Advice Service including counselling
• Cycle to Work scheme
• Voluntary health plans
• Wellbeing support and tools
• 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 £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)