Period
to 5 December 2019

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

Data Warehousing
England > South West
6 months to
5 Dec 2019
Same period 2018 Same period 2017
Rank 141 127 122
Rank change year-on-year -14 -5 +54
Permanent jobs citing Data Warehouse 201 243 296
As % of all permanent IT jobs advertised in the South West 2.09% 2.38% 2.90%
As % of the Database & Business Intelligence category 7.96% 8.49% 8.92%
Number of salaries quoted 190 212 223
South West median annual salary £50,000 £52,500 £42,500
Median salary % change year-on-year -4.76% +23.53% -
10th Percentile £36,200 £32,500 £31,286
90th Percentile £69,199 £78,625 £59,750
England median annual salary £57,275 £55,000 £52,500
% change year-on-year +4.14% +4.76% -4.55%

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 2,525 2,863 3,317
As % of all permanent IT jobs advertised in the South West 26.23% 28.05% 32.53%
Number of salaries quoted 2,127 2,464 2,824
South West median annual salary £45,000 £44,500 £40,000
Median salary % change year-on-year +1.12% +11.25% -2.44%
10th Percentile £27,500 £27,500 £26,250
90th Percentile £63,750 £67,500 £60,000
England median annual salary £52,500 £52,500 £50,000
% change year-on-year - +5.00% +5.26%

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 5 December 2019.

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 5 December 2019. 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 +18 80 £50,000 +0.50% 14
Wiltshire -12 70 £51,750 -16.72% 9
Somerset +15 20 £42,500 - 3
Gloucestershire -33 19 £43,750 -27.08% 2
Dorset -6 10 £50,550 +12.33% 3
Cornwall +8 1 £37,500 +29.31% 1
Devon -12 1 £36,500 - 1
Data Warehouse
England

