Period
to 18 November 2018

The table below looks at the prevalence of the term Reference Data in permanent job vacancies advertised in the City of London. Included is a benchmarking guide to the salaries offered in vacancies that have cited Reference Data over the 6 months to 18 November 2018 with a comparison to the same period over the previous 2 years.

Reference Data
Central London > City of London
6 months to
18 Nov 2018
Same period 2017 Same period 2016
Rank 323 306 293
Rank change year-on-year -17 -13 +44
Permanent jobs citing Reference Data 24 25 62
As % of all permanent IT jobs advertised in the City of London 0.22% 0.25% 0.53%
As % of the Miscellaneous category 0.44% 0.51% 1.11%
Number of salaries quoted 19 22 53
City of London median annual salary £65,000 £65,000 £75,000
Median salary % change year-on-year - -13.33% +25.00%
10th Percentile £48,788 £47,500 £32,500
90th Percentile £121,500 £92,875 £95,000
Central London median annual salary £67,500 £65,000 £75,000
% change year-on-year +3.85% -13.33% +25.00%

Reference Data is in the Generic IT Skills 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 generic IT skills.

All Generic IT Skills
City of London
Permanent vacancies with a requirement for generic IT skills 5,431 4,919 5,571
As % of all permanent IT jobs advertised in the City of London 49.14% 48.30% 47.62%
Number of salaries quoted 4,878 4,392 5,056
City of London median annual salary £65,000 £60,000 £57,500
Median salary % change year-on-year +8.33% +4.35% -
10th Percentile £37,500 £33,750 £33,500
90th Percentile £95,000 £96,250 £90,000
Central London median annual salary £65,000 £60,000 £57,500
% change year-on-year +8.33% +4.35% -

Reference Data
Job Vacancy Trend in the City of London

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

Job vacancy trend for Reference Data in the City of London

Reference Data
Salary Trend in the City of London

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

Salary trend for Reference Data in the City of London

Reference Data
Salary Histogram in the City of London

The salary distribution of IT jobs citing Reference Data in the City of London over the 6 months to 18 November 2018.

Salary histogram for Reference Data in the City of London

For the 6 months to 18 November 2018, IT jobs citing Reference Data 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 Reference Data.

1 22 (91.67%) SQL
2 11 (45.83%) Data Management
3 9 (37.50%) Oracle
3 9 (37.50%) Data Warehouse
4 8 (33.33%) Microsoft Excel
4 8 (33.33%) VBA
4 8 (33.33%) Analytical Skills
4 8 (33.33%) Reference Data Management
4 8 (33.33%) Problem-Solving
5 7 (29.17%) Data Structures
5 7 (29.17%) Data Governance
5 7 (29.17%) Degree
5 7 (29.17%) User Acceptance Testing
5 7 (29.17%) Linux
5 7 (29.17%) Finance
6 6 (25.00%) Front Office
6 6 (25.00%) Python
6 6 (25.00%) Data Analysis
6 6 (25.00%) Analytics
7 5 (20.83%) Tableau
7 5 (20.83%) Structured Programming
7 5 (20.83%) System Testing
7 5 (20.83%) Mathematics
7 5 (20.83%) Computer Science
7 5 (20.83%) Scenario Testing
7 5 (20.83%) Analytical Mindset
7 5 (20.83%) Virtual Team Management
7 5 (20.83%) Virtual Team
7 5 (20.83%) Agile Software Development
7 5 (20.83%) Scrum

