Period
to 20 June 2018

The following table provides summary statistics for permanent job vacancies advertised in the West Midlands with a requirement for ETL skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited ETL over the 6 months to 20 June 2018 with a comparison to the same period in the previous 2 years.

Extract, Transform and Load (ETL)
England > West Midlands
6 months to
20 Jun 2018
Same period 2017 Same period 2016
Rank 138 153 124
Rank change year-on-year +15 -29 +54
Permanent jobs citing ETL 196 191 284
As % of all permanent IT jobs advertised in the West Midlands 2.08% 1.95% 2.30%
As % of the Processes & Methodologies category 2.32% 2.16% 2.57%
Number of salaries quoted 156 177 216
West Midlands median annual salary £50,000 £40,000 £42,500
Median salary % change year-on-year +25.00% -5.88% -
10th Percentile £31,250 £27,500 £32,500
90th Percentile £78,750 £48,750 £61,250
England median annual salary £53,500 £50,000 £52,500
% change year-on-year +7.00% -4.76% -1.87%

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

All Process and Methodology Skills
West Midlands
Permanent vacancies with a requirement for process or methodology skills 8,466 8,847 11,038
As % of all permanent IT jobs advertised in the West Midlands 89.74% 90.37% 89.57%
Number of salaries quoted 6,497 7,262 8,769
West Midlands median annual salary £42,500 £40,000 £41,333
Median salary % change year-on-year +6.25% -3.23% +3.33%
10th Percentile £26,000 £25,750 £25,000
90th Percentile £66,250 £61,250 £65,000
England median annual salary £50,000 £50,000 £48,500
% change year-on-year - +3.09% +2.11%

ETL
Job Vacancy Trend in the West Midlands

Job postings citing ETL as a percentage of all IT jobs advertised in the West Midlands.

Job vacancy trend for ETL in the West Midlands

ETL
Salary Trend in the West Midlands

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing ETL in the West Midlands.

Salary trend for ETL in the West Midlands

ETL
Salary Histogram in the West Midlands

The salary distribution of IT jobs citing ETL in the West Midlands over the 6 months to 20 June 2018.

Salary histogram for ETL in the West Midlands

ETL
Job Locations in the West Midlands

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing ETL within the West Midlands region over the 6 months to 20 June 2018. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Birmingham +26 108 £52,500 +31.25% 11
Staffordshire +22 24 £45,000 +28.57% 9
Warwickshire -22 22 £60,000 +50.00% 4
Shropshire +29 9 - - 1
Coventry +6 9 £25,000 -41.18%
Walsall -2 5 £40,000 -1.36%
Wolverhampton - 5 £34,000 - 2
Solihull -23 2 £57,500 +64.29% 1
ETL
England

For the 6 months to 20 June 2018, IT jobs citing ETL 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 West Midlands region with a requirement for ETL.

1 121 (61.73%) SQL
2 93 (47.45%) Business Intelligence
3 81 (41.33%) SQL Server
4 78 (39.80%) Data Warehouse
5 72 (36.73%) SQL Server Integration Services
6 71 (36.22%) SQL Server Reporting Services
7 53 (27.04%) Microsoft
8 51 (26.02%) SQL Server Analysis Services
9 48 (24.49%) T-SQL
10 45 (22.96%) Analytics
11 42 (21.43%) Big Data
12 39 (19.90%) Migration
13 36 (18.37%) Agile Software Development
14 34 (17.35%) Finance
14 34 (17.35%) Oracle
14 34 (17.35%) Microsoft Azure
14 34 (17.35%) Power BI
15 32 (16.33%) Analytical Skills
15 32 (16.33%) Computer Science
16 29 (14.80%) Data Modelling
16 29 (14.80%) Tableau
17 25 (12.76%) Microsoft Excel
17 25 (12.76%) Salesforce.com
17 25 (12.76%) Data Management
18 24 (12.24%) Visualforce
18 24 (12.24%) Apex Code
19 23 (11.73%) QA
20 22 (11.22%) Management Information System
20 22 (11.22%) Java
20 22 (11.22%) SQL Server 2012

