Period
to 17 November 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 17 November 2018 with a comparison to the same period in the previous 2 years.

Extract, Transform and Load (ETL)
England > West Midlands
6 months to
17 Nov 2018
Same period 2017 Same period 2016
Rank 137 135 188
Rank change year-on-year -2 +53 -49
Permanent jobs citing ETL 174 222 171
As % of all permanent IT jobs advertised in the West Midlands 2.06% 2.18% 1.48%
As % of the Processes & Methodologies category 2.27% 2.40% 1.63%
Number of salaries quoted 148 190 112
West Midlands median annual salary £45,000 £45,000 £41,248
Median salary % change year-on-year - +9.10% -0.01%
10th Percentile £32,500 £29,000 £32,500
90th Percentile £69,125 £67,525 £55,000
England median annual salary £55,000 £50,000 £52,500
% change year-on-year +10.00% -4.76% -

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 7,661 9,264 10,486
As % of all permanent IT jobs advertised in the West Midlands 90.78% 91.00% 90.68%
Number of salaries quoted 5,814 7,536 8,217
West Midlands median annual salary £45,000 £40,000 £40,000
Median salary % change year-on-year +12.50% - -
10th Percentile £26,000 £25,000 £25,000
90th Percentile £70,000 £65,000 £63,750
England median annual salary £52,500 £50,000 £50,000
% change year-on-year +5.00% - +5.26%

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 17 November 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 17 November 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 -16 82 £45,000 -21.74% 16
Staffordshire +61 48 £45,000 +20.00% 15
Warwickshire +11 16 £60,000 +60.00% 4
Wolverhampton +12 8 £40,000 +26.98% 1
Walsall -6 4 £43,750 +45.83% 2
Shropshire - 4 - - 1
Solihull -4 3 £43,500 -11.22%
Worcestershire - 3 £36,207 -
Coventry -25 1 £47,500 +5.56% 1
ETL
England

