Period
to 19 January 2018

The median contractor rate for an Excel VBA Developer was £500 per day in advertised job vacancies in the City of London during the 6 months to 19 January 2018.

The first table below provides contractor rate benchmarking and summary statistics including a comparison to 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.

Excel VBA Developer
Central London > City of London
6 months to
19 Jan 2018
Same period 2017 Same period 2016
Rank 232 225 229
Rank change year-on-year -7 +4 +24
Contract jobs requiring an Excel VBA Developer 20 7 12
As % of all contract IT jobs advertised in the City of London 0.28% 0.11% 0.17%
As % of the Job Titles category 0.30% 0.12% 0.17%
Number of daily rates quoted 19 4 10
City of London median daily rate £500 £338 £444
Median daily rate % change year-on-year +48.15% -23.94% -11.25%
10th Percentile £275 £263 £272
90th Percentile £594 £434 £538
Central London median daily rate £500 £275 £444
% change year-on-year +81.82% -38.03% -11.25%
Number of hourly rates quoted 0 0 0
City of London median hourly rate - - -
Central London median hourly rate - - -

The following table is for comparison with the above and includes summary statistics for all contract IT job vacancies advertised in the City of London. Most job vacancies include a discernible job title that can be normalized. As such, the figures in the second row provide an indication of the number of contract jobs in our overall sample.

All Contract IT Job Vacancies
City of London
Contract vacancies in the City of London with a recognized job title 6,685 5,951 6,861
% of contract IT jobs with a recognized job title 94.23% 95.55% 95.61%
Number of daily rates quoted 5,311 4,722 5,412
City of London median daily rate £500 £475 £460
Median daily rate % change year-on-year +5.26% +3.26% +5.14%
10th Percentile £313 £313 £275
90th Percentile £688 £663 £644
Central London median daily rate £500 £475 £450
% change year-on-year +5.26% +5.56% +5.26%
Number of hourly rates quoted 89 67 100
City of London median hourly rate £17.00 £17.89 £20.00
Median hourly rate % change year-on-year -4.95% -10.55% +19.37%
10th Percentile £11.25 £12.84 £10.98
90th Percentile £30.80 £55.00 £41.30
Central London median hourly rate £18.10 £17.13 £19.50
% change year-on-year +5.69% -12.18% +18.18%

Excel VBA Developer
Job Vacancy Trend in the City of London

Job postings that featured Excel VBA Developer in the job title as a percentage of all IT jobs advertised in the City of London.

Job vacancy trend for Excel VBA Developer in the City of London

Excel VBA Developer
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 Excel VBA Developer in the City of London.

Contractor daily rate trend for Excel VBA Developer in the City of London

Excel VBA Developer
Contractor Daily Rate Histogram in the City of London

The daily rate distribution of IT jobs citing Excel VBA Developer in the City of London over the 6 months to 19 January 2018.

Contractor daily rate histogram for Excel VBA Developer in the City of London

Excel VBA Developer
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 Excel VBA Developer in the City of London.

Contractor hourly rate trend for Excel VBA Developer in the City of London

Excel VBA Developer Skill Set
Top 30 Co-occurring IT Skills in the City of London

For the 6 months to 19 January 2018, Excel VBA Developer contract jobs required the following IT 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 featuring Excel VBA Developer in the job title.

1 20 (100.00%) VBA
1 20 (100.00%) Microsoft Excel
2 14 (70.00%) Banking
3 12 (60.00%) Finance
4 9 (45.00%) Front Office
5 8 (40.00%) Risk Management
6 7 (35.00%) C#
6 7 (35.00%) Risk Analysis
6 7 (35.00%) Market Risk
6 7 (35.00%) Statistical Modelling
6 7 (35.00%) Analytical Skills
7 5 (25.00%) Investment Banking
7 5 (25.00%) Asset Management
8 4 (20.00%) .NET
8 4 (20.00%) Oracle
8 4 (20.00%) MS Access
9 3 (15.00%) Spreadsheet
9 3 (15.00%) Portfolio Management
9 3 (15.00%) .NET Framework
9 3 (15.00%) SQL
9 3 (15.00%) RAD
9 3 (15.00%) Agile Software Development
10 2 (10.00%) Fixed Income
10 2 (10.00%) Reuters
10 2 (10.00%) Bloomberg
10 2 (10.00%) Microsoft
10 2 (10.00%) C++
10 2 (10.00%) OOP
10 2 (10.00%) OO
11 1 (5.00%) Orchestrade

Excel VBA Developer Skill Set
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:

Applications
1 20 (100.00%) Microsoft Excel
2 3 (15.00%) Spreadsheet
Business Applications
1 1 (5.00%) Orchestrade
1 1 (5.00%) RMDS
Database & Business Intelligence
1 4 (20.00%) MS Access
2 1 (5.00%) BusinessObjects
2 1 (5.00%) SQL Server
General
1 14 (70.00%) Banking
2 12 (60.00%) Finance
3 9 (45.00%) Front Office
4 5 (25.00%) Investment Banking
Libraries, Frameworks & Software Standards
1 4 (20.00%) .NET
2 3 (15.00%) .NET Framework
3 1 (5.00%) MDX
Miscellaneous
1 7 (35.00%) Analytical Skills
1 7 (35.00%) Market Risk
2 2 (10.00%) Fixed Income
3 1 (5.00%) Derivative
3 1 (5.00%) Foreign Exchange (FX)
3 1 (5.00%) Greenfield Project
Processes & Methodologies
1 8 (40.00%) Risk Management
2 7 (35.00%) Risk Analysis
2 7 (35.00%) Statistical Modelling
3 5 (25.00%) Asset Management
4 3 (15.00%) Agile Software Development
4 3 (15.00%) Portfolio Management
4 3 (15.00%) RAD
5 2 (10.00%) OO
5 2 (10.00%) OOP
6 1 (5.00%) Business Analysis
6 1 (5.00%) Data Mapping
6 1 (5.00%) Fund Management
6 1 (5.00%) Investment Management
6 1 (5.00%) Wealth Management
6 1 (5.00%) Workflow
Programming Languages
1 20 (100.00%) VBA
2 7 (35.00%) C#
3 3 (15.00%) SQL
4 2 (10.00%) C++
Quality Assurance & Compliance
1 1 (5.00%) MiFID
Vendors
1 4 (20.00%) Oracle
2 2 (10.00%) Bloomberg
2 2 (10.00%) Microsoft
2 2 (10.00%) Reuters
3 1 (5.00%) Sun