Period
to 21 February 2018

The following table provides summary statistics for permanent job vacancies 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 21 February 2018 with a comparison to the same period in the previous 2 years.

Solvency II
UK
6 months to
21 Feb 2018
Same period 2017 Same period 2016
Rank 1082 1101 1042
Rank change year-on-year +19 -59 +84
Permanent jobs citing Solvency II 106 86 237
As % of all permanent IT jobs advertised in the UK 0.060% 0.049% 0.11%
As % of the Quality Assurance & Compliance category 0.47% 0.39% 0.88%
Number of salaries quoted 94 75 226
UK median annual salary £52,500 £60,000 £57,500
Median salary % change year-on-year -12.50% +4.35% -11.54%
10th Percentile £38,750 £43,250 £42,250
90th Percentile £91,125 £85,750 £85,000
UK excluding London median annual salary £42,500 £59,960 £52,500
% change year-on-year -29.12% +14.21% -19.23%

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 with a requirement for quality assurance or compliance skills.

All Quality Assurance and Compliance Skills
UK
Permanent vacancies with a requirement for quality assurance or compliance skills 22,781 21,835 26,913
As % of all permanent IT jobs advertised in the UK 12.92% 12.41% 12.92%
Number of salaries quoted 17,741 17,314 21,307
UK median annual salary £50,000 £47,500 £47,500
Median salary % change year-on-year +5.26% - +5.56%
10th Percentile £27,500 £26,250 £26,250
90th Percentile £80,000 £77,500 £75,000
UK excluding London median annual salary £43,500 £42,500 £42,500
% change year-on-year +2.35% - +6.25%

Solvency II
Job Vacancy Trend

Job postings citing Solvency II as a percentage of all IT jobs advertised.

Job vacancy trend for Solvency II in the UK

Solvency II
Salary Trend

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

Salary trend for Solvency II in the UK

Solvency II
Salary Histogram

The salary distribution of IT jobs citing Solvency II over the 6 months to 21 February 2018.

Salary histogram for Solvency II in the UK

Solvency II
Top 6 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Solvency II within the UK over the 6 months to 21 February 2018. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
England +31 105 £52,500 -12.50% 12
London +54 86 £55,000 -10.20% 6
UK excluding London -23 20 £42,500 -29.12% 8
South East +16 14 £45,000 -38.98% 3
South West +9 5 £42,500 - 1
Scotland - 1 £110,000 - 1

For the 6 months to 21 February 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 with a requirement for Solvency II.

1 86 (81.13%) Finance
2 46 (43.40%) SQL
3 40 (37.74%) Data Quality
4 39 (36.79%) Business Analysis
5 34 (32.08%) Big Data
6 33 (31.13%) Power BI
6 33 (31.13%) Microsoft Excel
7 31 (29.25%) Business Intelligence
8 30 (28.30%) ISEB
9 27 (25.47%) Data Governance
10 24 (22.64%) Hadoop
11 23 (21.70%) GDPR
12 20 (18.87%) Data Management
12 20 (18.87%) Microsoft
13 19 (17.92%) Sarbanes-Oxley
14 18 (16.98%) Data Warehouse
14 18 (16.98%) SQL Server
14 18 (16.98%) QA
15 16 (15.09%) Data Analysis
15 16 (15.09%) Agile Software Development
15 16 (15.09%) Cognos
15 16 (15.09%) VBA
15 16 (15.09%) SAS
16 14 (13.21%) MS Visio
16 14 (13.21%) VB
16 14 (13.21%) QlikView
16 14 (13.21%) Performance Management
16 14 (13.21%) Business Process Modelling
16 14 (13.21%) Line Management
16 14 (13.21%) Change Control

