Period
to 25 May 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 25 May 2018 with a comparison to the same period in the previous 2 years.

Solvency II
UK
6 months to
25 May 2018
Same period 2017 Same period 2016
Rank 1089 1130 1079
Rank change year-on-year +41 -51 +42
Permanent jobs citing Solvency II 88 57 216
As % of all permanent IT jobs advertised in the UK 0.051% 0.034% 0.11%
As % of the Quality Assurance & Compliance category 0.39% 0.28% 0.82%
Number of salaries quoted 81 56 190
UK median annual salary £52,500 £63,750 £57,500
Median salary % change year-on-year -17.65% +10.87% -11.54%
10th Percentile £37,750 £44,750 £39,750
90th Percentile £85,000 £83,750 £90,000
UK excluding London median annual salary £45,000 £62,500 £50,000
% change year-on-year -28.00% +25.00% -25.93%

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,787 20,324 26,450
As % of all permanent IT jobs advertised in the UK 13.10% 12.02% 13.18%
Number of salaries quoted 17,503 15,904 20,957
UK median annual salary £50,000 £47,500 £47,500
Median salary % change year-on-year +5.26% - +5.56%
10th Percentile £28,250 £26,250 £26,250
90th Percentile £80,000 £77,500 £75,000
UK excluding London median annual salary £45,000 £40,000 £42,500
% change year-on-year +12.50% -5.88% +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 25 May 2018.

Salary histogram for Solvency II in the UK

Solvency II
Top 5 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 25 May 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 +23 86 £51,000 -20.00% 10
London +21 70 £55,000 -15.38% 9
UK excluding London +5 18 £45,000 -28.00% 1
South East -6 16 £40,000 -42.86%
Scotland - 2 £95,000 -

