We are searching for an experienced Data Engineer / Analyst
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.
The Data Engineer / Analyst is a hands‑on technical role within the Forensic Technology team, responsible for building and maintaining datapipelines, performing forensic data analysis, and developing reports and dashboards that support live client engagements.
Working under the direction of a senior analytics lead, you will use Microsoft Fabric, Databricks, Python, PySpark, SQL, and Power BI to ingest and transform data from client systems, run automated forensic tests, and produce analytical outputs that are accurate, documented, and defensible.
This is a client‑facing role: you will attend client meetings, contribute to presentations, and explain your findings to investigators, lawyers, and non‑technical stakeholders. It is also a development role, you will receive structured training on the technology stack and build domain expertise in forensic analytics through direct engagement exposure, with a clear path to grow as the team expands.
You will make an impact by:
This is a client‑facing technical role in a team that is being built from the ground up. You will work alongside senior analytics lead and forensic investigators, with direct exposure to live engagements from day one.
- Building data pipelines on Microsoft Fabric and Databricks that ingest financial data from client systems and transform it into structured, analytical formats.
- Running forensic analytics including automated red flag testing, transaction analysis, and anomaly detection across financial data.
- Building Power BI reports and dashboards that present forensic findings to investigators, lawyers, and clients.
- Leading the strategy to leverage and integrate AI into process and output.
- Writing and optimising SQL queries and Python scripts for data extraction, transformation, and analysis.
- Documenting your analytical methods, assumptions, and data sources to a standard suitable for legal and regulatory proceedings.
- Contributing to client meetings and presentations explaining your work and findings to non‑technical audiences.
- Developing domain expertise in forensic analytics through engagement exposure and structured training.
- Collaborating with analytics professionals across the wider Consulting practice through a community of practice.
What we are looking for:
To be considered for this opportunity, your qualifications, skills and experience should include:
- SQL/SparkSQL comfortable writing queries, joins, and aggregations without supervision.
- Working knowledge of Python for data manipulation and scripting.
- Experience with Power BI or similar reporting and visualisation tools.
- Foundational understanding of data modelling and ETL/ELT concepts.
- Familiarity with Microsoft Fabric, Azure Synapse Analytics, and/or Databricks.
- Experience with Alteryx is useful but not essential.
- 2+ years’ experience in data engineering, data analysis, or a related role.
- Careful attention to detail, forensic analytics outputs may be used in legal or regulatory proceedings.
- Clear communicator, comfortable contributing to client meetings and explaining technical work to non‑technical colleagues.
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 working although travel to your local office will be required weekly.
- 25 Days Holiday.
- 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.
Experienced hire
Permanent
LONDON
Consulting
Couldn’t find a suitable vacancy? Please submit your CV here
Working here
Thousands of personalities make up RSM and we believe the power of being you, is the power of being understood. Every member of our team brings unique insights and a passion for the middle market companies we champion.
As one of the world’s largest networks of audit, tax and consulting firms, we deliver the big ideas and services that help middle market organisations thrive. Our global network spans more than 120 countries, but our passion is always the same: to help our clients move forward with confidence.
At RSM, we care about our people, it’s what shapes us. No two people are the same, which is why our approach is tailored to their specific needs, beyond the nine‑to‑five.
The UK group of companies and LLPs trading as RSM is a member of the RSM network. RSM is the trading name used by the members of the RSM network. Each member of the RSM network is an independent accounting and consulting firm which practises in its own right. The RSM network is not itself a separate legal entity in any jurisdiction. Read more
#J-18808-Ljbffr…