Period
to 20 January 2018

The following table provides summary statistics for permanent job vacancies advertised in Gloucestershire 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 January 2018 with a comparison to the same period in the previous 2 years.

Data Warehousing
South West > Gloucestershire
6 months to
20 Jan 2018
Same period 2017 Same period 2016
Rank 82 135 100
Rank change year-on-year +53 -35 +10
Permanent jobs citing Data Warehouse 50 34 51
As % of all permanent IT jobs advertised in Gloucestershire 3.52% 1.52% 2.53%
As % of the Database & Business Intelligence category 10.10% 5.05% 8.33%
Number of salaries quoted 36 33 29
Gloucestershire median annual salary £42,500 £44,500 £39,500
Median salary % change year-on-year -4.49% +12.66% +5.33%
10th Percentile £27,500 £37,500 £28,500
90th Percentile £61,250 £83,750 £51,250
South West median annual salary £41,500 £45,000 £42,000
% change year-on-year -7.78% +7.14% -1.18%

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

All Database and Business Intelligence Skills
Gloucestershire
Permanent vacancies with a requirement for database or business intelligence skills 495 673 612
As % of all permanent IT jobs advertised in Gloucestershire 34.81% 30.14% 30.42%
Number of salaries quoted 424 558 481
Gloucestershire median annual salary £45,000 £45,000 £40,000
Median salary % change year-on-year - +12.50% +3.90%
10th Percentile £25,000 £31,250 £26,250
90th Percentile £60,000 £62,875 £65,000
South West median annual salary £41,000 £42,500 £39,060
% change year-on-year -3.53% +8.81% +4.16%

Data Warehouse
Job Vacancy Trend in Gloucestershire

Job postings citing Data Warehouse as a percentage of all IT jobs advertised in Gloucestershire.

Job vacancy trend for Data Warehouse in Gloucestershire

Data Warehouse
Salary Trend in Gloucestershire

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

Salary trend for Data Warehouse in Gloucestershire

Data Warehouse
Salary Histogram in Gloucestershire

The salary distribution of IT jobs citing Data Warehouse in Gloucestershire over the 6 months to 20 January 2018.

Salary histogram for Data Warehouse in Gloucestershire

Data Warehouse
Job Locations in Gloucestershire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Data Warehouse within the Gloucestershire region over the 6 months to 20 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
Cirencester - 22 £52,500 - 2
Gloucester +33 14 £42,500 +0.59% 3
Cheltenham +18 3 £57,500 -2.13%
Data Warehouse
South West

For the 6 months to 20 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 Gloucestershire region with a requirement for Data Warehouse.

1 41 (82.00%) SQL
2 36 (72.00%) Business Intelligence
3 29 (58.00%) Data Modelling
4 26 (52.00%) SQL Server
5 21 (42.00%) ETL
5 21 (42.00%) SQL Server Integration Services
6 20 (40.00%) Data Analysis
6 20 (40.00%) ERwin
6 20 (40.00%) Power BI
7 19 (38.00%) BusinessObjects
7 19 (38.00%) Data Management
8 18 (36.00%) Finance
9 16 (32.00%) Analytical Skills
10 14 (28.00%) Microsoft Excel
10 14 (28.00%) Tableau
11 13 (26.00%) Degree
12 12 (24.00%) Mathematics
12 12 (24.00%) Numerate Degree
13 11 (22.00%) Kimball Methodology
13 11 (22.00%) Migration
14 10 (20.00%) SQL Server Reporting Services
14 10 (20.00%) Microsoft Azure
14 10 (20.00%) Qlik Sense
15 9 (18.00%) Analytics
16 8 (16.00%) Statistical Modelling
16 8 (16.00%) SQL Server Analysis Services
16 8 (16.00%) Data Mapping
16 8 (16.00%) Data Architecture
16 8 (16.00%) Cognos
17 7 (14.00%) T-SQL

