Lead Data Engineer

ZipRecruiter; Sunderland; On-site; GBP 60,000 - 80,000; Full time

Job summary

A global digital engineering consultancy is seeking a Lead Data Engineer for their Sunderland office. The role requires strong Azure cloud expertise, excellent communication skills, and experience in managing teams. You will be responsible for architecting data solutions and collaborating with clients.

Benefits

Up to 10% bonus

Employer pension scheme

25 days holiday + 8 bank holidays

Life Insurance & Income protection

Enhanced Maternity Pay & Paternity Pay

Cycle to work scheme

Travel loan scheme

Tech Scheme with discounts

Free unlimited Udemy account

Qualifications

• Proven experience as a Lead Data Engineer focusing on Azure cloud services.
• Strong database fundamentals including SQL/TSQL, performance, and schema design.
• Experience architecting data applications using Azure.

Responsibilities

• Manage small teams while remaining hands-on.
• Develop ETL pipelines for data integration and transformations.
• Collaborate with cross-functional teams effectively.

Skills

Communication

Stakeholder Engagement

Team Management

Programming in Python

Education

Azure Data Fundamentals DP-900 certification

Azure Fundamentals AZ-900 certification

Tools

Azure Data Factory

Azure Synapse Analytics

Azure Data Lake

Azure Databricks

Power BI

Terraform

Job description

Job Description

Peaple Talent has partnered with a global digital engineering consultancy who are recruiting for a Lead Data Engineer on a permanent basis based out of their Sunderland office. You will have a great understanding of technology consultancy services along with fantastic communication and stakeholder engagement skills as this role will be client facing.

Skills and experience:

• Proven experience as a Lead Data Engineer with a focus on Azure cloud services.
• Experience of managing small teams whilst also being hands-on.
• Strong database fundamentals including SQL/TSQL, performance and schema design.
• Experience architecting and building data applications using Azure, specifically a Data Warehouse and/or Data Lake.

Technologies:

• Azure Data Factory, Azure Synapse Analytics, Azure Data Lake, Azure Databricks and Power BI. Experience with creating low-level designs for data platform implementations.
• ETL pipeline development for the integration with data sources and data transformations including the creation of supplementary documentation.
• Proficiency in working with APIs and integrating them into data pipelines.
• Strong programming skills in Python.
• Experience of data wrangling such as cleansing, quality enforcement and curation e.g. using Azure Synapse notebooks, Databricks, etc.
• Experience of data modelling to describe the data landscape, entities and relationships.
• Experience with data migration from legacy systems to the cloud.
• Experience with Infrastructure as Code (IaC) particularly with Terraform.
• Proficient in the development of Power BI dashboards.
• Strong focus on documentation and diagramming (e.g. ERDs).
• Strong communication and teamwork skills to collaborate with cross-functional teams effectively.

It would be great if you have:

• Azure Data Fundamentals DP-900 certification.
• Azure Fundamentals AZ-900 certification.
• Good knowledge of data governance, data quality, security, metadata cataloguing and Master Data Management.
• Machine Learning and AI development experience

Benefits:

• Up to 10% bonus (based on company and personal performance).
• An employer pension scheme
• 25 days holiday + 8 bank holidays, with the option to carry forward or 'cash-in' 5 days each year
• Life Insurance & Income protection
• Enhanced Maternity Pay & Paternity Pay
• Cycle to work scheme
• Travel loan scheme
• A Tech Scheme which lets you choose from over 5000 tech products at up to a 12% discount
• Free unlimited Udemy account for every employee to support their continuous learning and improvement