Share this Job

Data Modelling and Analysis - Assistant Manager - Financial Services

Date: Apr 10, 2019

Location: London, United Kingdom

Company: KPMG UK

AutoReq ID143767BR
Job TitleData Modelling and Analysis - Assistant Manager - Financial Services
CountryUnited Kingdom
FunctionManagement Consulting
Service LineMC Technology
Service Line InformationIn KPMG's Management Consulting practice, we don't limit ourselves to either strategy or implementation. Instead, we deliver both - equally well. Indeed, it's this broad capability that's seen us accelerate to become a 1000-strong team in less than five years. Since our creation, we've developed in-depth knowledge of an incredibly broad spread of sectors.

In IT Advisory we leverage technology to help achieve clients' business strategy and help deliver sustainable business benefits.

KPMG OverviewKPMG is part of a global network of firms that offers Audit, Tax & Pensions, Consulting, Deal Advisory and Technology services. Through the talent of over 16,000 colleagues, we bring our creativity and insight to our clients’ most critical challenges.
With offices across the UK, we work with everyone from small start-ups and individuals to major multinationals, in virtually every industry imaginable. Our work is often complex, yet our vision is simple: to be the clear choice for our clients, for our people and for the communities we work in.

Job DescriptionThe Team

The Modelling team help our clients understand their business through building models, reviewing models, data modelling and data analytics. We work across a broad range of tools (Excel, VBA, SQL, Qlik, Tableau, Power BI, Alteryx, Python etc.) to support decision making and effective execution. If you enjoy translating complex problems into solutions, this is the team for you.

The Role:

- Devising compelling and well thought out modelling based solutions to support clients in tackling business issues
- Working within a network of modelling specialists, sharing experiences to develop technical and non-technical skills
- Building constructive working relationships to develop internal and external networks
- You will deliver real solutions by translating complex business problems into models which capture the drivers of values and risk
- You will work closely with teams across all functions at KPMG providing solutions to a variety of primarily financial services clients
- You will have an opportunity to further develop your financial modelling and consulting skills
The type of work includes:
- Reducing risk by building a solution using common technologies already present on client systems
- Developing tactical solutions that automate tasks and workflows (i.e. remediation)
- Development of data models to support modelling and analytics deliverables
- Automation of testing and data validation
- Creation of visualisations and dashboards for consuming analysis

Skills & Expertise


- An attitude of learning technical skills not because they are required for a project but because the candidate enjoys doing so. All prior successful candidates have demonstrated that they enjoy learning technical skills outside of work, even if there is no current direct application of those skills.
- A first-class or upper second-class degree
- Strong Excel skills including knowledge of VBA scripting and Power Query
- Strong in SQL
- Understanding of relational database design concepts
- Strong analytical and interpretative skills
- Ability to describe complex technical issues in a clear and non-technical way
- Initiative, enthusiasm and excellent communication skills (verbal and written)
- Ability to quickly assimilate and apply new techniques and knowledge
- Knowledge of financial services products and key concepts
- A recognised finance or accounting qualification and/or MBA or PhD
- An understanding of accounting and financial concepts
- Experience in designing and building financial models in best practice
- Programming experience, especially in Python or R
- Data visualisation experience in Power BI, Qlikview or Tableau
- Using visualisation and analytical software (such as the Power BI, QlikView and Tableau) to drive insights from data to inform client decisions

Our Deal

Flexible Working

Our employees have many varied work schedules to suit their individual needs!

Our intelligent working options range from role sharing and flexible start and finish times, to home working and more informal arrangements agreed within teams.

Check out examples of KPMG employees enjoying different working patterns on our website and please do share your own individual requirements with us.

Applying with a DisabilityAs a member of the Business Disability Forum we're committed to ensuring a great experience for colleagues with a disability. Should you be successful after the initial application stage, please discuss any adjustments that you may require with your recruitment contact.

KPMG's commitment to diversity

We are proud of the value we place on individuality. We want you to bring your full self to work and maximise your potential. KPMG is a place where everyone can thrive, whatever their gender, ethnicity, disability, sexual orientation and socio-economic background.

Policy for Agencies

KPMG has a commitment to sourcing candidates directly and as such we do not accept speculative CV’s from agencies. Please check here to see our policy on agencies: Policy

Job Segment: Assistant Manager, Database, Financial, Consulting, Data Analyst, Management, Technology, Finance, Data