Period
to 13 December 2018

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

Extract, Transform and Load (ETL)
East of England > Cambridgeshire
6 months to
13 Dec 2018
Same period 2017 Same period 2016
Rank 122 181 127
Rank change year-on-year +59 -54 +24
Permanent jobs citing ETL 56 28 49
As % of all permanent IT jobs advertised in Cambridgeshire 1.82% 0.65% 1.44%
As % of the Processes & Methodologies category 1.98% 0.69% 1.60%
Number of salaries quoted 43 20 43
Cambridgeshire median annual salary £47,500 £33,750 £60,000
Median salary % change year-on-year +40.74% -43.75% +33.33%
10th Percentile £36,500 £30,875 £32,500
90th Percentile £60,000 £63,625 £98,750
East of England median annual salary £52,500 £49,000 £50,000
% change year-on-year +7.14% -2.00% +5.26%

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

All Process and Methodology Skills
Cambridgeshire
Permanent vacancies with a requirement for process or methodology skills 2,830 4,054 3,063
As % of all permanent IT jobs advertised in Cambridgeshire 91.85% 93.73% 89.77%
Number of salaries quoted 2,035 3,085 2,523
Cambridgeshire median annual salary £49,500 £47,500 £45,000
Median salary % change year-on-year +4.21% +5.56% +2.27%
10th Percentile £28,250 £27,500 £26,250
90th Percentile £72,500 £70,000 £66,250
East of England median annual salary £47,500 £47,500 £45,000
% change year-on-year - +5.56% -

ETL
Job Vacancy Trend in Cambridgeshire

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

Job vacancy trend for ETL in Cambridgeshire

ETL
Salary Trend in Cambridgeshire

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

Salary trend for ETL in Cambridgeshire

ETL
Salary Histogram in Cambridgeshire

The salary distribution of IT jobs citing ETL in Cambridgeshire over the 6 months to 13 December 2018.

Salary histogram for ETL in Cambridgeshire

ETL
Job Locations in Cambridgeshire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing ETL within the Cambridgeshire region over the 6 months to 13 December 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
Cambridge +54 34 £50,000 +53.85% 8
Peterborough -16 18 £45,000 -21.74% 2
Huntingdon +8 1 - -
ETL
East of England

For the 6 months to 13 December 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 Cambridgeshire region with a requirement for ETL.

1 41 (73.21%) SQL Server Integration Services
2 39 (69.64%) SQL
3 33 (58.93%) SQL Server
3 33 (58.93%) SQL Server Reporting Services
4 26 (46.43%) Business Intelligence
4 26 (46.43%) Microsoft
5 25 (44.64%) SQL Server Analysis Services
6 24 (42.86%) Analytics
7 21 (37.50%) Microsoft Azure
7 21 (37.50%) Data Warehouse
8 18 (32.14%) Agile Software Development
9 17 (30.36%) Hadoop
10 16 (28.57%) T-SQL
11 14 (25.00%) Azure Data Factory
12 12 (21.43%) Relational Database
12 12 (21.43%) Data Science
12 12 (21.43%) Data Analysis
13 11 (19.64%) Retail
13 11 (19.64%) SQL Server 2008
13 11 (19.64%) Data Modelling
14 10 (17.86%) CA
14 10 (17.86%) Microsoft Excel
14 10 (17.86%) Data Analysis Expressions (DAX)
14 10 (17.86%) Hortonworks
14 10 (17.86%) Power BI
15 9 (16.07%) Data Lake
15 9 (16.07%) Python
15 9 (16.07%) Azure SQL Database
15 9 (16.07%) Tableau
15 9 (16.07%) QA

