Period
to 17 October 2021

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 17 October 2021 with a comparison to the same period in the previous 2 years.

Data Warehousing
England > Yorkshire
6 months to
17 Oct 2021
Same period 2020 Same period 2019
Rank 58 86 138
Rank change year-on-year +28 +52 -34
Permanent jobs citing Data Warehouse 275 72 179
As % of all permanent jobs advertised in Yorkshire 4.14% 2.69% 2.55%
As % of the Database & Business Intelligence category 15.98% 9.84% 10.53%
Number of salaries quoted 230 59 162
10th Percentile £32,975 £32,950 £32,500
25th Percentile £40,000 £42,500 £40,000
Median annual salary (50th Percentile) £45,000 £47,500 £45,000
Median % change year-on-year -5.26% +5.56% -
75th Percentile £59,875 £55,000 £50,000
90th Percentile £82,500 £65,000 £60,225
England median annual salary £60,000 £57,500 £55,000
% change year-on-year +4.35% +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,721 732 1,700
As % of all permanent IT jobs advertised in Yorkshire 25.89% 27.34% 24.18%
Number of salaries quoted 1,351 663 1,493
10th Percentile £30,750 £32,000 £29,000
25th Percentile £37,500 £37,500 £33,797
Median annual salary (50th Percentile) £47,500 £45,000 £45,000
Median % change year-on-year +5.56% - +5.88%
75th Percentile £60,000 £57,500 £53,750
90th Percentile £70,000 £65,000 £61,862
England median annual salary £58,500 £55,000 £52,500
% change year-on-year +6.36% +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 17 October 2021.

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 17 October 2021. 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 +9 171 £45,000 -18.18% 20
South Yorkshire -5 48 £45,000 - 4
North Yorkshire +24 42 £45,000 -5.26% 6
East Yorkshire -6 9 £54,500 +98.18%
Data Warehouse
England

