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

Data Warehousing
England > South West
6 months to
21 Jan 2018
Same period 2017 Same period 2016
Rank 116 192 102
Rank change year-on-year +76 -90 +34
Permanent jobs citing Data Warehouse 291 162 349
As % of all permanent IT jobs advertised in the South West 2.91% 1.55% 3.03%
As % of the Database & Business Intelligence category 8.58% 5.12% 9.09%
Number of salaries quoted 231 147 273
South West median annual salary £41,500 £45,000 £41,500
Median salary % change year-on-year -7.78% +8.43% -2.35%
10th Percentile £31,250 £29,200 £26,750
90th Percentile £58,750 £70,000 £60,000
England median annual salary £51,000 £55,000 £50,000
% change year-on-year -7.27% +10.00% -5.66%

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,390 3,164 3,839
As % of all permanent IT jobs advertised in the South West 33.89% 30.33% 33.31%
Number of salaries quoted 2,896 2,699 3,323
South West median annual salary £41,000 £42,500 £39,000
Median salary % change year-on-year -3.53% +8.97% +4.00%
10th Percentile £27,500 £27,500 £26,250
90th Percentile £60,000 £63,750 £60,000
England median annual salary £50,000 £47,500 £46,000
% change year-on-year +5.26% +3.26% +2.22%

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 January 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 January 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 +17 100 £40,000 -5.88% 21
Gloucestershire +55 50 £42,500 -4.49% 7
Somerset +20 40 £38,500 -14.44% 1
Wiltshire +15 38 £40,000 -20.00% 4
Dorset +3 34 £42,500 -39.29% 3
Cornwall -18 7 £35,000 -30.00%
Devon +16 6 £50,000 +69.49% 3
Data Warehouse
England

