Period
to 18 November 2017

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

Extract, Transform and Load (ETL)
England > West Midlands
6 months to
18 Nov 2017
Same period 2016 Same period 2015
Rank 136 192 135
Rank change year-on-year +56 -57 -29
Permanent jobs citing ETL 222 168 218
As % of all permanent IT jobs advertised in the West Midlands 2.20% 1.46% 1.99%
As % of the Processes & Methodologies category 2.48% 1.63% 2.27%
Number of salaries quoted 190 109 200
West Midlands median annual salary £45,000 £41,000 £41,250
Median salary % change year-on-year +9.76% -0.61% -0.60%
10th Percentile £29,000 £32,500 £29,400
90th Percentile £67,525 £55,000 £77,500
England median annual salary £50,000 £52,500 £52,500
% change year-on-year -4.76% - +0.96%

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 8965 10288 9615
As % of all permanent IT jobs advertised in the West Midlands 88.95% 89.17% 87.63%
Number of salaries quoted 7269 8051 7937
West Midlands median annual salary £40,000 £40,000 £40,000
10th Percentile £25,500 £25,000 £24,750
90th Percentile £65,000 £63,750 £65,000
England median annual salary £50,000 £50,000 £47,500
% change year-on-year - +5.26% +5.56%

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 18 November 2017.

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 18 November 2017. 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 +69 100 £57,500 +39.69% 5
Warwickshire +15 44 £37,500 -6.25%
Coventry +24 39 £45,000 -5.26% 2
Solihull +4 10 £49,000 +42.03% 1
Staffordshire +4 8 £37,500 -4.46% 3
Halesowen - 6 £42,500 -
Walsall +6 5 £30,000 -18.92%
Wolverhampton +2 2 £31,500 -10.64%
ETL
England

For the 6 months to 18 November 2017, IT jobs citing ETL also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads across the West Midlands region with a requirement for ETL.

