The table below looks at the statistics for Solvency II skills in IT jobs advertised for the City of London region. Included is a guide to the salaries offered in IT jobs that have cited Solvency II over the 3 months to 27 September 2016 with a comparison to the same period over the previous 2 years.

3 months to
27 Sep 2016
Same period 2015 Same period 2014
Solvency II
Rank 246 278 310
Rank change year-on-year
+32 +32
Permanent jobs citing Solvency II 2 12 21
As % of all permanent IT jobs located in the City of London 0.033% 0.14% 0.19%
As % of the Quality Assurance & Compliance category 0.29% 1.16% 1.71%
Number of salaries quoted 1 11 20
Median salary £75,000 £57,500 £81,250
Median salary % change year-on-year
+30.43% -29.23%
UK excluding London median salary £52,500 £57,500 £65,000
% change year-on-year
-8.69% -11.53%
Solvency II
London

The following table is for comparison with the above and provides statistics for the entire Quality Assurance & Compliance category in permanent jobs advertised in the City of London region.

Quality Assurance & Compliance Category
City of London
Permanent IT job ads with a match in the
Quality Assurance & Compliance category
689 1033 1228
As % of all permanent IT jobs located in the City of London 11.50% 11.98% 10.91%
Number of salaries quoted 613 848 1011
Median salary £57,500 £60,000 £55,000
Median salary % change year-on-year
-4.16% +9.09%
90% offered a salary of more than £32,800 £37,500 £35,000
10% offered a salary of more than £80,000 £80,000 £90,000
UK excluding London median salary £45,000 £42,500 £40,000
% change year-on-year
+5.88% +6.25%

Solvency II
Jobs Demand Trend in the City of London

The demand trend of job ads across the City of London region citing Solvency II as a proportion of all IT jobs with a match in the Quality Assurance & Compliance category.

Solvency II Jobs Demand Trend 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 across the City of London region.

Solvency II Salary Trend in the City of London

Solvency II
Top 30 Related IT Skills in the City of London

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

1 16 (80.00%) Finance
2 10 (50.00%) SQL
3 8 (40.00%) SharePoint
4 7 (35.00%) Data Management
5 6 (30.00%) Risk Management
5 6 (30.00%) Data Governance
6 5 (25.00%) Process Improvement
6 5 (25.00%) SQL Server 2012
6 5 (25.00%) Data Protection
6 5 (25.00%) SQL Server 2008
6 5 (25.00%) Relational Database
6 5 (25.00%) ITIL Foundation Certificate
6 5 (25.00%) Database Theory
6 5 (25.00%) Relational Database Theory
6 5 (25.00%) MCTS
6 5 (25.00%) SQL Server 2005
6 5 (25.00%) MCITP
6 5 (25.00%) Microsoft
6 5 (25.00%) Microsoft Certification
6 5 (25.00%) SQL Server
6 5 (25.00%) ITIL
6 5 (25.00%) MCSE
6 5 (25.00%) MCSA
6 5 (25.00%) MCDBA
7 4 (20.00%) MS Office
7 4 (20.00%) Validation
7 4 (20.00%) Process Management
7 4 (20.00%) Management Information System
7 4 (20.00%) Data Flow Diagram
8 3 (15.00%) Test Scripting

Solvency II
Top Related 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 (40.00%) SharePoint
Applications
1 4 (20.00%) MS Office
2 1 (5.00%) MS Excel
Database & Business Intelligence
1 5 (25.00%) Relational Database
1 5 (25.00%) SQL Server
1 5 (25.00%) SQL Server 2005
1 5 (25.00%) SQL Server 2008
1 5 (25.00%) SQL Server 2012
2 2 (10.00%) Crystal Reports
2 2 (10.00%) Data Warehouse
2 2 (10.00%) SQL Server Reporting Services
3 1 (5.00%) PowerPivot
3 1 (5.00%) SQL Server Analysis Services
3 1 (5.00%) SQL Server Integration Services
Development Applications
1 2 (10.00%) Eclipse
2 1 (5.00%) Visual Studio
General
1 16 (80.00%) Finance
2 2 (10.00%) Banking
2 2 (10.00%) Investment Banking
3 1 (5.00%) Advertising
Job Titles
1 10 (50.00%) Analyst
2 5 (25.00%) Administrator
2 5 (25.00%) Data Analyst
2 5 (25.00%) DBA
2 5 (25.00%) SQL DBA
2 5 (25.00%) SQL Server DBA
3 2 (10.00%) Business Analyst
3 2 (10.00%) Test Analyst
4 1 (5.00%) Asset Management Analyst
4 1 (5.00%) Banking Analyst
4 1 (5.00%) Business Intelligence Manager
4 1 (5.00%) Data Warehouse Analyst
4 1 (5.00%) Functional Analyst
4 1 (5.00%) Functional Test Analyst
4 1 (5.00%) Investment Banking Business Analyst
4 1 (5.00%) MiFID Business Analyst
4 1 (5.00%) MIS Manager
4 1 (5.00%) Project Manager
4 1 (5.00%) Report Analyst
4 1 (5.00%) SQL Reporting Analyst
Libraries, Frameworks & Software Standards
1 2 (10.00%) MDX
2 1 (5.00%) HTML
2 1 (5.00%) XML
Miscellaneous
1 4 (20.00%) Management Information System
2 1 (5.00%) Analytical Skills
2 1 (5.00%) Mathematics
Operating Systems
1 1 (5.00%) Linux
1 1 (5.00%) Unix
Processes & Methodologies
1 7 (35.00%) Data Management
2 6 (30.00%) Data Governance
2 6 (30.00%) Risk Management
3 5 (25.00%) Data Protection
3 5 (25.00%) Database Theory
3 5 (25.00%) ITIL
3 5 (25.00%) Process Improvement
3 5 (25.00%) Relational Database Theory
4 4 (20.00%) Data Flow Diagram
4 4 (20.00%) Process Management
4 4 (20.00%) Validation
5 3 (15.00%) Analytics
5 3 (15.00%) Stakeholder Management
5 3 (15.00%) Test Scripting
6 2 (10.00%) Business Analysis
6 2 (10.00%) Functional Testing
6 2 (10.00%) Integration Testing
6 2 (10.00%) System Integration Testing
6 2 (10.00%) User Acceptance Testing
7 1 (5.00%) Change Control
Programming Languages
1 10 (50.00%) SQL
2 3 (15.00%) VBA
3 1 (5.00%) C#
3 1 (5.00%) Data Analysis Expressions (DAX)
3 1 (5.00%) Java
3 1 (5.00%) Shell Script
3 1 (5.00%) T-SQL
Qualifications
1 5 (25.00%) ITIL Foundation Certificate
1 5 (25.00%) MCDBA
1 5 (25.00%) MCITP
1 5 (25.00%) MCSA
1 5 (25.00%) MCSE
1 5 (25.00%) MCTS
1 5 (25.00%) Microsoft Certification
2 1 (5.00%) Degree
Quality Assurance & Compliance
1 3 (15.00%) Data Quality
2 1 (5.00%) EMIR
2 1 (5.00%) FATCA
2 1 (5.00%) MiFID
Systems Management
1 2 (10.00%) HP Quality Center
Vendors
1 5 (25.00%) Microsoft
2 2 (10.00%) Cognos
2 2 (10.00%) HP