Period
to 14 December 2017

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

Data Warehousing
England > South West
6 months to
14 Dec 2017
Same period 2016 Same period 2015
Rank 121 184 102
Rank change year-on-year +63 -82 +37
Permanent jobs citing Data Warehouse 295 176 353
As % of all permanent IT jobs advertised in the South West 2.88% 1.63% 3.01%
As % of the Database & Business Intelligence category 8.77% 5.34% 9.12%
Number of salaries quoted 224 151 264
South West median annual salary £42,500 £42,500 £45,000
Median salary % change year-on-year - -5.56% +4.65%
10th Percentile £31,305 £28,000 £28,500
90th Percentile £58,750 £57,500 £63,813
England median annual salary £51,500 £55,000 £50,000
% change year-on-year -6.36% +10.00% -7.41%

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 3365 3297 3871
As % of all permanent IT jobs advertised in the South West 32.86% 30.50% 33.06%
Number of salaries quoted 2854 2819 3352
South West median annual salary £40,000 £41,500 £39,060
Median salary % change year-on-year -3.61% +6.25% +4.16%
10th Percentile £26,750 £27,500 £26,250
90th Percentile £60,000 £63,250 £60,000
England median annual salary £50,000 £47,500 £45,000
% 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 14 December 2017.

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 14 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
Bristol +1 91 £42,500 - 11
Somerset +22 49 £38,500 -4.94% 1
Wiltshire +28 48 £40,000 -11.11%
Gloucestershire +49 45 £42,500 - 7
Dorset +12 30 £42,500 -2.86% 1
Cornwall -11 8 £34,500 -31.00%
Devon +16 7 £50,000 +69.49%
Data Warehouse
England

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