For the 6 months to 17 October 2021, 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 216 (78.55%) Business Intelligence
2 175 (63.64%) SQL
3 120 (43.64%) Azure
4 119 (43.27%) Power BI
4 119 (43.27%) Power Platform
5 109 (39.64%) ETL
6 108 (39.27%) SQL Server
7 82 (29.82%) Microsoft
7 82 (29.82%) Agile Software Development
8 79 (28.73%) Analytics
9 73 (26.55%) SQL Server Integration Services
9 73 (26.55%) Data Modelling
10 57 (20.73%) SQL Server Reporting Services
11 53 (19.27%) Problem-Solving
12 50 (18.18%) Social Skills
13 47 (17.09%) Finance
14 44 (16.00%) T-SQL
14 44 (16.00%) Visualisation
15 43 (15.64%) SQL Server Analysis Services
16 41 (14.91%) Data Management
17 40 (14.55%) Tableau
18 39 (14.18%) AWS
19 36 (13.09%) Analytical Skills
19 36 (13.09%) Relational Database
20 33 (12.00%) Data Lake
21 30 (10.91%) Decision-Making
21 30 (10.91%) Data Architecture
22 29 (10.55%) Python
23 28 (10.18%) SAP
24 26 (9.45%) Microsoft Excel

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 13 (4.73%) Apache Spark
2 11 (4.00%) Confluence
3 7 (2.55%) Apache
3 7 (2.55%) SAS
3 7 (2.55%) SharePoint
4 4 (1.45%) Apache Synapse
5 3 (1.09%) Apache Solr
Applications
1 26 (9.45%) Microsoft Excel
2 7 (2.55%) MS Visio
3 4 (1.45%) Microsoft Office
4 1 (0.36%) Microsoft PowerPoint
Business Applications
1 6 (2.18%) Dynamics CRM
1 6 (2.18%) Dynamics NAV
1 6 (2.18%) Sage 50
2 4 (1.45%) Dynamics AX
3 3 (1.09%) Shopify
4 2 (0.73%) Unit4 Business World
5 1 (0.36%) Cognos Business Intelligence
5 1 (0.36%) IBM Planning Analytics
5 1 (0.36%) NetSuite
Cloud Services
1 120 (43.64%) Azure
2 119 (43.27%) Power Platform
3 39 (14.18%) AWS
4 26 (9.45%) Azure Data Factory
5 17 (6.18%) SaaS
6 15 (5.45%) Azure Synapse Analytics
7 13 (4.73%) Serverless
8 11 (4.00%) Dynamics 365
8 11 (4.00%) GCP
9 8 (2.91%) AWS Lambda
10 6 (2.18%) PaaS
11 5 (1.82%) AWS Step Functions
11 5 (1.82%) Azure Cosmos DB
11 5 (1.82%) Power Automate
11 5 (1.82%) PowerApps
11 5 (1.82%) Snowflake
12 4 (1.45%) Azure Functions
12 4 (1.45%) Azure Logic Apps
12 4 (1.45%) Microsoft 365
13 3 (1.09%) Boomi
Database & Business Intelligence
1 119 (43.27%) Power BI
2 108 (39.27%) SQL Server
3 73 (26.55%) SQL Server Integration Services
4 57 (20.73%) SQL Server Reporting Services
5 43 (15.64%) SQL Server Analysis Services
6 40 (14.55%) Tableau
7 36 (13.09%) Relational Database
8 33 (12.00%) Data Lake
9 25 (9.09%) Azure SQL Database
10 22 (8.00%) Azure SQL Data Warehouse
11 17 (6.18%) OLAP
12 16 (5.82%) BusinessObjects
12 16 (5.82%) SQL Server 2016
13 13 (4.73%) Oracle OLAP
13 13 (4.73%) QlikView
14 10 (3.64%) Amazon Athena
14 10 (3.64%) BusinessObjects Business Intelligence
14 10 (3.64%) Hadoop
14 10 (3.64%) PostgreSQL
15 9 (3.27%) Amazon Redshift
Development Applications
1 14 (5.09%) Visual Studio
2 13 (4.73%) Git (software)
3 12 (4.36%) JIRA
4 8 (2.91%) VSS/SourceSafe
5 4 (1.45%) Subversion
6 3 (1.09%) Team Foundation Server
6 3 (1.09%) Visual Studio Team System
7 1 (0.36%) Gatling
7 1 (0.36%) Oracle Forms
General
1 50 (18.18%) Social Skills
2 47 (17.09%) Finance
3 36 (13.09%) Analytical Skills
4 16 (5.82%) Manufacturing
5 12 (4.36%) Retail
6 10 (3.64%) Organisational Skills
7 9 (3.27%) Legal
8 5 (1.82%) Law
9 4 (1.45%) Automotive
9 4 (1.45%) Inclusion and Diversity
10 3 (1.09%) Electronics
10 3 (1.09%) Marketing
10 3 (1.09%) Presentation Skills
10 3 (1.09%) Public Sector
11 2 (0.73%) Banking
11 2 (0.73%) Billing
12 1 (0.36%) Influencing Skills
12 1 (0.36%) Publishing
Job Titles
1 101 (36.73%) Developer
2 59 (21.45%) Business Intelligence Developer
3 46 (16.73%) Architect
4 40 (14.55%) Analyst
5 38 (13.82%) Data Engineer
6 36 (13.09%) Data Architect
7 22 (8.00%) Azure Architect
7 22 (8.00%) Business Intelligence Lead
8 20 (7.27%) Business Developer
9 19 (6.91%) Senior Developer
10 16 (5.82%) AWS Architect
11 15 (5.45%) Business Intelligence Analyst
12 12 (4.36%) Data Warehouse Developer
12 12 (4.36%) Solutions Architect
13 11 (4.00%) Data Analyst
13 11 (4.00%) Lead Developer
13 11 (4.00%) Systems Developer
14 9 (3.27%) Power BI Developer
14 9 (3.27%) Test Analyst
15 8 (2.91%) Azure Developer
Libraries, Frameworks & Software Standards
1 19 (6.91%) .NET
2 14 (5.09%) PySpark
3 12 (4.36%) MDX
4 7 (2.55%) .NET Core
4 7 (2.55%) .NET Framework
4 7 (2.55%) REST
5 6 (2.18%) Blazor
5 6 (2.18%) NumPy
6 5 (1.82%) Middleware
7 4 (1.45%) JSON
7 4 (1.45%) RESTful
7 4 (1.45%) Web Services
8 3 (1.09%) GeoJSON
8 3 (1.09%) HTML
8 3 (1.09%) Kafka
8 3 (1.09%) Pandas
8 3 (1.09%) SAML
8 3 (1.09%) SOAP
9 2 (0.73%) EDI
9 2 (0.73%) Lambda Expressions
Miscellaneous
1 14 (5.09%) Data Structures
1 14 (5.09%) Management Information System
2 12 (4.36%) Data Protection Act
3 6 (2.18%) Taxonomies
4 5 (1.82%) Enterprise Software
5 4 (1.45%) Greenfield Project
5 4 (1.45%) Industry 4.0
5 4 (1.45%) Life Science
5 4 (1.45%) Reference Data
5 4 (1.45%) Renewable Energy
5 4 (1.45%) User Experience
6 3 (1.09%) Blog
6 3 (1.09%) FMCG
6 3 (1.09%) Hybrid Cloud
6 3 (1.09%) New Media
6 3 (1.09%) Social Network
6 3 (1.09%) Tandem
6 3 (1.09%) Video\Live Streaming
7 2 (0.73%) Analytical Mindset
7 2 (0.73%) Cloud Native
Operating Systems
1 7 (2.55%) Windows
2 3 (1.09%) Linux
3 1 (0.36%) Android
3 1 (0.36%) Apple iOS
3 1 (0.36%) Windows 10
Processes & Methodologies
1 216 (78.55%) Business Intelligence
2 109 (39.64%) ETL
3 82 (29.82%) Agile Software Development
4 79 (28.73%) Analytics
5 73 (26.55%) Data Modelling
6 53 (19.27%) Problem-Solving
7 44 (16.00%) Visualisation
8 41 (14.91%) Data Management
9 30 (10.91%) Data Architecture
9 30 (10.91%) Decision-Making
10 26 (9.45%) Migration
11 25 (9.09%) Data Analytics
12 24 (8.73%) Data Governance
12 24 (8.73%) ERP
13 22 (8.00%) Data Engineering
13 22 (8.00%) Machine Learning
14 21 (7.64%) Data Visualisation
14 21 (7.64%) DevOps
15 19 (6.91%) Stakeholder Management
16 17 (6.18%) Business Analysis
Programming Languages
1 175 (63.64%) SQL
2 44 (16.00%) T-SQL
3 29 (10.55%) Python
4 19 (6.91%) Data Analysis Expressions (DAX)
5 12 (4.36%) C#
6 11 (4.00%) Java
7 10 (3.64%) R
8 6 (2.18%) Scala
8 6 (2.18%) X++
9 4 (1.45%) VB
9 4 (1.45%) VBA
10 3 (1.09%) JavaScript
10 3 (1.09%) PL/SQL
11 2 (0.73%) PowerShell
12 1 (0.36%) RPG
12 1 (0.36%) TypeScript
Qualifications
1 17 (6.18%) Degree
2 3 (1.09%) Computer Science Degree
2 3 (1.09%) ISEB
2 3 (1.09%) Numerate Degree
Quality Assurance & Compliance
1 24 (8.73%) GDPR
2 18 (6.55%) Data Quality
3 6 (2.18%) QA
System Software
1 3 (1.09%) VMware Infrastructure
2 2 (0.73%) Docker
3 1 (0.36%) Oracle RAC
Systems Management
1 1 (0.36%) Kubernetes
Vendors
1 82 (29.82%) Microsoft
2 28 (10.18%) SAP
3 25 (9.09%) Oracle
4 20 (7.27%) Databricks
5 10 (3.64%) Google
6 9 (3.27%) Cognos
7 7 (2.55%) IBM
8 6 (2.18%) Sage
9 5 (1.82%) Informatica
9 5 (1.82%) Talend
10 4 (1.45%) Alteryx
10 4 (1.45%) IFS
11 3 (1.09%) Citrix
11 3 (1.09%) Dell
11 3 (1.09%) NVIDIA
11 3 (1.09%) VMware
12 2 (0.73%) Salesforce.com
13 1 (0.36%) Ab Initio
13 1 (0.36%) Anaplan
13 1 (0.36%) Capita