Period
to 3 December 2020

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

Data Warehousing
England > Yorkshire
6 months to
3 Dec 2020
Same period 2019 Same period 2018
Rank 89 114 98
Rank change year-on-year +25 -16 -25
Permanent jobs citing Data Warehouse 91 160 232
As % of all permanent jobs advertised in Yorkshire 2.76% 2.41% 2.80%
As % of the Database & Business Intelligence category 9.80% 9.63% 10.85%
Number of salaries quoted 93 149 215
Median annual salary £45,000 £45,000 £45,000
10th Percentile £37,500 £30,600 £31,566
90th Percentile £63,800 £65,000 £72,500
England median annual salary £55,500 £56,000 £55,000
% change year-on-year -0.89% +1.82% +4.76%

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 929 1,661 2,139
As % of all permanent IT jobs advertised in Yorkshire 28.18% 25.02% 25.85%
Number of salaries quoted 822 1,440 1,800
Median annual salary £45,000 £45,000 £42,500
Median salary % change year-on-year - +5.88% -
10th Percentile £31,250 £29,000 £27,500
90th Percentile £65,000 £63,825 £57,500
England median annual salary £55,000 £52,500 £52,500
% change year-on-year +4.76% - +5.00%

Data Warehouse
Job Vacancy Trend in Yorkshire

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

Job vacancy trend for Data Warehouse in Yorkshire

Data Warehouse
Salary Trend in Yorkshire

3-month moving average salary quoted in jobs citing Data Warehouse in Yorkshire.

Salary trend for Data Warehouse in Yorkshire

Data Warehouse
Salary Histogram in Yorkshire

Salary distribution for jobs citing Data Warehouse in Yorkshire over the 6 months to 3 December 2020.

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 3 December 2020. 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 +32 56 £50,000 +5.26% 13
North Yorkshire +46 24 £45,000 +20.00%
South Yorkshire -15 9 £45,000 +2.27% 3
Data Warehouse
England

