Period
to 20 June 2018

The following table provides summary statistics for permanent job vacancies advertised in the City of London with a requirement for Solvency II skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited Solvency II over the 6 months to 20 June 2018 with a comparison to the same period in the previous 2 years.

Solvency II
Central London > City of London
6 months to
20 Jun 2018
Same period 2017 Same period 2016
Rank 324 333 310
Rank change year-on-year +9 -23 +75
Permanent jobs citing Solvency II 22 9 79
As % of all permanent IT jobs advertised in the City of London 0.20% 0.089% 0.59%
As % of the Quality Assurance & Compliance category 1.45% 0.63% 4.31%
Number of salaries quoted 22 9 74
City of London median annual salary £42,500 £55,000 £60,000
Median salary % change year-on-year -22.73% -8.33% -20.00%
10th Percentile £39,750 £48,500 £41,625
90th Percentile £93,750 £81,250 £90,000
Central London median annual salary £42,500 £55,000 £60,000
% change year-on-year -22.73% -8.33% -14.29%

Solvency II is in the Quality Assurance and Compliance category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in the City of London with a requirement for quality assurance or compliance skills.

All Quality Assurance and Compliance Skills
City of London
Permanent vacancies with a requirement for quality assurance or compliance skills 1,516 1,422 1,831
As % of all permanent IT jobs advertised in the City of London 13.73% 14.04% 13.58%
Number of salaries quoted 1,375 1,276 1,581
City of London median annual salary £60,000 £57,500 £55,000
Median salary % change year-on-year +4.35% +4.55% +4.76%
10th Percentile £39,030 £36,250 £35,000
90th Percentile £92,500 £82,500 £83,250
Central London median annual salary £60,000 £57,500 £55,000
% change year-on-year +4.35% +4.55% +4.76%

Solvency II
Job Vacancy Trend in the City of London

Job postings citing Solvency II as a percentage of all IT jobs advertised in the City of London.

Job vacancy trend for Solvency II in the City of London

Solvency II
Salary Trend in the City of London

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing Solvency II in the City of London.

Salary trend for Solvency II in the City of London

Solvency II
Salary Histogram in the City of London

The salary distribution of IT jobs citing Solvency II in the City of London over the 6 months to 20 June 2018.

Salary histogram for Solvency II in the City of London

For the 6 months to 20 June 2018, IT jobs citing Solvency II also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all permanent job ads across the City of London region with a requirement for Solvency II.

1 22 (100.00%) Finance
2 19 (86.36%) SQL
2 19 (86.36%) Data Quality
2 19 (86.36%) Power BI
3 18 (81.82%) Business Intelligence
4 16 (72.73%) Microsoft Excel
5 12 (54.55%) Microsoft
5 12 (54.55%) SQL Server
6 11 (50.00%) Business Analysis
6 11 (50.00%) Stakeholder Management
7 10 (45.45%) Data Analysis
8 8 (36.36%) QA
8 8 (36.36%) Time Management
8 8 (36.36%) Performance Management
8 8 (36.36%) Data Management
8 8 (36.36%) ISEB
8 8 (36.36%) VB
8 8 (36.36%) SAS
8 8 (36.36%) Data Warehouse
8 8 (36.36%) MS Visio
8 8 (36.36%) Stakeholder and Relationship Management
8 8 (36.36%) Change Control
8 8 (36.36%) Business Process Modelling
8 8 (36.36%) Line Management
8 8 (36.36%) Analytical Skills
8 8 (36.36%) Self-Motivation
9 7 (31.82%) Analytics
10 6 (27.27%) D3.js
10 6 (27.27%) Data Analytics
10 6 (27.27%) QlikView

Solvency II
Co-occurring IT Skills in the City of London by Category

The follow tables expand on the table above by listing co-occurrences grouped by category. The same job type, locality and period is covered with up to 20 co-occurrences shown in each of the following categories:

