Data Engineer

• Collaborate with business stakeholders to map and integrate source data into the Data Warehouse.
• Design and build scalable data pipelines to onboard disparate data sources into a cloud-based SQL Data Warehouse.
• Modernise and optimise ETL/ELT processes through automation and metadata-driven frameworks.
• Develop and enhance data models that accurately represent end-to-end business processes.
• Implement best practices in data engineering, DevOps, and CI/CD.
• Improve pipeline performance, reliability, and scalability.
• Support infrastructure, data validation, and pipeline testing.
• Contribute to the design of a modern, enterprise-grade data architecture.
• Communicate complex technical concepts clearly to both technical and non-technical stakeholders.

We are seeking a highly skilled Data Engineer to join our team and play a pivotal role in modernising our data ecosystem. This is an exciting opportunity to design and build scalable, cloud-based data solutions that support advanced analytics, business intelligence, and strategic decision-making.

You will lead the onboarding of disparate data sources into a modern data warehouse, implement robust data pipelines, and help shape a future-ready architecture. The ideal candidate will bring deep expertise in Microsoft Azure technologies, particularly Azure Synapse and Microsoft Fabric alongside strong technical and stakeholder management skills., * Bachelor's or Master's degree in Computer Science, Engineering, or equivalent experience.

• Proven expertise in Microsoft Azure Synapse and/or Microsoft Fabric (essential).
• Minimum of 8 years' hands-on experience in data engineering across on-premise and cloud platforms.
• Strong experience designing and building large-scale data warehouses and platforms.
• Expertise in ETL/ELT processes, data modelling, and modern data architecture.
• Experience implementing DevOps practices, automation, and CI/CD pipelines.
• Proficiency in data modelling tools and methodologies.
• Excellent communication and stakeholder engagement skills.

Preferred Technical Skills

• Advanced knowledge of Microsoft SQL Server, including stored procedures, views, and functions.
• Strong experience in dimensional, transactional, and reporting data models (logical and physical).
• Proficiency in programming languages such as Python or C#.
• Experience with Spark, notebooks, and distributed data processing frameworks.

• Salary up to £55,000 DOE
• Company performance bonus
• Hybrid working (3 days per week in the office)
• Generous Holiday Package: Recoup with 26 days of holiday plus bank holidays, extending by one day each year of service up to a generous 31 days with the flexibility to buy and sell holiday days.
• Pension Plan: Secure your future with a generous pension plan
• Dedicated days for giving back to the community through charitable activities.
• Life Assurance and Income protection.
• Perks at Work: Access to a wide range of discounts including my gym discounts
• Peppy: Confidential access to expert health support across areas like fertility, menopause, pregnancy, and more.

At CPM, we are proud to foster an inclusive work environment. We believe in a workplace that celebrates the unique perspectives and skills of all individuals believing this makes us stronger and more innovative. Should you require any adjustments or support during the application process, please don't hesitate to let us know. Our goal is to help you feel comfortable and confident, allowing you to showcase your unique skills and abilities to their fullest potential. CPM has been accredited Investors in People Gold award and places great importance on the training and development of our people. We work in a cooperative environment where great ideas and achievements are shared and celebrated.