Period
to 20 July 2018

The following table provides summary statistics for permanent job vacancies advertised in the South West with a requirement for Data Warehouse skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited Data Warehouse over the 6 months to 20 July 2018 with a comparison to the same period in the previous 2 years.

Data Warehousing
England > South West
6 months to
20 Jul 2018
Same period 2017 Same period 2016
Rank 135 139 126
Rank change year-on-year +4 -13 -19
Permanent jobs citing Data Warehouse 246 239 289
As % of all permanent IT jobs advertised in the South West 2.28% 2.29% 2.60%
As % of the Database & Business Intelligence category 7.41% 7.41% 8.09%
Number of salaries quoted 189 194 201
South West median annual salary £42,500 £42,000 £41,000
Median salary % change year-on-year +1.19% +2.44% -3.53%
10th Percentile £31,250 £32,500 £27,500
90th Percentile £63,750 £65,000 £58,750
England median annual salary £52,500 £50,000 £52,500
% change year-on-year +5.00% -4.76% +0.96%

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 the South West with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
South West
Permanent vacancies with a requirement for database or business intelligence skills 3,320 3,225 3,573
As % of all permanent IT jobs advertised in the South West 30.71% 30.86% 32.09%
Number of salaries quoted 2,833 2,799 2,995
South West median annual salary £42,500 £40,000 £40,000
Median salary % change year-on-year +6.25% - +6.67%
10th Percentile £27,500 £26,250 £26,250
90th Percentile £62,500 £62,500 £61,250
England median annual salary £50,000 £47,500 £47,500
% change year-on-year +5.26% - +5.56%

Data Warehouse
Job Vacancy Trend in the South West

Job postings citing Data Warehouse as a percentage of all IT jobs advertised in the South West.

Job vacancy trend for Data Warehouse in the South West

Data Warehouse
Salary Trend in the South West

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

Salary trend for Data Warehouse in the South West

Data Warehouse
Salary Histogram in the South West

The salary distribution of IT jobs citing Data Warehouse in the South West over the 6 months to 20 July 2018.

Salary histogram for Data Warehouse in the South West

Data Warehouse
Job Locations in the South West

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Data Warehouse within the South West region over the 6 months to 20 July 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
Bristol -20 77 £47,500 +11.76% 12
Wiltshire -16 47 £42,500 +1.19% 6
Cornwall +26 35 £33,500 +3.08% 4
Gloucestershire +18 34 £55,000 +22.22% 16
Somerset +27 33 £40,000 -5.88%
Dorset -24 12 £32,625 -18.44% 3
Devon +17 6 £41,250 +5.10% 5
Data Warehouse
England

For the 6 months to 20 July 2018, IT jobs citing Data Warehouse 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 South West region with a requirement for Data Warehouse.

1 175 (71.14%) Business Intelligence
2 167 (67.89%) SQL
3 157 (63.82%) SQL Server
4 136 (55.28%) ETL
5 110 (44.72%) SQL Server Integration Services
6 88 (35.77%) Microsoft
6 88 (35.77%) SQL Server Reporting Services
7 71 (28.86%) T-SQL
8 70 (28.46%) Oracle
9 68 (27.64%) Analytical Skills
10 63 (25.61%) Power BI
11 59 (23.98%) Agile Software Development
12 55 (22.36%) SQL Server Analysis Services
12 55 (22.36%) Finance
13 51 (20.73%) Data Modelling
14 48 (19.51%) BusinessObjects
15 45 (18.29%) Data Analysis
16 42 (17.07%) SQL Server 2012
17 40 (16.26%) Data Quality
17 40 (16.26%) Relational Database
18 37 (15.04%) Analytics
18 37 (15.04%) Web Services
19 35 (14.23%) Data Integration
19 35 (14.23%) Problem-Solving
20 33 (13.41%) Decision-Making
20 33 (13.41%) C#
21 32 (13.01%) CRM
21 32 (13.01%) Big Data
22 31 (12.60%) MySQL
22 31 (12.60%) ITIL

