Senior Data Engineer

Location: Portsmouth/ London, UK (Hybrid Working Model)

Team: Data Team

Reports to: Head of Data

⭐ Your Mission:

Where data engineering meets customer impact. We need a sharp Data Engineer to own the end-to-end vision for our customer data flow. You will design, develop, and optimize our core CRM and customer data transformation, ensuring technical excellence every step of the way. Critically, you'll partner with Marketing to guarantee they have the best-in-class data required for activation, personalized experiences, and advanced analytics. This role is about delivering foundational technology with a direct, strategic business purpose.

🎯 What You'll Do:

Design & Build: Architect, build, test, and deploy robust, scalable, and reliable data pipelines, focusing on ingesting and transforming CRM and customer data from various sources as we undergo a customer data platform modernization.

Lead & Innovate: Take technical ownership of customer data integration solutions within our data platform (AWS/ SQL Server).

Collaborate: Work closely with a CRM team, data engineers & analysts and marketing teams to understand their data needs and deliver effective solutions.

Enable Marketing Analytics: Design and provide the necessary data structures and transformations required by marketing teams to measure the efficacy of campaigns, particularly tracking customer engagement and conversion through integrated communication and data platforms.

Optimise: Continuously monitor and improve data pipeline performance, reliability, and cost-efficiency.

🔧 What You'll Be Responsible For:

The end-to-end lifecycle of customer data pipelines, from ingestion to activation-ready datasets.

The technical quality, scalability, and reliability of the customer data platform components you build and manage.

Setting standards and promoting data engineering best practices within the customer data domain.

Translating complex business requirements related to customer data into effective technical data solutions.

💡 What You'll Bring (Essential Skills & Experience):

Proven Data Engineering Expertise: Demonstrable experience designing, building, and maintaining complex data pipelines in a production environment.

CRM/Customer Data Focus: Experience working directly with CRM systems (e.g. Salesforce, Dynamics 365, Hubspot) and understanding customer data structures.

Strong Technical Foundation: Expert-level SQL and proficiency in ETL principals. We currently use SQLSvr/ SSIS, but are on a transformation journey of our data platform (AWS)

Cloud Proficiency: Hands-on experience with at least one major cloud platform (AWS, Azure, or GCP) and its core data services (e.g., S3, Redshift, Lambda/Functions, Glue).

Data Modelling: Deep understanding of ELT/ETL patterns, and data modelling techniques.

Collaboration & Communication: Excellent communication skills, with the ability to articulate technical concepts to diverse audiences and collaborate effectively across teams.

✨ Bonus Points For:

Familiarity with data visualization tools (e.g., Tableau, Power BI, Looker).

Experience with specific orchestration tools (e.g., Airflow, dbt).

Experience working in Agile/Scrum development methodologies.

Experience with Big Data Technologies & Frameworks

🚀 Join Us!

If you're ready to make a significant impact by leading the modernization of our customer data capabilities, apply today!