Data Analytics Associate Director - Transactions

RSMUK; London; On-site; GBP 40,000 - 60,000; Full time

Job summary

RSMUK is seeking a Financial Due Diligence Data Analyst to enhance data analytics capabilities within the consulting team. The ideal candidate will lead projects, analyze complex datasets, and develop insightful visualizations to support financial decision-making. Applicants should hold an ACA qualification and have significant experience with data analytics tools.

Qualifications

• Experience in financial due diligence analytics.
• Skilled in data visualization tools like Power BI.
• Strong logical problem-solving skills.

Responsibilities

• Lead and manage the Transactions Data Analytics team.
• Analyse large datasets and communicate insights effectively.
• Develop dashboards and visualizations for stakeholder engagement.

Skills

Data analytics

Problem-solving

Communication

Team leadership

Attention to detail

Data visualization

Education

ACA qualification

Tools

Alteryx

Power BI

Excel

Tableau

RStudio

Python

Qlik

Job description

Consulting brings together multiple teams across Transactions, Risk & Consulting, ABA, and Outsourcing to provide client-centric solutions for RSM's current and future clients within the middle market. Our Consulting team has a major role to play in driving forward the growth of the firm with over 1,700 people delivering almost £200m revenue.

At the heart of Consulting are the six solutions we offer our clients: business transformation, deal services, finance function support, risk and governance, forensic and investigation services, and restructuring. Our solutions create an enhanced tailored approach to support our clients in achieving their strategic goals and empower our people to make an impact and develop their own unique career path.

Overall Job Purpose

The pace of innovation within RSM is increasing all the time and this has created the need for additional skills within the firm in relation to data and analytics. The role will be responsible for driving the adoption and deployment of data analytics across the firm by successfully delivering client facing project work and generating and driving internal innovation solutions.

The role is within the Transactions Data Analytics team, which was set up two years ago and sits within corporate finance. The Transactions Data Analytics team works with multiple service lines however this role will predominantly involve working closely with the financial due diligence team, supporting them to analyse large and difficult data sets using Alteryx and other tools, before then visualising findings in innovative and interactive ways through Microsoft Power BI and Excel, on both buy and sell side transactions. The internal innovation aspect of the role will involve identifying areas elsewhere across the business where analytics tools can drive efficiency and improve operations.

Responsibilities

• Lead others effectively and contribute to the wider strategy of the Transactions Data Analytics team
• Quickly review, consolidate, cleanse, and reconcile large quantities of disparate data to identify any issues and prioritise project requirements
• Uncover and interpret trends from business data and other available data sources
• Understand how to develop and build dashboards, reports, and other visualisations for stakeholders to tell the story of the data
• Communicate effectively with all stakeholders, regardless of seniority or technical understanding
• Be prepared to challenge the status quo, be confident building networks and presenting new ideas
• Support the development of a data-centric culture within RSM's transactions business by providing support, guidance, and training
• Coach, line manage and develop the junior staff within the team, contributing to the teams dynamic and entrepreneurial culture
• Actively own strategic relationships with key stakeholders across the business, gathering short and long-term requirements and providing on going analytic support
• Contribute to and lead the continuous improvement of analytic best practices and frameworks within RSM's transactions business
• Lead improvements in how RSM's transactions business's visualisations are delivered and own the visual style and narrative
• Deliver work to high standards within a fast-moving deal environment
• The preferred candidate will have strong problem-solving skills, bring the ability to focus on getting the job done, maintaining a view of the business benefits, and proving resilient in the face of obstacles and challenging deadlines.

Personal and Professional Qualities

This role is in an agile team, collaborating with colleagues and stakeholders so excellent communication skills are essential. The right candidate will be experienced in utilising data analytics tools within a financial due diligence setting across a broad range of transaction types. They should have strong problem-solving skills and demonstrable experience of delivering against challenging deadlines. They should be passionate about data analytics and their own continual development. Further qualities include:

• Fully qualified ACA (or equivalent)
• Significant financial due diligence data analytics experience
• Experience with data analytics tools (e.g. Alteryx, Qlik, RStudio)
• Experience with data visualisation tools (e.g. Power BI, Tableau, Spotfire, Excel)
• Excellent logical problem solver
• Natural team leader comfortable managing others and contributing to wider team strategy
• Demonstrate strong analytical mindset and high level of attention to detail
• Demonstrate successful interactions with business and technical stakeholders
• Experience of working with a variety of datasets and being able to shape and manipulate data
• Experience of delivering and presenting insights through visualisation of data
• High standard of written and verbal communication skills
• Self-starter able to master a brief quickly, taking complete ownership of the delivery of multiple financial due diligence data analytics projects at the same time. Prioritising appropriately and demonstrating an understanding of commercial risk and sensitivity to risk management
• Demonstrate a proven record of resilience and thriving under pressure
• Ability to prioritise effectively across multiple projects whilst managing others. Delegate and review effectively whilst working to challenging deadlines
• Excellent facilitation, collaboration, negotiation, and presentation skills
• Focused and versatile team player who is comfortable under pressure, ambiguity, frequent change, or unpredictability.

Desirable skills

• Experience of working with analytical languages (Python/R).

Do you already know your future colleagues? RSM operates an employee referral scheme where we will pay if your referral gets hired, forward this role to your connection to start the process.
For full details of the RSM Employee Referral policy please view the recruitment pages on the intranet.]]>