Data Engineering Lead / Data Architect

ZipRecruiter; 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 their Data Transformation Programme. In this pivotal role, you will guide a team of Data Engineers and BI Developers, ensuring the successful implementation of advanced analytics strategies. Your expertise in ETL/ELT processes, along with your proficiency in tools like Snowflake and Power BI, will be crucial in driving commercial growth. This is an exciting opportunity to shape the future of data strategy in a rapidly expanding organization, making a significant impact on business insights and decision-making.

Qualifications

• Experience leading data engineering teams and managing BI services.
• Strong knowledge of data architecture and cloud transformation.

Responsibilities

• Lead the design and implementation of ETL/ELT processes.
• Architect and develop the Snowflake data warehouse for analytics.

Skills

ETL/ELT tools (Matillion)

SQL Server

Snowflake

Kimball methodology

Power BI

Data migration

Business logic mapping

Tools

Power BI

Matillion

MS BI stack (SSIS, SSAS)

Job description

Job Description

This rapidly expanding manufacturer and retailer is looking to appoint a Data Engineering Lead / Data Architect to support the ongoing evolution of their Data Strategy and roadmap, aiming to leverage more advanced analytics and insights to drive commercial growth. You will play a pivotal and hands-on role 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 is seeking a Data Engineering Lead / Data Architect to support the continued development of their Data Strategy and roadmap, focusing on advanced analytics and insights for business growth. The role involves leading a team of Data Engineers and BI Developers, with a strong emphasis on supporting their Cloud transformation. Knowledge of Data Architecture is highly desirable; however, a Senior Data Engineer looking to transition into this domain will also be considered.

Key Responsibilities:

1. Oversee and lead the design and implementation of ETL/ELT processes to ingest data from new ERP system into Snowflake.
2. Architect and develop the Snowflake data warehouse to support reporting and analytics needs, incorporating existing SQL-Server based business logic, while optimizing the warehouse for performance, scalability, and ease of use.
3. Ensure close collaboration between the BI and Data teams and business users to understand, qualify, design, build, test, and deliver requirements.
4. Work with and oversee third-party providers to ensure cost-effective and optimized technologies and services, while ensuring adherence to SLAs.
5. Provide strategic direction on data movement, storage, and retrieval to enable efficient technology use.
6. Design, implement, and manage the BI infrastructure and services, delivering business data insights aligned with the IT strategy and roadmap.
7. Act as a subject matter expert on data analytics, modeling, warehousing, data mining, and presentation to support future projects.
8. Ensure smooth operation of BI services, acting as a point of escalation for support and technical issues.
9. Collaborate with senior stakeholders and programme boards to deliver KPI reporting.

Key Technical Areas:

• Systems Architecture: Knowledge of system architecture models ensuring scalable, secure, and efficient data solutions aligned with business goals.
• Business Analysis: Ability to translate stakeholder requirements into strategic application plans.
• Business Intelligence: Understanding of the data lifecycle from ETL to insight generation and trend analysis.
• IT Security: Awareness of security challenges and mitigation techniques.
• Effective Governance: Managing projects, policies, and stakeholder relationships effectively.
• Service and Supplier Management: Providing high-quality service management and managing external providers.

Key Skills & Experience:

Essential:

• Experience with ETL/ELT tools (Matillion)
• Experience with SQL Server and Snowflake (or similar cloud data warehousing solutions such as Azure/AWS)
• Experience supporting analytics and reporting using Kimball methodology
• Experience with data migration and business logic mapping
• Proven ability to convert business requirements into solutions
• Proficiency with Power BI

Desirable:

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

Profile

Key Skills & Experience:

Essential:

• Experience with ETL/ELT tools (Matillion)
• Experience of SQL Server and Snowflake (or other cloud data solutions)
• Experience using Kimball methodology
• Experience with data migration and business logic mapping
• Proven ability to deliver solutions from business requirements
• Experience with Power BI

Desirable:

• Experience with ERP reporting
• Knowledge of MS BI stack (SSIS, SSAS)
• Knowledge of Microsoft Dynamics AX or IFS
• Manufacturing and supply chain exposure
• Understanding of financial principles
• Experience with KPI reporting

Job Offer

Opportunity to work on a major Data Transformation Programme.

Opportunity to join a rapidly growing organization.