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

Extract, Transform and Load (ETL)
England > West Midlands
6 months to
21 Sep 2018
Same period 2017 Same period 2016
Rank 151 152 161
Rank change year-on-year +1 +9 -15
Permanent jobs citing ETL 170 193 219
As % of all permanent IT jobs advertised in the West Midlands 1.93% 1.94% 1.83%
As % of the Processes & Methodologies category 2.14% 2.12% 2.02%
Number of salaries quoted 141 175 151
West Midlands median annual salary £45,000 £40,000 £42,500
Median salary % change year-on-year +12.50% -5.88% -
10th Percentile £32,500 £28,750 £32,500
90th Percentile £71,250 £63,250 £60,000
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 7,928 9,108 10,820
As % of all permanent IT jobs advertised in the West Midlands 90.22% 91.32% 90.45%
Number of salaries quoted 6,069 7,481 8,477
West Midlands median annual salary £44,000 £40,000 £40,000
Median salary % change year-on-year +10.00% - -
10th Percentile £25,750 £25,750 £24,000
90th Percentile £67,500 £63,750 £65,000
England median annual salary £50,000 £50,000 £50,000

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 21 September 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 21 September 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 +4 74 £43,750 +6.06% 8
Staffordshire +50 40 £45,000 +28.57% 10
Warwickshire -10 17 £66,250 +76.67%
Shropshire - 9 - - 1
Wolverhampton - 8 £40,000 -
Walsall +1 4 £43,750 +32.58% 3
Worcestershire +12 3 £36,207 -7.75%
Solihull -9 3 £43,500 +8.75%
Coventry -3 2 £25,000 -43.18%
ETL
England