ETL
Co-occurring IT Skills in the West Midlands 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 14 (7.14%) Apache
1 14 (7.14%) Apache Spark
2 3 (1.53%) SharePoint
3 2 (1.02%) Apache Pig
3 2 (1.02%) Elasticsearch
3 2 (1.02%) IIS
3 2 (1.02%) WebSphere
4 1 (0.51%) SAS
Applications
1 25 (12.76%) Microsoft Excel
2 5 (2.55%) Microsoft Office
3 3 (1.53%) Microsoft PowerPoint
3 3 (1.53%) MS Visio
Business Applications
1 10 (5.10%) HFM
2 5 (2.55%) Cognos Business Intelligence
2 5 (2.55%) Cognos TM1
2 5 (2.55%) Dynamics AX
2 5 (2.55%) Hyperion Planning
3 3 (1.53%) Dynamics CRM
4 1 (0.51%) Carpe Diem
4 1 (0.51%) Cognos Planning
4 1 (0.51%) Dynamics NAV
4 1 (0.51%) Salesforce.com CRM
4 1 (0.51%) SAP MDG
4 1 (0.51%) SAP S/4HANA
Cloud Services
1 34 (17.35%) Microsoft Azure
2 20 (10.20%) Force.com
3 8 (4.08%) PaaS
4 7 (3.57%) Azure Data Factory
5 6 (3.06%) SaaS
5 6 (3.06%) Serverless
6 5 (2.55%) IaaS
7 4 (2.04%) Cortana Intelligence Suite
7 4 (2.04%) Dynamics 365
8 3 (1.53%) Amazon AWS
9 2 (1.02%) AWS Lambda
9 2 (1.02%) Google Cloud Platform
9 2 (1.02%) Office 365
9 2 (1.02%) Trello
Communications & Networking
1 2 (1.02%) AMQP
1 2 (1.02%) SMS
2 1 (0.51%) DAB
Database & Business Intelligence
1 81 (41.33%) SQL Server
2 78 (39.80%) Data Warehouse
3 72 (36.73%) SQL Server Integration Services
4 71 (36.22%) SQL Server Reporting Services
5 51 (26.02%) SQL Server Analysis Services
6 42 (21.43%) Big Data
7 34 (17.35%) Power BI
8 22 (11.22%) SQL Server 2012
9 21 (10.71%) Hadoop
10 18 (9.18%) QlikView
10 18 (9.18%) Relational Database
11 16 (8.16%) SQL Server 2008
12 14 (7.14%) BusinessObjects
13 11 (5.61%) Data Lake
14 10 (5.10%) Azure SQL Database
14 10 (5.10%) Enterprise Data Warehouse
14 10 (5.10%) Essbase
14 10 (5.10%) OLAP
15 9 (4.59%) Qlik Sense
16 8 (4.08%) SQL Server 2000
Development Applications
1 15 (7.65%) Git (software)
2 11 (5.61%) Jenkins
3 8 (4.08%) Visual Studio
4 6 (3.06%) Maven
5 4 (2.04%) Team Foundation Server
6 3 (1.53%) JIRA
7 2 (1.02%) Bitbucket
7 2 (1.02%) JUnit
7 2 (1.02%) SQL Server Management Studio (SSMS)
7 2 (1.02%) TestNG
8 1 (0.51%) Selenium
8 1 (0.51%) WebDriver
8 1 (0.51%) Zephyr
General
1 34 (17.35%) Finance
2 11 (5.61%) Games
2 11 (5.61%) Retail
3 6 (3.06%) Banking
3 6 (3.06%) Legal
4 5 (2.55%) Marketing
5 4 (2.04%) Financial Institution
6 3 (1.53%) Advertising
6 3 (1.53%) Telecoms
7 2 (1.02%) Automotive
7 2 (1.02%) Manufacturing
Job Titles
1 104 (53.06%) Developer
2 37 (18.88%) Architect
3 35 (17.86%) SQL Developer
4 24 (12.24%) Analyst
5 23 (11.73%) Salesforce Developer
5 23 (11.73%) Senior Developer
6 21 (10.71%) Business Intelligence Developer
7 20 (10.20%) Salesforce Architect
8 16 (8.16%) Data Warehouse Developer
8 16 (8.16%) Senior Salesforce Developer
9 15 (7.65%) Senior Architect
9 15 (7.65%) Senior Salesforce Architect
9 15 (7.65%) Test Analyst
10 13 (6.63%) Consultant
11 12 (6.12%) Data Engineer
12 10 (5.10%) Support Manager
13 8 (4.08%) SSRS Developer
14 7 (3.57%) Business Intelligence Consultant
14 7 (3.57%) Data Architect
14 7 (3.57%) Database Developer
Libraries, Frameworks & Software Standards
1 24 (12.24%) Visualforce
2 17 (8.67%) .NET
3 12 (6.12%) Kafka
4 8 (4.08%) Web Services
5 7 (3.57%) MDX
6 6 (3.06%) AngularJS
6 6 (3.06%) HTML
6 6 (3.06%) HTML5
6 6 (3.06%) JMS
6 6 (3.06%) jQuery
6 6 (3.06%) Node.js
6 6 (3.06%) RabbitMQ
6 6 (3.06%) Twitter Bootstrap
7 4 (2.04%) FIX Protocol
7 4 (2.04%) RESTful
8 3 (1.53%) .NET Framework
8 3 (1.53%) EDI
8 3 (1.53%) Natural Language Processing
9 2 (1.02%) Entity Framework
9 2 (1.02%) Play Framework
Miscellaneous
1 32 (16.33%) Analytical Skills
1 32 (16.33%) Computer Science
2 22 (11.22%) Management Information System
3 10 (5.10%) Client/Server
3 10 (5.10%) Data Centre
4 9 (4.59%) Fintech
5 8 (4.08%) Self-Motivation
6 6 (3.06%) Data Structures
7 5 (2.55%) Algorithms
8 3 (1.53%) AS400
8 3 (1.53%) Enterprise Software
8 3 (1.53%) iSeries
9 2 (1.02%) Replication
9 2 (1.02%) User Experience
10 1 (0.51%) Analytical Mindset
10 1 (0.51%) Driving Licence
10 1 (0.51%) EPoS
10 1 (0.51%) Mobile App
Operating Systems
1 12 (6.12%) Unix
2 8 (4.08%) Windows
3 6 (3.06%) Windows Server
4 5 (2.55%) Linux
Processes & Methodologies
1 93 (47.45%) Business Intelligence
2 45 (22.96%) Analytics
3 39 (19.90%) Migration
4 36 (18.37%) Agile Software Development
5 29 (14.80%) Data Modelling
6 25 (12.76%) Data Management
7 20 (10.20%) Data Migration
8 18 (9.18%) ERP
8 18 (9.18%) Kimball Methodology
9 17 (8.67%) Visualisation
10 16 (8.16%) Dimensional Modelling
10 16 (8.16%) Problem-Solving
11 14 (7.14%) Data Visualisation
12 13 (6.63%) Data Architecture
12 13 (6.63%) Decision-Making
12 13 (6.63%) Mentoring
12 13 (6.63%) Performance Tuning
13 12 (6.12%) Data Development
13 12 (6.12%) Stakeholder Management
13 12 (6.12%) TOGAF
Programming Languages
1 121 (61.73%) SQL
2 48 (24.49%) T-SQL
3 24 (12.24%) Apex Code
4 22 (11.22%) Java
5 13 (6.63%) C#
5 13 (6.63%) Python
6 8 (4.08%) PL/SQL
7 7 (3.57%) R
8 6 (3.06%) JavaScript
8 6 (3.06%) PowerShell
9 5 (2.55%) Scala
10 4 (2.04%) U-SQL
11 3 (1.53%) RPG
11 3 (1.53%) RPG IV
11 3 (1.53%) VB.NET
12 2 (1.02%) C++
12 2 (1.02%) COBOL
12 2 (1.02%) Delphi
12 2 (1.02%) Shell Script
13 1 (0.51%) VBA
Qualifications
1 20 (10.20%) Degree
2 9 (4.59%) Computer Science Degree
3 7 (3.57%) ISEB
4 3 (1.53%) Numerate Degree
5 2 (1.02%) CIPD
5 2 (1.02%) Microsoft Certification
5 2 (1.02%) PhD
5 2 (1.02%) Security Cleared
6 1 (0.51%) ISTQB
6 1 (0.51%) MCDBA
6 1 (0.51%) MCITP
6 1 (0.51%) MCP
6 1 (0.51%) MCSA
6 1 (0.51%) MCSD
Quality Assurance & Compliance
1 23 (11.73%) QA
2 10 (5.10%) Sarbanes-Oxley
3 6 (3.06%) Data Quality
4 1 (0.51%) COBIT
System Software
1 6 (3.06%) Docker
2 4 (2.04%) Virtual Machines
3 2 (1.02%) Apache ZooKeeper
3 2 (1.02%) HDFS
Systems Management
1 7 (3.57%) Systems Management Server (SMS)
2 2 (1.02%) Hadoop YARN
Vendors
1 53 (27.04%) Microsoft
2 34 (17.35%) Oracle
3 29 (14.80%) Tableau
4 25 (12.76%) Salesforce.com
5 20 (10.20%) Informatica
6 11 (5.61%) Talend
7 10 (5.10%) Hyperion
7 10 (5.10%) PeopleSoft
8 9 (4.59%) Cognos
9 7 (3.57%) Cloudera
9 7 (3.57%) Vertica
10 6 (3.06%) Greenplum
10 6 (3.06%) Teradata
10 6 (3.06%) Xamarin
11 5 (2.55%) Netezza
11 5 (2.55%) SAP
12 4 (2.04%) TIBCO
13 3 (1.53%) JD Edwards
14 2 (1.02%) IBM
14 2 (1.02%) Sybase