For the 6 months to 5 December 2019, 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 145 (72.14%) SQL
2 138 (68.66%) Business Intelligence
3 91 (45.27%) Agile Software Development
4 89 (44.28%) ETL
5 87 (43.28%) Analytics
6 81 (40.30%) Tableau
7 76 (37.81%) Visualisation
8 67 (33.33%) SQL Server Integration Services
9 66 (32.84%) Analytical Skills
10 61 (30.35%) Python
11 58 (28.86%) SQL Server
12 53 (26.37%) Hadoop
13 47 (23.38%) Finance
14 45 (22.39%) Data Modelling
15 44 (21.89%) Data Visualisation
16 43 (21.39%) Big Data
16 43 (21.39%) Power BI
16 43 (21.39%) Power Platform
17 42 (20.90%) SQL Server Reporting Services
18 41 (20.40%) Microsoft
18 41 (20.40%) Teradata
19 39 (19.40%) Data Science
20 37 (18.41%) R
21 33 (16.42%) Retail
21 33 (16.42%) Informatica
22 30 (14.93%) Azure
23 29 (14.43%) SQL Server Analysis Services
23 29 (14.43%) Data Integration
24 28 (13.93%) CRM
25 27 (13.43%) Data Lake

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 25 (12.44%) Apache Spark
2 9 (4.48%) BizTalk Server
3 7 (3.48%) SharePoint
4 2 (1.00%) Apache
4 2 (1.00%) Oracle Application Server
4 2 (1.00%) Oracle Spatial
4 2 (1.00%) SAS
5 1 (0.50%) Elasticsearch
5 1 (0.50%) NServiceBus
Applications
1 9 (4.48%) Microsoft Excel
2 2 (1.00%) SPSS
Business Applications
1 1 (0.50%) Remedy ITSM
Cloud Services
1 43 (21.39%) Power Platform
2 30 (14.93%) Azure
3 23 (11.44%) AWS
3 23 (11.44%) GCP
4 4 (1.99%) Azure Data Factory
4 4 (1.99%) WeChat
5 1 (0.50%) Azure Stack
5 1 (0.50%) Dynamics 365
5 1 (0.50%) PaaS
Communications & Networking
1 2 (1.00%) Internet
1 2 (1.00%) NAS
1 2 (1.00%) SAN
Database & Business Intelligence
1 67 (33.33%) SQL Server Integration Services
2 58 (28.86%) SQL Server
3 53 (26.37%) Hadoop
4 43 (21.39%) Big Data
4 43 (21.39%) Power BI
5 42 (20.90%) SQL Server Reporting Services
6 29 (14.43%) SQL Server Analysis Services
7 27 (13.43%) Data Lake
8 23 (11.44%) Amazon Redshift
8 23 (11.44%) BigQuery
9 19 (9.45%) Looker
9 19 (9.45%) QlikView
9 19 (9.45%) Relational Database
10 15 (7.46%) Apache Hive
11 14 (6.97%) Snowflake Schema
12 12 (5.97%) BusinessObjects
13 10 (4.98%) MySQL
14 9 (4.48%) Bigtable
14 9 (4.48%) Oracle Reports
15 8 (3.98%) Enterprise Data Warehouse
Development Applications
1 14 (6.97%) Cucumber
2 12 (5.97%) Jenkins
3 9 (4.48%) Team Foundation Server
4 4 (1.99%) Git (software)
4 4 (1.99%) JIRA
4 4 (1.99%) Selenium
5 3 (1.49%) SQL Server Management Studio (SSMS)
6 2 (1.00%) Subversion
7 1 (0.50%) Octopus Deploy
7 1 (0.50%) ProC
7 1 (0.50%) TeamCity
General
1 47 (23.38%) Finance
2 33 (16.42%) Retail
3 25 (12.44%) Banking
4 17 (8.46%) Marketing
5 13 (6.47%) Manufacturing
6 12 (5.97%) Electronics
6 12 (5.97%) Public Sector
6 12 (5.97%) Telecoms
7 9 (4.48%) Automotive
8 1 (0.50%) Advertising
8 1 (0.50%) German Language
8 1 (0.50%) Housing Association
8 1 (0.50%) Law
8 1 (0.50%) Police
8 1 (0.50%) Retail Banking
Job Titles
1 78 (38.81%) Developer
2 58 (28.86%) Business Intelligence Developer
3 37 (18.41%) Data Engineer
4 31 (15.42%) Analyst
5 29 (14.43%) Business Developer
6 22 (10.95%) Senior Business Intelligence Developer
6 22 (10.95%) Senior Developer
7 19 (9.45%) Data Analyst
8 13 (6.47%) Architect
8 13 (6.47%) SQL Developer
9 12 (5.97%) DBA
10 11 (5.47%) Data Architect
11 9 (4.48%) Data Warehouse Developer
12 8 (3.98%) Administrator
12 8 (3.98%) Business Intelligence Analyst
13 7 (3.48%) Consultant
13 7 (3.48%) Tableau Developer
14 6 (2.99%) Analytics Manager
14 6 (2.99%) Insight Manager
14 6 (2.99%) Senior Data Engineer
Libraries, Frameworks & Software Standards
1 13 (6.47%) REST
2 11 (5.47%) FusionCharts
3 9 (4.48%) JSON
4 8 (3.98%) Web Services
5 7 (3.48%) MDX
6 6 (2.99%) Node.js
6 6 (2.99%) SOAP
7 5 (2.49%) XML
8 4 (1.99%) .NET
9 3 (1.49%) Apache NiFi
9 3 (1.49%) XSD
9 3 (1.49%) XSLT
10 2 (1.00%) Kafka
10 2 (1.00%) LDAP
11 1 (0.50%) AngularJS
11 1 (0.50%) RESTful
11 1 (0.50%) Samza
11 1 (0.50%) YAML
Miscellaneous
1 66 (32.84%) Analytical Skills
2 13 (6.47%) Management Information System
3 4 (1.99%) Clustering
3 4 (1.99%) Social Media
4 3 (1.49%) Algorithms
5 2 (1.00%) Data Structures
5 2 (1.00%) Enterprise Software
5 2 (1.00%) Replication
6 1 (0.50%) Data Centre
6 1 (0.50%) Greenfield Project
6 1 (0.50%) NHS
6 1 (0.50%) Self-Motivation
6 1 (0.50%) Virtual Team
Operating Systems
1 4 (1.99%) Linux
2 3 (1.49%) Unix
2 3 (1.49%) Windows
2 3 (1.49%) Windows Server
3 2 (1.00%) AIX
3 2 (1.00%) Red Hat Enterprise Linux
3 2 (1.00%) Windows Server 2003
3 2 (1.00%) Windows Server 2008
Processes & Methodologies
1 138 (68.66%) Business Intelligence
2 91 (45.27%) Agile Software Development
3 89 (44.28%) ETL
4 87 (43.28%) Analytics
5 76 (37.81%) Visualisation
6 45 (22.39%) Data Modelling
7 44 (21.89%) Data Visualisation
8 39 (19.40%) Data Science
9 29 (14.43%) Data Integration
10 28 (13.93%) CRM
11 27 (13.43%) Decision-Making
12 26 (12.94%) Dimensional Modelling
13 25 (12.44%) Data Strategy
14 24 (11.94%) Data Analytics
15 23 (11.44%) Data Analysis
16 21 (10.45%) DevOps
16 21 (10.45%) Scrum
17 19 (9.45%) Data Architecture
18 18 (8.96%) Data Transformation
18 18 (8.96%) Machine Learning
Programming Languages
1 145 (72.14%) SQL
2 61 (30.35%) Python
3 37 (18.41%) R
4 23 (11.44%) T-SQL
5 17 (8.46%) Scala
6 14 (6.97%) Java
7 9 (4.48%) HiveQL
8 5 (2.49%) C#
8 5 (2.49%) Go
8 5 (2.49%) PL/SQL
9 2 (1.00%) Bash Shell
9 2 (1.00%) C
10 1 (0.50%) PowerShell
10 1 (0.50%) VB
10 1 (0.50%) VBA
Qualifications
1 6 (2.99%) Degree
2 4 (1.99%) Security Cleared
3 3 (1.49%) DV Cleared
4 2 (1.00%) SC Cleared
5 1 (0.50%) PRINCE2 Certification
Quality Assurance & Compliance
1 10 (4.98%) Data Quality
2 9 (4.48%) GDPR
3 4 (1.99%) ISO/IEC 27001
4 1 (0.50%) QA
4 1 (0.50%) SLA
System Software
1 17 (8.46%) Docker
2 3 (1.49%) VMware Infrastructure
3 2 (1.00%) Active Directory
3 2 (1.00%) Oracle Clusterware
3 2 (1.00%) Oracle RAC
4 1 (0.50%) Apache Flume
Systems Management
1 6 (2.99%) Kubernetes
2 2 (1.00%) Data Guard
2 2 (1.00%) Enterprise Manager Cloud Control
2 2 (1.00%) Oracle Flashback
2 2 (1.00%) Oracle RMAN
2 2 (1.00%) Single Sign-On
3 1 (0.50%) Chukwa
3 1 (0.50%) Hadoop YARN
Vendors
1 81 (40.30%) Tableau
2 41 (20.40%) Microsoft
2 41 (20.40%) Teradata
3 33 (16.42%) Informatica
4 23 (11.44%) Google
5 21 (10.45%) Talend
6 18 (8.96%) Oracle
6 18 (8.96%) SAP
7 8 (3.98%) Ab Initio
7 8 (3.98%) Netezza
8 5 (2.49%) Apple
8 5 (2.49%) Cloudera
9 4 (1.99%) Cognos
9 4 (1.99%) Twitter
9 4 (1.99%) YouTube
10 3 (1.49%) Alteryx
10 3 (1.49%) Remedy
10 3 (1.49%) VMware
11 2 (1.00%) Hortonworks
11 2 (1.00%) SnapLogic