For the 6 months to 21 September 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 112 (65.88%) SQL
2 90 (52.94%) SQL Server Reporting Services
3 89 (52.35%) Business Intelligence
3 89 (52.35%) SQL Server
4 83 (48.82%) SQL Server Integration Services
5 64 (37.65%) T-SQL
6 58 (34.12%) Data Warehouse
7 48 (28.24%) Analytics
8 46 (27.06%) SQL Server Analysis Services
9 42 (24.71%) Power BI
10 40 (23.53%) Microsoft Azure
11 39 (22.94%) Finance
11 39 (22.94%) Microsoft
12 35 (20.59%) Tableau
13 34 (20.00%) Migration
14 28 (16.47%) Agile Software Development
15 25 (14.71%) Data Modelling
16 23 (13.53%) Oracle
16 23 (13.53%) Management Information System
16 23 (13.53%) SQL Server 2012
17 22 (12.94%) Data Development
17 22 (12.94%) Visualisation
18 21 (12.35%) Data Management
18 21 (12.35%) Informatica
18 21 (12.35%) Big Data
19 20 (11.76%) Kimball Methodology
20 19 (11.18%) Cognos
20 19 (11.18%) Microsoft Excel
21 18 (10.59%) Hadoop
21 18 (10.59%) Data Visualisation

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 15 (8.82%) Apache
2 9 (5.29%) Apache Spark
3 3 (1.76%) IIS
4 1 (0.59%) Apache Pig
4 1 (0.59%) Elasticsearch
4 1 (0.59%) SAS
Applications
1 19 (11.18%) Microsoft Excel
2 4 (2.35%) Microsoft Office
2 4 (2.35%) Microsoft PowerPoint
3 3 (1.76%) MS Visio
Business Applications
1 10 (5.88%) HFM
2 5 (2.94%) Hyperion Planning
3 1 (0.59%) Dynamics AX
3 1 (0.59%) Dynamics CRM
3 1 (0.59%) SAP S/4HANA
Cloud Services
1 40 (23.53%) Microsoft Azure
2 14 (8.24%) PaaS
3 8 (4.71%) SaaS
4 6 (3.53%) IaaS
5 5 (2.94%) Cloud Computing
5 5 (2.94%) Force.com
6 4 (2.35%) Amazon AWS
7 1 (0.59%) AWS Lambda
7 1 (0.59%) Dynamics 365
7 1 (0.59%) Google Cloud Platform
7 1 (0.59%) Serverless
Communications & Networking
1 1 (0.59%) DAB
1 1 (0.59%) SMS
Database & Business Intelligence
1 90 (52.94%) SQL Server Reporting Services
2 89 (52.35%) SQL Server
3 83 (48.82%) SQL Server Integration Services
4 58 (34.12%) Data Warehouse
5 46 (27.06%) SQL Server Analysis Services
6 42 (24.71%) Power BI
7 23 (13.53%) SQL Server 2012
8 21 (12.35%) Big Data
9 18 (10.59%) Hadoop
10 17 (10.00%) QlikView
11 12 (7.06%) Qlik Sense
12 11 (6.47%) BusinessObjects
12 11 (6.47%) Enterprise Data Warehouse
12 11 (6.47%) Spotfire
13 10 (5.88%) Essbase
14 9 (5.29%) SQL Server 2000
15 8 (4.71%) Blockchain
16 7 (4.12%) Relational Database
17 6 (3.53%) SQL Server 2008
17 6 (3.53%) SQL Server 2016
Development Applications
1 8 (4.71%) SQL Server Management Studio (SSMS)
2 6 (3.53%) Git (software)
2 6 (3.53%) Jenkins
3 5 (2.94%) Team Foundation Server
4 2 (1.18%) Visual Studio
5 1 (0.59%) Bitbucket
5 1 (0.59%) JUnit
5 1 (0.59%) Maven
5 1 (0.59%) TestNG
5 1 (0.59%) Visual Studio Team System
General
1 39 (22.94%) Finance
2 11 (6.47%) Games
3 8 (4.71%) Advertising
4 6 (3.53%) Legal
5 4 (2.35%) Automotive
5 4 (2.35%) Local Government
6 2 (1.18%) Retail
7 1 (0.59%) Financial Institution
7 1 (0.59%) Manufacturing
Job Titles
1 91 (53.53%) Developer
2 46 (27.06%) SQL Developer
3 30 (17.65%) Business Intelligence Developer
4 24 (14.12%) Analyst
5 21 (12.35%) Architect
6 17 (10.00%) DBA
6 17 (10.00%) SQL DBA
7 13 (7.65%) SQL BI Developer
7 13 (7.65%) SSRS Developer
8 12 (7.06%) Senior Developer
8 12 (7.06%) SQL Server Developer
9 11 (6.47%) SQL Server DBA
10 10 (5.88%) Support Manager
10 10 (5.88%) Test Analyst
11 9 (5.29%) Data Engineer
11 9 (5.29%) Database Developer
11 9 (5.29%) Solutions Architect
12 8 (4.71%) Data Warehouse Developer
13 7 (4.12%) Business Developer
13 7 (4.12%) Business Intelligence Analyst
Libraries, Frameworks & Software Standards
1 16 (9.41%) .NET
2 9 (5.29%) HTML
2 9 (5.29%) HTML5
3 8 (4.71%) AngularJS
3 8 (4.71%) jQuery
3 8 (4.71%) Node.js
3 8 (4.71%) Twitter Bootstrap
4 7 (4.12%) Visualforce
5 5 (2.94%) Kafka
5 5 (2.94%) Web Services
6 3 (1.76%) .NET Framework
6 3 (1.76%) Entity Framework
7 2 (1.18%) MDX
7 2 (1.18%) Natural Language Processing
8 1 (0.59%) Akka
8 1 (0.59%) CSS
8 1 (0.59%) CSS3
8 1 (0.59%) J2EE
8 1 (0.59%) Lucene
8 1 (0.59%) Play Framework
Miscellaneous
1 23 (13.53%) Management Information System
2 18 (10.59%) Analytical Skills
3 13 (7.65%) Computer Science
4 10 (5.88%) Client/Server
4 10 (5.88%) Data Centre
5 7 (4.12%) Fintech
6 4 (2.35%) Enterprise Software
7 3 (1.76%) Replication
7 3 (1.76%) Self-Motivation
8 2 (1.18%) Algorithms
8 2 (1.18%) AS400
9 1 (0.59%) Credit Risk
9 1 (0.59%) Greenfield Project
9 1 (0.59%) Mobile App
9 1 (0.59%) User Experience
Operating Systems
1 13 (7.65%) Unix
2 3 (1.76%) Linux
3 2 (1.18%) Windows
3 2 (1.18%) Windows Server
Processes & Methodologies
1 89 (52.35%) Business Intelligence
2 48 (28.24%) Analytics
3 34 (20.00%) Migration
4 28 (16.47%) Agile Software Development
5 25 (14.71%) Data Modelling
6 22 (12.94%) Data Development
6 22 (12.94%) Visualisation
7 21 (12.35%) Data Management
8 20 (11.76%) Kimball Methodology
9 18 (10.59%) Data Visualisation
10 17 (10.00%) Data Security
11 16 (9.41%) Data Migration
12 15 (8.82%) Project Management
12 15 (8.82%) TOGAF
13 14 (8.24%) ETL Development
14 13 (7.65%) Performance Tuning
14 13 (7.65%) Test Automation
15 12 (7.06%) Capacity Management
15 12 (7.06%) Code Optimisation
16 11 (6.47%) SDLC
Programming Languages
1 112 (65.88%) SQL
2 64 (37.65%) T-SQL
3 13 (7.65%) Java
4 9 (5.29%) Python
5 8 (4.71%) JavaScript
6 7 (4.12%) Apex Code
6 7 (4.12%) R
7 5 (2.94%) PL/SQL
8 4 (2.35%) VBA
9 3 (1.76%) C#
9 3 (1.76%) PowerShell
9 3 (1.76%) Scala
10 2 (1.18%) Delphi
10 2 (1.18%) Shell Script
11 1 (0.59%) ANSI SQL
11 1 (0.59%) C++
11 1 (0.59%) Ruby
Qualifications
1 15 (8.82%) Degree
2 8 (4.71%) Computer Science Degree
3 4 (2.35%) Master's Degree
4 3 (1.76%) ISEB
5 2 (1.18%) CIPD
6 1 (0.59%) ISEB Practitioner
6 1 (0.59%) PhD
Quality Assurance & Compliance
1 14 (8.24%) QA
2 10 (5.88%) Sarbanes-Oxley
3 4 (2.35%) Data Quality
4 3 (1.76%) GDPR
5 2 (1.18%) Cyber Essentials
6 1 (0.59%) COBIT
System Software
1 8 (4.71%) Docker
2 1 (0.59%) Apache ZooKeeper
2 1 (0.59%) HDFS
Systems Management
1 6 (3.53%) Systems Management Server (SMS)
2 1 (0.59%) Hadoop YARN
Vendors
1 39 (22.94%) Microsoft
2 35 (20.59%) Tableau
3 23 (13.53%) Oracle
4 21 (12.35%) Informatica
5 19 (11.18%) Cognos
6 14 (8.24%) Alteryx
7 10 (5.88%) Hyperion
7 10 (5.88%) PeopleSoft
8 9 (5.29%) Talend
9 8 (4.71%) Salesforce.com
9 8 (4.71%) Xamarin
10 7 (4.12%) SAP
11 5 (2.94%) Cloudera
12 4 (2.35%) MicroStrategy
13 3 (1.76%) Greenplum
13 3 (1.76%) IBM
13 3 (1.76%) Logi Analytics
13 3 (1.76%) Sybase
13 3 (1.76%) Teradata
13 3 (1.76%) Vertica