Data Engineering Lead / Data Architect

Weston-super-Mare
6 days ago
Create job alert

This rapidly expanding manufacturer and retailer and looking to appoint a Data Engineering Lead / Data Architect to support on the continued evolution their Data Strategy and roadmap towards using more advanced analytics and insight to drive commercial growth. You will be pivotal and hands-on in leading a small team of Data Engineers and BI Developers to support their Cloud transformation.

Client Details

Rapidly expanding manufacturer and retailer

Description

This rapidly expanding manufacturer and retailer and looking to appoint a Data Engineering Lead / Data Architect to support on the continued evolution their Data Strategy and roadmap towards using more advanced analytics and insight to drive commercial growth. You will be pivotal and hands-on in leading a small team of Data Engineers and BI Developers to support their Cloud transformation, a knowledge of Data Architecture is highly desirable but a Senior Data Engineer looking to transition into this domain will also be considered.

Key Responsibilities:

Oversee and lead the design and implementation of ETL/ELT processes to ingest data from new ERP system into Snowflake
Architect and develop the Snowflake data warehouse to support reporting and analytics needs, incorporating existing SQL-Server based business logic, whilst optimising the warehouse structure for performance, scalability, and ease of use
Ensure that the BI and Data team work closely and collaboratively with business users to understand, qualify, design, build test, and deliver their requirements
Work in collaboration with and oversee third-party providers to ensure that technologies and services are both cost-effective and optimized for the organization, while ensuring that providers adhere to established Service Level Agreements.
Provide direction for how the business are moving, transforming, storing, and retrieving data to enable the most efficient and effective use of technology for the business
Design, implement, and manage the BI infrastructure and services, as well as deliver business data insights requirement in alignment to the IT strategy and roadmap
Act as subject matter expert on all aspects of data analytics, analytics data modelling and warehousing, data mining, and presentation with a view to support future relevant projects and initiatives
Ensure that BI service runs smoothly, including to act as a point of escalation for the Support and Technical teams, to monitor and resolve issues
Work with senior stakeholders and programme boards to deliver company KPI reportingKey Technical Areas:

Systems Architecture: Knowledge of system architecture models, including the design, behavior, and interaction of components and subsystems that enable seamless data integration, storage, processing, and analytics, ensuring scalable secure, and efficient solutions aligned with business objectives.
Business Analysis: Translate internal stakeholders'requirements and technology requirements into a strategic application portfolio plan and ensure its effective management and alignment with organisational goals.
Business Intelligence: Knowledge of the data lifecycle from ETL, through to the analysis of datasets, leading to the publication of information and aiding business stake holders to derive insight and potential trends.
IT Security: Understand IT security challenges and risks, and technologies and techniques to mitigate risks.
Effective Governance: Effectively manage projects and programmes including processes, customs and policies that affect these, as well as relationships between stakeholders and company goals.
Service and Supplier Management: The ability to provide high quality Service Management that aligns the delivery of IS services with the needs of the business, through high-quality products services and the management of external services Key Skills & Experience:

Essential:

Experience with ETL/ETL tools (Matillion preferred)
Experience of SQL Server and Snowflake (or other variants of Cloud Data Warehousing solutions e.g Azure / AWS etc)
Experience using Kimball methodology to support analytics and reporting
Experience with data migration, including mapping existing business logic to new data sources
Experience of converting business requirements into a delivered solution
Experience with Power BIDesirable:

Experience of Business Systems reporting, including ERP
Understanding of the MS BI stack (SSIS, SSAS)
Knowledge of Microsoft Dynamics AX or IFS
Manufacturing and supply chain exposure
Understanding of financial principles
Experience of business KPI reporting

Profile

Key Skills & Experience:

Essential:

Experience with ETL/ELT tools (Matillion preferred)
Experience of SQL Server and Snowflake (or other variants of Cloud Data Warehousing solutions e.g Azure / AWS etc)
Experience using Kimball methodology to support analytics and reporting
Experience with data migration, including mapping existing business logic to new data sources
Experience of converting business requirements into a delivered solution
Experience with Power BIDesirable:

