Job Vacancy Trend Salary Trend Salary Histogram Job Locations Skill Sets
Period
to 18 May 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 18 May 2021 with a comparison to the same period in the previous 2 years.

Data Warehousing
England > Yorkshire
6 months to
18 May 2021		 Same period 2020 Same period 2019
Rank 61 107 131
Rank change year-on-year +46 +24 -39
Permanent jobs citing Data Warehouse 211 105 198
As % of all permanent jobs advertised in Yorkshire 4.05% 2.21% 2.65%
As % of the Database & Business Intelligence category 15.56% 8.41% 10.28%
Number of salaries quoted 175 75 170
10th Percentile £32,500 £35,500 £36,250
25th Percentile £37,500 £41,250 £41,250
Median annual salary (50th Percentile) £50,000 £57,500 £47,500
Median % change year-on-year -13.04% +21.05% +5.56%
75th Percentile £68,250 £64,750 £55,000
90th Percentile £82,500 £73,750 £66,500
England median annual salary £60,000 £60,000 £55,000
% change year-on-year - +9.09% +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 1,356 1,248 1,927
As % of all permanent IT jobs advertised in Yorkshire 26.03% 26.26% 25.74%
Number of salaries quoted 1,147 1,082 1,721
10th Percentile £31,250 £30,000 £29,000
25th Percentile £37,063 £35,000 £33,750
Median annual salary (50th Percentile) £47,500 £45,000 £42,500
Median % change year-on-year +5.56% +5.88% -
75th Percentile £59,375 £57,500 £52,500
90th Percentile £65,000 £65,000 £61,250
England median annual salary £55,000 £55,000 £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 18 May 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 18 May 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 +48 143 £52,500 -16.00% 21
South Yorkshire -15 31 £46,500 +3.33% 4
North Yorkshire +17 21 £47,000 +21.29% 3
East Yorkshire -8 6 £50,377 +73.71% 1
Data Warehouse
England