For the 6 months to 3 December 2020, 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 74 (81.32%) SQL
2 55 (60.44%) Business Intelligence
3 52 (57.14%) ETL
4 42 (46.15%) Microsoft
5 40 (43.96%) SQL Server
6 39 (42.86%) Agile Software Development
7 37 (40.66%) Azure
8 36 (39.56%) SQL Server Integration Services
9 31 (34.07%) Data Lake
10 27 (29.67%) Python
11 26 (28.57%) SQL Server Reporting Services
11 26 (28.57%) SQL Server Analysis Services
12 25 (27.47%) Power BI
12 25 (27.47%) Power Platform
12 25 (27.47%) Analytics
13 20 (21.98%) Retail
13 20 (21.98%) Data Modelling
14 17 (18.68%) Machine Learning
15 16 (17.58%) .NET
15 16 (17.58%) Unit Testing
16 15 (16.48%) AWS
16 15 (16.48%) Finance
16 15 (16.48%) Scrum
17 14 (15.38%) Java
18 13 (14.29%) Software Engineering
18 13 (14.29%) R
18 13 (14.29%) GCP
19 12 (13.19%) Google
20 11 (12.09%) Data Management
20 11 (12.09%) Computer Science

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 5 (5.49%) Apache Spark
2 3 (3.30%) Apache
2 3 (3.30%) Apache Synapse
3 1 (1.10%) Apache Airflow
Applications
1 4 (4.40%) MS Visio
2 1 (1.10%) Microsoft Excel
Cloud Services
1 37 (40.66%) Azure
2 25 (27.47%) Power Platform
3 15 (16.48%) AWS
4 13 (14.29%) GCP
5 11 (12.09%) Azure Data Factory
6 3 (3.30%) Amazon Kinesis
7 2 (2.20%) Azure Machine Learning
7 2 (2.20%) PaaS
7 2 (2.20%) SaaS
8 1 (1.10%) Amazon S3
8 1 (1.10%) Azure Stack
8 1 (1.10%) Power Automate
8 1 (1.10%) PowerApps
8 1 (1.10%) Serverless
Database & Business Intelligence
1 40 (43.96%) SQL Server
2 36 (39.56%) SQL Server Integration Services
3 31 (34.07%) Data Lake
4 26 (28.57%) SQL Server Analysis Services
4 26 (28.57%) SQL Server Reporting Services
5 25 (27.47%) Power BI
6 11 (12.09%) Amazon Redshift
6 11 (12.09%) BigQuery
7 10 (10.99%) CloverETL
8 9 (9.89%) Azure SQL Data Warehouse
9 7 (7.69%) Amazon Athena
9 7 (7.69%) Tableau
10 6 (6.59%) Azure SQL Database
10 6 (6.59%) Cosmos DB
10 6 (6.59%) NoSQL
11 5 (5.49%) Big Data
12 4 (4.40%) Apache Cassandra
12 4 (4.40%) Data Mart
12 4 (4.40%) Hadoop
12 4 (4.40%) QlikView
Development Applications
1 3 (3.30%) Cucumber
1 3 (3.30%) Selenium
1 3 (3.30%) SpecFlow
2 2 (2.20%) Team Foundation Server
3 1 (1.10%) Visual Studio
General
1 20 (21.98%) Retail
2 15 (16.48%) Finance
3 7 (7.69%) Marketing
4 6 (6.59%) Public Sector
5 5 (5.49%) Law
6 1 (1.10%) Billing
6 1 (1.10%) Digital Economy
Job Titles
1 32 (35.16%) Developer
2 25 (27.47%) Business Intelligence Developer
3 16 (17.58%) Data Engineer
4 11 (12.09%) Business Developer
5 10 (10.99%) Analyst
5 10 (10.99%) Architect
5 10 (10.99%) Data Architect
6 9 (9.89%) SQL Developer
7 7 (7.69%) Microsoft BI Developer
8 6 (6.59%) Business Intelligence Analyst
9 5 (5.49%) Data Warehouse Developer
9 5 (5.49%) Designer
9 5 (5.49%) Microsoft Developer
9 5 (5.49%) Solutions Designer
9 5 (5.49%) SQL Server Developer
9 5 (5.49%) Test Analyst
10 4 (4.40%) Data Modeller
10 4 (4.40%) DBA
10 4 (4.40%) SQL BI Developer
10 4 (4.40%) SQL DBA
Libraries, Frameworks & Software Standards
1 16 (17.58%) .NET
2 9 (9.89%) Kafka
3 3 (3.30%) .NET Core
3 3 (3.30%) Gherkin
4 2 (2.20%) Dask
4 2 (2.20%) Pandas
5 1 (1.10%) RabbitMQ
Miscellaneous
1 10 (10.99%) Management Information System
2 8 (8.79%) Analytical Skills
3 3 (3.30%) Driving Licence
4 2 (2.20%) Data Structures
4 2 (2.20%) Self-Motivation
5 1 (1.10%) Greenfield Project
5 1 (1.10%) NHS
5 1 (1.10%) User Experience
Operating Systems
1 3 (3.30%) Windows
1 3 (3.30%) Windows Server
Processes & Methodologies
1 55 (60.44%) Business Intelligence
2 52 (57.14%) ETL
3 39 (42.86%) Agile Software Development
4 25 (27.47%) Analytics
5 20 (21.98%) Data Modelling
6 17 (18.68%) Machine Learning
7 16 (17.58%) Unit Testing
8 15 (16.48%) Scrum
9 13 (14.29%) Software Engineering
10 11 (12.09%) Computer Science
10 11 (12.09%) Data Management
11 10 (10.99%) Data Analytics
11 10 (10.99%) Information Management
11 10 (10.99%) Project Management
12 9 (9.89%) Dimensional Modelling
12 9 (9.89%) Problem-Solving
12 9 (9.89%) Stakeholder Management
13 8 (8.79%) Data Visualisation
13 8 (8.79%) Visualisation
14 7 (7.69%) TDD
Programming Languages
1 74 (81.32%) SQL
2 27 (29.67%) Python
3 14 (15.38%) Java
4 13 (14.29%) R
5 11 (12.09%) T-SQL
6 3 (3.30%) C#
7 2 (2.20%) Data Analysis Expressions (DAX)
7 2 (2.20%) JavaScript
Qualifications
1 10 (10.99%) Degree
2 3 (3.30%) VMware Certified Professional (VCP)
Quality Assurance & Compliance
1 6 (6.59%) Data Quality
2 3 (3.30%) QA
3 2 (2.20%) SLA
4 1 (1.10%) PMO
System Software
1 3 (3.30%) VMware Infrastructure
Vendors
1 42 (46.15%) Microsoft
2 12 (13.19%) Google
3 7 (7.69%) Databricks
4 3 (3.30%) SAP
4 3 (3.30%) VMware
5 2 (2.20%) Informatica
5 2 (2.20%) Talend
6 1 (1.10%) Confluent
6 1 (1.10%) Oracle