Data Warehouse
Co-occurring IT Skills in Gloucestershire 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 4 (8.00%) SAS
2 1 (2.00%) Confluence
2 1 (2.00%) WebLogic
2 1 (2.00%) WebSphere
Applications
1 14 (28.00%) Microsoft Excel
Business Applications
1 3 (6.00%) Cognos Business Intelligence
2 1 (2.00%) Oracle BPM
Cloud Services
1 10 (20.00%) Microsoft Azure
2 3 (6.00%) Amazon AWS
2 3 (6.00%) Azure Data Factory
3 1 (2.00%) Amazon SQS
Communications & Networking
1 3 (6.00%) SMS
Database & Business Intelligence
1 26 (52.00%) SQL Server
2 21 (42.00%) SQL Server Integration Services
3 20 (40.00%) Power BI
4 19 (38.00%) BusinessObjects
5 10 (20.00%) Qlik Sense
5 10 (20.00%) SQL Server Reporting Services
6 8 (16.00%) SQL Server Analysis Services
7 6 (12.00%) QlikView
8 5 (10.00%) SQL Server 2008
8 5 (10.00%) SQL Server 2012
9 4 (8.00%) Big Data
10 3 (6.00%) Amazon Redshift
10 3 (6.00%) Cognos Framework Manager
10 3 (6.00%) Cognos Report Studio
10 3 (6.00%) DecisionStream
10 3 (6.00%) IBM InfoSphere
10 3 (6.00%) Semantic Layer
11 2 (4.00%) MySQL
11 2 (4.00%) PostgreSQL
12 1 (2.00%) MySQL Workbench
Development Applications
1 20 (40.00%) ERwin
2 1 (2.00%) Atlassian Bamboo
2 1 (2.00%) Git (software)
2 1 (2.00%) JIRA
2 1 (2.00%) JMeter
2 1 (2.00%) LoadRunner
2 1 (2.00%) Selenium
2 1 (2.00%) SoapUI
General
1 18 (36.00%) Finance
2 7 (14.00%) Manufacturing
3 2 (4.00%) Advertising
3 2 (4.00%) Banking
3 2 (4.00%) Marketing
4 1 (2.00%) Electronics
4 1 (2.00%) Retail Banking
4 1 (2.00%) Telecoms
Job Titles
1 28 (56.00%) Analyst
2 21 (42.00%) Data Analyst
3 12 (24.00%) Developer
4 11 (22.00%) Business Intelligence Analyst
5 7 (14.00%) SQL Developer
6 6 (12.00%) Business Intelligence Developer
7 5 (10.00%) Financial Analyst
7 5 (10.00%) Senior Analyst
7 5 (10.00%) Senior Data Analyst
7 5 (10.00%) SQL Analyst
8 4 (8.00%) Business Intelligence Data Analyst
8 4 (8.00%) Data Quality Analyst
8 4 (8.00%) Quality Analyst
9 3 (6.00%) Cognos BI Developer
9 3 (6.00%) Cognos Developer
9 3 (6.00%) Senior Business Intelligence Analyst
9 3 (6.00%) Senior Financial Analyst
9 3 (6.00%) Team Leader
9 3 (6.00%) Technical Leader
9 3 (6.00%) Technical Team Leader
Libraries, Frameworks & Software Standards
1 3 (6.00%) REST
2 2 (4.00%) JSON
3 1 (2.00%) SOAP
3 1 (2.00%) Visualforce
3 1 (2.00%) XML
3 1 (2.00%) XSD
Miscellaneous
1 16 (32.00%) Analytical Skills
2 4 (8.00%) Algorithms
2 4 (8.00%) Greenfield Project
3 1 (2.00%) User Experience
Operating Systems
1 1 (2.00%) AIX
1 1 (2.00%) Linux
Processes & Methodologies
1 36 (72.00%) Business Intelligence
2 29 (58.00%) Data Modelling
3 21 (42.00%) ETL
4 20 (40.00%) Data Analysis
5 19 (38.00%) Data Management
6 12 (24.00%) Mathematics
7 11 (22.00%) Kimball Methodology
7 11 (22.00%) Migration
8 9 (18.00%) Analytics
9 8 (16.00%) Data Architecture
9 8 (16.00%) Data Mapping
9 8 (16.00%) Statistical Modelling
10 6 (12.00%) Data Governance
11 5 (10.00%) Agile Software Development
11 5 (10.00%) Business Analysis
11 5 (10.00%) Stakeholder Management
12 4 (8.00%) Data Integration
12 4 (8.00%) Visualisation
13 3 (6.00%) Data Visualisation
13 3 (6.00%) Translating Business Requirements
Programming Languages
1 41 (82.00%) SQL
2 7 (14.00%) T-SQL
3 3 (6.00%) PowerShell
3 3 (6.00%) U-SQL
4 1 (2.00%) Apex Code
4 1 (2.00%) C
4 1 (2.00%) C++
4 1 (2.00%) Java
4 1 (2.00%) Python
4 1 (2.00%) Shell Script
Qualifications
1 13 (26.00%) Degree
2 12 (24.00%) Numerate Degree
3 1 (2.00%) Security Cleared
Quality Assurance & Compliance
1 5 (10.00%) Data Quality
2 4 (8.00%) GDPR
2 4 (8.00%) QA
2 4 (8.00%) Solvency II
Vendors
1 14 (28.00%) Tableau
2 8 (16.00%) Cognos
3 6 (12.00%) Microsoft
4 5 (10.00%) IBM
5 4 (8.00%) DataFlux
6 3 (6.00%) Salesforce.com
7 2 (4.00%) Oracle
7 2 (4.00%) Teradata
8 1 (2.00%) SAP