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

Lead data Engineer - Financial Markets - Day rate

Senior Data Consultant

Data Engineering Lead (Snowflake & AWS Environment)

Data Engineering Lead

Data Engineering Lead (Snowflake & AWS Environment)

Senior 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 Machine Learning Jobs (With Real GitHub Examples)

In today’s data-driven landscape, the field of machine learning (ML) is one of the most sought-after career paths. From startups to multinational enterprises, organisations are on the lookout for professionals who can develop and deploy ML models that drive impactful decisions. Whether you’re an aspiring data scientist, a seasoned researcher, or a machine learning engineer, one element can truly make your CV shine: a compelling portfolio. While your CV and cover letter detail your educational background and professional experiences, a portfolio reveals your practical know-how. The code you share, the projects you build, and your problem-solving process all help prospective employers ascertain if you’re the right fit for their team. But what kinds of portfolio projects stand out, and how can you showcase them effectively? This article provides the answers. We’ll look at: Why a machine learning portfolio is critical for impressing recruiters. How to select appropriate ML projects for your target roles. Inspirational GitHub examples that exemplify strong project structure and presentation. Tangible project ideas you can start immediately, from predictive modelling to computer vision. Best practices for showcasing your work on GitHub, personal websites, and beyond. Finally, we’ll share how you can leverage these projects to unlock opportunities—plus a handy link to upload your CV on Machine Learning Jobs when you’re ready to apply. Get ready to build a portfolio that underscores your skill set and positions you for the ML role you’ve been dreaming of!

Machine Learning Job Interview Warm‑Up: 30 Real Coding & System‑Design Questions

Machine learning is fuelling innovation across every industry, from healthcare to retail to financial services. As organisations look to harness large datasets and predictive algorithms to gain competitive advantages, the demand for skilled ML professionals continues to soar. Whether you’re aiming for a machine learning engineer role or a research scientist position, strong interview performance can open doors to dynamic projects and fulfilling careers. However, machine learning interviews differ from standard software engineering ones. Beyond coding proficiency, you’ll be tested on algorithms, mathematics, data manipulation, and applied problem-solving skills. Employers also expect you to discuss how to deploy models in production and maintain them effectively—touching on MLOps or advanced system design for scaling model inferences. In this guide, we’ve compiled 30 real coding & system‑design questions you might face in a machine learning job interview. From linear regression to distributed training strategies, these questions aim to test your depth of knowledge and practical know‑how. And if you’re ready to find your next ML opportunity in the UK, head to www.machinelearningjobs.co.uk—a prime location for the latest machine learning vacancies. Let’s dive in and gear up for success in your forthcoming interviews.

Negotiating Your Machine Learning Job Offer: Equity, Bonuses & Perks Explained

How to Secure a Compensation Package That Matches Your Technical Mastery and Strategic Influence in the UK’s ML Landscape Machine learning (ML) has rapidly shifted from an emerging discipline to a mission-critical function in modern enterprises. From optimising e-commerce recommendations to powering autonomous vehicles and driving innovation in healthcare, ML experts hold the keys to transformative outcomes. As a mid‑senior professional in this field, you’re not only crafting sophisticated algorithms; you’re often guiding strategic decisions about data pipelines, model deployment, and product direction. With such a powerful impact on business results, companies across the UK are going beyond standard salary structures to attract top ML talent. Negotiating a compensation package that truly reflects your value means looking beyond the numbers on your monthly payslip. In addition to a competitive base salary, you could be securing equity, performance-based bonuses, and perks that support your ongoing research, development, and growth. However, many mid‑senior ML professionals leave these additional benefits on the table—either because they’re unsure how to negotiate them or they simply underestimate their long-term worth. This guide explores every critical aspect of negotiating a machine learning job offer. Whether you’re joining an AI-focused start-up or a major tech player expanding its ML capabilities, understanding equity structures, bonus schemes, and strategic perks will help you lock in a package that matches your technical expertise and strategic influence. Let’s dive in.