Data Engineer - Customer

Fortnum & Mason; London; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

A leading retail company in London is seeking a SCV and CDP Engineer to develop and maintain customer data platforms. This role involves ensuring data accuracy, building robust data models, and collaborating across teams to support marketing initiatives. The ideal candidate has a minimum of 3-5 years in SCV and CDP environments, excellent skills in Power BI, SQL, and Python, and a strong understanding of data governance practices. The position offers a flexible work location and opportunities for professional growth.

Benefits

Generous store and restaurant discount

25 days holidays plus one for birthday

Subsidised staff restaurant

Development opportunities

Qualifications

• Minimum of 3-5 years experience working within SCV and CDP landscape.
• Good understanding of Data Warehouse and ETL processes.
• Experience in Data Privacy Frameworks and GDPR.
• Experience in coding using Python.
• Experience with Data Pipelines.

Responsibilities

• Translate business needs to technical specifications.
• Develop and maintain SCV Data Model and architecture.
• Ensure reliability and performance of both platforms.
• Implement Data Quality rules and ensure adherence.
• Ensure GDPR regulations are followed.

Skills

Power BI

SQL

Python

Data Modelling

Data Governance

Customer Experience

Education

BSc/BA in Computer Science, Engineering or relevant Data or Analytics field

Tools

Databricks

Azure Synapse

Azure Data Lake

Job description

Social network you want to login/join with:

Reports to:Data and Engineering Platforms Manager

Key Relationships:Fortnum’s Management Group, Marketing and Analytics, Transformation Teams, Finance, B&M, Logistics, Retail, Data and Development Teams, UK and HK Stores, external suppliers and partners

Location:Piccadilly/Remote

Role Purpose

The SCV and CDP Engineer will have dual responsibilities, which are listed below, but it is important that the role respects the close link between the two – changes or adjustments in one will be linked naturally to the other so the role will specifically be around how these two applications work together well and an understanding of the need for a broader, holistic way of thinking.

Single Customer View (SCV):

Develop and maintain the F&M SCV in order to maintain a comprehensive and unified view of customers data across various systems and channels. Of paramount importance is reliable and trouble-free access to relevant SCV information, with the data being both accurate and consistent.

The SCV platform will require maintenance and updating, and there will be further phases of ingestion and cleansing from other data sources and platforms and this will need managing. There will be a requirement to ensure the Data Dictionary is accurate and up to date and that various quality checks on the data are completed (e.g. Name and Address management).

There is also a need to maintain close ties with our in-house Engineering team and our various suppliers – especially our probabilistic matching supplier.

Customer Data Platform (CDP):

Develop, build and maintain the F&M CDP to ensure stored data is accessible, accurate, consistent and can be easily used in marketing and personalisation campaigns.

Particular focus should be given to working with the chosen CDP platform to understand data modelling, quality, consistent performance and continued optimisation. A good understanding of data governance is a must as well as being able to fully understand the platform architecture and its ability to scale in an efficient manner to further support growth initiatives.

They must be able to collaborate effectively with colleagues across the organisation at all levels and be conscientious and accurate whilst working in a fast-paced retail environment. Our teams are small so being aligned to our ways of working, values and team culture are very important.

They must show a passion for what they do and be a natural self-starter, and ensure they keep up with the latest trends and technologies within the Data Landscape and are willing to try new initiatives and explore different ways of ensuring we get to know our customers better.

Responsibilities

• Translate business needs to technical specifications – this will require collaboration across various teams and stakeholders within F&M to understand requirements and then implement
• Develop and maintain a robust and efficient SCV Data Model/s and architecture
• Assist in maintenance and support of the SCV, CDP and applicable supporting applications
• Ensure reliability, scalability and performance aspects of both platforms
• Develop and maintain API and other relevant ingestion integrations with required systems
• Implementation of Data Quality rules and ensure adherence
• Ensure CDP architecture and scalability; ability to ensure the platform responds efficiently both now and in the future.
• Ensure comprehensive planning, estimation and management of projects of all sizes across a range of stakeholders
• Ability to troubleshoot technical issues on all applicable platforms and environments
• Ensure a high level of data governance is adhered to at all times
• Ensuring that regulations surrounding GDPR legislation are followed and adhered to at all times
• Ability to stay up to date with the latest innovations and technological solutions within the SCV and CDP areas
• Ensure F&M have a clear roadmap and vision for enhancements and improvements to both platforms moving forward
• Ensure that engineering functions are worked through alongside the Data Engineering team and our external partners and suppliers where required

Experience and Qualifications

• A minimum of 3-5 years demonstrable experience working within the SCV and CDP landscape
• Good understanding of the Data Modelling, Data Warehouse and ETL processes
• Good technical and operational knowledge of Databricks and Azure Synapse
• Experience of working within Data Privacy Frameworks and GDPR
• Experience of working with Data Visualisation and an operational awareness of analytics tools, specifically Power BI
• Experience of coding using Python
• Demonstrable experience of cloud storage technologies (e.g. Azure Data Lake)
• Experience of working with probabilistic modelling applications
• Experience of working within Database Management
• Excellent communication skills and ability to work at all levels within a business
• Experience of building and maintaining data models and applications – specifically around entity resolution and chosen record
• Experience of relevant CDP Platforms
• Experience of working with Data Pipelines
• Ability to communicate in an understandable way technical aspects to a non-technical audience at all levels
• BSc/BA in Computer Science, Engineering or relevant Data or Analytics field
• Experience of working within MS Fabric
• Experience of working with CDP or SCV suppliers
• Retail industry experience

Competencies, Behaviours and Skills

• Strong knowledge of Power BI, SQL and Python
• Good experience and understanding of Customer Experience and Customer Relationship Management* Must be happy to work in a fast-paced environment
• Must be able to manage workload independently
• Ability to work across divisions within the company as required
• Ability to understand how an end user would use the applications and be able to transfer requests from end user/s into the application
• Ability challenge end users and the business, if required, to ensure scalability, reliability and resilience of the system and where the time spent outstrips the estimated ROI
• Ability to work as a team player and put provision of customer and company value as a defining principal
• To be able to work from defined principles and processes
• Experience of working within a Retail environment would be advantageous

In return, we offer:

• A generous store and restaurant discount of up to 40%
• 25 days holidays (excluded bank holidays) and an extra day off for your birthday
• A fantastic subsidised staff restaurant which uses Fortnum’s ingredients
• A range of opportunities to develop and grow personally and professionally

We are committed to developing your career and nurturing your talent, regardless of age; disability; gender reassignment; marriage and civil partnership; pregnancy and maternity; race; religion or belief; sex; sexual orientation. We respect and embrace each other's differences, to create a truly inclusive environment.

In the last year alone, our people have been recognised and celebrated, winning awards for their outstanding contributions to Retail, Technology, Global Hospitality & Tourism, Visual Merchandising & Display, Customer Service and Local Community Awards.