Experience of Business Systems reporting, including ERP
Understanding of the MS BI stack (SSIS, SSAS)
Knowledge of Microsoft Dynamics AX or IFS
Manufacturing and supply chain exposure
Understanding of financial principles
Experience of business KPI reportingJob Offer

Opportunity to work on a major Data Transformation Programme

Opportunity to join a rapid growth organisation

Related Jobs

View all jobs

Data Architect - Contract

Lead data Engineer - Financial Markets - Day rate

Senior Data Consultant

Data Engineering Lead (Snowflake & AWS Environment)

Lead Data Architect

Lead Data Engineer

Get the latest insights and jobs direct. Sign up for our newsletter.

By subscribing you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

Portfolio Projects That Get You Hired for Data Engineering Jobs (With Real GitHub Examples)

Data is increasingly the lifeblood of businesses, driving everything from product development to customer experience. At the centre of this revolution are data engineers—professionals responsible for building robust data pipelines, architecting scalable storage solutions, and preparing data for analytics and machine learning. If you’re looking to land a role in this exciting and high-demand field, a strong CV is only part of the puzzle. You also need a compelling data engineering portfolio that shows you can roll up your sleeves and deliver real-world results. In this guide, we’ll cover: Why a data engineering portfolio is crucial for standing out in the job market. Choosing the right projects for your target data engineering roles. Real GitHub examples that demonstrate best practices in data pipeline creation, cloud deployments, and more. Actionable project ideas you can start right now, from building ETL pipelines to implementing real-time streaming solutions. Best practices for structuring your GitHub repositories and showcasing your work effectively. By the end, you’ll know exactly how to build and present a portfolio that resonates with hiring managers—and when you’re ready to take the next step, don’t forget to upload your CV on DataEngineeringJobs.co.uk. Our platform connects top data engineering talent with companies that need your skills, ensuring your portfolio gets the attention it deserves.

Data Engineering Job Interview Warm‑Up: 30 Real Coding & System‑Design Questions

The world of data engineering has rapidly emerged as a critical pillar for businesses, enabling them to extract insights from vast amounts of information and power data-driven decision-making. From building scalable ETL pipelines to designing real-time streaming infrastructures and cloud data warehouses, data engineers are in high demand across every industry—from tech giants to healthcare providers to financial institutions. If you’re seeking a data engineering role, you may already know that interviews can be rigorous, spanning software development, database design, distributed systems, and cloud computing. Many organisations need engineers who can handle both traditional batch processing and cutting-edge real-time analytics frameworks, all while keeping data secure, consistent, and optimised. In this guide, we’ll explore 30 real coding & system-design questions that often come up in data engineering interviews. From classic coding challenges to architecture-focused scenarios, these questions will help you gauge your readiness and build confidence before stepping into that interview room. If you’re actively searching for new data engineering opportunities in the UK, www.dataengineeringjobs.co.uk is a fantastic resource. It features a wide range of vacancies—from junior data engineering positions to senior-level cloud architecture roles. Let’s dive in so you can approach your next interview with insight and poise.

Negotiating Your Data Engineering Job Offer: Equity, Bonuses & Perks Explained

How to Secure a Compensation Package That Reflects Your Value in the UK’s Fast-Growing Data Ecosystem Introduction Data engineering has quickly become the backbone of modern business operations. Whether powering analytics platforms, migrating data to the cloud, or building pipelines for machine learning, data engineers enable organisations to extract meaningful insights from vast datasets. With companies across every sector looking to harness data for competitive advantage, mid‑senior data engineers are in especially high demand—and that spells opportunity for you to negotiate a compelling compensation package. Yet for many professionals, negotiations around a job offer still focus primarily on salary, leading them to overlook valuable components such as equity, performance bonuses, and perks that can collectively add significant value to your overall deal. In the world of data engineering, it’s not uncommon to see advanced compensation packages involving shares, annual or quarterly bonuses, and a range of benefits that support both your technical growth and work-life balance. This guide aims to be your comprehensive manual for negotiating a data engineering job offer in the UK. We’ll cover why negotiation isn’t just about your monthly paycheck, explore how equity works in data-centric organisations, break down different bonus structures, and highlight perks that matter most for mid‑senior professionals. By the end, you’ll have the knowledge—and the confidence—to land a package that fully reflects your critical role in unlocking the power of data.