Period
to 21 April 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 21 April 2018 with a comparison to the same period in the previous 2 years.

Data Warehousing
England > South West
6 months to
21 Apr 2018
Same period 2017 Same period 2016
Rank 131 169 97
Rank change year-on-year +38 -72 +8
Permanent jobs citing Data Warehouse 263 193 387
As % of all permanent IT jobs advertised in the South West 2.46% 1.89% 3.40%
As % of the Database & Business Intelligence category 7.52% 6.15% 9.76%
Number of salaries quoted 212 174 283
South West median annual salary £42,500 £42,500 £40,000
Median salary % change year-on-year - +6.25% -5.88%
10th Percentile £31,000 £32,500 £26,250
90th Percentile £58,625 £69,250 £58,750
England median annual salary £52,500 £52,500 £52,500

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,498 3,138 3,967
As % of all permanent IT jobs advertised in the South West 32.78% 30.77% 34.88%
Number of salaries quoted 2,969 2,703 3,379
South West median annual salary £42,500 £40,500 £40,000
Median salary % change year-on-year +4.94% +1.25% +6.67%
10th Percentile £27,500 £27,500 £26,250
90th Percentile £60,000 £62,500 £60,000
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 21 April 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 21 April 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 +6 95 £40,000 - 9
Wiltshire +2 49 £40,000 -15.79% 3
Gloucestershire +26 41 £53,750 +19.44% 5
Somerset +19 30 £38,500 -23.00% 6
Dorset -31 20 £42,500 +6.25% 2
Cornwall -8 19 £35,000 +12.90% 1
Devon +21 5 £45,000 +12.50% 4
Data Warehouse
England

