Period
to 20 January 2019

The following table provides summary statistics for permanent job vacancies advertised in the 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 January 2019 with a comparison to the same period in the previous 2 years.

Extract, Transform and Load (ETL)
England > Midlands
6 months to
20 Jan 2019
Same period 2018 Same period 2017
Rank 158 140 176
Rank change year-on-year -18 +36 -68
Permanent jobs citing ETL 245 331 285
As % of all permanent IT jobs advertised in the Midlands 2.06% 2.22% 1.71%
As % of the Processes & Methodologies category 2.24% 2.44% 1.87%
Number of salaries quoted 187 273 240
Midlands median annual salary £47,500 £45,000 £42,500
Median salary % change year-on-year +5.56% +5.88% -
10th Percentile £34,500 £29,200 £32,500
90th Percentile £71,250 £71,000 £55,000
England median annual salary £55,000 £50,000 £52,500
% change year-on-year +10.00% -4.76% +2.94%

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 Midlands with a requirement for process or methodology skills.

All Process and Methodology Skills
Midlands
Permanent vacancies with a requirement for process or methodology skills 10,935 13,574 15,253
As % of all permanent IT jobs advertised in the Midlands 91.94% 90.93% 91.49%
Number of salaries quoted 8,107 10,950 12,010
Midlands median annual salary £44,000 £40,000 £42,500
Median salary % change year-on-year +10.00% -5.88% +6.25%
10th Percentile £26,250 £25,000 £25,500
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 Midlands

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

Job vacancy trend for ETL in the Midlands

ETL
Salary Trend in the Midlands

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

Salary trend for ETL in the Midlands

ETL
Salary Histogram in the Midlands

The salary distribution of IT jobs citing ETL in the Midlands over the 6 months to 20 January 2019.

Salary histogram for ETL in the Midlands

ETL
Job Locations in the Midlands

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing ETL within the Midlands region over the 6 months to 20 January 2019. 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
West Midlands -24 154 £47,500 -3.06% 33
East Midlands +29 90 £45,000 +12.50% 13
ETL
England

For the 6 months to 20 January 2019, 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 Midlands region with a requirement for ETL.

1 176 (71.84%) SQL
2 156 (63.67%) Business Intelligence
3 144 (58.78%) SQL Server
4 136 (55.51%) SQL Server Integration Services
5 131 (53.47%) SQL Server Reporting Services
6 110 (44.90%) Data Warehouse
7 102 (41.63%) Microsoft
8 97 (39.59%) Tableau
9 96 (39.18%) Power BI
10 90 (36.73%) T-SQL
11 85 (34.69%) SQL Server Analysis Services
12 72 (29.39%) Agile Software Development
13 67 (27.35%) Visualisation
14 60 (24.49%) Analytical Skills
15 59 (24.08%) Analytics
16 56 (22.86%) Microsoft Azure
17 47 (19.18%) MDX
17 47 (19.18%) Finance
18 46 (18.78%) Data Modelling
19 43 (17.55%) Hadoop
20 41 (16.73%) Big Data
21 39 (15.92%) Microsoft Analysis Services
22 38 (15.51%) Cognos
23 37 (15.10%) Retail
24 35 (14.29%) SAS
24 35 (14.29%) Team Foundation Server
25 32 (13.06%) SQL Server 2012
25 32 (13.06%) Data Analysis Expressions (DAX)
26 30 (12.24%) Relational Database
26 30 (12.24%) Marketing

