Data Engineer in Edinburgh

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 include but are not limited to:

• 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 escalate 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 Modelling, 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 pipelines 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:

• Databricks Data Engineer Associate.
• Databricks Data Engineer Professional.
• 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.