For the 6 months to 25 May 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 72 (81.82%) Finance
2 44 (50.00%) SQL
3 39 (44.32%) Microsoft Excel
4 36 (40.91%) Data Quality
5 32 (36.36%) Power BI
6 31 (35.23%) Business Intelligence
7 23 (26.14%) Business Analysis
8 22 (25.00%) Data Management
8 22 (25.00%) Microsoft
8 22 (25.00%) GDPR
9 20 (22.73%) Big Data
9 20 (22.73%) SQL Server
10 19 (21.59%) Data Analysis
10 19 (21.59%) Data Governance
11 18 (20.45%) Analytics
11 18 (20.45%) Data Warehouse
12 17 (19.32%) QA
13 16 (18.18%) Performance Management
13 16 (18.18%) MS Visio
13 16 (18.18%) VB
13 16 (18.18%) VBA
13 16 (18.18%) Stakeholder Management
13 16 (18.18%) ISEB
13 16 (18.18%) Dodd-Frank
13 16 (18.18%) Line Management
13 16 (18.18%) Change Control
13 16 (18.18%) Business Process Modelling
14 15 (17.05%) FATCA
14 15 (17.05%) Visualisation
15 14 (15.91%) Analytical Skills

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 14 (15.91%) SAS
2 8 (9.09%) Apache Spark
3 1 (1.14%) SharePoint
Applications
1 39 (44.32%) Microsoft Excel
2 16 (18.18%) MS Visio
Cloud Services
1 5 (5.68%) Amazon AWS
1 5 (5.68%) Cortana Intelligence Suite
1 5 (5.68%) Microsoft Azure
2 2 (2.27%) Cloud Computing
2 2 (2.27%) Force.com
2 2 (2.27%) Salesforce Service Cloud
3 1 (1.14%) Office 365
3 1 (1.14%) SaaS
Communications & Networking
1 1 (1.14%) WAN
Database & Business Intelligence
1 32 (36.36%) Power BI
2 20 (22.73%) Big Data
2 20 (22.73%) SQL Server
3 18 (20.45%) Data Warehouse
4 11 (12.50%) QlikView
5 8 (9.09%) Apache Hive
5 8 (9.09%) Hadoop
5 8 (9.09%) MongoDB
6 5 (5.68%) Apache Cassandra
6 5 (5.68%) HBase
6 5 (5.68%) Neo4j
7 4 (4.55%) SAS EBI
8 2 (2.27%) PowerPivot
9 1 (1.14%) SQL Server Reporting Services
Development Applications
1 2 (2.27%) Ant
2 1 (1.14%) SQL Server Management Studio (SSMS)
General
1 72 (81.82%) Finance
2 13 (14.77%) Banking
3 12 (13.64%) Financial Institution
4 3 (3.41%) Law
5 2 (2.27%) Marketing
6 1 (1.14%) Back Office
6 1 (1.14%) Front Office
6 1 (1.14%) Legal
Job Titles
1 57 (64.77%) Analyst
2 28 (31.82%) Data Analyst
3 24 (27.27%) Data Quality Analyst
4 20 (22.73%) Quality Analyst
5 13 (14.77%) Financial Analyst
6 12 (13.64%) Finance Systems Analyst
6 12 (13.64%) Systems Analyst
7 10 (11.36%) Consultant
8 9 (10.23%) Data Consultant
9 8 (9.09%) Senior Analyst
9 8 (9.09%) SQL Analyst
9 8 (9.09%) Support Analyst
10 7 (7.95%) Commercial Analyst
10 7 (7.95%) Data Manager
10 7 (7.95%) Excel Analyst
10 7 (7.95%) SQL Data Analyst
11 6 (6.82%) Applications Support
11 6 (6.82%) Applications Support Analyst
11 6 (6.82%) Senior Financial Analyst
11 6 (6.82%) Senior Systems Analyst
Libraries, Frameworks & Software Standards
1 14 (15.91%) XML
2 12 (13.64%) XBRL
3 10 (11.36%) D3.js
4 5 (5.68%) Natural Language Processing
5 2 (2.27%) CSS
5 2 (2.27%) DHTML
5 2 (2.27%) HTML
5 2 (2.27%) J2EE
5 2 (2.27%) J2SE
5 2 (2.27%) JSON
5 2 (2.27%) REST
5 2 (2.27%) SOAP
5 2 (2.27%) Visualforce
5 2 (2.27%) Web Services
Miscellaneous
1 14 (15.91%) Analytical Skills
2 12 (13.64%) Taxonomies
3 9 (10.23%) Self-Motivation
4 7 (7.95%) Grid Computing
5 4 (4.55%) Management Information System
6 3 (3.41%) Computer Science
7 2 (2.27%) Data Protection Act
7 2 (2.27%) Reinsurance
8 1 (1.14%) Cyberattack
Operating Systems
1 7 (7.95%) Linux
1 7 (7.95%) Unix
2 2 (2.27%) AIX
Processes & Methodologies
1 31 (35.23%) Business Intelligence
2 23 (26.14%) Business Analysis
3 22 (25.00%) Data Management
4 19 (21.59%) Data Analysis
4 19 (21.59%) Data Governance
5 18 (20.45%) Analytics
6 16 (18.18%) Business Process Modelling
6 16 (18.18%) Change Control
6 16 (18.18%) Line Management
6 16 (18.18%) Performance Management
6 16 (18.18%) Stakeholder Management
7 15 (17.05%) Visualisation
8 13 (14.77%) Data Analytics
9 12 (13.64%) Data Conversion
9 12 (13.64%) Data Deduplication
9 12 (13.64%) Data Science
9 12 (13.64%) Incident Management
10 11 (12.50%) Problem-Solving
11 10 (11.36%) Data Cleansing
11 10 (11.36%) Risk Management
Programming Languages
1 44 (50.00%) SQL
2 16 (18.18%) VB
2 16 (18.18%) VBA
3 11 (12.50%) T-SQL
4 10 (11.36%) R
5 9 (10.23%) Python
6 7 (7.95%) Shell Script
7 2 (2.27%) Apex Code
7 2 (2.27%) Java
7 2 (2.27%) JavaScript
7 2 (2.27%) PL/SQL
7 2 (2.27%) SOQL
7 2 (2.27%) SOSL
Qualifications
1 16 (18.18%) ISEB
2 14 (15.91%) Degree
3 3 (3.41%) Security Cleared
4 2 (2.27%) ACCA
Quality Assurance & Compliance
1 36 (40.91%) Data Quality
2 22 (25.00%) GDPR
3 17 (19.32%) QA
4 16 (18.18%) Dodd-Frank
5 15 (17.05%) FATCA
6 14 (15.91%) IFRS
7 12 (13.64%) IFRS 9
8 7 (7.95%) EMIR
9 5 (5.68%) MiFID
10 4 (4.55%) Sarbanes-Oxley
11 2 (2.27%) COBIT
11 2 (2.27%) COSO
11 2 (2.27%) GAAP
11 2 (2.27%) ISAE 3402
12 1 (1.14%) AIFMD
Systems Management
1 2 (2.27%) SCOM
Vendors
1 22 (25.00%) Microsoft
2 10 (11.36%) Tableau
3 9 (10.23%) Oracle
4 5 (5.68%) Apple
4 5 (5.68%) Google
4 5 (5.68%) IBM
5 2 (2.27%) Intel
5 2 (2.27%) MicroStrategy
5 2 (2.27%) Pardot
5 2 (2.27%) Salesforce.com