Period
to 17 November 2017

The following table provides summary statistics for contract job vacancies advertised in the City of London with a requirement for Spreadsheet skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited Spreadsheet over the 6 months to 17 November 2017 with a comparison to the same period in the previous 2 years.

Note that daily and hourly rates are treated separately in these statistics. When calculating contractor rate percentiles, daily rates are never derived from quoted hourly rates or vice versa.

Spreadsheets
Central London > City of London
6 months to
17 Nov 2017
Same period 2016 Same period 2015
Rank 220 216 243
Rank change year-on-year -4 +27 +5
Contract jobs citing Spreadsheet 31 30 38
As % of all contract IT jobs advertised in the City of London 0.44% 0.45% 0.41%
As % of the Applications category 5.31% 5.15% 3.63%
Number of daily rates quoted 18 16 29
City of London median daily rate £538 £425 £475
Median daily rate % change year-on-year +26.47% -10.53% +11.76%
10th Percentile £240 £305 £245
90th Percentile £722 £813 £675
Central London median daily rate £500 £425 £475
% change year-on-year +17.65% -10.53% +11.76%
Number of hourly rates quoted 2 1 3
City of London median hourly rate £18.11 £19.92 £13.39
Median hourly rate % change year-on-year -9.07% +48.82% -29.55%
10th Percentile £15.56 £17.02 £10.79
90th Percentile £21.15 £22.83 £23.22
Central London median hourly rate £18.11 £19.92 £13.39
% change year-on-year -9.07% +48.82% -29.55%

Spreadsheet is in the Software Applications category. The following table is for comparison with the above and provides summary statistics for all contract job vacancies advertised in the City of London with a requirement for software application skills.

All Software Application Skills
City of London
Contract vacancies with a requirement for software application skills 584 583 1046
As % of all contract IT jobs advertised in the City of London 8.20% 8.67% 11.24%
Number of daily rates quoted 425 398 786
City of London median daily rate £410 £391 £375
Median daily rate % change year-on-year +4.79% +4.33% -
10th Percentile £182 £170 £171
90th Percentile £638 £571 £613
Central London median daily rate £400 £383 £375
% change year-on-year +4.58% +2.00% -
Number of hourly rates quoted 17 28 47
City of London median hourly rate £20.50 £18.25 £16.50
Median hourly rate % change year-on-year +12.33% +10.61% +3.13%
10th Percentile £13.33 £11.25 £9.70
90th Percentile £32.20 £35.25 £24.74
Central London median hourly rate £20.50 £17.13 £16.50
% change year-on-year +19.71% +3.79% +4.76%

Spreadsheet
Job Vacancy Trend in the City of London

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

Job vacancy trend for Spreadsheet in the City of London

Spreadsheet
Contractor Daily Rate Trend in the City of London

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing Spreadsheet in the City of London.

Contractor daily rate trend for Spreadsheet in the City of London

Spreadsheet
Contractor Daily Rate Histogram in the City of London

The daily rate distribution of IT jobs citing Spreadsheet in the City of London over the 6 months to 17 November 2017.

Contractor daily rate histogram for Spreadsheet in the City of London

Spreadsheet
Contractor Hourly Rate Trend in the City of London

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing Spreadsheet in the City of London.

Contractor hourly rate trend for Spreadsheet in the City of London

For the 6 months to 17 November 2017, IT contractor jobs citing Spreadsheet also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all contract ads across the City of London region with a requirement for Spreadsheet.

1 22 (70.97%) Finance
2 16 (51.61%) Microsoft Excel
3 14 (45.16%) Banking
4 11 (35.48%) VBA
5 10 (32.26%) Security Cleared
6 9 (29.03%) DV Cleared
7 8 (25.81%) CheckPoint
8 5 (16.13%) Foreign Exchange (FX)
8 5 (16.13%) Front Office
8 5 (16.13%) Project Management
8 5 (16.13%) PRINCE2
8 5 (16.13%) Microsoft
9 4 (12.90%) OO
9 4 (12.90%) Microsoft Office
9 4 (12.90%) Stakeholder Management
9 4 (12.90%) Investment Banking
10 3 (9.68%) Microsoft PowerPoint
10 3 (9.68%) Derivative
10 3 (9.68%) Analytical Skills
10 3 (9.68%) Fixed Income
10 3 (9.68%) Workflow
10 3 (9.68%) Oracle
10 3 (9.68%) C#
11 2 (6.45%) C++
11 2 (6.45%) Java
11 2 (6.45%) SQL
11 2 (6.45%) Microsoft Project
11 2 (6.45%) SharePoint
11 2 (6.45%) Business Intelligence
11 2 (6.45%) RAD

