Period
to 7 December 2019

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

Data Warehousing
England > Yorkshire
6 months to
7 Dec 2019
Same period 2018 Same period 2017
Rank 118 92 72
Rank change year-on-year -26 -20 +33
Permanent jobs citing Data Warehouse 156 237 338
As % of all permanent IT jobs advertised in Yorkshire 2.40% 2.94% 3.47%
As % of the Database & Business Intelligence category 9.65% 11.42% 12.23%
Number of salaries quoted 139 213 292
Yorkshire median annual salary £45,000 £47,500 £45,000
Median salary % change year-on-year -5.26% +5.56% -
10th Percentile £27,590 £31,505 £31,250
90th Percentile £63,000 £72,500 £60,000
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 Yorkshire with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
Yorkshire
Permanent vacancies with a requirement for database or business intelligence skills 1,617 2,075 2,763
As % of all permanent IT jobs advertised in Yorkshire 24.92% 25.75% 28.37%
Number of salaries quoted 1,404 1,746 2,397
Yorkshire median annual salary £45,000 £42,500 £42,500
Median salary % change year-on-year +5.88% - +6.25%
10th Percentile £29,000 £27,750 £27,000
90th Percentile £63,750 £57,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 Yorkshire

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

Job vacancy trend for Data Warehouse in Yorkshire

Data Warehouse
Salary Trend in Yorkshire

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

Salary trend for Data Warehouse in Yorkshire

Data Warehouse
Salary Histogram in Yorkshire

The salary distribution of IT jobs citing Data Warehouse in Yorkshire over the 6 months to 7 December 2019.

Salary histogram for Data Warehouse in Yorkshire

Data Warehouse
Job Locations in Yorkshire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Data Warehouse within the Yorkshire region over the 6 months to 7 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
West Yorkshire -18 99 £46,456 -2.20% 27
South Yorkshire +18 34 £44,000 +34.87% 6
North Yorkshire -36 17 £35,000 -30.00% 3
Data Warehouse
England

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

1 112 (71.79%) Business Intelligence
2 104 (66.67%) SQL
3 78 (50.00%) SQL Server
3 78 (50.00%) Power BI
3 78 (50.00%) Power Platform
4 75 (48.08%) ETL
5 70 (44.87%) Microsoft
6 56 (35.90%) SQL Server Integration Services
7 47 (30.13%) Data Modelling
7 47 (30.13%) T-SQL
8 45 (28.85%) Agile Software Development
9 42 (26.92%) SQL Server Reporting Services
10 37 (23.72%) Analytics
11 36 (23.08%) Azure
12 31 (19.87%) SQL Server Analysis Services
12 31 (19.87%) Finance
13 24 (15.38%) Visualisation
14 21 (13.46%) Big Data
15 20 (12.82%) Python
15 20 (12.82%) Star Schema
15 20 (12.82%) AWS
15 20 (12.82%) ETL Development
16 19 (12.18%) Tableau
17 18 (11.54%) Migration
17 18 (11.54%) Data Lake
18 17 (10.90%) Oracle
19 16 (10.26%) QlikView
19 16 (10.26%) Mentoring
20 15 (9.62%) Relational Database
20 15 (9.62%) Analytical Skills

