Period
to 18 January 2018

The following table provides summary statistics for contract job vacancies advertised in Birmingham with a requirement for ETL skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited ETL over the 6 months to 18 January 2018 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.

Extract, Transform and Load (ETL)
West Midlands > Birmingham
6 months to
18 Jan 2018
Same period 2017 Same period 2016
Rank 71 64 46
Rank change year-on-year -7 -18 +18
Contract jobs citing ETL 30 39 40
As % of all contract IT jobs advertised in Birmingham 1.88% 2.79% 3.12%
As % of the Processes & Methodologies category 2.33% 3.47% 4.02%
Number of daily rates quoted 23 22 32
Birmingham median daily rate £450 £320 £378
Median daily rate % change year-on-year +40.85% -15.36% +7.86%
10th Percentile £363 £175 £213
90th Percentile £538 £605 £468
West Midlands median daily rate £425 £373 £388
% change year-on-year +14.09% -3.87% +6.90%
Number of hourly rates quoted 1 0 0
Birmingham median hourly rate £35.00 - -
West Midlands median hourly rate £59.00 - -

ETL is in the Processes and Methodologies category. The following table is for comparison with the above and provides summary statistics for all contract job vacancies advertised in Birmingham with a requirement for process or methodology skills.

All Process and Methodology Skills
Birmingham
Contract vacancies with a requirement for process or methodology skills 1,289 1,124 995
As % of all contract IT jobs advertised in Birmingham 80.76% 80.34% 77.49%
Number of daily rates quoted 940 708 630
Birmingham median daily rate £400 £400 £375
Median daily rate % change year-on-year - +6.67% +1.49%
10th Percentile £225 £250 £225
90th Percentile £538 £550 £525
West Midlands median daily rate £400 £400 £375
% change year-on-year - +6.67% +4.17%
Number of hourly rates quoted 28 26 42
Birmingham median hourly rate £15.50 £17.25 £17.50
Median hourly rate % change year-on-year -10.14% -1.43% -12.50%
10th Percentile £9.31 £10.81 £10.64
90th Percentile £45.35 £32.10 £43.75
West Midlands median hourly rate £23.00 £21.22 £20.00
% change year-on-year +8.39% +6.10% -10.81%

ETL
Job Vacancy Trend in Birmingham

Job postings citing ETL as a percentage of all IT jobs advertised in Birmingham.

Job vacancy trend for ETL in Birmingham

ETL
Contractor Daily Rate Trend in Birmingham

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing ETL in Birmingham.

Contractor daily rate trend for ETL in Birmingham

ETL
Contractor Daily Rate Histogram in Birmingham

The daily rate distribution of IT jobs citing ETL in Birmingham over the 6 months to 18 January 2018.

Contractor daily rate histogram for ETL in Birmingham

For the 6 months to 18 January 2018, IT contractor jobs citing ETL 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 Birmingham region with a requirement for ETL.

1 22 (73.33%) SQL
2 21 (70.00%) SQL Server
3 19 (63.33%) Business Intelligence
4 15 (50.00%) Microsoft
5 14 (46.67%) SQL Server Reporting Services
5 14 (46.67%) SQL Server Integration Services
6 13 (43.33%) T-SQL
7 11 (36.67%) SQL Server Analysis Services
8 10 (33.33%) Data Quality
8 10 (33.33%) Data Modelling
9 8 (26.67%) Data Warehouse
9 8 (26.67%) Microsoft Excel
10 7 (23.33%) Finance
10 7 (23.33%) Migration
11 6 (20.00%) Agile Software Development
11 6 (20.00%) Analytics
11 6 (20.00%) Tableau
11 6 (20.00%) Data Migration
11 6 (20.00%) Visualisation
11 6 (20.00%) Power BI
12 5 (16.67%) Complex ETL
12 5 (16.67%) SharePoint
12 5 (16.67%) Web Services
12 5 (16.67%) MDX
13 4 (13.33%) Information Management
13 4 (13.33%) Microsoft Analysis Services
13 4 (13.33%) Workflow
13 4 (13.33%) Java
13 4 (13.33%) Microsoft Azure
13 4 (13.33%) Amazon AWS

