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

Data Warehousing
England > Yorkshire
6 months to
21 Sep 2019
Same period 2018 Same period 2017
Rank 136 98 64
Rank change year-on-year -38 -34 +52
Permanent jobs citing Data Warehouse 194 245 425
As % of all permanent IT jobs advertised in Yorkshire 2.61% 2.79% 4.21%
As % of the Database & Business Intelligence category 10.72% 10.48% 13.45%
Number of salaries quoted 175 210 378
Yorkshire median annual salary £45,000 £47,500 £45,000
Median salary % change year-on-year -5.26% +5.56% -
10th Percentile £33,300 £31,437 £32,000
90th Percentile £61,050 £72,500 £62,500
England median annual salary £55,000 £55,000 £50,000
% change year-on-year - +10.00% -9.09%

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,809 2,337 3,160
As % of all permanent IT jobs advertised in Yorkshire 24.38% 26.64% 31.29%
Number of salaries quoted 1,595 1,964 2,698
Yorkshire median annual salary £44,000 £42,500 £42,500
Median salary % change year-on-year +3.53% - +6.25%
10th Percentile £29,200 £27,500 £27,000
90th Percentile £61,250 £58,000 £60,000
England median annual salary £52,500 £50,000 £48,500
% change year-on-year +5.00% +3.09% +2.11%

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 21 September 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 21 September 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 +19 129 £45,000 -10.00% 27
South Yorkshire +10 37 £44,000 +15.03% 6
North Yorkshire -72 21 £47,500 - 8
East Yorkshire - 1 £61,000 - 2
Data Warehouse
England