1 155 (69.82%) SQL
2 139 (62.61%) Business Intelligence
3 108 (48.65%) Data Warehouse
4 106 (47.75%) SQL Server
5 103 (46.40%) SQL Server Integration Services
6 66 (29.73%) SQL Server Reporting Services
7 62 (27.93%) Microsoft
8 51 (22.97%) SQL Server Analysis Services
9 50 (22.52%) Agile Software Development
10 49 (22.07%) T-SQL
11 46 (20.72%) Oracle
12 45 (20.27%) Finance
13 44 (19.82%) Analytics
14 43 (19.37%) BusinessObjects
15 41 (18.47%) Power BI
16 36 (16.22%) Microsoft Azure
17 35 (15.77%) Cognos
18 31 (13.96%) Data Modelling
19 30 (13.51%) SAP
20 28 (12.61%) QlikView
21 27 (12.16%) C#
21 27 (12.16%) SQL Server 2008
21 27 (12.16%) Tableau
22 26 (11.71%) IBM
23 25 (11.26%) .NET
23 25 (11.26%) Data Management
24 23 (10.36%) OLAP
24 23 (10.36%) XML
24 23 (10.36%) Scrum
25 22 (9.91%) Migration

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 7 (3.15%) SAS
2 6 (2.70%) Apache Spark
2 6 (2.70%) GlassFish
2 6 (2.70%) JBoss
2 6 (2.70%) Jetty
2 6 (2.70%) Tomcat
3 3 (1.35%) IIS
3 3 (1.35%) SharePoint
4 1 (0.45%) Apache
4 1 (0.45%) ArcGIS
4 1 (0.45%) Confluence
4 1 (0.45%) IBM Domino
4 1 (0.45%) WordPress
Applications
1 16 (7.21%) Microsoft Excel
2 12 (5.41%) SPSS
3 2 (0.90%) Microsoft Office
3 2 (0.90%) Microsoft PowerPoint
4 1 (0.45%) Spreadsheet
Business Applications
1 2 (0.90%) Dynamics AX
2 1 (0.45%) Cognos Business Intelligence
2 1 (0.45%) Cognos TM1
2 1 (0.45%) Dynamics CRM
2 1 (0.45%) Oracle Applications
Cloud Services
1 36 (16.22%) Microsoft Azure
2 17 (7.66%) Azure Data Factory
2 17 (7.66%) Force.com
3 12 (5.41%) Azure Machine Learning
4 7 (3.15%) Amazon AWS
5 3 (1.35%) IaaS
6 2 (0.90%) Office 365
6 2 (0.90%) SaaS
7 1 (0.45%) Cortana Intelligence Suite
7 1 (0.45%) Dynamics 365
7 1 (0.45%) PaaS
Communications & Networking
1 6 (2.70%) AMQP
2 1 (0.45%) SMS
Database & Business Intelligence
1 108 (48.65%) Data Warehouse
2 106 (47.75%) SQL Server
3 103 (46.40%) SQL Server Integration Services
4 66 (29.73%) SQL Server Reporting Services
5 51 (22.97%) SQL Server Analysis Services
6 43 (19.37%) BusinessObjects
7 41 (18.47%) Power BI
8 28 (12.61%) QlikView
9 27 (12.16%) SQL Server 2008
10 23 (10.36%) OLAP
11 19 (8.56%) DataStage
11 19 (8.56%) Relational Database
11 19 (8.56%) SAP Data Services
12 18 (8.11%) MySQL
13 16 (7.21%) Big Data
13 16 (7.21%) NoSQL
14 12 (5.41%) Hadoop
14 12 (5.41%) SQL Server 2014
15 10 (4.50%) IBM InfoSphere
16 9 (4.05%) SQL Server 2016
Development Applications
1 12 (5.41%) Team Foundation Server
2 10 (4.50%) Visual Studio
3 7 (3.15%) Jenkins
4 6 (2.70%) Hudson
4 6 (2.70%) Talend Open Studio
5 5 (2.25%) Git (software)
5 5 (2.25%) Selenium
6 2 (0.90%) JIRA
6 2 (0.90%) Oracle APEX
7 1 (0.45%) Eclipse
7 1 (0.45%) ERwin
7 1 (0.45%) Maven
7 1 (0.45%) SQL Server Management Studio (SSMS)
General
1 45 (20.27%) Finance
2 20 (9.01%) Retail
3 10 (4.50%) Legal
4 6 (2.70%) Billing
5 5 (2.25%) Games
5 5 (2.25%) Marketing
6 3 (1.35%) Advertising
7 2 (0.90%) Automotive
7 2 (0.90%) Telecoms
8 1 (0.45%) Banking
Job Titles
1 108 (48.65%) Developer
2 42 (18.92%) Analyst
3 35 (15.77%) Business Intelligence Developer
4 30 (13.51%) Consultant
5 29 (13.06%) Architect
6 28 (12.61%) SQL Developer
7 24 (10.81%) Senior Developer
8 16 (7.21%) Business Consultant
8 16 (7.21%) Salesforce Architect
8 16 (7.21%) Salesforce Developer
9 15 (6.76%) Data Analyst
9 15 (6.76%) Senior Salesforce Developer
10 14 (6.31%) Senior Architect
10 14 (6.31%) Senior Salesforce Architect
11 13 (5.86%) SAP Developer
12 12 (5.41%) Business Intelligence Consultant
13 10 (4.50%) ETL Developer
13 10 (4.50%) Junior
13 10 (4.50%) SQL BI Developer
14 9 (4.05%) Business Intelligence Analyst
Libraries, Frameworks & Software Standards
1 25 (11.26%) .NET
2 23 (10.36%) XML
3 19 (8.56%) MDX
3 19 (8.56%) Visualforce
4 15 (6.76%) Web Services
5 11 (4.95%) REST
6 9 (4.05%) HTML
6 9 (4.05%) RESTful
7 8 (3.60%) CSS
7 8 (3.60%) Spring
8 7 (3.15%) JMS
8 7 (3.15%) JSON
8 7 (3.15%) SOAP
9 6 (2.70%) Java EE
9 6 (2.70%) JAX-RS
9 6 (2.70%) JPA
9 6 (2.70%) RESTEasy
9 6 (2.70%) Spring Boot
10 5 (2.25%) XSLT
11 4 (1.80%) XSD
Miscellaneous
1 22 (9.91%) Analytical Skills
2 19 (8.56%) Computer Science
3 14 (6.31%) Virtual Team
4 7 (3.15%) iPad
4 7 (3.15%) Management Information System
5 6 (2.70%) Enterprise Software
5 6 (2.70%) Smart Meter
6 5 (2.25%) Algorithms
6 5 (2.25%) BBC
7 4 (1.80%) Data Structures
8 2 (0.90%) Blog
8 2 (0.90%) Replication
9 1 (0.45%) Clustering
9 1 (0.45%) Fintech
9 1 (0.45%) FMCG
9 1 (0.45%) Greenfield Project
9 1 (0.45%) iSeries
Operating Systems
1 6 (2.70%) Unix
2 1 (0.45%) Windows
Processes & Methodologies
1 139 (62.61%) Business Intelligence
2 50 (22.52%) Agile Software Development
3 44 (19.82%) Analytics
4 31 (13.96%) Data Modelling
5 25 (11.26%) Data Management
6 23 (10.36%) Scrum
7 22 (9.91%) Migration
8 21 (9.46%) Mentoring
8 21 (9.46%) Visualisation
9 20 (9.01%) Data Analysis
10 17 (7.66%) Kimball Methodology
11 16 (7.21%) Unit Testing
12 15 (6.76%) Data Migration
12 15 (6.76%) ETL Development
12 15 (6.76%) Performance Tuning
13 14 (6.31%) Continuous Integration
14 13 (5.86%) Coaching
14 13 (5.86%) Machine Learning
14 13 (5.86%) Software Engineering
15 12 (5.41%) Data Visualisation
Programming Languages
1 155 (69.82%) SQL
2 49 (22.07%) T-SQL
3 27 (12.16%) C#
4 19 (8.56%) Apex Code
4 19 (8.56%) Java
5 11 (4.95%) JavaScript
6 10 (4.50%) Data Analysis Expressions (DAX)
7 7 (3.15%) PL/SQL
8 6 (2.70%) Clojure
8 6 (2.70%) Scala
8 6 (2.70%) VBA
9 5 (2.25%) XPath
10 4 (1.80%) SPARQL
10 4 (1.80%) XQuery
11 3 (1.35%) PHP
11 3 (1.35%) Python
11 3 (1.35%) R
12 2 (0.90%) VB.NET
13 1 (0.45%) RPG
13 1 (0.45%) SOQL
Qualifications
1 10 (4.50%) Degree
2 7 (3.15%) Security Cleared
3 4 (1.80%) Microsoft Certification
4 3 (1.35%) Computer Science Degree
5 2 (0.90%) MCSD
5 2 (0.90%) MCTS
6 1 (0.45%) ISTQB
6 1 (0.45%) Master's Degree
6 1 (0.45%) SC Cleared
Quality Assurance & Compliance
1 19 (8.56%) Data Quality
2 10 (4.50%) QA
3 2 (0.90%) ISO/IEC 27001
4 1 (0.45%) SLA
System Software
1 6 (2.70%) Docker
Systems Management
1 6 (2.70%) Marathon
2 5 (2.25%) Oozie
3 1 (0.45%) Opscode Chef
3 1 (0.45%) Puppet
3 1 (0.45%) Terraform
Vendors
1 62 (27.93%) Microsoft
2 46 (20.72%) Oracle
3 35 (15.77%) Cognos
4 30 (13.51%) SAP
5 27 (12.16%) Tableau
6 26 (11.71%) IBM
7 20 (9.01%) Informatica
8 19 (8.56%) Salesforce.com
9 7 (3.15%) Netezza
10 6 (2.70%) Talend
11 4 (1.80%) Jitterbit
12 3 (1.35%) Ab Initio
12 3 (1.35%) Civica
12 3 (1.35%) Zoomdata
13 2 (0.90%) Guidewire
13 2 (0.90%) JD Edwards
13 2 (0.90%) Sybase
14 1 (0.45%) Birst
14 1 (0.45%) Capita
14 1 (0.45%) Jedox