Data Warehouse
Co-occurring IT Skills in Yorkshire 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 10 (6.41%) Apache Spark
2 7 (4.49%) CMS
3 4 (2.56%) Sitecore CMS
4 2 (1.28%) Confluence
4 2 (1.28%) MS Exchange
4 2 (1.28%) PowerExchange
4 2 (1.28%) SAS
4 2 (1.28%) SharePoint
4 2 (1.28%) SharePoint 2013
5 1 (0.64%) Elasticsearch
Applications
1 15 (9.62%) Microsoft Excel
2 11 (7.05%) Microsoft Office
3 1 (0.64%) MS Visio
Business Applications
1 5 (3.21%) Dynamics CRM
2 2 (1.28%) Dynamics AX
2 2 (1.28%) Epicor Tropos
3 1 (0.64%) Elite 3E
Cloud Services
1 78 (50.00%) Power Platform
2 36 (23.08%) Azure
3 20 (12.82%) AWS
4 7 (4.49%) Office 365
5 5 (3.21%) SaaS
6 4 (2.56%) Amazon Kinesis
6 4 (2.56%) Azure Data Factory
7 3 (1.92%) GCP
8 2 (1.28%) Amazon EC2
8 2 (1.28%) Amazon EMR
8 2 (1.28%) Amazon SageMaker
9 1 (0.64%) AWS CloudFormation
9 1 (0.64%) Dynamics 365
Communications & Networking
1 2 (1.28%) Wi-Fi
Database & Business Intelligence
1 78 (50.00%) Power BI
1 78 (50.00%) SQL Server
2 56 (35.90%) SQL Server Integration Services
3 42 (26.92%) SQL Server Reporting Services
4 31 (19.87%) SQL Server Analysis Services
5 21 (13.46%) Big Data
6 20 (12.82%) Star Schema
7 18 (11.54%) Data Lake
8 16 (10.26%) QlikView
9 15 (9.62%) Relational Database
10 9 (5.77%) Azure SQL Database
10 9 (5.77%) SQL Server 2008
11 7 (4.49%) Hadoop
12 6 (3.85%) Amazon Redshift
13 5 (3.21%) BusinessObjects
13 5 (3.21%) Enterprise Data Warehouse
13 5 (3.21%) Microsoft Analysis Services
13 5 (3.21%) Qlik Sense
13 5 (3.21%) SQL Server 2012
13 5 (3.21%) SQL Server 2016
Development Applications
1 8 (5.13%) ERwin
2 7 (4.49%) Team Foundation Server
3 4 (2.56%) Git (software)
3 4 (2.56%) Subversion
3 4 (2.56%) Visual Studio
4 2 (1.28%) Bitbucket
4 2 (1.28%) JIRA
5 1 (0.64%) RStudio
5 1 (0.64%) SQL Server Management Studio (SSMS)
General
1 31 (19.87%) Finance
2 6 (3.85%) Public Sector
3 5 (3.21%) Retail
4 3 (1.92%) Pharmaceutical
5 2 (1.28%) Manufacturing
6 1 (0.64%) Advertising
6 1 (0.64%) Back Office
6 1 (0.64%) Financial Institution
6 1 (0.64%) Housing Association
6 1 (0.64%) Marketing
Job Titles
1 74 (47.44%) Developer
2 59 (37.82%) Business Intelligence Developer
3 21 (13.46%) ETL Developer
4 16 (10.26%) Analyst
4 16 (10.26%) Data Engineer
5 14 (8.97%) Architect
5 14 (8.97%) Business Developer
5 14 (8.97%) Business Intelligence Analyst
6 10 (6.41%) Junior
7 7 (4.49%) Project Manager
7 7 (4.49%) Senior Developer
8 6 (3.85%) Business Intelligence Lead
8 6 (3.85%) Solutions Architect
8 6 (3.85%) SQL Developer
9 5 (3.21%) Consultant
9 5 (3.21%) Data Architect
9 5 (3.21%) Data Modeller
9 5 (3.21%) Junior Analyst
9 5 (3.21%) Technical Manager
9 5 (3.21%) Technical Project Manager
Libraries, Frameworks & Software Standards
1 7 (4.49%) Web Services
2 6 (3.85%) Kafka
3 5 (3.21%) MDX
4 4 (2.56%) .NET
4 4 (2.56%) Middleware
5 3 (1.92%) HTML
6 2 (1.28%) CSS
6 2 (1.28%) CSS3
6 2 (1.28%) Elastic Stack
6 2 (1.28%) HTML5
7 1 (0.64%) AngularJS
Miscellaneous
1 15 (9.62%) Analytical Skills
2 6 (3.85%) Self-Motivation
3 4 (2.56%) Management Information System
3 4 (2.56%) NHS
4 3 (1.92%) Greenfield Project
4 3 (1.92%) Robotics
5 2 (1.28%) Driving Licence
5 2 (1.28%) e-Learning
5 2 (1.28%) Tandem
5 2 (1.28%) User Experience
5 2 (1.28%) Virtual Team
6 1 (0.64%) FMCG
6 1 (0.64%) New Media
6 1 (0.64%) Reinsurance
6 1 (0.64%) Replication
6 1 (0.64%) Taxonomies
6 1 (0.64%) Video on Demand
6 1 (0.64%) Video\Live Streaming
Operating Systems
1 4 (2.56%) Windows
2 2 (1.28%) Linux
2 2 (1.28%) Unix
2 2 (1.28%) Windows 10
2 2 (1.28%) Windows Server
Processes & Methodologies
1 112 (71.79%) Business Intelligence
2 75 (48.08%) ETL
3 47 (30.13%) Data Modelling
4 45 (28.85%) Agile Software Development
5 37 (23.72%) Analytics
6 24 (15.38%) Visualisation
7 20 (12.82%) ETL Development
8 18 (11.54%) Migration
9 16 (10.26%) Mentoring
10 15 (9.62%) Data Visualisation
10 15 (9.62%) Kimball Methodology
10 15 (9.62%) Problem-Solving
11 13 (8.33%) Coaching
11 13 (8.33%) Data Engineering
12 12 (7.69%) Data Analysis
13 11 (7.05%) Data Governance
13 11 (7.05%) Data Science
13 11 (7.05%) Project Management
14 10 (6.41%) Continuous Improvement
14 10 (6.41%) Decision-Making
Programming Languages
1 104 (66.67%) SQL
2 47 (30.13%) T-SQL
3 20 (12.82%) Python
4 13 (8.33%) Java
5 9 (5.77%) PL/SQL
6 7 (4.49%) C#
7 6 (3.85%) JavaScript
7 6 (3.85%) Scala
8 5 (3.21%) Shell Script
9 4 (2.56%) Ruby
9 4 (2.56%) VB
9 4 (2.56%) VBA
10 3 (1.92%) Bash Shell
11 2 (1.28%) Data Analysis Expressions (DAX)
11 2 (1.28%) Korn
11 2 (1.28%) PowerShell
11 2 (1.28%) R
11 2 (1.28%) X++
Qualifications
1 11 (7.05%) Degree
2 3 (1.92%) ITIL Certification
3 2 (1.28%) MCSE
3 2 (1.28%) Microsoft Certification
4 1 (0.64%) MCP
4 1 (0.64%) MCSA
4 1 (0.64%) MCSD
Quality Assurance & Compliance
1 14 (8.97%) Data Quality
2 5 (3.21%) GDPR
3 2 (1.28%) QA
3 2 (1.28%) SLA
4 1 (0.64%) GMP
4 1 (0.64%) ISO 9001
System Software
1 2 (1.28%) Active Directory
1 2 (1.28%) HDFS
1 2 (1.28%) Hyper-V
Systems Management
1 2 (1.28%) Hadoop YARN
1 2 (1.28%) Mesos
2 1 (0.64%) Opscode Chef
2 1 (0.64%) Puppet
Vendors
1 70 (44.87%) Microsoft
2 19 (12.18%) Tableau
3 17 (10.90%) Oracle
4 15 (9.62%) Informatica
5 7 (4.49%) SAP
6 6 (3.85%) Alteryx
6 6 (3.85%) Talend
7 4 (2.56%) Cloudera
7 4 (2.56%) Cognos
7 4 (2.56%) Databricks
7 4 (2.56%) IBM
7 4 (2.56%) Paxata
7 4 (2.56%) Sitecore
8 3 (1.92%) Google
8 3 (1.92%) Remedy
9 2 (1.28%) Avaya
10 1 (0.64%) Concur
10 1 (0.64%) Netezza