Application Platforms
1 8 (36.36%) SAS
2 4 (18.18%) Apache Spark
3 1 (4.55%) SharePoint
Applications
1 16 (72.73%) Microsoft Excel
2 8 (36.36%) MS Visio
3 1 (4.55%) Microsoft Office
3 1 (4.55%) Microsoft PowerPoint
Cloud Services
1 2 (9.09%) Amazon AWS
1 2 (9.09%) Cortana Intelligence Suite
1 2 (9.09%) Microsoft Azure
Database & Business Intelligence
1 19 (86.36%) Power BI
2 12 (54.55%) SQL Server
3 8 (36.36%) Data Warehouse
4 6 (27.27%) QlikView
5 4 (18.18%) Apache Hive
5 4 (18.18%) Big Data
5 4 (18.18%) Hadoop
5 4 (18.18%) MongoDB
5 4 (18.18%) SAS EBI
6 2 (9.09%) Apache Cassandra
6 2 (9.09%) HBase
6 2 (9.09%) Neo4j
7 1 (4.55%) PowerPivot
7 1 (4.55%) SQL Server Reporting Services
Development Applications
1 1 (4.55%) SQL Server Management Studio (SSMS)
General
1 22 (100.00%) Finance
Job Titles
1 17 (77.27%) Analyst
2 14 (63.64%) Data Analyst
3 12 (54.55%) Data Quality Analyst
4 8 (36.36%) Quality Analyst
5 4 (18.18%) Analytics Manager
5 4 (18.18%) Data Analytics Manager
5 4 (18.18%) Senior Analytics Manager
5 4 (18.18%) Senior Manager
6 1 (4.55%) Applications Manager
6 1 (4.55%) Asset Management Analyst
6 1 (4.55%) Information Analyst
6 1 (4.55%) IT Manager
6 1 (4.55%) IT Relationships Manager
6 1 (4.55%) MI Analyst
6 1 (4.55%) Relationships Manager
6 1 (4.55%) SQL Analyst
6 1 (4.55%) SSRS Analyst
Libraries, Frameworks & Software Standards
1 6 (27.27%) D3.js
2 2 (9.09%) Natural Language Processing
Miscellaneous
1 8 (36.36%) Analytical Skills
1 8 (36.36%) Self-Motivation
2 2 (9.09%) Computer Science
2 2 (9.09%) Management Information System
Processes & Methodologies
1 18 (81.82%) Business Intelligence
2 11 (50.00%) Business Analysis
2 11 (50.00%) Stakeholder Management
3 10 (45.45%) Data Analysis
4 8 (36.36%) Business Process Modelling
4 8 (36.36%) Change Control
4 8 (36.36%) Data Management
4 8 (36.36%) Line Management
4 8 (36.36%) Performance Management
4 8 (36.36%) Stakeholder and Relationship Management
4 8 (36.36%) Time Management
5 7 (31.82%) Analytics
6 6 (27.27%) Data Analytics
6 6 (27.27%) Data Cleansing
6 6 (27.27%) Visualisation
7 4 (18.18%) Data Governance
7 4 (18.18%) Machine Learning
8 3 (13.64%) Wealth Management
9 2 (9.09%) Data Transformation
9 2 (9.09%) Deep Learning
Programming Languages
1 19 (86.36%) SQL
2 8 (36.36%) VB
3 4 (18.18%) Python
3 4 (18.18%) R
3 4 (18.18%) T-SQL
4 2 (9.09%) VBA
Qualifications
1 8 (36.36%) ISEB
2 2 (9.09%) Security Cleared
3 1 (4.55%) ACCA
Quality Assurance & Compliance
1 19 (86.36%) Data Quality
2 8 (36.36%) QA
3 4 (18.18%) GDPR
4 2 (9.09%) EMIR
4 2 (9.09%) MiFID
5 1 (4.55%) Dodd-Frank
5 1 (4.55%) FATCA
5 1 (4.55%) GAAP
Vendors
1 12 (54.55%) Microsoft
2 6 (27.27%) Tableau
3 2 (9.09%) Apple
3 2 (9.09%) Google
3 2 (9.09%) IBM