Period
to 18 February 2018

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

Extract, Transform and Load (ETL)
Cambridgeshire > Peterborough
6 months to
18 Feb 2018
Same period 2017 Same period 2016
Rank 66 - 56
Rank change year-on-year - +56 -8
Permanent jobs citing ETL 7 0 7
As % of all permanent IT jobs advertised in Peterborough 1.17% - 1.32%
As % of the Processes & Methodologies category 1.38% - 1.48%
Number of salaries quoted 3 0 6
Peterborough median annual salary £45,000 - £46,250
Cambridgeshire median annual salary £45,000 £62,500 £47,500
% change year-on-year -28.00% +31.58% -20.83%

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

All Process and Methodology Skills
Peterborough
Permanent vacancies with a requirement for process or methodology skills 508 478 473
As % of all permanent IT jobs advertised in Peterborough 84.95% 84.01% 89.08%
Number of salaries quoted 387 371 390
Peterborough median annual salary £45,000 £45,000 £40,000
Median salary % change year-on-year - +12.50% -5.88%
10th Percentile £27,500 £26,750 £22,450
90th Percentile £67,500 £60,000 £61,375
Cambridgeshire median annual salary £50,000 £45,000 £43,000
% change year-on-year +11.11% +4.65% +1.18%

ETL
Job Vacancy Trend in Peterborough

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

Job vacancy trend for ETL in Peterborough

ETL
Salary Trend in Peterborough

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

Salary trend for ETL in Peterborough

For the 6 months to 18 February 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 Peterborough region with a requirement for ETL.

1 7 (100.00%) T-SQL
1 7 (100.00%) SQL Server
1 7 (100.00%) SQL Server Reporting Services
1 7 (100.00%) SQL Server Integration Services
2 6 (85.71%) SQL Server 2012
2 6 (85.71%) Business Intelligence
3 5 (71.43%) Data Warehouse
4 4 (57.14%) Microsoft
4 4 (57.14%) Microsoft Excel
5 3 (42.86%) Kimball Methodology
6 2 (28.57%) SQL Server 2008
6 2 (28.57%) SQL Server 2016
6 2 (28.57%) SQL
7 1 (14.29%) Microsoft Analysis Services
7 1 (14.29%) Business Analysis
7 1 (14.29%) Data Analysis
7 1 (14.29%) Crystal Reports
7 1 (14.29%) Configuration Management
7 1 (14.29%) Data Modelling
7 1 (14.29%) Customer Requirements
7 1 (14.29%) PowerPivot
7 1 (14.29%) Data Analysis Expressions (DAX)
7 1 (14.29%) SQL Server 2014
7 1 (14.29%) QA
7 1 (14.29%) SQL Server Analysis Services

ETL
Co-occurring IT Skills in Peterborough 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:

Applications
1 4 (57.14%) Microsoft Excel
Database & Business Intelligence
1 7 (100.00%) SQL Server
1 7 (100.00%) SQL Server Integration Services
1 7 (100.00%) SQL Server Reporting Services
2 6 (85.71%) SQL Server 2012
3 5 (71.43%) Data Warehouse
4 2 (28.57%) SQL Server 2008
4 2 (28.57%) SQL Server 2016
5 1 (14.29%) Crystal Reports
5 1 (14.29%) Microsoft Analysis Services
5 1 (14.29%) PowerPivot
5 1 (14.29%) SQL Server 2014
5 1 (14.29%) SQL Server Analysis Services
Job Titles
1 7 (100.00%) Developer
2 6 (85.71%) Business Intelligence Developer
3 5 (71.43%) Data Warehouse Developer
4 2 (28.57%) SQL Developer
5 1 (14.29%) Report Developer
5 1 (14.29%) SQL BI Developer
Processes & Methodologies
1 6 (85.71%) Business Intelligence
2 3 (42.86%) Kimball Methodology
3 1 (14.29%) Business Analysis
3 1 (14.29%) Configuration Management
3 1 (14.29%) Customer Requirements
3 1 (14.29%) Data Analysis
3 1 (14.29%) Data Modelling
Programming Languages
1 7 (100.00%) T-SQL
2 2 (28.57%) SQL
3 1 (14.29%) Data Analysis Expressions (DAX)
Quality Assurance & Compliance
1 1 (14.29%) QA
Vendors
1 4 (57.14%) Microsoft