Spreadsheet
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 2 (6.45%) SharePoint
2 1 (3.23%) SharePoint 2010
Applications
1 16 (51.61%) Microsoft Excel
2 4 (12.90%) Microsoft Office
3 3 (9.68%) Microsoft PowerPoint
4 2 (6.45%) Microsoft Project
Business Applications
1 2 (6.45%) Orchestrade
1 2 (6.45%) RMDS
2 1 (3.23%) Oracle General Ledger
Cloud Services
1 1 (3.23%) Google Analytics
1 1 (3.23%) Office 365
Database & Business Intelligence
1 2 (6.45%) Power BI
2 1 (3.23%) Data Mart
2 1 (3.23%) OLAP
2 1 (3.23%) OLTP
2 1 (3.23%) PerformancePoint
2 1 (3.23%) PowerPivot
2 1 (3.23%) Relational Database
2 1 (3.23%) SQL Server
2 1 (3.23%) SQL Server 2012
2 1 (3.23%) SQL Server Analysis Services
2 1 (3.23%) SQL Server Integration Services
2 1 (3.23%) SQL Server Reporting Services
2 1 (3.23%) Star Schema
General
1 22 (70.97%) Finance
2 14 (45.16%) Banking
3 5 (16.13%) Front Office
4 4 (12.90%) Investment Banking
5 2 (6.45%) Law
5 2 (6.45%) Marketing
6 1 (3.23%) Advertising
6 1 (3.23%) Back Office
6 1 (3.23%) Financial Institution
6 1 (3.23%) General Ledger
6 1 (3.23%) International Banking
6 1 (3.23%) Telecoms
Job Titles
1 9 (29.03%) Developer
1 9 (29.03%) Project Officer
1 9 (29.03%) Project Support Officer
1 9 (29.03%) Support Officer
2 6 (19.35%) Analyst
2 6 (19.35%) VBA Developer
3 3 (9.68%) Excel Developer
3 3 (9.68%) Excel VBA Developer
4 2 (6.45%) Business Analyst
4 2 (6.45%) Data Analyst
4 2 (6.45%) Front Office Developer
4 2 (6.45%) Front Office RAD Developer
4 2 (6.45%) Java Developer
4 2 (6.45%) Java Quantitative Developer
4 2 (6.45%) Low Latency Java Developer
4 2 (6.45%) Quantitative Developer
4 2 (6.45%) RAD Developer
4 2 (6.45%) Senior Developer
4 2 (6.45%) Senior Java Developer
4 2 (6.45%) Senior Quantitative Developer
Libraries, Frameworks & Software Standards
1 2 (6.45%) Middleware
2 1 (3.23%) .NET
2 1 (3.23%) .NET Framework
2 1 (3.23%) ASP.NET
Miscellaneous
1 5 (16.13%) Foreign Exchange (FX)
2 3 (9.68%) Analytical Skills
2 3 (9.68%) Derivative
2 3 (9.68%) Fixed Income
3 2 (6.45%) Computer Science
3 2 (6.45%) Equities
4 1 (3.23%) Blackberry
4 1 (3.23%) Credit Derivative
4 1 (3.23%) Credit Risk
4 1 (3.23%) Management Information System
4 1 (3.23%) Market Risk
Processes & Methodologies
1 5 (16.13%) PRINCE2
1 5 (16.13%) Project Management
2 4 (12.90%) OO
2 4 (12.90%) Stakeholder Management
3 3 (9.68%) Workflow
4 2 (6.45%) Agile Software Development
4 2 (6.45%) Analytics
4 2 (6.45%) Asset Management
4 2 (6.45%) Business Intelligence
4 2 (6.45%) Low Latency
4 2 (6.45%) RAD
4 2 (6.45%) Risk Management
5 1 (3.23%) Actionable Insight
5 1 (3.23%) Client Onboarding
5 1 (3.23%) Digital Analytics
5 1 (3.23%) Matrix Organization
5 1 (3.23%) Performance Tuning
5 1 (3.23%) PnL Attribution
5 1 (3.23%) SDLC
5 1 (3.23%) Workflow Analysis
Programming Languages
1 11 (35.48%) VBA
2 3 (9.68%) C#
3 2 (6.45%) C++
3 2 (6.45%) Java
3 2 (6.45%) SQL
4 1 (3.23%) C
4 1 (3.23%) VB
Qualifications
1 10 (32.26%) Security Cleared
2 9 (29.03%) DV Cleared
3 2 (6.45%) Computer Science Degree
3 2 (6.45%) Degree
4 1 (3.23%) SC Cleared
Quality Assurance & Compliance
1 2 (6.45%) MiFID
2 1 (3.23%) PMO
Vendors
1 8 (25.81%) CheckPoint
2 5 (16.13%) Microsoft
3 3 (9.68%) Oracle
4 1 (3.23%) Google
4 1 (3.23%) MobileIron
4 1 (3.23%) Murex