1 241 (81.69%) Business Intelligence
2 224 (75.93%) SQL
3 169 (57.29%) SQL Server
4 157 (53.22%) ETL
4 157 (53.22%) SQL Server Integration Services
5 143 (48.47%) SQL Server Reporting Services
6 103 (34.92%) Data Modelling
7 102 (34.58%) T-SQL
8 91 (30.85%) Microsoft
9 87 (29.49%) Finance
10 84 (28.47%) SQL Server Analysis Services
11 81 (27.46%) Power BI
12 66 (22.37%) Analytics
13 59 (20.00%) Stakeholder Management
14 58 (19.66%) Tableau
14 58 (19.66%) Microsoft Azure
15 57 (19.32%) QlikView
15 57 (19.32%) BusinessObjects
16 56 (18.98%) Agile Software Development
17 51 (17.29%) Data Management
18 47 (15.93%) Analytical Skills
19 43 (14.58%) SQL Server 2014
20 41 (13.90%) Migration
21 39 (13.22%) Microsoft Excel
21 39 (13.22%) SQL Server 2012
22 38 (12.88%) Data Analysis
23 36 (12.20%) Degree
24 34 (11.53%) QA
25 33 (11.19%) C#
26 31 (10.51%) Amazon AWS

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 26 (8.81%) SharePoint
2 6 (2.03%) SharePoint 2010
3 5 (1.69%) SAS
3 5 (1.69%) SharePoint 2013
4 4 (1.36%) Apache Spark
5 3 (1.02%) CMS
5 3 (1.02%) IIS
6 2 (0.68%) Kentico
7 1 (0.34%) Confluence
7 1 (0.34%) Oracle 10gAS
7 1 (0.34%) WebLogic
7 1 (0.34%) WebSphere
Applications
1 39 (13.22%) Microsoft Excel
2 5 (1.69%) Microsoft Office
2 5 (1.69%) MS Visio
3 3 (1.02%) SPSS
4 2 (0.68%) SPSS Modeler
5 1 (0.34%) InfoPath
Business Applications
1 10 (3.39%) Cognos Business Intelligence
2 5 (1.69%) SAP Business ByDesign
2 5 (1.69%) SAP Business One
3 4 (1.36%) Dynamics NAV
3 4 (1.36%) Maximo
4 2 (0.68%) Dynamics AX
4 2 (0.68%) Oracle ERP
5 1 (0.34%) Cognos TM1
5 1 (0.34%) Oracle 11i
5 1 (0.34%) Oracle BPM
5 1 (0.34%) Oracle EBS
5 1 (0.34%) Oracle EBS R12
5 1 (0.34%) SAP BPC
Cloud Services
1 58 (19.66%) Microsoft Azure
2 31 (10.51%) Amazon AWS
3 15 (5.08%) Google Cloud Platform
4 3 (1.02%) Office 365
5 2 (0.68%) Amazon EMR
5 2 (0.68%) Amazon Kinesis
5 2 (0.68%) Amazon S3
5 2 (0.68%) Azure Data Factory
5 2 (0.68%) Cloud Computing
5 2 (0.68%) IaaS
5 2 (0.68%) PaaS
6 1 (0.34%) Amazon SQS
6 1 (0.34%) Cortana Intelligence Suite
Communications & Networking
1 5 (1.69%) Skype
2 2 (0.68%) SMS
3 1 (0.34%) Internet
Database & Business Intelligence
1 169 (57.29%) SQL Server
2 157 (53.22%) SQL Server Integration Services
3 143 (48.47%) SQL Server Reporting Services
4 84 (28.47%) SQL Server Analysis Services
5 81 (27.46%) Power BI
6 57 (19.32%) BusinessObjects
6 57 (19.32%) QlikView
7 43 (14.58%) SQL Server 2014
8 39 (13.22%) SQL Server 2012
9 24 (8.14%) Crystal Reports
9 24 (8.14%) Enterprise Data Warehouse
9 24 (8.14%) Relational Database
10 20 (6.78%) PostgreSQL
11 19 (6.44%) OLAP
12 18 (6.10%) SQL Server 2016
13 17 (5.76%) Data Mining
13 17 (5.76%) SQL Server 2008
14 16 (5.42%) Big Data
15 14 (4.75%) Semantic Layer
16 13 (4.41%) Qlik Sense
Development Applications
1 24 (8.14%) ERwin
2 22 (7.46%) Team Foundation Server
2 22 (7.46%) Visual Studio
3 10 (3.39%) Oracle Forms
4 8 (2.71%) SQL Server Management Studio (SSMS)
5 6 (2.03%) Talend Open Studio
5 6 (2.03%) Toad
6 2 (0.68%) Git (software)
6 2 (0.68%) RStudio
7 1 (0.34%) Atlassian Bamboo
7 1 (0.34%) JIRA
7 1 (0.34%) JMeter
7 1 (0.34%) LoadRunner
7 1 (0.34%) Selenium
7 1 (0.34%) SoapUI
General
1 87 (29.49%) Finance
2 20 (6.78%) Marketing
3 17 (5.76%) Manufacturing
4 14 (4.75%) Banking
5 13 (4.41%) Electronics
5 13 (4.41%) Telecoms
6 11 (3.73%) Retail
7 8 (2.71%) Advertising
8 5 (1.69%) French Language
9 2 (0.68%) Retail Banking
10 1 (0.34%) Automotive
10 1 (0.34%) Back Office
10 1 (0.34%) Law
Job Titles
1 145 (49.15%) Developer
2 88 (29.83%) Business Intelligence Developer
3 43 (14.58%) Analyst
4 38 (12.88%) Business Developer
5 35 (11.86%) SQL Developer
6 27 (9.15%) Data Analyst
7 26 (8.81%) Architect
8 24 (8.14%) Data Warehouse Developer
9 22 (7.46%) Data Architect
9 22 (7.46%) SQL BI Developer
10 18 (6.10%) Consultant
10 18 (6.10%) SSRS Developer
11 17 (5.76%) SSIS Developer
12 16 (5.42%) SQL Server BI Developer
12 16 (5.42%) SQL Server Developer
13 14 (4.75%) Business Intelligence Analyst
14 12 (4.07%) DBA
15 11 (3.73%) Business Intelligence Consultant
15 11 (3.73%) Database Engineer
15 11 (3.73%) QlikView Developer
Libraries, Frameworks & Software Standards
1 19 (6.44%) REST
2 16 (5.42%) .NET
3 13 (4.41%) Web Services
4 9 (3.05%) .NET Framework
5 8 (2.71%) JSON
6 6 (2.03%) ASP.NET
6 6 (2.03%) CSS
6 6 (2.03%) HTML
6 6 (2.03%) MDX
6 6 (2.03%) SOAP
7 5 (1.69%) XML
8 4 (1.36%) AngularJS
8 4 (1.36%) ASP.NET MVC
8 4 (1.36%) RESTful
9 2 (0.68%) Entity Framework
9 2 (0.68%) Hibernate
9 2 (0.68%) Java Concurrency
9 2 (0.68%) jQuery
9 2 (0.68%) Spring
9 2 (0.68%) Twitter Bootstrap
Miscellaneous
1 47 (15.93%) Analytical Skills
2 22 (7.46%) Data Structures
3 16 (5.42%) Management Information System
4 7 (2.37%) Replication
5 6 (2.03%) Greenfield Project
6 5 (1.69%) Computer Science
6 5 (1.69%) Driving Licence
7 4 (1.36%) Algorithms
7 4 (1.36%) Renewable Energy
7 4 (1.36%) User Experience
8 3 (1.02%) Data Protection Act
8 3 (1.02%) Tandem
9 2 (0.68%) Mainframe
9 2 (0.68%) N-Tier
9 2 (0.68%) Taxonomies
10 1 (0.34%) Clustering
10 1 (0.34%) Data Centre
10 1 (0.34%) Fintech
10 1 (0.34%) Reference Data
Operating Systems
1 11 (3.73%) Linux
2 7 (2.37%) Unix
2 7 (2.37%) Windows
3 3 (1.02%) Windows Server
4 2 (0.68%) AIX
5 1 (0.34%) Solaris
Processes & Methodologies
1 241 (81.69%) Business Intelligence
2 157 (53.22%) ETL
3 103 (34.92%) Data Modelling
4 66 (22.37%) Analytics
5 59 (20.00%) Stakeholder Management
6 56 (18.98%) Agile Software Development
7 51 (17.29%) Data Management
8 41 (13.90%) Migration
9 38 (12.88%) Data Analysis
10 30 (10.17%) Visualisation
11 25 (8.47%) Kimball Methodology
12 24 (8.14%) Data Architecture
12 24 (8.14%) Data Integration
12 24 (8.14%) Data Migration
13 22 (7.46%) Mathematics
13 22 (7.46%) SDLC
14 21 (7.12%) CRM
15 18 (6.10%) ERP
16 17 (5.76%) Continuous Integration
17 15 (5.08%) Stakeholder Engagement
Programming Languages
1 224 (75.93%) SQL
2 102 (34.58%) T-SQL
3 33 (11.19%) C#
4 20 (6.78%) Python
5 17 (5.76%) Java
6 13 (4.41%) JavaScript
7 10 (3.39%) VBA
8 9 (3.05%) C
9 7 (2.37%) PL/SQL
10 6 (2.03%) PowerShell
10 6 (2.03%) R
11 2 (0.68%) Scala
12 1 (0.34%) Apex Code
12 1 (0.34%) C++
12 1 (0.34%) Ruby
12 1 (0.34%) Shell Script
12 1 (0.34%) VB.NET
12 1 (0.34%) X++
Qualifications
1 36 (12.20%) Degree
2 27 (9.15%) Security Cleared
3 25 (8.47%) SC Cleared
4 14 (4.75%) Numerate Degree
5 5 (1.69%) BC Cleared
5 5 (1.69%) ISEB
5 5 (1.69%) Microsoft Certification
6 4 (1.36%) MCPD
7 3 (1.02%) ISTQB
8 2 (0.68%) Computer Science Degree
9 1 (0.34%) APMP
9 1 (0.34%) DV Cleared
Quality Assurance & Compliance
1 34 (11.53%) QA
2 21 (7.12%) Data Quality
3 10 (3.39%) GCP
4 9 (3.05%) GDPR
5 4 (1.36%) Solvency II
6 3 (1.02%) PCI DSS
7 1 (0.34%) SLA
System Software
1 11 (3.73%) Oracle RAC
2 5 (1.69%) VMware Infrastructure
3 2 (0.68%) Docker
4 1 (0.34%) HDFS
4 1 (0.34%) Virtual Machines
Systems Management
1 1 (0.34%) Endace
1 1 (0.34%) Enterprise Manager Cloud Control
1 1 (0.34%) HP Data Protector
1 1 (0.34%) Oozie
1 1 (0.34%) Oracle Enterprise Manager
1 1 (0.34%) Systems Management Server (SMS)
Vendors
1 91 (30.85%) Microsoft
2 58 (19.66%) Tableau
3 27 (9.15%) Cognos
4 26 (8.81%) Oracle
5 23 (7.80%) SAP
6 14 (4.75%) IBM
7 7 (2.37%) Informatica
8 6 (2.03%) Google
8 6 (2.03%) Talend
8 6 (2.03%) VMware
9 5 (1.69%) Capita
10 4 (1.36%) BT
10 4 (1.36%) DataFlux
10 4 (1.36%) Teradata
11 3 (1.02%) Netezza
11 3 (1.02%) Salesforce.com
12 2 (0.68%) Hortonworks
12 2 (0.68%) Hyperion
12 2 (0.68%) IDERA
12 2 (0.68%) Nintex