Lead Data Engineer

ZipRecruiter; City of Edinburgh; On-site; GBP 60,000 - 80,000; Full time

Job summary

Apexon seeks a Lead Data Engineer with Azure experience to lead teams on client projects in the digital transformation space. The role includes managing data architecture, developing data applications, and ensuring documentation standards, offering career progression and health benefits. Join us for a collaborative and supportive work environment with opportunities for continuous learning and skill development.

Benefits

Employer pension scheme

25 days holiday + 8 bank holidays

Access to wellness platform and apps

Life Insurance & Income protection

Cycle to work scheme

Free unlimited Udemy account

Support in obtaining certifications

Qualifications

• Proven experience as a Lead Data Engineer focused on Azure.
• Experience managing small teams and hands-on work.
• Strong database fundamentals and data application architecture.

Responsibilities

• Manage teams on client projects for data engineering.
• Architect and build data applications using Azure technologies.
• Develop ETL pipelines and integration with data sources.

Skills

Data Engineering

Azure Cloud Services

SQL/TSQL

Python

ETL Development

APIs

Data Modelling

Documentation

Team Collaboration

Education

Azure Data Fundamentals DP-900 certification

Azure Fundamentals AZ-900 certification

Tools

Azure Data Factory

Azure Synapse Analytics

Azure Data Lake

Power BI

Azure Databricks

Terraform

Job description

Job Description

Apexon is a digital-first technology services firm specializing in accelerating business transformation and delivering human-centric digital experiences. We have been meeting customers wherever they are in the digital lifecycle and helping them outperform their competition through speed and innovation.

Apexon brings together distinct core competencies – in AI, analytics, app development, cloud, commerce, CX, data, DevOps, IoT, mobile, quality engineering and UX, and our deep expertise in BFSI, healthcare, and life sciences – to help businesses capitalize on the unlimited opportunities digital offers. Our reputation is built on a comprehensive suite of engineering services, a dedication to solving clients’ toughest technology problems, and a commitment to continuous improvement.

Backed by Goldman Sachs Asset Management and Everstone Capital, Apexon now has a global presence of 15 offices (and 10 delivery centers) across four continents.

Job Title: Lead Data Engineer with Azure Experience

Location: Sunderland, UK

About the Role:

We are currently looking for a Lead Data Engineer to manage teams on client projects.

Your Profile:

• 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

We’re committed to providing our people with a great environment to work in. You can expect ongoing skills-based development, career progression as well as health & well-being benefits and support. You’ll work within a friendly and supportive team, working on a variety of projects and the chance to obtain relevant certifications along the way!

We also offer:

• 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
• Access to YuLife wellness platform, subscription to Meditopia App, premium subscription to Fiit, life coaching & emotional wellbeing sessions, 24 / 7 virtual GP Access, Employee Assistance Programme
• 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
• Support in obtaining relevant certifications