Data Warehouse
Co-occurring IT Skills in the South West 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.35%) BizTalk Server
2 21 (8.54%) SharePoint
3 11 (4.47%) Oracle SOA Suite
4 7 (2.85%) WebSphere
5 4 (1.63%) Confluence
5 4 (1.63%) SharePoint Server
6 3 (1.22%) WebLogic
7 2 (0.81%) Apache Spark
7 2 (0.81%) CMS
7 2 (0.81%) IIS
7 2 (0.81%) SAS
7 2 (0.81%) SharePoint 2010
8 1 (0.41%) Elasticsearch
Applications
1 26 (10.57%) Microsoft Excel
2 7 (2.85%) Microsoft Office
3 4 (1.63%) Microsoft PowerPoint
4 3 (1.22%) Spreadsheet
5 1 (0.41%) Chatbot
Business Applications
1 10 (4.07%) Oracle EBS
1 10 (4.07%) Oracle EBS R12
2 7 (2.85%) Cognos Business Intelligence
3 4 (1.63%) Dynamics CRM
4 3 (1.22%) Cognos TM1
4 3 (1.22%) Oracle BPM
5 2 (0.81%) FastStats
5 2 (0.81%) FastStats PeopleStage
Cloud Services
1 30 (12.20%) Amazon AWS
1 30 (12.20%) Microsoft Azure
2 7 (2.85%) Office 365
3 5 (2.03%) SaaS
4 4 (1.63%) Azure Data Factory
5 2 (0.81%) Amazon S3
5 2 (0.81%) Azure Active Directory
5 2 (0.81%) Data Lake Analytics
5 2 (0.81%) PaaS
6 1 (0.41%) Amazon EC2
6 1 (0.41%) Amazon EMR
6 1 (0.41%) Amazon SageMaker
6 1 (0.41%) Amazon SQS
6 1 (0.41%) Google Cloud Platform
Communications & Networking
1 9 (3.66%) Intranet
2 5 (2.03%) SMS
3 2 (0.81%) Extranet
Database & Business Intelligence
1 157 (63.82%) SQL Server
2 110 (44.72%) SQL Server Integration Services
3 88 (35.77%) SQL Server Reporting Services
4 63 (25.61%) Power BI
5 55 (22.36%) SQL Server Analysis Services
6 48 (19.51%) BusinessObjects
7 42 (17.07%) SQL Server 2012
8 40 (16.26%) Relational Database
9 32 (13.01%) Big Data
10 31 (12.60%) MySQL
11 24 (9.76%) SQL Server 2008
12 19 (7.72%) RDBMS
13 17 (6.91%) Oracle Database
13 17 (6.91%) SQL Server 2016
14 16 (6.50%) Microsoft Analysis Services
15 15 (6.10%) Oracle Database 11g
15 15 (6.10%) SQL Server 2014
16 14 (5.69%) Oracle BI EE
16 14 (5.69%) QlikView
17 13 (5.28%) SAP Data Services
Development Applications
1 8 (3.25%) Visual Studio
2 6 (2.44%) ERwin
2 6 (2.44%) Git (software)
3 5 (2.03%) Team Foundation Server
4 4 (1.63%) JIRA
5 3 (1.22%) JMeter
5 3 (1.22%) LoadRunner
5 3 (1.22%) Selenium
5 3 (1.22%) SoapUI
5 3 (1.22%) Toad
6 2 (0.81%) Bitbucket
6 2 (0.81%) SQL Server Management Studio (SSMS)
7 1 (0.41%) Atlassian Bamboo
7 1 (0.41%) Eclipse
7 1 (0.41%) ER Studio
7 1 (0.41%) IntelliJ
7 1 (0.41%) XMLSpy
General
1 55 (22.36%) Finance
2 8 (3.25%) Manufacturing
3 7 (2.85%) Law
3 7 (2.85%) Marketing
3 7 (2.85%) Retail
4 5 (2.03%) Advertising
4 5 (2.03%) Electronics
4 5 (2.03%) Telecoms
5 4 (1.63%) Banking
6 3 (1.22%) French Language
7 2 (0.81%) Legal
7 2 (0.81%) Private Banking
8 1 (0.41%) Aerospace
Job Titles
1 104 (42.28%) Developer
2 69 (28.05%) Analyst
3 53 (21.54%) Business Intelligence Developer
4 36 (14.63%) SQL Developer
5 25 (10.16%) Data Analyst
6 23 (9.35%) Business Intelligence Analyst
6 23 (9.35%) Senior Analyst
7 21 (8.54%) SQL BI Developer
8 20 (8.13%) DBA
9 16 (6.50%) Administrator
10 15 (6.10%) Data Warehouse Developer
11 14 (5.69%) Architect
12 13 (5.28%) Business Data Analyst
12 13 (5.28%) Business Intelligence Data Analyst
12 13 (5.28%) Oracle Developer
12 13 (5.28%) SQL DBA
13 12 (4.88%) Senior Business Systems Analyst
13 12 (4.88%) Senior Solutions Analyst
13 12 (4.88%) Senior Systems Analyst
13 12 (4.88%) Solutions Analyst
Libraries, Frameworks & Software Standards
1 37 (15.04%) Web Services
2 30 (12.20%) XML
3 28 (11.38%) .NET
4 27 (10.98%) SOAP
5 26 (10.57%) REST
6 24 (9.76%) HTML
7 6 (2.44%) RESTful
8 4 (1.63%) JSON
9 3 (1.22%) J2EE
9 3 (1.22%) WebSphere MQ
9 3 (1.22%) XML Messaging
9 3 (1.22%) XSD
10 2 (0.81%) ASP.NET
10 2 (0.81%) Kafka
10 2 (0.81%) WCF
11 1 (0.41%) .NET Framework
11 1 (0.41%) Django
11 1 (0.41%) Natural Language Processing
11 1 (0.41%) React
11 1 (0.41%) React Native
Miscellaneous
1 68 (27.64%) Analytical Skills
2 31 (12.60%) Management Information System
3 24 (9.76%) Enterprise Software
4 20 (8.13%) Computer Science
5 7 (2.85%) Client/Server
5 7 (2.85%) Virtual Team
6 6 (2.44%) Driving Licence
7 5 (2.03%) Fintech
8 4 (1.63%) Data Centre
8 4 (1.63%) Data Structures
8 4 (1.63%) Greenfield Project
8 4 (1.63%) NHS
8 4 (1.63%) User Experience
9 3 (1.22%) Data Protection Act
10 2 (0.81%) Algorithms
10 2 (0.81%) Clustering
10 2 (0.81%) Marketing Technology
10 2 (0.81%) Self-Motivation
11 1 (0.41%) Linked Data
11 1 (0.41%) N-Tier
Operating Systems
1 23 (9.35%) Windows
2 21 (8.54%) Linux
3 13 (5.28%) Unix
4 3 (1.22%) AIX
4 3 (1.22%) Oracle Linux
4 3 (1.22%) Windows Server
Processes & Methodologies
1 175 (71.14%) Business Intelligence
2 136 (55.28%) ETL
3 59 (23.98%) Agile Software Development
4 51 (20.73%) Data Modelling
5 45 (18.29%) Data Analysis
6 37 (15.04%) Analytics
7 35 (14.23%) Data Integration
7 35 (14.23%) Problem-Solving
8 33 (13.41%) Decision-Making
9 32 (13.01%) CRM
10 31 (12.60%) ITIL
11 27 (10.98%) Project Management
12 26 (10.57%) SOA
13 25 (10.16%) Validation
14 23 (9.35%) Data Management
14 23 (9.35%) SDLC
15 22 (8.94%) Continuous Improvement
15 22 (8.94%) ERP
15 22 (8.94%) Migration
16 21 (8.54%) Data Science
Programming Languages
1 167 (67.89%) SQL
2 71 (28.86%) T-SQL
3 33 (13.41%) C#
4 28 (11.38%) Java
4 28 (11.38%) PL/SQL
5 21 (8.54%) Python
6 13 (5.28%) C++
7 12 (4.88%) PHP
7 12 (4.88%) VB.NET
8 10 (4.07%) Shell Script
9 7 (2.85%) C
10 6 (2.44%) PowerShell
10 6 (2.44%) R
11 5 (2.03%) VBA
12 2 (0.81%) Data Analysis Expressions (DAX)
12 2 (0.81%) JavaScript
12 2 (0.81%) U-SQL
12 2 (0.81%) VB
13 1 (0.41%) Bash Shell
13 1 (0.41%) Korn
Qualifications
1 30 (12.20%) Degree
2 24 (9.76%) Security Cleared
3 23 (9.35%) Postgraduate
4 14 (5.69%) SC Cleared
5 12 (4.88%) Microsoft Certification
6 11 (4.47%) ITIL Certification
7 4 (1.63%) BPSS Clearance
8 3 (1.22%) Oracle Certification
9 2 (0.81%) DV Cleared
10 1 (0.41%) Master's Degree
10 1 (0.41%) MBA
10 1 (0.41%) Numerate Degree
10 1 (0.41%) TOGAF Certification
Quality Assurance & Compliance
1 40 (16.26%) Data Quality
2 8 (3.25%) QA
3 6 (2.44%) GDPR
4 2 (0.81%) ISO 9001
4 2 (0.81%) ISO/IEC 20000
5 1 (0.41%) HL7
5 1 (0.41%) SNOMED CT
System Software
1 5 (2.03%) Active Directory
2 2 (0.81%) VMware Infrastructure
Systems Management
1 2 (0.81%) Endace
1 2 (0.81%) HP Data Protector
Vendors
1 88 (35.77%) Microsoft
2 70 (28.46%) Oracle
3 27 (10.98%) Informatica
4 26 (10.57%) SAP
5 25 (10.16%) IBM
5 25 (10.16%) Tableau
6 13 (5.28%) Cognos
7 10 (4.07%) Siebel
8 9 (3.66%) Trillium
9 6 (2.44%) Salesforce.com
10 4 (1.63%) Teradata
11 3 (1.22%) Apple
11 3 (1.22%) Citrix
11 3 (1.22%) Cloudera
11 3 (1.22%) Google
11 3 (1.22%) Hortonworks
11 3 (1.22%) IFS
11 3 (1.22%) Talend
11 3 (1.22%) TOWER Software
12 2 (0.81%) Twitter