ETL
Co-occurring IT Skills in the 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 35 (14.29%) SAS
2 14 (5.71%) SharePoint
3 7 (2.86%) Apache Spark
4 5 (2.04%) Apache
5 3 (1.22%) Oracle SOA Suite
6 2 (0.82%) DNN
6 2 (0.82%) Oracle Workflow
7 1 (0.41%) Apache Pig
Applications
1 15 (6.12%) Microsoft Excel
2 4 (1.63%) Microsoft PowerPoint
3 2 (0.82%) MS Visio
4 1 (0.41%) ArchiCAD
4 1 (0.41%) AutoCAD
4 1 (0.41%) Microsoft Office
4 1 (0.41%) MicroStation
4 1 (0.41%) Revit
Business Applications
1 13 (5.31%) Dynamics AX
2 6 (2.45%) NetSuite
3 3 (1.22%) Carpe Diem
3 3 (1.22%) Elite 3E
4 2 (0.82%) Cognos Business Intelligence
5 1 (0.41%) Dynamics CRM
Cloud Services
1 56 (22.86%) Microsoft Azure
2 14 (5.71%) Amazon AWS
3 11 (4.49%) PaaS
4 5 (2.04%) Azure Data Factory
4 5 (2.04%) IaaS
4 5 (2.04%) SaaS
5 4 (1.63%) Cloud Computing
6 3 (1.22%) Boomi
6 3 (1.22%) Office 365
6 3 (1.22%) Slack
6 3 (1.22%) Trello
7 2 (0.82%) Dynamics 365
8 1 (0.41%) Google Analytics
8 1 (0.41%) Google Cloud Platform
Communications & Networking
1 2 (0.82%) FTP
2 1 (0.41%) Internet
Database & Business Intelligence
1 144 (58.78%) SQL Server
2 136 (55.51%) SQL Server Integration Services
3 131 (53.47%) SQL Server Reporting Services
4 110 (44.90%) Data Warehouse
5 96 (39.18%) Power BI
6 85 (34.69%) SQL Server Analysis Services
7 43 (17.55%) Hadoop
8 41 (16.73%) Big Data
9 39 (15.92%) Microsoft Analysis Services
10 32 (13.06%) SQL Server 2012
11 30 (12.24%) Relational Database
12 24 (9.80%) QlikView
13 21 (8.57%) SAS EBI
14 20 (8.16%) OLAP
15 16 (6.53%) BusinessObjects
16 13 (5.31%) Qlik Sense
17 11 (4.49%) Enterprise Data Warehouse
17 11 (4.49%) OLAP Cube
18 9 (3.67%) NoSQL
19 8 (3.27%) Azure SQL Database
Development Applications
1 35 (14.29%) Team Foundation Server
2 27 (11.02%) Visual Studio
3 4 (1.63%) Jenkins
3 4 (1.63%) JIRA
3 4 (1.63%) SQL Server Management Studio (SSMS)
4 1 (0.41%) Artifactory
4 1 (0.41%) Bitbucket
4 1 (0.41%) Gatling
4 1 (0.41%) Git (software)
4 1 (0.41%) JMeter
4 1 (0.41%) Maven
4 1 (0.41%) Selenium
General
1 47 (19.18%) Finance
2 37 (15.10%) Retail
3 30 (12.24%) Marketing
4 10 (4.08%) Manufacturing
5 8 (3.27%) Telecoms
6 5 (2.04%) Advertising
6 5 (2.04%) Banking
7 4 (1.63%) Local Government
8 3 (1.22%) Legal
9 2 (0.82%) Automotive
9 2 (0.82%) Digital Economy
9 2 (0.82%) Financial Institution
9 2 (0.82%) Front Office
10 1 (0.41%) Law
Job Titles
1 148 (60.41%) Developer
2 77 (31.43%) Business Intelligence Developer
3 53 (21.63%) SQL Developer
4 38 (15.51%) Senior Developer
5 36 (14.69%) Architect
5 36 (14.69%) Senior Business Intelligence Developer
6 29 (11.84%) Analyst
7 24 (9.80%) Lead Developer
8 20 (8.16%) Data Architect
9 19 (7.76%) Business Intelligence Lead
10 18 (7.35%) DBA
10 18 (7.35%) SQL DBA
10 18 (7.35%) SSIS Developer
11 17 (6.94%) SQL BI Developer
12 16 (6.53%) SSRS Developer
13 14 (5.71%) Business Developer
13 14 (5.71%) SSAS Developer
14 13 (5.31%) Business Intelligence Analyst
14 13 (5.31%) Data Analyst
14 13 (5.31%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 47 (19.18%) MDX
2 28 (11.43%) .NET
3 14 (5.71%) Middleware
4 9 (3.67%) EDI
5 7 (2.86%) HTML
6 6 (2.45%) HTML5
6 6 (2.45%) Kafka
7 5 (2.04%) AngularJS
7 5 (2.04%) jQuery
7 5 (2.04%) Node.js
7 5 (2.04%) Twitter Bootstrap
7 5 (2.04%) Web Services
8 4 (1.63%) .NET Framework
8 4 (1.63%) Entity Framework
8 4 (1.63%) XML
9 3 (1.22%) ASP.NET
10 2 (0.82%) CSS
11 1 (0.41%) CSS3
11 1 (0.41%) J2EE
11 1 (0.41%) RESTful
Miscellaneous
1 60 (24.49%) Analytical Skills
2 25 (10.20%) Management Information System
3 11 (4.49%) AS400
4 9 (3.67%) iSeries
5 7 (2.86%) Greenfield Project
6 6 (2.45%) NHS
7 4 (1.63%) Credit Risk
7 4 (1.63%) Fintech
7 4 (1.63%) Replication
8 3 (1.22%) Data Structures
8 3 (1.22%) Self-Motivation
9 2 (0.82%) Private Cloud
9 2 (0.82%) Taxonomies
Operating Systems
1 4 (1.63%) Linux
1 4 (1.63%) Unix
Processes & Methodologies
1 156 (63.67%) Business Intelligence
2 72 (29.39%) Agile Software Development
3 67 (27.35%) Visualisation
4 59 (24.08%) Analytics
5 46 (18.78%) Data Modelling
6 28 (11.43%) Data Analysis
6 28 (11.43%) Dimensional Modelling
7 27 (11.02%) Scrum
8 25 (10.20%) Data Security
9 24 (9.80%) ETL Development
10 23 (9.39%) Decision-Making
10 23 (9.39%) Technical Architecture
11 22 (8.98%) Data Management
11 22 (8.98%) ERP
12 21 (8.57%) Data Development
12 21 (8.57%) SDLC
13 20 (8.16%) Data Architecture
14 18 (7.35%) Code Optimisation
14 18 (7.35%) Kimball Methodology
14 18 (7.35%) Test Automation
Programming Languages
1 176 (71.84%) SQL
2 90 (36.73%) T-SQL
3 32 (13.06%) Data Analysis Expressions (DAX)
4 30 (12.24%) Java
5 15 (6.12%) R
6 14 (5.71%) C#
7 13 (5.31%) VB
8 12 (4.90%) PL/SQL
9 9 (3.67%) RPG
9 9 (3.67%) RPG IV
10 7 (2.86%) JavaScript
10 7 (2.86%) VBA
11 6 (2.45%) Python
12 3 (1.22%) Shell Script
13 1 (0.41%) C++
13 1 (0.41%) Scala
Qualifications
1 19 (7.76%) Degree
2 7 (2.86%) Computer Science Degree
2 7 (2.86%) Master's Degree
3 4 (1.63%) Microsoft Certification
4 3 (1.22%) Security Cleared
5 2 (0.82%) ISEB
5 2 (0.82%) SC Cleared
6 1 (0.41%) ISEB Practitioner
6 1 (0.41%) MBCS
Quality Assurance & Compliance
1 24 (9.80%) GDPR
2 18 (7.35%) Data Quality
3 6 (2.45%) QA
4 3 (1.22%) Cyber Essentials
5 2 (0.82%) Basel III
5 2 (0.82%) COREP
5 2 (0.82%) CRD IV
System Software
1 5 (2.04%) Docker
2 1 (0.41%) Apache Flume
Systems Management
1 1 (0.41%) Ansible
1 1 (0.41%) Control-M
1 1 (0.41%) Oozie
1 1 (0.41%) Terraform
Vendors
1 102 (41.63%) Microsoft
2 97 (39.59%) Tableau
3 38 (15.51%) Cognos
4 29 (11.84%) Oracle
5 24 (9.80%) Alteryx
6 23 (9.39%) Informatica
7 14 (5.71%) Teradata
8 13 (5.31%) JD Edwards
9 8 (3.27%) Talend
10 7 (2.86%) Greenplum
10 7 (2.86%) IBM
10 7 (2.86%) SAP
11 5 (2.04%) Hortonworks
11 5 (2.04%) MuleSoft
11 5 (2.04%) Xamarin
12 4 (1.63%) Google
12 4 (1.63%) MicroStrategy
12 4 (1.63%) Netezza
13 3 (1.22%) Birst
13 3 (1.22%) Dell