Senior Consultant- Data Engineering

RSM UK; Greater London; Hybrid; GBP 70,000 - 110,000; Full time

Benefits offered by this job

Hybrid and Flexible working

26 Days Holiday (with option to buy)

Lifestyle and Wellbeing benefits

Job summary

RSM UK is seeking an experienced Senior Consultant in Business Transformation to design and deliver data-led solutions for mid-market clients. You will shape data strategies, implement cloud-based platforms, and guide clients through data maturity improvements.

You'll lead workshops, collaborate with multi-disciplinary teams, and ensure governance, security, and quality across engagements while supporting business development and proposals.

Qualifications

• Strong understanding of Azure data services and integration systems and how they complement Fabric/Databricks.
• Experience implementing platform security practices 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.
• Strong hands-on engineering capability across Microsoft Fabric and Azure Databricks, with SQL and Python experience to design and build scalable data solutions.
• 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.

Responsibilities

• Design and deliver data solutions using modern cloud-based platforms.
• Advise clients on current data landscape and maturity, shaping data strategies and roadmaps.
• Facilitate requirements gathering workshops across business areas to agree objectives and data needs.
• Guide data governance, frameworks, and policies to improve data maturity.
• Manage delivery across multiple workstreams and engagements, mentoring juniors.

Skills

Azure data services

Azure Data Factory

Azure Data Lake

Fabric/Databricks

Platform security

Data quality assessments

Client-facing data engineering

SQL

Python

PySpark

Proposal writing

Business development

Databricks fundamentals

Education

Azure Data Engineer certification

Fabric Data Engineer certification

Tools

Azure Data Factory

Azure Data Lake

Fabric

Databricks

Job description

As one of the world's largest networks of audit, tax and consulting firms, RSM delivers big ideas and premium service to help middle-market businesses thrive. We are a fast-growing firm with big ambitions - we have a clear goal to become the premium adviser to the middle market, globally. This vision touches everything we do, motivating and inspiring us to become better every day. If you are looking for a firm where you can build a future and make an impact, then RSM is the place for you.

Make an Impact at RSM UK

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.

Our solutions are designed to address the unique needs, challenges, and opportunities our clients face as they strive to achieve their aspirations and organisational goals. 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.

It’s an exciting time to join our consulting team, as we embark on ambitious growth plans that promise to create diverse career opportunities. We are committed to enhancing our six solutions, expanding and developing our team of expert consultants, embracing a digital-first approach, strengthening our global presence, and building strong client relationships.

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 (eg, 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, or equivalent experience in an in‑industry role.
• 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.

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 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 inhouse Talent Development team

Diversity and Inclusion at RSM

At RSM, we want to create a strong sense of belonging so that people of all identities, backgrounds, and cultures feel they can bring their true self to work. Our clients come from all walks of life. We aim to achieve that same diversity of background, experience and perspective in our own teams, so that we can genuinely understand our client's needs. Diverse teams bring a broader range of ideas and insights to work. That’s why we’re working together to ensure our firm’s principles and processes support a culture that embraces difference and strengthens inclusion.

At RSM we work hard to create an environment where our people can make a difference - to themselves, their career, their teams, and to the success of our firm and clients. We support all our people to work flexibly, to manage their family and other responsibilities alongside their work commitments; we believe this is key to achieving an inspiring and fulfilling working environment.