Period
to 8 December 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 8 December 2019 with a comparison to the same period in the previous 2 years.

Extract, Transform and Load (ETL)
England > Midlands
6 months to
8 Dec 2019
Same period 2018 Same period 2017
Rank 138 162 143
Rank change year-on-year +24 -19 +38
Permanent jobs citing ETL 241 256 328
As % of all permanent IT jobs advertised in the Midlands 2.17% 2.03% 2.13%
As % of the Processes & Methodologies category 2.35% 2.20% 2.33%
Number of salaries quoted 226 209 277
Midlands median annual salary £45,000 £45,000 £45,000
10th Percentile £31,500 £32,500 £28,550
90th Percentile £62,500 £69,000 £67,500
England median annual salary £55,000 £55,000 £50,000
% 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 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,259 11,619 14,073
As % of all permanent IT jobs advertised in the Midlands 92.20% 91.92% 91.38%
Number of salaries quoted 8,413 8,780 11,451
Midlands median annual salary £45,000 £44,000 £40,000
Median salary % change year-on-year +2.27% +10.00% -3.61%
10th Percentile £26,250 £26,250 £25,000
90th Percentile £71,250 £70,000 £65,000
England median annual salary £52,500 £52,500 £50,000
% change year-on-year - +5.00% -

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 8 December 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 8 December 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 +38 191 £47,500 +5.56% 39
East Midlands -15 50 £45,000 +5.88% 16
ETL
England