For the 6 months to 18 May 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 159 (75.36%) Business Intelligence
2 140 (66.35%) SQL
3 120 (56.87%) Azure
4 94 (44.55%) Agile Software Development
5 89 (42.18%) Power BI
5 89 (42.18%) Power Platform
6 79 (37.44%) SQL Server Integration Services
6 79 (37.44%) ETL
7 74 (35.07%) SQL Server
8 73 (34.60%) SQL Server Reporting Services
9 66 (31.28%) Analytics
10 64 (30.33%) SQL Server Analysis Services
11 61 (28.91%) Data Lake
12 54 (25.59%) T-SQL
13 53 (25.12%) Microsoft
14 52 (24.64%) Data Modelling
15 48 (22.75%) AWS
16 43 (20.38%) Python
17 41 (19.43%) Finance
18 39 (18.48%) Visualisation
19 36 (17.06%) Databricks
19 36 (17.06%) Azure Data Factory
20 35 (16.59%) Social Skills
21 34 (16.11%) Data Architecture
22 31 (14.69%) Azure Synapse Analytics
22 31 (14.69%) Data Engineering
23 30 (14.22%) DevOps
23 30 (14.22%) Tableau
24 28 (13.27%) Problem-Solving
25 27 (12.80%) 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 19 (9.00%) Apache Spark
2 5 (2.37%) Apache
2 5 (2.37%) Apache Synapse
3 1 (0.47%) Apache Airflow
3 1 (0.47%) CMS
3 1 (0.47%) Confluence
Applications
1 27 (12.80%) Microsoft Excel
2 2 (0.95%) Microsoft Office
3 1 (0.47%) MS Visio
Business Applications
1 5 (2.37%) Shopify
2 4 (1.90%) Dynamics CRM
2 4 (1.90%) Dynamics NAV
2 4 (1.90%) Sage 50
3 1 (0.47%) Oracle ERP
Cloud Services
1 120 (56.87%) Azure
2 89 (42.18%) Power Platform
3 48 (22.75%) AWS
4 36 (17.06%) Azure Data Factory
5 31 (14.69%) Azure Synapse Analytics
6 16 (7.58%) GCP
7 13 (6.16%) Serverless
8 12 (5.69%) Azure Machine Learning
9 10 (4.74%) Dynamics 365
10 7 (3.32%) AWS Lambda
10 7 (3.32%) SaaS
11 5 (2.37%) Azure Functions
11 5 (2.37%) Azure Stack
11 5 (2.37%) Azure Storage
11 5 (2.37%) Google Sheets
11 5 (2.37%) Matillion
12 3 (1.42%) Amazon S3
12 3 (1.42%) Azure Cosmos DB
12 3 (1.42%) Azure Logic Apps
12 3 (1.42%) PaaS
Database & Business Intelligence
1 89 (42.18%) Power BI
2 79 (37.44%) SQL Server Integration Services
3 74 (35.07%) SQL Server
4 73 (34.60%) SQL Server Reporting Services
5 64 (30.33%) SQL Server Analysis Services
6 61 (28.91%) Data Lake
7 30 (14.22%) Tableau
8 26 (12.32%) Enterprise Data Warehouse
9 23 (10.90%) Azure SQL Data Warehouse
10 20 (9.48%) Big Data
11 16 (7.58%) Azure SQL Database
11 16 (7.58%) Microsoft Analysis Services
11 16 (7.58%) SQL Server 2016
12 15 (7.11%) Delta Lake
13 14 (6.64%) Relational Database
14 11 (5.21%) Amazon Athena
14 11 (5.21%) Amazon Redshift
14 11 (5.21%) PowerPivot
14 11 (5.21%) SQL Server 2019
15 9 (4.27%) Spark SQL
Development Applications
1 12 (5.69%) Team Foundation Server
2 3 (1.42%) SQL Server Management Studio (SSMS)
3 1 (0.47%) Gatling
3 1 (0.47%) JIRA
3 1 (0.47%) Selenium
3 1 (0.47%) Visual Studio
General
1 41 (19.43%) Finance
2 35 (16.59%) Social Skills
3 16 (7.58%) Law
4 15 (7.11%) Analytical Skills
5 7 (3.32%) Manufacturing
6 6 (2.84%) Billing
6 6 (2.84%) Presentation Skills
7 5 (2.37%) Marketing
7 5 (2.37%) Retail
8 4 (1.90%) Public Sector
9 3 (1.42%) Publishing
10 2 (0.95%) Digital Economy
11 1 (0.47%) Legal
Job Titles
1 48 (22.75%) Data Engineer
1 48 (22.75%) Developer
2 43 (20.38%) Architect
3 40 (18.96%) Analyst
4 32 (15.17%) Azure Architect
4 32 (15.17%) Data Architect
5 28 (13.27%) Business Intelligence Developer
6 24 (11.37%) Azure Engineer
7 22 (10.43%) AWS Architect
8 16 (7.58%) Business Intelligence Analyst
9 13 (6.16%) Data Analyst
10 12 (5.69%) Data Warehouse Developer
10 12 (5.69%) Power BI Analyst
11 9 (4.27%) Business Developer
11 9 (4.27%) Solutions Architect
12 8 (3.79%) AWS Engineer
13 6 (2.84%) SQL Developer
13 6 (2.84%) Systems Developer
14 5 (2.37%) Lead Developer
14 5 (2.37%) Senior Developer
Libraries, Frameworks & Software Standards
1 12 (5.69%) MDX
2 11 (5.21%) PySpark
3 6 (2.84%) EDI
4 5 (2.37%) JSON
4 5 (2.37%) XML
5 4 (1.90%) HTML
6 3 (1.42%) .NET
7 2 (0.95%) Kafka
7 2 (0.95%) NumPy
8 1 (0.47%) .NET Core
8 1 (0.47%) .NET Framework
8 1 (0.47%) Oracle GoldenGate
8 1 (0.47%) pytest
Miscellaneous
1 9 (4.27%) Management Information System
2 4 (1.90%) Industry 4.0
2 4 (1.90%) New Media
2 4 (1.90%) Self-Motivation
2 4 (1.90%) Video\Live Streaming
3 3 (1.42%) Data Structures
3 3 (1.42%) User Experience
4 2 (0.95%) Cloud Native
4 2 (0.95%) Greenfield Project
5 1 (0.47%) Analytical Mindset
5 1 (0.47%) e-Learning
5 1 (0.47%) Embedded Systems
5 1 (0.47%) Enterprise Software
5 1 (0.47%) iSeries
5 1 (0.47%) Private Cloud
Operating Systems
1 4 (1.90%) Windows
2 1 (0.47%) Android
2 1 (0.47%) Apple iOS
2 1 (0.47%) Linux
Processes & Methodologies
1 159 (75.36%) Business Intelligence
2 94 (44.55%) Agile Software Development
3 79 (37.44%) ETL
4 66 (31.28%) Analytics
5 52 (24.64%) Data Modelling
6 39 (18.48%) Visualisation
7 34 (16.11%) Data Architecture
8 31 (14.69%) Data Engineering
9 30 (14.22%) DevOps
10 28 (13.27%) Problem-Solving
11 27 (12.80%) Data Visualisation
12 23 (10.90%) Machine Learning
13 22 (10.43%) Business Analysis
13 22 (10.43%) Data Management
13 22 (10.43%) Data Strategy
13 22 (10.43%) DataOps
13 22 (10.43%) Migration
14 21 (9.95%) Release Management
15 17 (8.06%) Scrum
15 17 (8.06%) Unit Testing
Programming Languages
1 140 (66.35%) SQL
2 54 (25.59%) T-SQL
3 43 (20.38%) Python
4 19 (9.00%) Data Analysis Expressions (DAX)
5 14 (6.64%) Scala
6 9 (4.27%) C#
7 5 (2.37%) PL/SQL
7 5 (2.37%) R
8 4 (1.90%) Java
9 1 (0.47%) RPG
Qualifications
1 3 (1.42%) Degree
1 3 (1.42%) ISEB
2 2 (0.95%) ISTQB
2 2 (0.95%) ISTQB Foundation Certification
3 1 (0.47%) Numerate Degree
3 1 (0.47%) SC Cleared
3 1 (0.47%) Security Cleared
Quality Assurance & Compliance
1 15 (7.11%) Data Quality
2 3 (1.42%) GDPR
3 2 (0.95%) QA
System Software
1 6 (2.84%) Docker
2 1 (0.47%) Virtual Machines
Systems Management
1 5 (2.37%) Kubernetes
Vendors
1 53 (25.12%) Microsoft
2 36 (17.06%) Databricks
3 9 (4.27%) Oracle
4 8 (3.79%) Google
5 6 (2.84%) Informatica
6 5 (2.37%) Alteryx
7 4 (1.90%) IFS
7 4 (1.90%) Sage
7 4 (1.90%) SAP
8 3 (1.42%) IBM
9 2 (0.95%) Salesforce.com
10 1 (0.47%) Confluent
10 1 (0.47%) ServiceNow
10 1 (0.47%) Talend
10 1 (0.47%) Xamarin