Period
to 17 December 2017

The following table provides summary statistics for permanent job vacancies advertised in England with a requirement for Enterprise Data Warehouse skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited Enterprise Data Warehouse over the 6 months to 17 December 2017 with a comparison to the same period in the previous 2 years.

Enterprise Data Warehouse (EDW)
UK > England
6 months to
17 Dec 2017
Same period 2016 Same period 2015
Rank 966 956 955
Rank change year-on-year -10 -1 +129
Permanent jobs citing Enterprise Data Warehouse 188 226 323
As % of all permanent IT jobs advertised in England 0.11% 0.13% 0.16%
As % of the Database & Business Intelligence category 0.37% 0.44% 0.51%
Number of salaries quoted 134 189 286
England median annual salary £55,000 £57,500 £55,000
Median salary % change year-on-year -4.35% +4.55% -8.33%
10th Percentile £37,500 £33,300 £37,500
90th Percentile £76,250 £76,050 £77,000
UK median annual salary £55,000 £57,500 £55,000
% change year-on-year -4.35% +4.55% -8.33%

Enterprise Data Warehouse is in the Databases and Business Intelligence category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in England with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
England
Permanent vacancies with a requirement for database or business intelligence skills 50597 51582 63693
As % of all permanent IT jobs advertised in England 30.31% 29.73% 31.54%
Number of salaries quoted 42099 44514 54337
England median annual salary £50,000 £47,500 £45,000
Median salary % change year-on-year +5.26% +5.56% -
10th Percentile £30,000 £29,750 £28,750
90th Percentile £77,500 £77,500 £75,000
UK median annual salary £47,500 £47,500 £45,000
% change year-on-year - +5.56% +2.27%

Enterprise Data Warehouse
Job Vacancy Trend in England

Job postings citing Enterprise Data Warehouse as a percentage of all IT jobs advertised in England.

Job vacancy trend for Enterprise Data Warehouse in England

Enterprise Data Warehouse
Salary Trend in England

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing Enterprise Data Warehouse in England.

Salary trend for Enterprise Data Warehouse in England

Enterprise Data Warehouse
Salary Histogram in England

The salary distribution of IT jobs citing Enterprise Data Warehouse in England over the 6 months to 17 December 2017.

Salary histogram for Enterprise Data Warehouse in England

Enterprise Data Warehouse
Job Locations in England

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Enterprise Data Warehouse within the England region over the 6 months to 17 December 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
London -17 93 £60,000 -9.43% 13
East of England +17 25 £60,000 +4.35%
North of England +6 25 £55,000 +10.00% 2
South West +37 24 £42,500 -7.10%
Yorkshire +28 19 £55,000 +10.00% 2
Midlands +25 16 £45,000 +5.88% 2
East Midlands +20 12 £48,250 -19.58%
North West -16 6 £53,500 -16.08%
South East +6 5 £45,000 +20.00%
West Midlands -19 4 £42,500 - 2
Enterprise Data Warehouse
UK

For the 6 months to 17 December 2017, IT jobs citing Enterprise Data Warehouse 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 England region with a requirement for Enterprise Data Warehouse.

1 162 (86.17%) Data Warehouse
2 149 (79.26%) Business Intelligence
3 143 (76.06%) SQL
4 104 (55.32%) ETL
5 93 (49.47%) Agile Software Development
6 87 (46.28%) SQL Server Integration Services
7 83 (44.15%) SQL Server
8 73 (38.83%) Microsoft
9 65 (34.57%) T-SQL
9 65 (34.57%) SQL Server Reporting Services
10 61 (32.45%) SQL Server Analysis Services
11 60 (31.91%) Data Modelling
12 57 (30.32%) Analytics
13 44 (23.40%) Finance
13 44 (23.40%) Power BI
14 43 (22.87%) PL/SQL
15 39 (20.74%) Degree
15 39 (20.74%) Analytical Skills
16 37 (19.68%) Kimball Methodology
17 36 (19.15%) Oracle
17 36 (19.15%) SDLC
18 34 (18.09%) Performance Tuning
18 34 (18.09%) SQL Server 2012
19 33 (17.55%) Microsoft Azure
19 33 (17.55%) QA
19 33 (17.55%) SQL Server 2014
20 32 (17.02%) .NET
21 29 (15.43%) Visualisation
21 29 (15.43%) Data Integration
22 28 (14.89%) Dimensional Modelling

