Data Engineering - Senior Consultant

Data Engineering - Senior Consultant

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.

* 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

Essential:

* 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, 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.

* Understanding SQL Server Databases, SQL Server Integration Services (SSIS), Azure Data Resources, Azure Data Factory, Azure Data Lake, Azure Data Bricks and Azure Analysis Services.

* 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 Dev Ops (ADO).

* Experience implementing data quality controls and validation checks, and producing clear documentation to support traceability, handover and adoption.

* Experience implementing platform security practices (secure connectivity to sources, secrets management, role-based access concepts) aligned to client policies.

* 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.

* Effective project management skills.

* 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 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