Share this Job

Data Architect and Analytics Manager – Government & Healthcare

Date: Jun 29, 2019

Location: London, United Kingdom

Company: KPMG UK

AutoReq ID142372BR
Job TitleData Architect and Analytics Manager – Government & Healthcare
CountryUnited Kingdom
FunctionRisk Consulting
Service LineRC Technology
Service Line InformationUsing a wide variety of technical and sector-specific skills, KPMG's Risk Consulting group proactively helps clients increase profits whilst reducing reputational, operational, financial and other risks. We are experienced in managing diverse issues including fraud, regulatory compliance, risk frameworks and modelling, capital efficiency, corporate governance, dispute resolution, deriving value from contracts and much more.

Technology - Our clients need to deal effectively with technology related risks and derive maximum value from data and documentation. Our specialists provide independent, jargon free advice and advanced technology capabilities to help our clients proactively manage their technology risks and use their data to its full potential.

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 DescriptionRoles and Responsibilities

A Data Architect and Analytics Manager within the team would typically be responsible for:

- Identifying requirements, develop data models, perform data analysis, write SQL queries, design and code complex stored procedures, and performance tune database processes.

- Assisting with troubleshooting transaction logs, viewing execution plans, tuning queries, and indexing strategies

- Designing and implementing an end to end analytics solution on both on premise and cloud with thorough experience of incorporating business processes and user requirements into dashboards with a consistent workflow and/or actionable insight

- Leading technical discussions and engagements with clients and excellent working knowledge of Microsoft BI technology stack, including SQL Server, SQL SSIS, MS Power Query, MS Power Pivot, MS Power BI

- Thorough understanding of best-practice approaches to the development of data models in Excel and SQL (“our modelling tools”)

- Building excellent client relationships across a range of clients
- Managing a team to deliver specific engagements
- Providing management and quality assurance over work done by our graduate trainees, analysts and assistant managers
- Producing final reports and work papers for client engagements
- Actively identifying and progressing business development opportunities
- Developing internal networks and maintaining excellent relationships with colleagues across KPMG, but in particular in the wider Technology area and with audit colleagues
- Coaching and developing team members, both while on engagements and as part of a continuing performance manager role

- Contributing to the development of the overall infrastructure, government and health analytics practice, for example through delivering training on new or developing propositions relating to your work; providing assurance and formal or informal expertise to other projects; and identifying and pursuing opportunities to improve the services provided by the practice.

Experience & Background


Over 5 years of professional analytics work experience in architecture design and development of data analytics solutions.


Proficient in designing/ implementing/ administering database environments e.g. SQL Server, Oracle


Strong Data Modelling experience having used a variety of frameworks and concepts


Advanced SQL, T-SQL, PL-SQL skills


Hands-on technical capability: willingness and ability to “roll sleeves up” when required on projects. Understanding a variety of technologies and techniques so that the optimal solution can be determined for each project / task; including:


Data analysis, manipulation, querying and profiling;


Experience of leading and delivering analytical projects for internal or external clients, including the experience of leading and managing teams;


Reporting using data visualisation tools (e.g. Microsoft SSRS, Tableau, Qlikview, Power BI etc);


Knowledge of ELT and ETL tools (e.g. Alteryx, SQL Server Integration Services, Data Factory)


Knowledge of database and cloud computing technologies (Microsoft SQL Server, Oracle, Azure, Amazon Web Services, SQL Server Analytics Services)

Qualifications and Skills

- Ideally, a numerate (computer science or maths-based) degree

- A professional qualification (e.g. Microsoft SQL Certified Professional)

- Excellent communication skills (both written and oral) and interpersonal skills

- Positive approach towards problem solving under pressure, including the ability to think through a problem and apply a logical, analytical approach to develop a solution

- The ability to manage time and work independently with multiple stakeholders

- Ability to quickly assimilate information and propose workable solutions

- Ability to describe complex technical issues in a clear non-technical way

- Strong enthusiasm for solving complex problems with our modelling tools with a demonstrable ability to efficiently build solutions that adhere to best practice

- Strong analytical and interpretative skills Sustained attention to detail

Our Deal

Flexible WorkingWhile some of our client-facing professionals can be required to travel regularly, and at times be based at client sites, we are supportive where possible of helping you to achieve a balance between your home and work demands.

We are happy to discuss individual requirements and our range of flexible working arrangements could be of interest. Furthermore, as part of the recruitment process, we can put you in touch with people who work flexibly so you can understand from them what our culture is like.

Applying with a DisabilityKPMG are proud to be an inclusive, equal opportunity employer and we seek to attract and retain the best people from the widest possible talent pool. As a member of the Business Disability Forum we're committed to ensuring that you are treated fairly throughout our Recruitment Process. Should you be successful after the initial application stage, please discuss any reasonable adjustments that you may require, with your recruitment contact.

KPMG's commitment to diversity

KPMG consistently features in the Sunday Times Best Big Companies to work for, which has been recognised with a special achievement award to mark our 10 years in the Top 25. We are proud of the value we place on individuality; we want you to bring your full self to work and truly maximise your potential. We believe that your individuality helps us to deliver the best results for our clients. Diversity of background, diversity of experience, diversity of perspective - that's the KPMG difference. But, don't take our word for it, find out more about diversity at KPMG.

Returning to work after a break

At KPMG, we appreciate that returning to work after an extended career break can be daunting. We understand that those with experience who have taken a career break have a wealth of experience and knowledge to offer our organisation, which helps us to achieve our business goals. We will support you to refresh your skills, develop your confidence and provide a supportive network across the firm to help you best integrate into the working environment. This role welcomes applications for individuals who have been out of work for 18 months or more and who have previous relevant experience.

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: Database, Analytics, Data Architect, Data Analyst, Technology, Management, Data, Government