Data Engineer

Dufrain; City of Edinburgh, Manchester, Greater London; Hybrid; GBP 45,000 - 65,000; Full time

Benefits offered by this job

Personal development investment

High performance rewards

Collaborative work culture

Job summary

A leading data consultancy in the UK is seeking a Data Engineer to join their team. This role involves building robust data solutions primarily on Azure and requires proficiency in Python and SQL. You'll work collaboratively with clients, ensuring high-quality outputs and contributing to consulting initiatives. The position offers a hybrid working arrangement across major cities like Edinburgh, Manchester, and London, along with opportunities for personal development and growth.

Qualifications

• Experience as a data engineer in creating efficient end-to-end solutions.
• Strong design and delivery experience using Azure.
• Proven ability in Data Governance and Data Modeling.

Responsibilities

• Develop strong client relationships and deliver high-quality work.
• Elevate problems for client/senior team guidance and provide solutions.
• Contribute to the growth of the consulting practice.

Skills

Data solutions on Azure

Python

Apache Spark

SQL

Data Governance

Data Migration

ETL/ELT

Agile & DevOps processes

Data Lakes

Data Warehousing

Tools

Microsoft Fabric

Databricks

Snowflake

Azure Data Factory

Azure Synapse

Microsoft SQL/SSIS

Job description

Dufrain is a pure-play data consultancy specialising in helping businesses unlock the true value of their data by providing market-leading data solutions and services which includes developing strategies for AI readiness, improving data literacy and culture, enhancing real-time reporting, and managing data from mergers and acquisitions.

Our Data Engineers provide expertise, guidance, and strategic advice to clients in order to help them effectively leverage their data assets for making informed decisions and achieving their business objectives

This role is UK-based (Edinburgh, Manchester, or London) with hybrid working. Occasional on-site attendance at client locations as required.

Responsibilities

• Develop good working relationships with clients on a project including interpersonal skills with both business and technical focused colleagues.
• Experience working as a data engineer to develop performant end-to-end solutions in a collaborative team environment.
• Delivering high-quality pieces of work, proven ability to elevate problems to client / senior team members where necessary and propose possible solutions.
• Support building the Consulting practice through contribution to ongoing initiatives. This can include contributing to knowledge-sharing activities, and data services.

Essential Technical Skills and Experience

• Strong experience designing and delivering data solutions on Azure
• Excellent working knowledge of Python, Apache Spark, and SQL
• Broad data engineering skillset; with preference in either Microsoft Fabric, Databricks or Snowflake
• Proven delivery of multiple solutions using Data Governance, Data Migration, Data Modeling, ETL/ELT, Data Lakes, Data Warehousing, Master Data Management and BI
• Solid understanding of engineering delivery processes: Agile & DevOps, Git, APIs, containers, microservices, and data pipelines

Highly Desirable Skills and Experience

• Experience with one or more of Databricks, Snowflake, Azure Data Factory, Azure Synapse, or Microsoft SQL/SSIS
• Hands‑on experience building data pipeline(s) using Azure Data Factory, Pipelines, Notebooks, and Dataflows Gen2
• Good working knowledge of Lakehouse components: Delta Lake, Unity Catalog/One Lake, ML Flow, Databricks Asset Bundles, Fabric CICD, Real Time Analytics/Structured Streaming, etc

Desirable Certifications

• Microsoft DP-600 or DP-700

You Will Have

• The drive to meet tight deadlines and maintain high standards of delivery
• Confidence participating effectively in meetings with senior stakeholders
• A collaborative mindset—supporting, encouraging, and sharing knowledge across the team
• Self‑starter habits; you work well under pressure with limited supervision
• A track record of accurate output and ownership of elements of project delivery
• Flexibility to work as part of an integrated team or independently as needed
• Awareness of relevant industry standards, regulations, and current developments

You can expect guaranteed investment to your personal development. We have a working culture that rewards high performance and nurtures talent, while providing exciting opportunities and challenges to generate positive change for our clients.

Applicants must have the right to work in the UK and not require sponsorship now or in the future. Visa sponsorship is not available.

We are an equal opportunity employer and value diversity at our company.. We do not discriminate on the basis of race, colour, religion, sex, sexual orientation, gender identity, national origin, disability, age, or any other status protected by law. All qualified applicants will receive consideration for employment without regard to these factors. We encourage applications from individuals of all backgrounds and experiences.