Senior Data Engineer / Senior Data Consultant

Location: West London, M4 Corridor UK (Hybrid)

About the Opportunity

We are seeking an experienced Senior Data Engineer / Consultant to join a growing data and analytics consultancy delivering innovative solutions across the Microsoft data and AI ecosystem.

The organisation works with a diverse range of clients to modernise data platforms, improve analytics capabilities and unlock business value through data and AI. Its expertise spans cloud data engineering, business intelligence, platform modernisation, data strategy and managed services.

This is an opportunity for a technically strong, commercially aware consultant who enjoys working directly with clients, solving complex business challenges and delivering scalable, high-quality data solutions.

The Role

The Senior Consultant will lead and contribute to client-facing Data, Analytics and AI engagements, combining hands-on engineering expertise with solution architecture, stakeholder management and technical leadership.

Working with technologies such as Microsoft Fabric, Azure Databricks, Azure Data Factory, Azure Synapse Analytics, Azure SQL and Power BI, you will help clients design, build and optimise modern data platforms that support better business decision-making.

You will also contribute to business development, mentor colleagues and help clients maximise the value of their data and technology investments. Occasional UK and international travel may be required.

Key Responsibilities

• Lead the delivery of complex data engineering, analytics, AI and platform modernisation projects.
• Facilitate client workshops, discovery sessions and technical discussions to translate business requirements into effective technical solutions.
• Design scalable, secure and well-governed data architectures aligned with business objectives and industry best practices.
• Provide technical leadership throughout project delivery, ensuring quality, performance and successful business outcomes.
• Support pre-sales activities, solution design, project estimation, scoping and commercial proposals.
• Develop data models, semantic models and analytics solutions that enable data-driven decision-making.
• Promote effective data governance, user adoption and change management.
• Mentor consultants and encourage engineering excellence, knowledge sharing and continuous improvement.
• Produce high-quality technical documentation, architecture designs and client-facing deliverables.
• Identify and manage technical risks, dependencies and delivery challenges throughout the project lifecycle.

Technical Skills and Experience

Candidates should have experience across several of the following technologies and disciplines:

• Microsoft Data Technologies: Microsoft Fabric, Azure Databricks, Azure Data Factory, Azure Synapse Analytics, Azure SQL and cloud data lake technologies.
• Data Architecture: Lakehouse, data warehouse and Medallion Architecture patterns, including data modelling, governance and performance optimisation.
• Data Engineering: Building scalable data ingestion, transformation and orchestration pipelines across cloud, on-premises and third-party systems.
• Programming: Strong hands-on experience with SQL, Python, Spark and PySpark.
• Modern Data Platforms: Experience with Databricks or Microsoft Fabric engineering workloads, including notebooks, Delta Lake, data transformation and workload optimisation.
• Governance and Security: Understanding of data quality, lineage, access controls and governance frameworks, including Microsoft Purview.
• Business Intelligence: Power BI reporting, semantic modelling and self-service analytics.
• DevOps and Automation: Familiarity with CI/CD, Infrastructure as Code and automated deployment practices.
• Solution Design: Ability to translate business requirements into secure, scalable and supportable data solutions.

Project Delivery Requirements

The successful candidate will ideally demonstrate:

• At least 3 years of experience delivering data engineering, analytics, data platform or AI projects using Microsoft technologies and/or Azure Databricks.
• Approximately 5–8 years of experience in consultancy, professional services or a client-facing technical environment.
• Strong knowledge of modern data architectures, data warehousing, Lakehouse solutions and data modelling.
• Proven experience building cloud-based data platforms, integration solutions and production data pipelines.
• Excellent stakeholder management, workshop facilitation and communication skills.
• The ability to bridge business requirements and technical implementation.
• Experience delivering projects using Agile methodologies.
• Strong analytical thinking, problem-solving and consulting capabilities.

Consulting and Commercial Skills

Alongside technical expertise, you will bring:

• A proven track record of delivering successful client engagements.
• Experience supporting pre-sales, project estimation, scoping and Statements of Work.
• Strong client relationship management skills and a commitment to client satisfaction.
• Excellent verbal, written and presentation skills.
• A strategic mindset combined with practical delivery and decision-making abilities.
• The confidence to influence stakeholders, guide technical teams and advise clients.
• A proactive approach to identifying opportunities, managing challenges and improving outcomes.

Benefits and Working Environment

The organisation offers a supportive and collaborative working environment, with opportunities to develop your technical expertise and progress your consulting career.

Benefits include:

• Competitive salary and performance-related bonus.
• Hybrid working arrangements.
• Comprehensive benefits package, including private medical cover, life assurance, income protection and enhanced pension contributions.
• Generous annual leave allowance, with additional entitlement based on length of service.
• Access to office facilities and employee wellbeing benefits.
• Ongoing professional development and career progression opportunities.
• Exposure to modern cloud data, analytics and AI technologies.
• The opportunity to work on varied client projects and make a meaningful business impact.
• A collaborative, inclusive culture that encourages knowledge sharing and teamwork.

Diversity and Inclusion

The organisation is committed to equal opportunities and creating an inclusive working environment where individuals from all backgrounds feel valued, respected and supported.

Reasonable adjustments and additional support are available throughout the recruitment process.

Eligibility

Applicants must have the existing right to live and work in the UK without requiring employer-sponsored immigration permission.