For the 6 months to 21 April 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 195 (74.14%) Business Intelligence
2 187 (71.10%) SQL
3 161 (61.22%) SQL Server
4 142 (53.99%) ETL
5 120 (45.63%) SQL Server Integration Services
6 104 (39.54%) SQL Server Reporting Services
7 100 (38.02%) Microsoft
8 94 (35.74%) T-SQL
9 77 (29.28%) Power BI
10 67 (25.48%) SQL Server Analysis Services
11 66 (25.10%) Data Modelling
12 60 (22.81%) Analytics
12 60 (22.81%) Analytical Skills
13 56 (21.29%) Finance
14 52 (19.77%) Agile Software Development
15 48 (18.25%) Oracle
16 46 (17.49%) Microsoft Azure
17 43 (16.35%) BusinessObjects
18 42 (15.97%) Data Analysis
19 39 (14.83%) SQL Server 2012
19 39 (14.83%) Tableau
20 36 (13.69%) Big Data
20 36 (13.69%) SQL Server 2014
20 36 (13.69%) Microsoft Excel
21 35 (13.31%) Data Management
22 31 (11.79%) Amazon AWS
22 31 (11.79%) Data Integration
23 30 (11.41%) SQL Server 2016
23 30 (11.41%) Problem-Solving
23 30 (11.41%) Migration

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 22 (8.37%) SharePoint
2 11 (4.18%) BizTalk Server
3 7 (2.66%) Oracle SOA Suite
3 7 (2.66%) WebSphere
4 5 (1.90%) Apache Spark
4 5 (1.90%) SharePoint 2010
5 4 (1.52%) IIS
5 4 (1.52%) SharePoint Server
6 3 (1.14%) CMS
6 3 (1.14%) WebLogic
7 2 (0.76%) SAS
8 1 (0.38%) Apache
8 1 (0.38%) Confluence
8 1 (0.38%) Elasticsearch
8 1 (0.38%) Oracle 10gAS
8 1 (0.38%) SharePoint 2013
Applications
1 36 (13.69%) Microsoft Excel
2 4 (1.52%) Microsoft Office
2 4 (1.52%) Microsoft PowerPoint
2 4 (1.52%) Spreadsheet
3 1 (0.38%) InfoPath
Business Applications
1 11 (4.18%) Oracle EBS
1 11 (4.18%) Oracle EBS R12
2 7 (2.66%) Cognos Business Intelligence
3 4 (1.52%) Dynamics CRM
4 3 (1.14%) Cognos TM1
4 3 (1.14%) Oracle BPM
4 3 (1.14%) SAP Business ByDesign
4 3 (1.14%) SAP Business One
5 2 (0.76%) FastStats
5 2 (0.76%) FastStats PeopleStage
6 1 (0.38%) Dynamics AX
6 1 (0.38%) Oracle 11i
6 1 (0.38%) Oracle ERP
Cloud Services
1 46 (17.49%) Microsoft Azure
2 31 (11.79%) Amazon AWS
3 8 (3.04%) Office 365
4 7 (2.66%) Azure Data Factory
5 4 (1.52%) Google Cloud Platform
5 4 (1.52%) SaaS
6 3 (1.14%) Amazon EMR
7 2 (0.76%) Amazon Kinesis
7 2 (0.76%) Amazon Kinesis Data Analytics
7 2 (0.76%) Amazon S3
7 2 (0.76%) Azure Active Directory
7 2 (0.76%) Data Lake Analytics
7 2 (0.76%) PaaS
8 1 (0.38%) Amazon SQS
Communications & Networking
1 8 (3.04%) SMS
2 7 (2.66%) Intranet
3 2 (0.76%) Internet
4 1 (0.38%) HTTP
4 1 (0.38%) LAN
4 1 (0.38%) TCP/IP
Database & Business Intelligence
1 161 (61.22%) SQL Server
2 120 (45.63%) SQL Server Integration Services
3 104 (39.54%) SQL Server Reporting Services
4 77 (29.28%) Power BI
5 67 (25.48%) SQL Server Analysis Services
6 43 (16.35%) BusinessObjects
7 39 (14.83%) SQL Server 2012
8 36 (13.69%) Big Data
8 36 (13.69%) SQL Server 2014
9 30 (11.41%) SQL Server 2016
10 26 (9.89%) QlikView
10 26 (9.89%) Relational Database
11 22 (8.37%) SQL Server 2008
12 17 (6.46%) MySQL
13 16 (6.08%) Amazon Redshift
13 16 (6.08%) Oracle BI EE
14 15 (5.70%) Oracle Database
15 13 (4.94%) Oracle Database 11g
15 13 (4.94%) RDBMS
16 11 (4.18%) Oracle Database 10g
Development Applications
1 20 (7.60%) Team Foundation Server
2 18 (6.84%) ERwin
3 14 (5.32%) Visual Studio
4 10 (3.80%) SQL Server Management Studio (SSMS)
5 4 (1.52%) Toad
6 3 (1.14%) JMeter
6 3 (1.14%) LoadRunner
6 3 (1.14%) Selenium
6 3 (1.14%) SoapUI
7 2 (0.76%) Git (software)
8 1 (0.38%) Atlassian Bamboo
8 1 (0.38%) JIRA
General
1 56 (21.29%) Finance
2 9 (3.42%) Advertising
2 9 (3.42%) Manufacturing
3 7 (2.66%) Law
3 7 (2.66%) Marketing
4 4 (1.52%) Electronics
4 4 (1.52%) Telecoms
5 3 (1.14%) Banking
5 3 (1.14%) French Language
6 2 (0.76%) Legal
7 1 (0.38%) Aerospace
7 1 (0.38%) Automotive
7 1 (0.38%) Publishing
7 1 (0.38%) Retail
Job Titles
1 143 (54.37%) Developer
2 88 (33.46%) Business Intelligence Developer
3 55 (20.91%) Analyst
4 43 (16.35%) SQL Developer
5 32 (12.17%) SQL BI Developer
6 28 (10.65%) Data Analyst
7 23 (8.75%) Data Warehouse Developer
8 22 (8.37%) Business Developer
9 19 (7.22%) Business Intelligence Analyst
9 19 (7.22%) Senior Analyst
10 17 (6.46%) Architect
11 16 (6.08%) SQL Server BI Developer
11 16 (6.08%) SQL Server Developer
12 15 (5.70%) Consultant
13 14 (5.32%) Data Architect
13 14 (5.32%) DBA
14 13 (4.94%) SSIS Developer
15 12 (4.56%) SSRS Developer
16 11 (4.18%) T-SQL Developer
17 10 (3.80%) OBIEE Developer
Libraries, Frameworks & Software Standards
1 24 (9.13%) Web Services
2 22 (8.37%) REST
3 18 (6.84%) .NET
4 14 (5.32%) SOAP
5 10 (3.80%) RESTful
6 8 (3.04%) HTML
6 8 (3.04%) XML
7 7 (2.66%) .NET Framework
8 5 (1.90%) JSON
9 4 (1.52%) WCF
10 3 (1.14%) Kafka
10 3 (1.14%) WebSphere MQ
10 3 (1.14%) XSD
11 2 (0.76%) Hibernate
11 2 (0.76%) Java Concurrency
11 2 (0.76%) MDX
11 2 (0.76%) Spring
12 1 (0.38%) J2EE
12 1 (0.38%) Oracle Fusion
12 1 (0.38%) Visualforce
Miscellaneous
1 60 (22.81%) Analytical Skills
2 21 (7.98%) Management Information System
3 11 (4.18%) Enterprise Software
4 8 (3.04%) Self-Motivation
5 7 (2.66%) Data Structures
5 7 (2.66%) Virtual Team
6 6 (2.28%) Computer Science
6 6 (2.28%) Driving Licence
6 6 (2.28%) User Experience
7 4 (1.52%) Clustering
7 4 (1.52%) Data Centre
7 4 (1.52%) Greenfield Project
7 4 (1.52%) NHS
8 3 (1.14%) Algorithms
9 2 (0.76%) Marketing Technology
10 1 (0.38%) Digital Media
10 1 (0.38%) Digital TV
10 1 (0.38%) Fintech
10 1 (0.38%) Mainframe
10 1 (0.38%) Social Media
Operating Systems
1 22 (8.37%) Linux
2 12 (4.56%) Unix
3 9 (3.42%) Windows
4 3 (1.14%) AIX
4 3 (1.14%) Oracle Linux
4 3 (1.14%) Windows Server
Processes & Methodologies
1 195 (74.14%) Business Intelligence
2 142 (53.99%) ETL
3 66 (25.10%) Data Modelling
4 60 (22.81%) Analytics
5 52 (19.77%) Agile Software Development
6 42 (15.97%) Data Analysis
7 35 (13.31%) Data Management
8 31 (11.79%) Data Integration
9 30 (11.41%) Migration
9 30 (11.41%) Problem-Solving
10 29 (11.03%) CRM
11 26 (9.89%) Decision-Making
11 26 (9.89%) ERP
12 22 (8.37%) Scrum
12 22 (8.37%) Stakeholder Management
13 21 (7.98%) Kimball Methodology
13 21 (7.98%) SDLC
13 21 (7.98%) Visualisation
14 17 (6.46%) Data Science
14 17 (6.46%) ITIL
Programming Languages
1 187 (71.10%) SQL
2 94 (35.74%) T-SQL
3 29 (11.03%) C#
4 20 (7.60%) Java
5 19 (7.22%) PL/SQL
5 19 (7.22%) Python
6 10 (3.80%) VBA
7 8 (3.04%) Shell Script
8 7 (2.66%) C
9 5 (1.90%) U-SQL
10 4 (1.52%) C++
10 4 (1.52%) PHP
10 4 (1.52%) PowerShell
10 4 (1.52%) VB.NET
11 3 (1.14%) R
12 2 (0.76%) Java 8
12 2 (0.76%) Scala
13 1 (0.38%) Apex Code
13 1 (0.38%) Data Analysis Expressions (DAX)
13 1 (0.38%) Ruby
Qualifications
1 22 (8.37%) Degree
1 22 (8.37%) Security Cleared
2 14 (5.32%) Microsoft Certification
3 11 (4.18%) Postgraduate
4 10 (3.80%) SC Cleared
5 7 (2.66%) ITIL Certification
6 6 (2.28%) Numerate Degree
7 4 (1.52%) BPSS Clearance
7 4 (1.52%) DV Cleared
8 2 (0.76%) Computer Science Degree
9 1 (0.38%) ISEB
9 1 (0.38%) Sun Certification
9 1 (0.38%) TOGAF Certification
Quality Assurance & Compliance
1 23 (8.75%) Data Quality
2 9 (3.42%) QA
3 5 (1.90%) GDPR
4 2 (0.76%) GCP
4 2 (0.76%) Solvency II
5 1 (0.38%) HL7
5 1 (0.38%) SLA
5 1 (0.38%) SNOMED CT
System Software
1 5 (1.90%) Active Directory
1 5 (1.90%) VMware Infrastructure
2 3 (1.14%) Docker
3 1 (0.38%) Oracle RAC
3 1 (0.38%) Virtual Machines
Systems Management
1 4 (1.52%) Endace
1 4 (1.52%) HP Data Protector
2 1 (0.38%) Enterprise Manager Cloud Control
2 1 (0.38%) Kubernetes
2 1 (0.38%) Oracle Enterprise Manager
2 1 (0.38%) Single Sign-On
2 1 (0.38%) Systems Management Server (SMS)
Vendors
1 100 (38.02%) Microsoft
2 48 (18.25%) Oracle
3 39 (14.83%) Tableau
4 30 (11.41%) SAP
5 22 (8.37%) Cognos
6 14 (5.32%) IBM
6 14 (5.32%) Informatica
7 11 (4.18%) Siebel
8 6 (2.28%) Google
9 5 (1.90%) Salesforce.com
9 5 (1.90%) VMware
10 4 (1.52%) HP
10 4 (1.52%) Talend
11 3 (1.14%) Citrix
11 3 (1.14%) IFS
11 3 (1.14%) Teradata
12 2 (0.76%) BT
12 2 (0.76%) Capita
12 2 (0.76%) MicroStrategy
12 2 (0.76%) Nintex