Senior Data Engineer

Personio GmbH; United Kingdom; Hybrid; GBP 70,000 - 90,000; Full time

Job summary

A leading tech consulting firm in the UK is seeking a Senior Technical Consultant to deliver end-to-end data solutions. The role involves managing resources, mentoring team members, and leading client workshops to gather requirements. The ideal candidate has extensive experience with Azure technologies and strong relationship-building skills. A competitive salary and numerous benefits are offered, including flexibility in working locations and health support.

Benefits

25 days holiday

Home working allowance

Private health insurance

Electric car scheme

Cyclescheme

Employee Assistance Programme

Qualifications

• Strong hands-on experience in Data Engineering.
• Proficiency in Azure tools for ETL/ELT processes.
• Advanced SQL and Python skills.
• Familiarity with MDX/DAX for Analysis Services.

Responsibilities

• Deliver end-to-end data solutions.
• Lead client workshops and gather requirements.
• Create dashboards with Power BI.
• Manage resources and mentor team members.

Skills

Strong relationship‑building skills

Data Engineering experience

ETL/ELT process design

SQL and Python expertise

Power BI knowledge

Problem-solving skills

Communication skills

Tools

Microsoft Azure

SQL Server

Power BI

Databricks

Synapse

Job description

Who we're looking for

An expert in technical delivery, a Senior Technical Consultant, is expected to take responsibility for owning aspects of the delivery. Working in conjunction with the Technical Team Lead to drive and deliver high quality solutions on time and to budget. Areas of responsibility will vary and will largely be dictated by the resource profile of the project. Areas may include management of resources aligned with the project, mentoring junior members of the team, building relationships with customers, managing expectations and establishing delivery timelines.

A Senior Technical Consultant will be a trusted technical resource the Technical Team Lead can entrust to run point on projects to ensure they are delivered on‑time, to budget, and demonstrate the practices’ ability to deliver class leading data solutions.

We work with a Winning from Anywhere® approach but there is an element of travel to client sites when required, along with travel to our company conference and events.

What you'll be delivering

• Deliver end-to-end data solutions, including acquisition, engineering, modelling, analysis, and visualisation.
• Lead client workshops, gather requirements, and communicate effectively on business and technical levels.
• Design and implement scalable ETL/ELT pipelines and data lakes using Microsoft Azure technologies (Fabric, Databricks, Synapse).
• Migrate on‑premises SQL Server solutions to the cloud and build robust, future‑ready architectures.
• Create insightful dashboards and reports with Power BI to help clients unlock data‑driven decisions.
• Own delivery workstreams, manage resources, and mentor team members to drive knowledge sharing.
• Build strong client relationships, manage expectations, and ensure timely, high‑quality delivery aligned with best practices.

We think you'll be successful in this role if you have some of the following

• Strong relationship‑building skills with clients and team members, fostering collaboration and inclusion.
• Extensive hands‑on experience in Data Engineering or Data Warehouse development using Azure/Microsoft and SQL Server technologies.
• Proficiency in designing ETL/ELT processes with Azure tools (Synapse, Data Factory, Databricks, Fabric), plus SQL and Python expertise.
• Solid knowledge of data lake implementation, medallion architecture, and handling large, complex datasets.
• Advanced skills in SQL/Python (queries, stored procedures, notebooks) and familiarity with MDX/DAX for Analysis Services.
• Working knowledge of Power BI and strong understanding of BI and data warehousing concepts.
• Excellent problem‑solving, communication, and delivery skills, with certifications (Microsoft DP‑600/DP‑700 or Databricks) considered a plus.

What we’ll offer in return

In addition to a competitive salary, there are a number of benefits and perks we offer to say thank you for being a part of our journey:

• To work at a 3* World Class Best Company
• Flexibility over where you work with our Winning from Anywhere® approach
• 25 days holiday
• Home working allowance paid monthly
• Winning from Anywhere® allowance to help your set up at home
• 24/7 GP at hand
• Immediate 24/7 access to an Employee Assistance Programme
• We’ll support you when you’re not well with our Company sick pay scheme
• 4x base salary life assurance
• Private health insurance after a successful year’s service
• Enhanced parental pay and leave, supporting you with those precious life moments
• Access to the Perkbox platform to help make your money go further
• Cyclescheme
• Electric car scheme
• And many more!

Disability Confident

Transparity have a proactive attitude when it comes to looking after the wellbeing and inclusion of all our employees. We promote equal opportunities through our recruitment process and a positive, inclusive culture across the business which we are proud of. We are diverse in our approach to recruitment and recognise that talent comes in all different forms. The diversity in our team is what helps our business work so well.

To find out more about our disability commitment please contact People & Culture or ask during the interview