For the 6 months to 8 December 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 207 (85.89%) SQL
2 138 (57.26%) Business Intelligence
3 131 (54.36%) Data Warehouse
4 128 (53.11%) SQL Server Integration Services
5 114 (47.30%) SQL Server
6 103 (42.74%) SQL Server Reporting Services
7 101 (41.91%) SQL Server Analysis Services
8 83 (34.44%) T-SQL
9 80 (33.20%) Microsoft
10 79 (32.78%) Power Platform
11 76 (31.54%) Power BI
12 71 (29.46%) Azure
13 64 (26.56%) Finance
14 59 (24.48%) Analytics
15 58 (24.07%) Agile Software Development
16 56 (23.24%) Analytical Skills
17 49 (20.33%) Data Modelling
18 42 (17.43%) Problem-Solving
19 41 (17.01%) Kimball Methodology
20 38 (15.77%) Data Quality
20 38 (15.77%) Python
21 31 (12.86%) QA
22 28 (11.62%) AWS
23 27 (11.20%) Relational Database
23 27 (11.20%) Visualisation
24 26 (10.79%) Cognos
25 25 (10.37%) Data Analysis
26 24 (9.96%) Big Data
27 23 (9.54%) SAS
28 22 (9.13%) C#

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 23 (9.54%) SAS
2 14 (5.81%) SharePoint
3 6 (2.49%) Apache Pig
3 6 (2.49%) Confluence
4 5 (2.07%) Apache Spark
5 4 (1.66%) Apache Airflow
6 1 (0.41%) Apache
6 1 (0.41%) ArcGIS
6 1 (0.41%) IIS
Applications
1 12 (4.98%) Microsoft Excel
2 2 (0.83%) Microsoft Office
2 2 (0.83%) Microsoft PowerPoint
3 1 (0.41%) MS Visio
Business Applications
1 5 (2.07%) Dynamics GP
2 3 (1.24%) OPENHousing
3 2 (0.83%) Dynamics AX
3 2 (0.83%) NetSuite
4 1 (0.41%) Cognos TM1
Cloud Services
1 79 (32.78%) Power Platform
2 71 (29.46%) Azure
3 28 (11.62%) AWS
4 17 (7.05%) Azure Data Factory
5 13 (5.39%) GCP
6 9 (3.73%) PaaS
7 7 (2.90%) IaaS
8 6 (2.49%) Microsoft Flow
8 6 (2.49%) Office 365
8 6 (2.49%) PowerApps
9 5 (2.07%) SaaS
10 4 (1.66%) Cloud Computing
11 2 (0.83%) Azure Stack
11 2 (0.83%) Dynamics 365
12 1 (0.41%) AWS Lambda
12 1 (0.41%) Serverless
Communications & Networking
1 1 (0.41%) Intranet
1 1 (0.41%) LAN
1 1 (0.41%) WAN
Database & Business Intelligence
1 131 (54.36%) Data Warehouse
2 128 (53.11%) SQL Server Integration Services
3 114 (47.30%) SQL Server
4 103 (42.74%) SQL Server Reporting Services
5 101 (41.91%) SQL Server Analysis Services
6 76 (31.54%) Power BI
7 27 (11.20%) Relational Database
8 24 (9.96%) Big Data
9 19 (7.88%) Hadoop
10 13 (5.39%) MySQL
11 11 (4.56%) Data Lake
11 11 (4.56%) Looker
11 11 (4.56%) Microsoft Analysis Services
11 11 (4.56%) MongoDB
12 10 (4.15%) Oracle Database
13 9 (3.73%) Azure SQL Data Warehouse
13 9 (3.73%) BusinessObjects
13 9 (3.73%) Cognos Framework Manager
14 8 (3.32%) BusinessObjects XI
14 8 (3.32%) QlikView
Development Applications
1 8 (3.32%) JIRA
2 7 (2.90%) Visual Studio
3 6 (2.49%) Oracle Forms
3 6 (2.49%) Selenium
3 6 (2.49%) Team Foundation Server
4 5 (2.07%) Git (software)
4 5 (2.07%) JMeter
4 5 (2.07%) Postman
5 4 (1.66%) Subversion
6 3 (1.24%) SQL Server Management Studio (SSMS)
7 2 (0.83%) Artifactory
7 2 (0.83%) Bitbucket
7 2 (0.83%) Jenkins
7 2 (0.83%) Maven
7 2 (0.83%) Visual Studio Team System
General
1 64 (26.56%) Finance
2 20 (8.30%) Retail
3 14 (5.81%) Billing
4 10 (4.15%) General Ledger
5 9 (3.73%) Marketing
6 3 (1.24%) Manufacturing
6 3 (1.24%) Public Sector
6 3 (1.24%) Social Housing
7 2 (0.83%) French Language
8 1 (0.41%) Aerospace
8 1 (0.41%) Automotive
8 1 (0.41%) Publishing
Job Titles
1 111 (46.06%) Developer
2 51 (21.16%) Analyst
2 51 (21.16%) Business Intelligence Developer
3 38 (15.77%) SQL Developer
4 28 (11.62%) Data Engineer
5 22 (9.13%) Architect
5 22 (9.13%) Data Analyst
5 22 (9.13%) SSIS Developer
6 18 (7.47%) SSRS Developer
7 16 (6.64%) Business Analyst
7 16 (6.64%) SSAS Developer
8 14 (5.81%) Business Developer
9 13 (5.39%) Analyst Developer
9 13 (5.39%) Senior Data Engineer
10 12 (4.98%) Data Architect
10 12 (4.98%) Developer Analyst
10 12 (4.98%) ETL Developer
11 11 (4.56%) C# Developer
11 11 (4.56%) Data Business Analyst
12 10 (4.15%) Technical Architect
Libraries, Frameworks & Software Standards
1 16 (6.64%) .NET
2 14 (5.81%) .NET Framework
3 13 (5.39%) Entity Framework
3 13 (5.39%) LINQ
3 13 (5.39%) MDX
3 13 (5.39%) WinForms
4 12 (4.98%) Ajax
4 12 (4.98%) ASP.NET
4 12 (4.98%) ASP.NET Web Forms
4 12 (4.98%) CSS
4 12 (4.98%) CSS3
4 12 (4.98%) HTML
4 12 (4.98%) HTML5
4 12 (4.98%) WCF
5 10 (4.15%) Web Services
6 4 (1.66%) Kafka
7 3 (1.24%) JSON
8 2 (0.83%) Java EE
8 2 (0.83%) Spring
9 1 (0.41%) LAPP Stack
Miscellaneous
1 56 (23.24%) Analytical Skills
2 10 (4.15%) Management Information System
3 7 (2.90%) Credit Risk
4 5 (2.07%) User Experience
5 4 (1.66%) Data Structures
5 4 (1.66%) Self-Motivation
6 2 (0.83%) Data Centre
6 2 (0.83%) EPoS
6 2 (0.83%) Public Cloud
6 2 (0.83%) Replication
7 1 (0.41%) Analytical Mindset
7 1 (0.41%) Clustering
7 1 (0.41%) LLPG
7 1 (0.41%) Media Streaming
7 1 (0.41%) N-Tier
Operating Systems
1 8 (3.32%) Linux
2 6 (2.49%) Unix
3 2 (0.83%) Android
3 2 (0.83%) Apple iOS
4 1 (0.41%) Debian
4 1 (0.41%) Windows
4 1 (0.41%) Windows 10
4 1 (0.41%) Windows Server 2012
Processes & Methodologies
1 138 (57.26%) Business Intelligence
2 59 (24.48%) Analytics
3 58 (24.07%) Agile Software Development
4 49 (20.33%) Data Modelling
5 42 (17.43%) Problem-Solving
6 41 (17.01%) Kimball Methodology
7 27 (11.20%) Visualisation
8 25 (10.37%) Data Analysis
9 22 (9.13%) Data Engineering
10 21 (8.71%) OO
11 20 (8.30%) Data Visualisation
12 19 (7.88%) Data Transformation
13 18 (7.47%) User Stories
14 17 (7.05%) Continuous Integration
14 17 (7.05%) Data Analytics
14 17 (7.05%) Web Development
15 16 (6.64%) Data Governance
15 16 (6.64%) Dimensional Modelling
15 16 (6.64%) Scrum
16 15 (6.22%) ETL Development
Programming Languages
1 207 (85.89%) SQL
2 83 (34.44%) T-SQL
3 38 (15.77%) Python
4 22 (9.13%) C#
5 17 (7.05%) Data Analysis Expressions (DAX)
6 13 (5.39%) JavaScript
7 12 (4.98%) VB.NET
8 10 (4.15%) PL/SQL
9 9 (3.73%) Java
10 7 (2.90%) R
11 5 (2.07%) Scala
12 3 (1.24%) PowerShell
13 2 (0.83%) Java 8
13 2 (0.83%) VBA
14 1 (0.41%) Bash Shell
14 1 (0.41%) C
14 1 (0.41%) Perl
Qualifications
1 13 (5.39%) ISTQB
2 5 (2.07%) Degree
2 5 (2.07%) ISTQB Foundation Certification
3 2 (0.83%) Microsoft Certification
4 1 (0.41%) Computer Science Degree
4 1 (0.41%) HND
4 1 (0.41%) ISEB
Quality Assurance & Compliance
1 38 (15.77%) Data Quality
2 31 (12.86%) QA
3 12 (4.98%) GDPR
4 5 (2.07%) Solvency II
5 3 (1.24%) SLA
System Software
1 4 (1.66%) Hyper-V
1 4 (1.66%) VMware Infrastructure
2 2 (0.83%) HDFS
2 2 (0.83%) Virtual Machines
3 1 (0.41%) Active Directory
3 1 (0.41%) Docker
3 1 (0.41%) pfSense
Systems Management
1 3 (1.24%) Ansible
2 2 (0.83%) NetBackup
2 2 (0.83%) Terraform
3 1 (0.41%) Nagios
Vendors
1 80 (33.20%) Microsoft
2 26 (10.79%) Cognos
3 19 (7.88%) Tableau
4 17 (7.05%) IBM
4 17 (7.05%) Oracle
5 13 (5.39%) Google
6 10 (4.15%) Databricks
7 7 (2.90%) Snowplow
8 6 (2.49%) Ab Initio
8 6 (2.49%) Informatica
8 6 (2.49%) Netezza
8 6 (2.49%) Talend
9 4 (1.66%) Cloudera
9 4 (1.66%) MicroStrategy
9 4 (1.66%) VMware
10 3 (1.24%) Capita
11 2 (0.83%) JD Edwards
11 2 (0.83%) SAP
11 2 (0.83%) Twitter
12 1 (0.41%) Dell