Data Engineering - Senior Consultant in London

We are searching for an experienced Data Engineering - Senior Consultant. At RSM, our consulting team brings together diverse advisory experts to deliver our six core solutions: business transformation, forensic, deal services, restructuring, finance function support, and risk and governance. Whether it’s supporting global expansion, developing acquisition strategies, facilitating private equity investments, or collaborating with boards to manage risk and governance, our consulting experts work as one cohesive team. We prioritise simplicity, providing data-driven insights, value-added assurance, and high-quality execution to empower our clients in building sustainable, future-fit businesses.

As a senior consultant within the Business Transformation team, you will be responsible for designing and delivering data solutions using a variety of modern cloud-based platforms. You will also advise clients on their current data landscape and maturity, shaping their data strategies and future roadmaps. You will make an impact by:

• Facilitating requirements gathering workshops across business areas to agree objectives, use cases, and data needs.
• Supporting the development of data solutions that align initiatives to business objectives, balancing best practice ways of working with clients’ requirements.
• Providing guidance on data governance and strategies, including advising on recommended frameworks and policies to enable clients to increase their data maturity.
• Managing delivery across multiple workstreams and engagements, supporting junior team members, and supporting the use of structured engineering practices across the team.

What we are looking for:

Are you someone who thrives on variety, loves learning new things, and enjoys connecting with people? If you can spot inefficiencies in everyday life and are passionate about making improvements, this role is perfect for you! We value diverse experiences and perspectives. Here’s what we’re looking for in our ideal candidate:

• Strong understanding of Azure data services and integration systems (e.g., Azure Data Factory, Azure Data Lake) and how they complement Fabric/Databricks.
• Experience implementing platform security practices (secure connectivity to sources, secrets management, role-based access concepts) aligned to client policies.
• Experience in formal data quality assessments and defining reconciliation approaches with business stakeholders.
• Client-facing data engineering experience (3+ years) in a professional services environment, including leading requirements workshops with clients.
• Strong hands-on engineering capability across Microsoft Fabric and Azure Databricks, with SQL and Python experience to design and build scalable data solutions.
• A background in PySpark is desirable.
• Experience in proposal writing and business development, supporting bids and client presentations.
• Relevant certifications (desirable): Azure Data Engineer / Fabric Data Engineer or Analytics Engineer, Databricks fundamentals.

Requirements:

• Strong academic record: preferably with a relevant degree (such as computer science, software engineering, data engineering, data analytics, or information systems).
• Minimum of 4 years’ work experience, ideally within a professional services environment, delivering data engineering and/or data platform engagements.
• Participate in/lead client engagements, facilitating workshops to confirm objectives and requirements, identifying data requirements, and developing delivery plans and budgets.
• Design, build and optimise end-to-end data pipelines (ingestion, transformation, or orchestration) using SQL and Python, with a focus on reliability, maintainability and performance.
• Hands-on experience with modern cloud data platforms, including Microsoft Fabric and Azure Databricks.
• Practical experience with Apache Spark and PySpark.
• Strong engineering practices: version control (Git), CI/CD for data and platform artefacts, and disciplined release management via Azure DevOps (ADO).
• Experience implementing data quality controls and validation checks, and producing clear documentation to support traceability, handover and adoption.
• Able to interact effectively with internal and external resources, at all organisational levels, establishing trust and credibility quickly.
• Ability to meet deadlines and work on multiple projects simultaneously.
• Good communication and presentation skills, with the ability to explain complex ideas to non-technical stakeholders.
• Demonstrate the ability to understand and assess client requirements/issues, consider and analyse the impact and propose solutions to address these.
• Create high quality, client-facing document outputs.
• London-based or willing to travel to London fortnightly.

What we can offer you:

We recognise that our people are our most important assets. That’s why we offer a flexible reward and benefits package that will help you have a fulfilling experience, both in and out of work.

• Hybrid and Flexible working
• 26 Days Holiday (with the option of purchasing additional days)
• Lifestyle, Health, and Wellbeing including financial wellbeing benefits such as financial tools, electric car scheme and access to a virtual GP
• Access to a suite of 300+ courses on demand developed by our in-house Talent Development team