Data Engineering Lead / Data Architect

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 reporting

Key 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 BI

Desirable:

• 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