Reference Data
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 5 (20.83%) SAS
2 2 (8.33%) SharePoint
Applications
1 8 (33.33%) Microsoft Excel
Cloud Services
1 2 (8.33%) SaaS
Database & Business Intelligence
1 9 (37.50%) Data Warehouse
2 5 (20.83%) BusinessObjects
3 4 (16.67%) Big Data
3 4 (16.67%) KDB
3 4 (16.67%) MySQL
3 4 (16.67%) OLAP
3 4 (16.67%) OLTP
3 4 (16.67%) Oracle OLAP
3 4 (16.67%) PostgreSQL
3 4 (16.67%) Snowflake Schema
3 4 (16.67%) Star Schema
4 2 (8.33%) Oracle Reports
5 1 (4.17%) SQL Server
Development Applications
1 3 (12.50%) Git (software)
1 3 (12.50%) Gradle
1 3 (12.50%) JUnit
2 2 (8.33%) JIRA
2 2 (8.33%) Maven
2 2 (8.33%) Subversion
General
1 7 (29.17%) Finance
2 6 (25.00%) Front Office
Job Titles
1 8 (33.33%) Analyst
2 6 (25.00%) Data Analyst
2 6 (25.00%) Developer
3 5 (20.83%) Solutions Analyst
4 4 (16.67%) Data Engineer
5 3 (12.50%) Business Analyst
5 3 (12.50%) Java Developer
6 2 (8.33%) Architect
6 2 (8.33%) Data Architect
6 2 (8.33%) Python Developer
6 2 (8.33%) Technical Analyst
6 2 (8.33%) VBA Developer
7 1 (4.17%) C# .NET Developer
7 1 (4.17%) Derivatives Business Analyst
7 1 (4.17%) Senior Analyst
7 1 (4.17%) Senior C# .NET Developer
7 1 (4.17%) Senior Developer
7 1 (4.17%) Senior SQL Developer
7 1 (4.17%) SQL Analyst
7 1 (4.17%) UML Analyst
Libraries, Frameworks & Software Standards
1 4 (16.67%) FIX Protocol
2 3 (12.50%) .NET
2 3 (12.50%) Spring
3 1 (4.17%) ASP.NET
3 1 (4.17%) ASP.NET Core
Miscellaneous
1 8 (33.33%) Analytical Skills
2 7 (29.17%) Data Structures
3 5 (20.83%) Analytical Mindset
3 5 (20.83%) Computer Science
3 5 (20.83%) Fixed Income
3 5 (20.83%) Virtual Team
4 4 (16.67%) Algorithms
4 4 (16.67%) Derivative
4 4 (16.67%) Equities
4 4 (16.67%) Tandem
5 2 (8.33%) Management Information System
5 2 (8.33%) Taxonomies
6 1 (4.17%) Credit Derivative
6 1 (4.17%) Hedge funds
Operating Systems
1 7 (29.17%) Linux
2 4 (16.67%) Unix
Processes & Methodologies
1 11 (45.83%) Data Management
2 8 (33.33%) Problem-Solving
2 8 (33.33%) Reference Data Management
3 7 (29.17%) Data Governance
3 7 (29.17%) User Acceptance Testing
4 6 (25.00%) Analytics
4 6 (25.00%) Data Analysis
5 5 (20.83%) Agile Software Development
5 5 (20.83%) Business Intelligence
5 5 (20.83%) Mathematics
5 5 (20.83%) PRINCE2
5 5 (20.83%) Scenario Testing
5 5 (20.83%) Scrum
5 5 (20.83%) Structured Programming
5 5 (20.83%) System Testing
5 5 (20.83%) Virtual Team Management
6 4 (16.67%) Data Development
6 4 (16.67%) Data Modelling
6 4 (16.67%) ETL
6 4 (16.67%) Risk Management
Programming Languages
1 22 (91.67%) SQL
2 8 (33.33%) VBA
3 6 (25.00%) Python
4 4 (16.67%) Perl
5 3 (12.50%) C#
5 3 (12.50%) Java
5 3 (12.50%) PL/SQL
6 1 (4.17%) C++
Qualifications
1 7 (29.17%) Degree
Quality Assurance & Compliance
1 3 (12.50%) Data Quality
Vendors
1 9 (37.50%) Oracle
2 5 (20.83%) Cognos
2 5 (20.83%) Microsoft
2 5 (20.83%) MicroStrategy
2 5 (20.83%) Tableau
3 2 (8.33%) Google
3 2 (8.33%) Salesforce.com