Data Engineer

TN United Kingdom; Weston-super-Mare; On-site; GBP 60,000 - 100,000; Full time

Job summary

An established industry player is seeking a Data Engineering Lead to spearhead a major Data Transformation Programme. In this pivotal role, you will lead a talented team of Data Engineers and BI Developers, driving the evolution of their Data Strategy. Your expertise in ETL processes, data architecture, and cloud solutions will be crucial in optimizing data management and analytics. This is a fantastic opportunity to join a rapidly growing organization, where your contributions will directly impact commercial growth and innovation. If you're passionate about data and eager to take on a leadership role, this is the perfect fit for you.

Qualifications

• Experience with ETL/ELT tools, especially Matillion, is essential.
• Proven track record in data migration and business logic mapping.

Responsibilities

• Lead the design and implementation of ETL processes for new ERP systems.
• Architect and develop the Snowflake data warehouse for analytics.

Skills

ETL/ELT Tools

SQL Server

Snowflake

Power BI

Data Migration

Business Analysis

Data Analytics

KPI Reporting

Manufacturing and Supply Chain

Financial Principles

Tools

Matillion

Microsoft Dynamics AX

MS BI Stack

Job description

Social network you want to login/join with:

• Opportunity to work on a major Data Transformation Programme
• Opportunity to join a rapid growth organisation

About Our Client

Rapidly expanding manufacturer and retailer

Job Description

This rapidly expanding manufacturer and retailer is looking to appoint a Data Engineering Lead / Data Architect to support the continued evolution of their Data Strategy and roadmap towards using more advanced analytics and insights 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. 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 the 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, while optimizing the warehouse structure for performance, scalability, and ease of use.
• Ensure collaboration between BI and Data teams with business users to understand, qualify, design, build, test, and deliver requirements.
• Work with and oversee third-party providers to ensure cost-effective and optimized technologies and services, while ensuring adherence to SLAs.
• Provide direction on data management, storage, and retrieval to enable efficient use of technology.
• Design, implement, and manage BI infrastructure and services, delivering business data insights aligned with IT strategy and roadmap.
• Act as a subject matter expert on data analytics, data modeling, warehousing, data mining, and presentation to support future projects.
• Ensure smooth operation of BI services, acting as a point of escalation for support and technical issues.
• Collaborate with senior stakeholders and programme boards to deliver KPI reporting.

Key Technical Areas:

• Systems Architecture: Knowledge of system architecture models for scalable, secure, and efficient data solutions.
• Business Analysis: Translate stakeholder requirements into strategic application plans.
• Business Intelligence: Understanding of data lifecycle from ETL to analysis and reporting.
• IT Security: Knowledge of security challenges and mitigation techniques.
• Effective Governance: Manage projects and stakeholder relationships effectively.
• Service and Supplier Management: Provide high-quality service management, aligning with business needs.
• Experience with ETL tools (Matillion preferred).
• Experience with SQL Server and Snowflake or other cloud data warehousing solutions (Azure/AWS).
• Experience with Kimball methodology for analytics and reporting.
• Data migration experience, including business logic mapping.
• Ability to convert business requirements into solutions.
• Experience with Power BI and ERP reporting.
• Understanding of MS BI stack (SSIS, SSAS).
• Knowledge of Microsoft Dynamics AX or IFS.
• Manufacturing and supply chain exposure.
• Understanding of financial principles.
• Experience of KPI reporting.

The Successful Applicant

• Experience with ETL/ELT tools (Matillion preferred).
• Experience with SQL Server and Snowflake or other cloud data warehousing solutions.
• Experience with Kimball methodology.
• Data migration and business logic mapping experience.
• Proficiency in Power BI and ERP systems reporting.
• Understanding of MS BI stack.
• Knowledge of Microsoft Dynamics AX or IFS.
• Manufacturing and supply chain exposure.
• Understanding of financial principles.
• Experience with KPI reporting.

What's on Offer

Opportunity to work on a major Data Transformation Programme and to join a rapidly growing organization.