ETL
Co-occurring IT Skills in Cambridgeshire 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 6 (10.71%) Apache Spark
2 4 (7.14%) SharePoint
3 2 (3.57%) SAS
4 1 (1.79%) Apache
Applications
1 10 (17.86%) Microsoft Excel
2 1 (1.79%) SPSS
Business Applications
1 5 (8.93%) Cognos Business Intelligence
1 5 (8.93%) Cognos TM1
1 5 (8.93%) Dynamics CRM
2 1 (1.79%) Dynamics AX
Cloud Services
1 21 (37.50%) Microsoft Azure
2 14 (25.00%) Azure Data Factory
3 7 (12.50%) Amazon AWS
4 4 (7.14%) Dynamics 365
5 1 (1.79%) Amazon EMR
5 1 (1.79%) Amazon S3
5 1 (1.79%) Office 365
Database & Business Intelligence
1 41 (73.21%) SQL Server Integration Services
2 33 (58.93%) SQL Server
2 33 (58.93%) SQL Server Reporting Services
3 25 (44.64%) SQL Server Analysis Services
4 21 (37.50%) Data Warehouse
5 17 (30.36%) Hadoop
6 12 (21.43%) Relational Database
7 11 (19.64%) SQL Server 2008
8 10 (17.86%) Power BI
9 9 (16.07%) Azure SQL Database
9 9 (16.07%) Data Lake
9 9 (16.07%) Microsoft Analysis Services
10 7 (12.50%) Apache Hive
11 6 (10.71%) Big Data
12 5 (8.93%) Azure SQL Data Warehouse
12 5 (8.93%) Cosmos DB
12 5 (8.93%) Crystal Reports
12 5 (8.93%) PowerPivot
12 5 (8.93%) Sqoop
13 3 (5.36%) OLAP
Development Applications
1 2 (3.57%) Visual Studio
2 1 (1.79%) GitLab
2 1 (1.79%) SQL Server Management Studio (SSMS)
General
1 11 (19.64%) Retail
2 6 (10.71%) Finance
3 2 (3.57%) Manufacturing
4 1 (1.79%) Advertising
4 1 (1.79%) Banking
4 1 (1.79%) Pharmaceutical
4 1 (1.79%) Publishing
Job Titles
1 31 (55.36%) Developer
2 14 (25.00%) Business Intelligence Developer
3 13 (23.21%) Hadoop Developer
4 7 (12.50%) DBA
4 7 (12.50%) ETL Developer
5 6 (10.71%) Business Developer
5 6 (10.71%) Business Intelligence Consultant
5 6 (10.71%) Consultant
5 6 (10.71%) Data Engineer
5 6 (10.71%) SQL BI Developer
5 6 (10.71%) SQL DBA
5 6 (10.71%) SQL Developer
6 5 (8.93%) Administrator
6 5 (8.93%) Data Warehouse Developer
6 5 (8.93%) Microsoft BI Consultant
6 5 (8.93%) Principal Developer
6 5 (8.93%) SQL Server BI Developer
6 5 (8.93%) SQL Server Data Warehouse Developer
6 5 (8.93%) SQL Server Developer
6 5 (8.93%) Technical Consultant
Libraries, Frameworks & Software Standards
1 6 (10.71%) Kafka
2 4 (7.14%) JSON
3 2 (3.57%) .NET
3 2 (3.57%) .NET Framework
3 2 (3.57%) Web Services
4 1 (1.79%) Apache Camel
4 1 (1.79%) NumPy
4 1 (1.79%) Pandas
4 1 (1.79%) REST
4 1 (1.79%) SOAP
Miscellaneous
1 7 (12.50%) Analytical Skills
2 6 (10.71%) Data Structures
3 2 (3.57%) Life Science
4 1 (1.79%) Management Information System
4 1 (1.79%) Self-Motivation
Operating Systems
1 1 (1.79%) Linux
1 1 (1.79%) Windows
Processes & Methodologies
1 26 (46.43%) Business Intelligence
2 24 (42.86%) Analytics
3 18 (32.14%) Agile Software Development
4 12 (21.43%) Data Analysis
4 12 (21.43%) Data Science
5 11 (19.64%) Data Modelling
6 8 (14.29%) Data Management
6 8 (14.29%) Mentoring
7 7 (12.50%) Data Integration
8 6 (10.71%) Performance Tuning
8 6 (10.71%) Presales
9 5 (8.93%) CRM
9 5 (8.93%) Data Governance
9 5 (8.93%) Dimensional Modelling
9 5 (8.93%) Kimball Methodology
9 5 (8.93%) MapReduce
9 5 (8.93%) PRINCE2
9 5 (8.93%) Waterfall
10 4 (7.14%) Database Tuning
10 4 (7.14%) Scrum
Programming Languages
1 39 (69.64%) SQL
2 16 (28.57%) T-SQL
3 10 (17.86%) Data Analysis Expressions (DAX)
4 9 (16.07%) Python
5 7 (12.50%) Bash Shell
5 7 (12.50%) Java
5 7 (12.50%) PowerShell
5 7 (12.50%) Scala
6 6 (10.71%) R
7 2 (3.57%) C#
8 1 (1.79%) VBA
Qualifications
1 4 (7.14%) MCP
2 1 (1.79%) Computer Science Degree
2 1 (1.79%) Degree
Quality Assurance & Compliance
1 9 (16.07%) QA
2 2 (3.57%) Data Quality
System Software
1 5 (8.93%) HDFS
2 1 (1.79%) Docker
Systems Management
1 5 (8.93%) Oozie
Vendors
1 26 (46.43%) Microsoft
2 10 (17.86%) CA
2 10 (17.86%) Hortonworks
3 9 (16.07%) Tableau
4 7 (12.50%) Cognos
5 5 (8.93%) Databricks
6 1 (1.79%) JD Edwards
6 1 (1.79%) Oracle
6 1 (1.79%) Talend