For the 6 months to 21 January 2018, 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 233 (80.07%) Business Intelligence
2 223 (76.63%) SQL
3 172 (59.11%) SQL Server
4 162 (55.67%) ETL
4 162 (55.67%) SQL Server Integration Services
5 144 (49.48%) SQL Server Reporting Services
6 113 (38.83%) T-SQL
7 100 (34.36%) Microsoft
8 98 (33.68%) Data Modelling
9 86 (29.55%) Power BI
10 84 (28.87%) SQL Server Analysis Services
11 74 (25.43%) Finance
12 70 (24.05%) Analytics
13 60 (20.62%) Agile Software Development
14 59 (20.27%) Tableau
14 59 (20.27%) Microsoft Azure
15 56 (19.24%) BusinessObjects
16 52 (17.87%) Analytical Skills
17 51 (17.53%) QlikView
18 49 (16.84%) Stakeholder Management
19 44 (15.12%) SQL Server 2014
20 42 (14.43%) Microsoft Excel
20 42 (14.43%) Data Management
21 41 (14.09%) Data Analysis
22 40 (13.75%) Migration
23 39 (13.40%) SQL Server 2012
24 37 (12.71%) C#
25 33 (11.34%) Degree
25 33 (11.34%) Visualisation
26 29 (9.97%) QA

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 (7.90%) SharePoint
2 6 (2.06%) SharePoint 2010
3 4 (1.37%) Apache Spark
3 4 (1.37%) IIS
3 4 (1.37%) SAS
3 4 (1.37%) SharePoint 2013
4 3 (1.03%) CMS
5 2 (0.69%) Kentico
6 1 (0.34%) Apache
6 1 (0.34%) Confluence
6 1 (0.34%) Oracle 10gAS
6 1 (0.34%) WebLogic
6 1 (0.34%) WebSphere
Applications
1 42 (14.43%) Microsoft Excel
2 6 (2.06%) Microsoft Office
3 5 (1.72%) MS Visio
4 1 (0.34%) InfoPath
4 1 (0.34%) Spreadsheet
4 1 (0.34%) SPSS
4 1 (0.34%) SPSS Modeler
Business Applications
1 6 (2.06%) Cognos Business Intelligence
2 5 (1.72%) SAP Business ByDesign
2 5 (1.72%) SAP Business One
3 3 (1.03%) Dynamics NAV
3 3 (1.03%) Maximo
3 3 (1.03%) Oracle EBS
3 3 (1.03%) Oracle EBS R12
4 2 (0.69%) Dynamics AX
5 1 (0.34%) Oracle 11i
5 1 (0.34%) Oracle BPM
5 1 (0.34%) Oracle ERP
5 1 (0.34%) SAP BPC
Cloud Services
1 59 (20.27%) Microsoft Azure
2 26 (8.93%) Amazon AWS
3 7 (2.41%) Google Cloud Platform
4 5 (1.72%) Azure Data Factory
5 3 (1.03%) Office 365
6 2 (0.69%) Amazon EMR
6 2 (0.69%) Amazon Kinesis
6 2 (0.69%) Amazon Kinesis Data Analytics
6 2 (0.69%) Amazon S3
6 2 (0.69%) Cloud Computing
6 2 (0.69%) IaaS
6 2 (0.69%) PaaS
7 1 (0.34%) Amazon SQS
7 1 (0.34%) Cortana Intelligence Suite
Communications & Networking
1 5 (1.72%) SMS
2 2 (0.69%) Internet
3 1 (0.34%) HTTP
3 1 (0.34%) LAN
3 1 (0.34%) Skype
3 1 (0.34%) TCP/IP
Database & Business Intelligence
1 172 (59.11%) SQL Server
2 162 (55.67%) SQL Server Integration Services
3 144 (49.48%) SQL Server Reporting Services
4 86 (29.55%) Power BI
5 84 (28.87%) SQL Server Analysis Services
6 56 (19.24%) BusinessObjects
7 51 (17.53%) QlikView
8 44 (15.12%) SQL Server 2014
9 39 (13.40%) SQL Server 2012
10 24 (8.25%) Enterprise Data Warehouse
10 24 (8.25%) SQL Server 2016
11 21 (7.22%) Crystal Reports
12 20 (6.87%) Big Data
13 18 (6.19%) SQL Server 2008
14 16 (5.50%) PostgreSQL
15 15 (5.15%) Data Mining
15 15 (5.15%) Relational Database
16 14 (4.81%) OLAP
16 14 (4.81%) Semantic Layer
17 13 (4.47%) Qlik Sense
Development Applications
1 27 (9.28%) ERwin
1 27 (9.28%) Team Foundation Server
2 24 (8.25%) Visual Studio
3 10 (3.44%) SQL Server Management Studio (SSMS)
4 6 (2.06%) Oracle Forms
4 6 (2.06%) Toad
5 2 (0.69%) Git (software)
6 1 (0.34%) Atlassian Bamboo
6 1 (0.34%) JIRA
6 1 (0.34%) JMeter
6 1 (0.34%) LoadRunner
6 1 (0.34%) RStudio
6 1 (0.34%) Selenium
6 1 (0.34%) SoapUI
General
1 74 (25.43%) Finance
2 14 (4.81%) Banking
3 13 (4.47%) Manufacturing
4 9 (3.09%) Advertising
5 7 (2.41%) Retail
6 6 (2.06%) Marketing
7 5 (1.72%) Electronics
7 5 (1.72%) French Language
7 5 (1.72%) Telecoms
8 2 (0.69%) Retail Banking
9 1 (0.34%) Automotive
9 1 (0.34%) Back Office
9 1 (0.34%) Law
9 1 (0.34%) Publishing
Job Titles
1 160 (54.98%) Developer
2 97 (33.33%) Business Intelligence Developer
3 49 (16.84%) Analyst
4 42 (14.43%) SQL Developer
5 38 (13.06%) Business Developer
6 30 (10.31%) Data Analyst
7 28 (9.62%) SQL BI Developer
8 26 (8.93%) Data Warehouse Developer
9 20 (6.87%) Consultant
10 19 (6.53%) Business Intelligence Analyst
10 19 (6.53%) SQL Server BI Developer
10 19 (6.53%) SQL Server Developer
10 19 (6.53%) SSIS Developer
11 18 (6.19%) Architect
11 18 (6.19%) SSRS Developer
12 14 (4.81%) Data Architect
13 13 (4.47%) Business Intelligence Consultant
14 12 (4.12%) QlikView Developer
15 11 (3.78%) DBA
16 10 (3.44%) Microsoft BI Developer
Libraries, Frameworks & Software Standards
1 18 (6.19%) REST
2 16 (5.50%) .NET
3 15 (5.15%) Web Services
4 11 (3.78%) .NET Framework
5 8 (2.75%) JSON
6 7 (2.41%) MDX
6 7 (2.41%) RESTful
7 6 (2.06%) SOAP
8 5 (1.72%) ASP.NET
8 5 (1.72%) CSS
8 5 (1.72%) HTML
8 5 (1.72%) XML
9 3 (1.03%) AngularJS
9 3 (1.03%) ASP.NET MVC
10 2 (0.69%) Entity Framework
10 2 (0.69%) Java Concurrency
10 2 (0.69%) jQuery
10 2 (0.69%) Spring
10 2 (0.69%) Twitter Bootstrap
10 2 (0.69%) WCF
Miscellaneous
1 52 (17.87%) Analytical Skills
2 12 (4.12%) Data Structures
3 10 (3.44%) Management Information System
4 9 (3.09%) Greenfield Project
5 5 (1.72%) Driving Licence
6 4 (1.37%) Algorithms
6 4 (1.37%) User Experience
7 2 (0.69%) Clustering
7 2 (0.69%) Computer Science
7 2 (0.69%) Fintech
7 2 (0.69%) Mainframe
7 2 (0.69%) N-Tier
7 2 (0.69%) Taxonomies
8 1 (0.34%) Digital Media
8 1 (0.34%) Digital TV
8 1 (0.34%) Media Streaming
8 1 (0.34%) Reference Data
8 1 (0.34%) Social Media
Operating Systems
1 11 (3.78%) Linux
2 7 (2.41%) Unix
3 5 (1.72%) Windows
4 2 (0.69%) AIX
4 2 (0.69%) Windows Server
Processes & Methodologies
1 233 (80.07%) Business Intelligence
2 162 (55.67%) ETL
3 98 (33.68%) Data Modelling
4 70 (24.05%) Analytics
5 60 (20.62%) Agile Software Development
6 49 (16.84%) Stakeholder Management
7 42 (14.43%) Data Management
8 41 (14.09%) Data Analysis
9 40 (13.75%) Migration
10 33 (11.34%) Visualisation
11 27 (9.28%) Data Integration
12 25 (8.59%) SDLC
13 24 (8.25%) CRM
14 23 (7.90%) Data Migration
15 22 (7.56%) Kimball Methodology
16 21 (7.22%) Mathematics
17 19 (6.53%) ERP
18 18 (6.19%) Continuous Integration
19 17 (5.84%) Dimensional Modelling
19 17 (5.84%) Scrum
Programming Languages
1 223 (76.63%) SQL
2 113 (38.83%) T-SQL
3 37 (12.71%) C#
4 14 (4.81%) Python
5 12 (4.12%) Java
5 12 (4.12%) JavaScript
6 10 (3.44%) VBA
7 9 (3.09%) PL/SQL
7 9 (3.09%) PowerShell
8 8 (2.75%) C
9 5 (1.72%) R
10 3 (1.03%) U-SQL
11 2 (0.69%) C++
11 2 (0.69%) Scala
11 2 (0.69%) Shell Script
12 1 (0.34%) Apex Code
12 1 (0.34%) Ruby
12 1 (0.34%) X++
Qualifications
1 33 (11.34%) Degree
2 23 (7.90%) Security Cleared
3 20 (6.87%) SC Cleared
4 13 (4.47%) Numerate Degree
5 5 (1.72%) Microsoft Certification
6 3 (1.03%) BC Cleared
6 3 (1.03%) MCPD
7 2 (0.69%) Computer Science Degree
7 2 (0.69%) DV Cleared
7 2 (0.69%) ISEB
8 1 (0.34%) APMP
8 1 (0.34%) Sun Certification
Quality Assurance & Compliance
1 29 (9.97%) QA
2 18 (6.19%) Data Quality
3 5 (1.72%) GDPR
4 4 (1.37%) Solvency II
5 2 (0.69%) GCP
6 1 (0.34%) SLA
System Software
1 7 (2.41%) Oracle RAC
2 6 (2.06%) VMware Infrastructure
3 3 (1.03%) Docker
4 1 (0.34%) Virtual Machines
Systems Management
1 2 (0.69%) Endace
1 2 (0.69%) HP Data Protector
1 2 (0.69%) Systems Management Server (SMS)
2 1 (0.34%) Enterprise Manager Cloud Control
2 1 (0.34%) Kubernetes
2 1 (0.34%) Oracle Enterprise Manager
Vendors
1 100 (34.36%) Microsoft
2 59 (20.27%) Tableau
3 27 (9.28%) Oracle
4 22 (7.56%) Cognos
5 17 (5.84%) SAP
6 13 (4.47%) IBM
7 9 (3.09%) Informatica
8 7 (2.41%) Google
9 6 (2.06%) Talend
9 6 (2.06%) VMware
10 4 (1.37%) BT
10 4 (1.37%) DataFlux
10 4 (1.37%) Teradata
11 3 (1.03%) Netezza
11 3 (1.03%) Salesforce.com
11 3 (1.03%) Siebel
12 2 (0.69%) Capita
12 2 (0.69%) Hortonworks
12 2 (0.69%) HP
12 2 (0.69%) Hyperion