ETL
Co-occurring IT Skills in Birmingham 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 (16.67%) SharePoint
2 1 (3.33%) SAS
Applications
1 8 (26.67%) Microsoft Excel
Business Applications
1 1 (3.33%) Dynamics CRM
Cloud Services
1 4 (13.33%) Amazon AWS
1 4 (13.33%) Microsoft Azure
2 3 (10.00%) SaaS
3 1 (3.33%) Dynamics 365
Database & Business Intelligence
1 21 (70.00%) SQL Server
2 14 (46.67%) SQL Server Integration Services
2 14 (46.67%) SQL Server Reporting Services
3 11 (36.67%) SQL Server Analysis Services
4 8 (26.67%) Data Warehouse
5 6 (20.00%) Power BI
6 4 (13.33%) Microsoft Analysis Services
7 3 (10.00%) PowerPivot
8 2 (6.67%) SQL Server 2008
9 1 (3.33%) OLAP
9 1 (3.33%) OLAP Cube
9 1 (3.33%) Oracle Database
9 1 (3.33%) Pentaho
9 1 (3.33%) RDBMS
9 1 (3.33%) Relational Database
9 1 (3.33%) SAS Visual Analytics
9 1 (3.33%) SQL Server 2012
9 1 (3.33%) SQL Server 2014
Development Applications
1 1 (3.33%) Git (software)
1 1 (3.33%) Jenkins
1 1 (3.33%) Maven
General
1 7 (23.33%) Finance
2 1 (3.33%) Banking
2 1 (3.33%) Manufacturing
2 1 (3.33%) Retail
Job Titles
1 17 (56.67%) Developer
2 12 (40.00%) Business Intelligence Developer
3 6 (20.00%) Analyst
3 6 (20.00%) Architect
4 5 (16.67%) Business Intelligence Analyst
4 5 (16.67%) Microsoft BI Developer
5 4 (13.33%) Business Analyst
5 4 (13.33%) Business Intelligence Business Analyst
5 4 (13.33%) Consultant
5 4 (13.33%) ETL Developer
5 4 (13.33%) SSIS Developer
6 3 (10.00%) Business Developer
6 3 (10.00%) Business Intelligence Consultant
6 3 (10.00%) Microsoft Developer
6 3 (10.00%) Senior Architect
6 3 (10.00%) Senior Developer
6 3 (10.00%) Solutions Architect
6 3 (10.00%) SQL BI Developer
6 3 (10.00%) SQL Developer
6 3 (10.00%) SSRS Developer
Libraries, Frameworks & Software Standards
1 5 (16.67%) MDX
1 5 (16.67%) Web Services
2 3 (10.00%) .NET
2 3 (10.00%) REST
2 3 (10.00%) RESTful
3 1 (3.33%) FIX Protocol
3 1 (3.33%) JMS
3 1 (3.33%) Kafka
3 1 (3.33%) RabbitMQ
3 1 (3.33%) Visualforce
Miscellaneous
1 4 (13.33%) FMCG
2 2 (6.67%) Analytical Skills
2 2 (6.67%) Computer Science
2 2 (6.67%) Management Information System
3 1 (3.33%) Fintech
3 1 (3.33%) Life Science
Operating Systems
1 1 (3.33%) Windows
1 1 (3.33%) Windows 10
Processes & Methodologies
1 19 (63.33%) Business Intelligence
2 10 (33.33%) Data Modelling
3 7 (23.33%) Migration
4 6 (20.00%) Agile Software Development
4 6 (20.00%) Analytics
4 6 (20.00%) Data Migration
4 6 (20.00%) Visualisation
5 5 (16.67%) Complex ETL
6 4 (13.33%) Business Analytics
6 4 (13.33%) Data Management
6 4 (13.33%) Data Visualisation
6 4 (13.33%) Information Management
6 4 (13.33%) Time Management
6 4 (13.33%) Use Case
6 4 (13.33%) Workflow
7 3 (10.00%) Collaborative Working
7 3 (10.00%) Data Integration
7 3 (10.00%) Data Transformation
7 3 (10.00%) ERP
7 3 (10.00%) Master Data Management
Programming Languages
1 22 (73.33%) SQL
2 13 (43.33%) T-SQL
3 4 (13.33%) Java
4 3 (10.00%) Data Analysis Expressions (DAX)
5 1 (3.33%) Apex Code
5 1 (3.33%) VBA
Qualifications
1 3 (10.00%) Security Cleared
2 2 (6.67%) SC Cleared
3 1 (3.33%) BPSS Clearance
3 1 (3.33%) Degree
Quality Assurance & Compliance
1 10 (33.33%) Data Quality
2 1 (3.33%) Disclosure Scotland
2 1 (3.33%) QA
Systems Management
1 3 (10.00%) Opscode Chef
1 3 (10.00%) Puppet
1 3 (10.00%) Terraform
2 1 (3.33%) Oracle EDQ
Vendors
1 15 (50.00%) Microsoft
2 6 (20.00%) Tableau
3 3 (10.00%) Oracle
4 1 (3.33%) Capita
4 1 (3.33%) Salesforce.com