For the 6 months to 17 November 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 131 (75.29%) SQL
2 99 (56.90%) SQL Server
3 97 (55.75%) Business Intelligence
4 94 (54.02%) SQL Server Reporting Services
5 93 (53.45%) SQL Server Integration Services
6 66 (37.93%) T-SQL
7 65 (37.36%) Data Warehouse
8 60 (34.48%) Power BI
9 55 (31.61%) Tableau
9 55 (31.61%) Analytics
10 52 (29.89%) Microsoft Azure
11 46 (26.44%) Microsoft
12 44 (25.29%) SQL Server Analysis Services
13 37 (21.26%) Finance
14 35 (20.11%) Data Modelling
15 34 (19.54%) Agile Software Development
16 33 (18.97%) Management Information System
17 28 (16.09%) Cognos
17 28 (16.09%) Analytical Skills
18 26 (14.94%) Oracle
19 23 (13.22%) Data Security
19 23 (13.22%) Informatica
20 22 (12.64%) Java
20 22 (12.64%) Data Management
20 22 (12.64%) QlikView
20 22 (12.64%) Visualisation
21 21 (12.07%) Microsoft Excel
21 21 (12.07%) Alteryx
21 21 (12.07%) Data Development
22 20 (11.49%) .NET

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 9 (5.17%) Apache
2 4 (2.30%) Apache Spark
2 4 (2.30%) SharePoint
3 3 (1.72%) IIS
4 2 (1.15%) DNN
4 2 (1.15%) Oracle SOA Suite
4 2 (1.15%) Oracle Workflow
5 1 (0.57%) SAS
Applications
1 21 (12.07%) Microsoft Excel
2 4 (2.30%) Microsoft Office
2 4 (2.30%) Microsoft PowerPoint
3 3 (1.72%) MS Visio
Business Applications
1 6 (3.45%) HFM
2 3 (1.72%) Dynamics AX
2 3 (1.72%) Hyperion Planning
3 2 (1.15%) Carpe Diem
3 2 (1.15%) Elite 3E
3 2 (1.15%) NetSuite
4 1 (0.57%) Dynamics CRM
4 1 (0.57%) SAP S/4HANA
Cloud Services
1 52 (29.89%) Microsoft Azure
2 14 (8.05%) PaaS
3 7 (4.02%) Amazon AWS
3 7 (4.02%) IaaS
3 7 (4.02%) SaaS
4 6 (3.45%) Cloud Computing
5 3 (1.72%) Slack
5 3 (1.72%) Trello
6 2 (1.15%) Office 365
7 1 (0.57%) Azure Data Factory
7 1 (0.57%) Dynamics 365
7 1 (0.57%) Google Analytics
7 1 (0.57%) Google Cloud Platform
Communications & Networking
1 2 (1.15%) FTP
Database & Business Intelligence
1 99 (56.90%) SQL Server
2 94 (54.02%) SQL Server Reporting Services
3 93 (53.45%) SQL Server Integration Services
4 65 (37.36%) Data Warehouse
5 60 (34.48%) Power BI
6 44 (25.29%) SQL Server Analysis Services
7 22 (12.64%) QlikView
8 18 (10.34%) SQL Server 2012
9 15 (8.62%) Big Data
10 13 (7.47%) Qlik Sense
11 12 (6.90%) BusinessObjects
11 12 (6.90%) Hadoop
12 11 (6.32%) Enterprise Data Warehouse
12 11 (6.32%) Spotfire
13 9 (5.17%) Relational Database
14 7 (4.02%) Azure SQL Database
14 7 (4.02%) Blockchain
14 7 (4.02%) SQL Server 2014
14 7 (4.02%) SQL Server 2016
15 6 (3.45%) NoSQL
Development Applications
1 11 (6.32%) Team Foundation Server
2 9 (5.17%) SQL Server Management Studio (SSMS)
3 7 (4.02%) Visual Studio
4 5 (2.87%) Jenkins
5 3 (1.72%) JIRA
6 2 (1.15%) Git (software)
7 1 (0.57%) Visual Studio Team System
General
1 37 (21.26%) Finance
2 8 (4.60%) Advertising
3 7 (4.02%) Games
3 7 (4.02%) Telecoms
4 6 (3.45%) Legal
5 4 (2.30%) Automotive
5 4 (2.30%) Local Government
5 4 (2.30%) Retail
6 2 (1.15%) Digital Economy
6 2 (1.15%) Financial Institution
6 2 (1.15%) Manufacturing
Job Titles
1 110 (63.22%) Developer
2 59 (33.91%) SQL Developer
3 42 (24.14%) Business Intelligence Developer
4 21 (12.07%) Analyst
5 20 (11.49%) DBA
5 20 (11.49%) SQL DBA
6 18 (10.34%) SQL BI Developer
7 15 (8.62%) Architect
8 14 (8.05%) SQL Server Developer
8 14 (8.05%) SSRS Developer
9 13 (7.47%) SQL Server DBA
10 11 (6.32%) Business Developer
10 11 (6.32%) Data Warehouse Developer
11 10 (5.75%) Data Analyst
11 10 (5.75%) Integration Developer
11 10 (5.75%) SSIS Developer
12 9 (5.17%) RPG Developer
12 9 (5.17%) Senior Developer
12 9 (5.17%) SSAS Developer
13 8 (4.60%) Business Intelligence Analyst
Libraries, Frameworks & Software Standards
1 20 (11.49%) .NET
2 9 (5.17%) EDI
3 8 (4.60%) HTML
3 8 (4.60%) HTML5
4 7 (4.02%) AngularJS
4 7 (4.02%) jQuery
4 7 (4.02%) Middleware
4 7 (4.02%) Node.js
4 7 (4.02%) Twitter Bootstrap
5 5 (2.87%) .NET Framework
5 5 (2.87%) Entity Framework
5 5 (2.87%) MDX
6 3 (1.72%) Kafka
6 3 (1.72%) Web Services
7 1 (0.57%) CSS
7 1 (0.57%) CSS3
7 1 (0.57%) J2EE
7 1 (0.57%) Natural Language Processing
Miscellaneous
1 33 (18.97%) Management Information System
2 28 (16.09%) Analytical Skills
3 11 (6.32%) AS400
4 9 (5.17%) iSeries
5 7 (4.02%) Computer Science
5 7 (4.02%) Fintech
6 6 (3.45%) Client/Server
6 6 (3.45%) Data Centre
7 5 (2.87%) NHS
7 5 (2.87%) Replication
8 4 (2.30%) Greenfield Project
9 3 (1.72%) Enterprise Software
9 3 (1.72%) Self-Motivation
10 2 (1.15%) Taxonomies
11 1 (0.57%) Algorithms
11 1 (0.57%) Credit Risk
11 1 (0.57%) Data Structures
11 1 (0.57%) Mobile App
Operating Systems
1 11 (6.32%) Unix
2 5 (2.87%) Linux
Processes & Methodologies
1 97 (55.75%) Business Intelligence
2 55 (31.61%) Analytics
3 35 (20.11%) Data Modelling
4 34 (19.54%) Agile Software Development
5 23 (13.22%) Data Security
6 22 (12.64%) Data Management
6 22 (12.64%) Visualisation
7 21 (12.07%) Data Development
8 19 (10.92%) Data Analysis
8 19 (10.92%) Decision-Making
8 19 (10.92%) SDLC
9 18 (10.34%) Kimball Methodology
10 17 (9.77%) Migration
10 17 (9.77%) Performance Tuning
11 16 (9.20%) Data Visualisation
11 16 (9.20%) Project Management
11 16 (9.20%) Test Automation
12 15 (8.62%) Capacity Management
12 15 (8.62%) Code Optimisation
12 15 (8.62%) ERP
Programming Languages
1 131 (75.29%) SQL
2 66 (37.93%) T-SQL
3 22 (12.64%) Java
4 11 (6.32%) VB
5 9 (5.17%) RPG
5 9 (5.17%) RPG IV
6 8 (4.60%) JavaScript
6 8 (4.60%) PL/SQL
6 8 (4.60%) VBA
7 7 (4.02%) C#
8 6 (3.45%) Python
9 4 (2.30%) R
9 4 (2.30%) Shell Script
10 2 (1.15%) Delphi
11 1 (0.57%) ANSI SQL
11 1 (0.57%) C++
11 1 (0.57%) PowerShell
11 1 (0.57%) Scala
Qualifications
1 18 (10.34%) Degree
2 6 (3.45%) Computer Science Degree
3 5 (2.87%) Master's Degree
4 3 (1.72%) ISEB
5 1 (0.57%) ISEB Practitioner
Quality Assurance & Compliance
1 10 (5.75%) QA
2 9 (5.17%) Data Quality
3 6 (3.45%) Sarbanes-Oxley
4 5 (2.87%) GDPR
5 3 (1.72%) Cyber Essentials
System Software
1 7 (4.02%) Docker
Systems Management
1 5 (2.87%) Systems Management Server (SMS)
Vendors
1 55 (31.61%) Tableau
2 46 (26.44%) Microsoft
3 28 (16.09%) Cognos
4 26 (14.94%) Oracle
5 23 (13.22%) Informatica
6 21 (12.07%) Alteryx
7 9 (5.17%) JD Edwards
7 9 (5.17%) Talend
8 7 (4.02%) Xamarin
9 6 (3.45%) Greenplum
9 6 (3.45%) Hyperion
9 6 (3.45%) PeopleSoft
9 6 (3.45%) SAP
9 6 (3.45%) Teradata
10 5 (2.87%) IBM
11 4 (2.30%) MicroStrategy
12 3 (1.72%) Logi Analytics
12 3 (1.72%) Netezza
12 3 (1.72%) Sybase
12 3 (1.72%) Vertica