Willis Towers Watson Data Analyst in London, United Kingdom

Data Analyst

Date Posted: June 27, 2018


Not ready to Apply? at https://willistowerswatson.avature.net/WTWTalentNetwork


Affinity is a line of business (LoB) within Corporate Risk & Broking (CRB) that supports clients to develop ancillary revenues through targeted solutions that help reduce costs, create differentiation, and improve customer retention and satisfaction rates. This is a high focus area of the Willis Tower Watson (WTW) business with huge potential and challenging targets.

The Role

Currently Affinity is delivered through a variety of platforms and solutions. A key part of the role is aggregating data from our bespoke, proprietary system and other Affinity legacy systems to provide insights into consumer behaviours that will help us tailor the solution to provide more value for our clients. In addition to this, the development of advanced analytics and reporting capabilities will make it easy for our clients to have complete transparency and control over their Affinity programmes. The Data Analyst will also be responsible for the creation of internal performance dashboards, working with our Technology teams to best utilise the WTW data stores and supporting the core teams in analysis covering for example: financial i.e. investment returns, and prospect performance reporting.

Based in our London office and reporting directly to the Affinity Delivery Lead, we are seeking an experienced, personable, high energy Data Analyst, with strong data analysis skills, excellent interpersonal skills and experience working collaboratively with senior stakeholders across geographies – Europe, Asia Pacific and Latin America – in a matrix environment. Alternatively, we will also consider high-calibre graduate candidates with excellent data analysis skills seeking their first step in this career path.


  • Provide a single view of the Affinity prospects pipeline and performance (KPI) across all regions – “Sales Dashboard”

  • Analyse the specific data requirements for Affinity e.g. price phasing and with work with MS Dynamics team to get this onto product roadmap

  • Review monthly P&L reports and conduct revenue analysis for all regions – “Finance Dashboard”

  • Establish Business Case KPIs

  • Conduct Investment Appraisal to ascertain ROI

  • Establish clear traceability from Prospect to Go-live

  • Establish KPIs to demonstrate Warranty and BAU Performance

  • Create a “Delivery Dashboard” that encompasses the status of prospects, implementations and BAU activity

  • Establish and measure the performance of Balanced Scorecard e.g. NPS, TCO, Customer Retention

  • Support the Senior Product Owner (SPO) in the creation of the Data & Analytics Strategy

  • Understand key concepts i.e. Big Data, Telematics

  • Support the SPO in the integration of WTW Data Stores into the GenASys platform

  • Work with ICT, CMA and Affinity Teams to develop our External Analytics proposition.

  • Work with CRB Technology teams to develop GenASys Dashboard reporting capability both internally and externally

  • Support the Global Delivery Lead and CFO in undertaking a “Total Cost of Ownership” exercise to establish the true cost of IT across the Affinity Technical Landscape.

The Requirements

You will preferably be educated to degree level or relevant professional qualification in the field of data analysis or certificated evidence of data analysis training courses attended. You will be able to display superior written and oral communication skills with the ability to quickly understand the organisation and how the different functions act with each other. Ideally, you will have experience of working with IT departments and supporting the development, testing and maintenance of IT systems in a business (not IT) capacity. In addition you will have an understanding and experience of the full project lifecycle and required documentation.


  • Data analysis experience gained from projects of similar nature

  • Power BI experience

  • SQL Enterprise Manager experience

  • In-depth experience of managing and interrogating large datasets using SQL (T-SQL scripts)

  • Advanced Excel (including lookups and pivot tables)

  • Ability to manipulate, analyse and interpret different data to derive insight and drive decision making


  • Experience of the insurance/financial sector is desirable together with a broad understanding of operational insurance processes (e.g. new business, renewals, mid-term adjustments).

  • Data Modelling tools such as: Select Architect, Enterprise Architect

  • Experience with ETL tools such as SQL Server and SSIS

  • Ability to translate logical data models into physical data models

  • E-R (Entity-Relationship) Modelling

  • Ability to normalise data relationships and design a logical data model

  • Ability to design and de-normalise a logical data model

  • Dimensional Data Modelling

  • Experience with MS Dynamics CRM, Oracle Finance, MS Team Foundation Server, WebTrends.

The Company

Willis Towers Watson is a leading global advisory, broking and solutions company that helps clients around the world turn risk into a path for growth. With roots dating to 1828, Willis Towers Watson has 40,000 employees serving more than 140 countries. We design and deliver solutions that manage risk, optimize benefits, cultivate talent, and expand the power of capital to protect and strengthen institutions and individuals. Our unique perspective allows us to see the critical intersections between talent, assets and ideas – the dynamic formula that drives business performance. Together, we unlock potential. Learn more at willistowerswatson.com

Willis Towers Watson is an equal opportunity employer

Willis Towers Watson believes that effectively managing a diverse workforce is vital to our business strategy. We have an obligation to our organization, ourselves and our clients to hire and develop the best people we can find. We will continually review our policies and practices to ensure that all areas of the employment process (including recruiting, hiring, work assignments, compensation, benefits, promotions, transfers, company-sponsored development programs and overall workplace experience) are free from discriminatory practices. We are committed to equal employment opportunities at Willis Towers Watson.

Unsolicited Contact: Any unsolicited resumes/candidate profiles submitted through our web site or to personal e-mail accounts of employees of Willis Towers Watson are considered property of Willis Towers Watson and are not subject to payment of agency fees. In order to be an authorized Recruitment Agency/Search Firm for Willis Towers Watson, any such agency must have an existing formal written agreement signed by an authorized Willis Towers Watson recruiter and an active working relationship with the organization. Resumes must be submitted according to our candidate submission process, which includes being actively engaged on the particular search. Likewise, for our authorized Recruitment Agencies/Search Firms, if the candidate submission process is not followed, no agency fees will be paid by Willis Towers Watson. Willis Towers Watson is an equal opportunity employer.


Not ready to Apply? at https://willistowerswatson.avature.net/WTWTalentNetwork


  • Share on Facebook

  • Share on Twitter

  • Share on Google+ Share on Pinterest

  • Share on Linkedin

  • Share by Mail


  • Location:London, England, GB

  • Date Posted:June 27, 2018