Solvency II
Co-occurring IT Skills 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 16 (15.09%) SAS
2 12 (11.32%) Apache Spark
3 4 (3.77%) Apache
4 1 (0.94%) SharePoint
Applications
1 33 (31.13%) Microsoft Excel
2 14 (13.21%) MS Visio
3 1 (0.94%) Microsoft PowerPoint
Cloud Services
1 6 (5.66%) Amazon AWS
1 6 (5.66%) Cortana Intelligence Suite
1 6 (5.66%) Microsoft Azure
2 4 (3.77%) Google Cloud Platform
3 2 (1.89%) Cloud Computing
4 1 (0.94%) Office 365
4 1 (0.94%) SaaS
Communications & Networking
1 2 (1.89%) WAN
2 1 (0.94%) LAN
2 1 (0.94%) SAN
2 1 (0.94%) VoIP
Database & Business Intelligence
1 34 (32.08%) Big Data
2 33 (31.13%) Power BI
3 24 (22.64%) Hadoop
4 18 (16.98%) Data Warehouse
4 18 (16.98%) SQL Server
5 14 (13.21%) QlikView
6 8 (7.55%) Apache Hive
6 8 (7.55%) MongoDB
7 6 (5.66%) Apache Cassandra
7 6 (5.66%) HBase
7 6 (5.66%) Neo4j
8 4 (3.77%) BigQuery
8 4 (3.77%) BusinessObjects
9 3 (2.83%) SAS EBI
10 2 (1.89%) PowerPivot
10 2 (1.89%) RDBMS
10 2 (1.89%) Relational Database
General
1 86 (81.13%) Finance
2 9 (8.49%) Banking
2 9 (8.49%) Financial Institution
3 3 (2.83%) Law
4 1 (0.94%) Legal
4 1 (0.94%) Telecoms
Job Titles
1 80 (75.47%) Analyst
2 45 (42.45%) Data Analyst
3 30 (28.30%) Data Quality Analyst
4 27 (25.47%) Quality Analyst
5 12 (11.32%) Finance Systems Analyst
5 12 (11.32%) Financial Analyst
5 12 (11.32%) Systems Analyst
6 10 (9.43%) Business Analyst
6 10 (9.43%) Consultant
6 10 (9.43%) Data Consultant
6 10 (9.43%) Support Analyst
7 9 (8.49%) Business Data Analyst
7 9 (8.49%) Governance Analyst
8 8 (7.55%) Senior Analyst
9 7 (6.60%) Applications Support
9 7 (6.60%) Applications Support Analyst
9 7 (6.60%) Commercial Analyst
9 7 (6.60%) Data Business Analyst
9 7 (6.60%) Project Manager
9 7 (6.60%) SQL Data Analyst
Libraries, Frameworks & Software Standards
1 12 (11.32%) XBRL
1 12 (11.32%) XML
2 10 (9.43%) D3.js
3 6 (5.66%) Natural Language Processing
Miscellaneous
1 12 (11.32%) Taxonomies
2 11 (10.38%) Analytical Skills
3 10 (9.43%) Grid Computing
4 4 (3.77%) Algorithms
5 3 (2.83%) Computer Science
5 3 (2.83%) Management Information System
6 2 (1.89%) Reinsurance
7 1 (0.94%) Cyberattack
7 1 (0.94%) Data Centre
Operating Systems
1 11 (10.38%) Unix
2 10 (9.43%) Linux
3 2 (1.89%) AIX
Processes & Methodologies
1 39 (36.79%) Business Analysis
2 31 (29.25%) Business Intelligence
3 27 (25.47%) Data Governance
4 20 (18.87%) Data Management
5 16 (15.09%) Agile Software Development
5 16 (15.09%) Data Analysis
6 14 (13.21%) Business Process Modelling
6 14 (13.21%) Change Control
6 14 (13.21%) Line Management
6 14 (13.21%) Performance Management
7 13 (12.26%) Analytics
7 13 (12.26%) Incident Management
7 13 (12.26%) Stakeholder Management
7 13 (12.26%) Use Case
7 13 (12.26%) Workflow
7 13 (12.26%) Workflow Analysis
8 12 (11.32%) Data Conversion
8 12 (11.32%) Data Deduplication
8 12 (11.32%) Disaster Recovery
9 11 (10.38%) Data Analytics
Programming Languages
1 46 (43.40%) SQL
2 16 (15.09%) VBA
3 14 (13.21%) VB
4 10 (9.43%) Shell Script
4 10 (9.43%) T-SQL
5 9 (8.49%) Python
5 9 (8.49%) R
6 1 (0.94%) C
Qualifications
1 30 (28.30%) ISEB
2 11 (10.38%) Degree
3 3 (2.83%) Security Cleared
4 2 (1.89%) ACCA
Quality Assurance & Compliance
1 40 (37.74%) Data Quality
2 23 (21.70%) GDPR
3 19 (17.92%) Sarbanes-Oxley
4 18 (16.98%) QA
5 12 (11.32%) Dodd-Frank
6 11 (10.38%) FATCA
6 11 (10.38%) IFRS
7 9 (8.49%) IFRS 9
8 5 (4.72%) EMIR
9 4 (3.77%) GAAP
10 3 (2.83%) MiFID
11 2 (1.89%) ISAE 3402
12 1 (0.94%) AIFMD
12 1 (0.94%) COBIT
12 1 (0.94%) PCI DSS
12 1 (0.94%) PMO
Vendors
1 20 (18.87%) Microsoft
2 16 (15.09%) Cognos
3 14 (13.21%) Tableau
4 12 (11.32%) Cloudera
4 12 (11.32%) Informatica
5 10 (9.43%) Google
5 10 (9.43%) Oracle
6 6 (5.66%) Apple
6 6 (5.66%) IBM
7 4 (3.77%) DataFlux
8 2 (1.89%) Intel