Lead Data Engineer

Mott MacDonald Bentley; Leeds; On-site; GBP 61,000 - 101,000; Full time

Benefits offered by this job

Hybrid work Leeds 2 days/week

Competitive salary & benefits

Job summary

JN Bentley is seeking a Lead Data Engineer in Leeds to design and implement scalable data warehouse and Microsoft Fabric solutions. You will define data architecture standards, model data, and develop pipelines, while mentoring a data team in a hybrid Leeds office.

The role requires strong leadership, cloud experience (Azure Fabric), and expertise in data governance, security, and performance optimization. Hybrid working arrangement with competitive pay and benefits.

Qualifications

• Experience in senior data roles with data architecture/engineering focus.
• Experience designing and delivering cloud data platforms (Fabric/Azure).
• Strong knowledge of SQL, data modelling, warehousing, and lakehouse concepts.

Responsibilities

• Design and implement scalable data warehouse and Microsoft Fabric solutions
• Define data architecture standards, design patterns, and engineering best practices
• Develop data models aligned with business requirements
• Build and maintain data pipelines and integrations
• Integrate data from databases, APIs, files, and third-party platforms
• Set standards for ingestion, transformation, storage, and consumption
• Support data governance, quality, security, lineage, and access controls
• Optimize performance, resilience, storage, and cost of the data platform
• Evaluate new technologies and recommend solutions
• Provide technical leadership, design assurance, and mentoring
• Line manage data team members, including objective setting and development

Skills

Senior data role

Data architecture

Data engineering

Cloud data platforms

Microsoft Fabric

Azure

SQL

Data modelling

Warehousing

Lakehouse

Integration patterns

Data governance

Security

Source control

Automation

Leadership

Git

Line management

Tools

Git

Azure

Microsoft Fabric

SQL

Job description

Salary: £61,000 - 101,000 per year

Requirements:

• Strong experience in data architecture, data engineering, or a comparable senior data role
• Experience designing and delivering modern cloud data platforms, ideally using Microsoft Fabric or Azure
• Strong knowledge of SQL, data modelling, warehousing, lakehouse architecture, and integration patterns
• Experience with data governance, security, source control, and automated deployment practices
• Strong communication, problem-solving, and technical leadership skills
• Experience using source control tools such as Git
• Previous line-management experience, with the ability to develop, support, and motivate technical team members

Responsibilities:

• Design and implement scalable data warehouse and Microsoft Fabric solutions
• Define data architecture standards, design patterns, and engineering best practices
• Develop conceptual, logical, and physical data models aligned with business requirements
• Design, build, and maintain reliable data pipelines and integrations
• Integrate data from databases, APIs, files, and third-party platforms
• Set standards for data ingestion, transformation, storage, and consumption
• Support data governance, quality, security, lineage, and access controls
• Optimise the performance, resilience, storage, and cost of the data platform
• Evaluate new technologies and recommend solutions that meet business needs
• Provide technical leadership, design assurance, and mentoring across the data team
• Line manage data team members, including objective setting, development, workload planning, and performance support

Technologies:

• AI
• Azure
• Cloud
• Data Warehouse
• Fabric
• Git
• Support
• SQL
• Security

More:

We are JN Bentley, a leading civil engineering and construction organisation directly employing over 2,500 people. We work with clients including National Grid, Rolls Royce, Yorkshire Water, United Utilities, Welsh Water, Severn Trent Water, the Environment Agency, and the Coal Authority. Across JN Bentley and our design and build companies MMB and JBA Bentley, annual revenue exceeds £650 million. As Lead Data Engineer, you will help us deliver secure, scalable, trusted data for reporting, analytics, and AI. We offer hybrid working from our Leeds office (two days per week), a competitive salary, a supportive working culture, and a wide range of financial, lifestyle, health, and wellbeing benefits.

last updated 40 week of 2026