For the 6 months to 21 September 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 138 (71.13%) Business Intelligence
2 135 (69.59%) SQL
3 105 (54.12%) ETL
4 103 (53.09%) SQL Server
5 97 (50.00%) Power BI
5 97 (50.00%) Power Platform
6 84 (43.30%) SQL Server Integration Services
7 80 (41.24%) Microsoft
8 63 (32.47%) SQL Server Reporting Services
8 63 (32.47%) Data Modelling
9 55 (28.35%) Agile Software Development
10 53 (27.32%) SQL Server Analysis Services
11 51 (26.29%) T-SQL
12 43 (22.16%) Analytics
13 39 (20.10%) Azure
14 31 (15.98%) Visualisation
15 30 (15.46%) Finance
16 29 (14.95%) Tableau
17 28 (14.43%) Data Quality
17 28 (14.43%) Migration
18 26 (13.40%) Oracle
19 25 (12.89%) Star Schema
19 25 (12.89%) Big Data
20 24 (12.37%) Mentoring
21 22 (11.34%) Relational Database
21 22 (11.34%) Kimball Methodology
22 21 (10.82%) Performance Tuning
22 21 (10.82%) ETL Development
22 21 (10.82%) Data Lake
23 20 (10.31%) 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 9 (4.64%) Apache Spark
2 7 (3.61%) SharePoint
3 4 (2.06%) CMS
4 2 (1.03%) Elasticsearch
4 2 (1.03%) SharePoint 2013
4 2 (1.03%) Sitecore CMS
5 1 (0.52%) Confluence
5 1 (0.52%) SAS
Applications
1 19 (9.79%) Microsoft Excel
2 17 (8.76%) Microsoft Office
3 3 (1.55%) Microsoft PowerPoint
Business Applications
1 2 (1.03%) Dynamics AX
1 2 (1.03%) Dynamics CRM
Cloud Services
1 97 (50.00%) Power Platform
2 39 (20.10%) Azure
3 20 (10.31%) AWS
4 6 (3.09%) Azure Data Factory
5 5 (2.58%) Office 365
6 3 (1.55%) GCP
7 2 (1.03%) Azure Stack
7 2 (1.03%) PaaS
8 1 (0.52%) Amazon Kinesis
8 1 (0.52%) Amazon SageMaker
8 1 (0.52%) Dynamics 365
8 1 (0.52%) Google Analytics
8 1 (0.52%) IaaS
Database & Business Intelligence
1 103 (53.09%) SQL Server
2 97 (50.00%) Power BI
3 84 (43.30%) SQL Server Integration Services
4 63 (32.47%) SQL Server Reporting Services
5 53 (27.32%) SQL Server Analysis Services
6 25 (12.89%) Big Data
6 25 (12.89%) Star Schema
7 22 (11.34%) Relational Database
8 21 (10.82%) Data Lake
9 20 (10.31%) QlikView
10 15 (7.73%) SQL Server 2012
11 11 (5.67%) Hadoop
11 11 (5.67%) SQL Server 2008
12 9 (4.64%) Azure SQL Database
12 9 (4.64%) NoSQL
13 8 (4.12%) PostgreSQL
13 8 (4.12%) SQL Server 2016
14 7 (3.61%) Microsoft Analysis Services
14 7 (3.61%) Qlik Sense
15 6 (3.09%) Enterprise Data Warehouse
Development Applications
1 8 (4.12%) ERwin
1 8 (4.12%) Team Foundation Server
2 4 (2.06%) Git (software)
2 4 (2.06%) Subversion
3 2 (1.03%) Visual Studio
4 1 (0.52%) JIRA
4 1 (0.52%) RStudio
4 1 (0.52%) SQL Server Management Studio (SSMS)
General
1 30 (15.46%) Finance
2 14 (7.22%) Retail
3 10 (5.15%) Public Sector
4 6 (3.09%) Pharmaceutical
5 5 (2.58%) Financial Institution
6 4 (2.06%) Marketing
7 2 (1.03%) Manufacturing
8 1 (0.52%) Advertising
8 1 (0.52%) Back Office
8 1 (0.52%) Housing Association
Job Titles
1 98 (50.52%) Developer
2 77 (39.69%) Business Intelligence Developer
3 18 (9.28%) ETL Developer
4 17 (8.76%) Business Developer
4 17 (8.76%) Data Engineer
4 17 (8.76%) SQL Developer
5 16 (8.25%) Analyst
6 14 (7.22%) Business Intelligence Lead
6 14 (7.22%) Data Warehouse Developer
6 14 (7.22%) SQL BI Developer
7 13 (6.70%) Architect
7 13 (6.70%) Business Intelligence Analyst
8 11 (5.67%) DBA
9 10 (5.15%) Senior Developer
9 10 (5.15%) SQL DBA
9 10 (5.15%) SSIS Developer
10 9 (4.64%) Project Manager
11 8 (4.12%) Junior
12 7 (3.61%) Data Manager
13 6 (3.09%) Data Architect
Libraries, Frameworks & Software Standards
1 6 (3.09%) MDX
2 5 (2.58%) Web Services
3 4 (2.06%) .NET
3 4 (2.06%) Kafka
4 2 (1.03%) AngularJS
4 2 (1.03%) Middleware
5 1 (0.52%) ASP.NET
5 1 (0.52%) HTML
Miscellaneous
1 20 (10.31%) Analytical Skills
2 9 (4.64%) NHS
3 7 (3.61%) Self-Motivation
4 5 (2.58%) Management Information System
4 5 (2.58%) Taxonomies
5 4 (2.06%) Data Structures
6 3 (1.55%) Robotics
6 3 (1.55%) Virtual Team
7 2 (1.03%) Driving Licence
7 2 (1.03%) e-Learning
7 2 (1.03%) Greenfield Project
7 2 (1.03%) Mainframe
7 2 (1.03%) Replication
7 2 (1.03%) User Experience
8 1 (0.52%) Algorithms
8 1 (0.52%) FMCG
8 1 (0.52%) New Media
8 1 (0.52%) Video on Demand
8 1 (0.52%) Video\Live Streaming
Operating Systems
1 3 (1.55%) Linux
Processes & Methodologies
1 138 (71.13%) Business Intelligence
2 105 (54.12%) ETL
3 63 (32.47%) Data Modelling
4 55 (28.35%) Agile Software Development
5 43 (22.16%) Analytics
6 31 (15.98%) Visualisation
7 28 (14.43%) Migration
8 24 (12.37%) Mentoring
9 22 (11.34%) Kimball Methodology
10 21 (10.82%) ETL Development
10 21 (10.82%) Performance Tuning
11 19 (9.79%) Data Architecture
11 19 (9.79%) Data Visualisation
12 18 (9.28%) Problem-Solving
12 18 (9.28%) Stakeholder Management
13 17 (8.76%) Data Management
14 15 (7.73%) Continuous Improvement
15 14 (7.22%) Decision-Making
16 13 (6.70%) Coaching
16 13 (6.70%) Data Engineering
Programming Languages
1 135 (69.59%) SQL
2 51 (26.29%) T-SQL
3 11 (5.67%) Python
4 8 (4.12%) PL/SQL
5 7 (3.61%) Shell Script
6 6 (3.09%) C#
7 5 (2.58%) Java
8 3 (1.55%) Bash Shell
8 3 (1.55%) R
8 3 (1.55%) VBA
9 2 (1.03%) Data Analysis Expressions (DAX)
9 2 (1.03%) VB
9 2 (1.03%) VB.NET
9 2 (1.03%) X++
Qualifications
1 8 (4.12%) Degree
2 3 (1.55%) ITIL Certification
2 3 (1.55%) Microsoft Certification
3 2 (1.03%) MCSE
4 1 (0.52%) MCSA
4 1 (0.52%) Numerate Degree
Quality Assurance & Compliance
1 28 (14.43%) Data Quality
2 8 (4.12%) GDPR
3 4 (2.06%) QA
4 2 (1.03%) SLA
5 1 (0.52%) GMP
5 1 (0.52%) ISO 9001
Vendors
1 80 (41.24%) Microsoft
2 29 (14.95%) Tableau
3 26 (13.40%) Oracle
4 13 (6.70%) Informatica
5 12 (6.19%) IBM
6 9 (4.64%) Cognos
7 6 (3.09%) Alteryx
7 6 (3.09%) SAP
7 6 (3.09%) Talend
8 5 (2.58%) Databricks
8 5 (2.58%) Google
9 4 (2.06%) Adobe
9 4 (2.06%) Cloudera
9 4 (2.06%) Paxata
10 3 (1.55%) Netezza
10 3 (1.55%) Remedy
11 2 (1.03%) Sitecore
12 1 (0.52%) MicroStrategy