Enterprise Data Warehouse
Co-occurring IT Skills in England 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.72%) SAS
2 6 (3.19%) JBoss
2 6 (3.19%) WildFly
3 4 (2.13%) SharePoint
4 3 (1.60%) Apache Spark
4 3 (1.60%) Oracle SOA Suite
5 2 (1.06%) IIS
5 2 (1.06%) SharePoint 2013
Applications
1 5 (2.66%) Microsoft Excel
1 5 (2.66%) MS Visio
2 1 (0.53%) Microsoft Office
Business Applications
1 16 (8.51%) Oracle Retail
Cloud Services
1 33 (17.55%) Microsoft Azure
2 8 (4.26%) Amazon AWS
3 3 (1.60%) Cloud Computing
3 3 (1.60%) GitHub
3 3 (1.60%) PaaS
3 3 (1.60%) SaaS
4 2 (1.06%) Azure Data Factory
5 1 (0.53%) Boomi
Communications & Networking
1 1 (0.53%) SMS
Database & Business Intelligence
1 162 (86.17%) Data Warehouse
2 87 (46.28%) SQL Server Integration Services
3 83 (44.15%) SQL Server
4 65 (34.57%) SQL Server Reporting Services
5 61 (32.45%) SQL Server Analysis Services
6 44 (23.40%) Power BI
7 34 (18.09%) SQL Server 2012
8 33 (17.55%) SQL Server 2014
9 26 (13.83%) OLAP
10 17 (9.04%) Big Data
11 16 (8.51%) Data Mart
12 14 (7.45%) SQL Server 2016
13 12 (6.38%) SAP Data Services
14 11 (5.85%) Oracle Database
14 11 (5.85%) Oracle Database 12c
14 11 (5.85%) QlikView
15 10 (5.32%) Relational Database
16 8 (4.26%) Snowflake Schema
16 8 (4.26%) Star Schema
17 7 (3.72%) OLTP
Development Applications
1 24 (12.77%) Team Foundation Server
2 23 (12.23%) Visual Studio
3 13 (6.91%) Talend Open Studio
4 3 (1.60%) Jenkins
4 3 (1.60%) Subversion
5 1 (0.53%) JIRA
5 1 (0.53%) Visual Studio Team System
General
1 44 (23.40%) Finance
2 28 (14.89%) Retail
3 17 (9.04%) Marketing
4 15 (7.98%) Advertising
5 12 (6.38%) Games
6 3 (1.60%) Back Office
6 3 (1.60%) Banking
7 2 (1.06%) Financial Institution
7 2 (1.06%) Manufacturing
8 1 (0.53%) Law
8 1 (0.53%) Telecoms
Job Titles
1 98 (52.13%) Developer
2 56 (29.79%) Business Intelligence Developer
3 36 (19.15%) ETL Developer
4 27 (14.36%) Analyst
4 27 (14.36%) Architect
5 22 (11.70%) SQL Developer
6 17 (9.04%) Data Analyst
6 17 (9.04%) SQL BI Developer
7 16 (8.51%) Business Analyst
7 16 (8.51%) Data Business Analyst
7 16 (8.51%) Data Warehouse Analyst
7 16 (8.51%) Data Warehouse Business Analyst
8 15 (7.98%) SSIS Developer
8 15 (7.98%) SSRS Developer
9 11 (5.85%) SSAS Developer
10 10 (5.32%) Designer
10 10 (5.32%) Solutions Designer
11 9 (4.79%) Business Developer
11 9 (4.79%) Business Intelligence Lead
12 8 (4.26%) Oracle Solutions Architect
Libraries, Frameworks & Software Standards
1 32 (17.02%) .NET
2 25 (13.30%) MDX
3 13 (6.91%) JSON
3 13 (6.91%) Web Services
4 6 (3.19%) Java EE
4 6 (3.19%) Spring
5 3 (1.60%) XML
5 3 (1.60%) XSD
6 2 (1.06%) FIX Protocol
Miscellaneous
1 39 (20.74%) Analytical Skills
2 13 (6.91%) Computer Science
3 7 (3.72%) Data Structures
3 7 (3.72%) iPhone
4 6 (3.19%) Management Information System
5 5 (2.66%) Hedge funds
6 3 (1.60%) Credit Risk
6 3 (1.60%) Greenfield Project
7 2 (1.06%) Data Centre
7 2 (1.06%) Derivative
7 2 (1.06%) Equities
7 2 (1.06%) Fixed Income
7 2 (1.06%) Virtual Team
8 1 (0.53%) NHS
8 1 (0.53%) Reference Data
Operating Systems
1 8 (4.26%) Unix
2 6 (3.19%) Linux
Processes & Methodologies
1 149 (79.26%) Business Intelligence
2 104 (55.32%) ETL
3 93 (49.47%) Agile Software Development
4 60 (31.91%) Data Modelling
5 57 (30.32%) Analytics
6 37 (19.68%) Kimball Methodology
7 36 (19.15%) SDLC
8 34 (18.09%) Performance Tuning
9 29 (15.43%) Data Integration
9 29 (15.43%) Visualisation
10 28 (14.89%) Dimensional Modelling
10 28 (14.89%) Migration
11 27 (14.36%) Data Management
12 26 (13.83%) Continuous Integration
13 21 (11.17%) Scrum
14 20 (10.64%) Master Data Management
15 19 (10.11%) System Testing
15 19 (10.11%) Translating Business Requirements
16 18 (9.57%) Mentoring
17 17 (9.04%) Data Visualisation
Programming Languages
1 143 (76.06%) SQL
2 65 (34.57%) T-SQL
3 43 (22.87%) PL/SQL
4 18 (9.57%) C#
5 7 (3.72%) Data Analysis Expressions (DAX)
6 6 (3.19%) Java
7 5 (2.66%) Python
7 5 (2.66%) VB.NET
7 5 (2.66%) VBScript
8 4 (2.13%) C
8 4 (2.13%) R
9 3 (1.60%) ABAP
10 1 (0.53%) PowerShell
Qualifications
1 39 (20.74%) Degree
2 11 (5.85%) Computer Science Degree
3 10 (5.32%) SC Cleared
3 10 (5.32%) Security Cleared
4 5 (2.66%) Microsoft Certification
5 2 (1.06%) ISTQB
Quality Assurance & Compliance
1 33 (17.55%) QA
2 27 (14.36%) Data Quality
3 2 (1.06%) ISO 9001
3 2 (1.06%) ISO/IEC 27001
3 2 (1.06%) PCI DSS
4 1 (0.53%) GDPR
Systems Management
1 3 (1.60%) Rundeck
Vendors
1 73 (38.83%) Microsoft
2 36 (19.15%) Oracle
3 23 (12.23%) Tableau
4 19 (10.11%) SAP
5 16 (8.51%) Retek
6 13 (6.91%) Talend
7 8 (4.26%) MicroStrategy
7 8 (4.26%) Netezza
8 7 (3.72%) IBM
9 6 (3.19%) Teradata
10 5 (2.66%) Informatica
11 3 (1.60%) Salesforce.com
11 3 (1.60%) Vertica
12 2 (1.06%) Cognos
13 1 (0.53%) Birst
13 1 (0.53%) Dell
13 1 (0.53%) SnapLogic