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

Data Warehousing
England > Yorkshire
6 months to
23 Jul 2021
Same period 2020 Same period 2019
Rank 56 114 134
Rank change year-on-year +58 +20 -38
Permanent jobs citing Data Warehouse 274 80 215
As % of all permanent jobs advertised in Yorkshire 4.60% 2.13% 2.81%
As % of the Database & Business Intelligence category 17.24% 8.01% 11.30%
Number of salaries quoted 223 57 191
10th Percentile £32,500 £34,000 £36,250
25th Percentile £38,750 £41,250 £41,250
Median annual salary (50th Percentile) £47,500 £52,500 £45,000
Median % change year-on-year -9.52% +16.67% -
75th Percentile £67,500 £63,750 £55,125
90th Percentile £82,500 £67,500 £67,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,589 999 1,903
As % of all permanent IT jobs advertised in Yorkshire 26.66% 26.55% 24.85%
Number of salaries quoted 1,276 878 1,706
10th Percentile £30,000 £30,000 £29,500
25th Percentile £37,000 £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 £60,000 £56,250 £52,500
90th Percentile £68,750 £65,000 £61,625
England median annual salary £57,000 £55,000 £52,500
% change year-on-year +3.64% +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 23 July 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 23 July 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 +28 173 £52,500 -12.50% 12
North Yorkshire +38 43 £45,000 +34.33% 1
South Yorkshire -9 38 £46,500 +7.51% 1
East Yorkshire -3 11 £52,689 +91.59%
Data Warehouse
England

For the 6 months to 23 July 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 219 (79.93%) Business Intelligence
2 169 (61.68%) SQL
3 142 (51.82%) Azure
4 121 (44.16%) Power BI
4 121 (44.16%) Power Platform
5 108 (39.42%) SQL Server
6 106 (38.69%) Agile Software Development
7 105 (38.32%) ETL
8 89 (32.48%) SQL Server Integration Services
9 86 (31.39%) Analytics
10 75 (27.37%) Data Modelling
11 74 (27.01%) SQL Server Reporting Services
12 68 (24.82%) SQL Server Analysis Services
13 67 (24.45%) Microsoft
14 61 (22.26%) Data Lake
15 59 (21.53%) T-SQL
16 55 (20.07%) Social Skills
17 51 (18.61%) AWS
18 50 (18.25%) Visualisation
19 46 (16.79%) Finance
20 43 (15.69%) Python
20 43 (15.69%) Azure Data Factory
21 42 (15.33%) Data Architecture
22 39 (14.23%) Problem-Solving
23 36 (13.14%) Tableau
24 35 (12.77%) Databricks
24 35 (12.77%) Data Engineering
25 33 (12.04%) Azure Synapse Analytics
26 32 (11.68%) DevOps
27 31 (11.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 22 (8.03%) Apache Spark
2 8 (2.92%) Apache
2 8 (2.92%) Apache Synapse
3 7 (2.55%) Confluence
4 5 (1.82%) SharePoint
5 1 (0.36%) CMS
5 1 (0.36%) SAS
Applications
1 24 (8.76%) Microsoft Excel
2 2 (0.73%) Microsoft Office
2 2 (0.73%) MS Visio
Business Applications
1 10 (3.65%) Dynamics CRM
1 10 (3.65%) Dynamics NAV
1 10 (3.65%) Sage 50
2 5 (1.82%) Shopify
3 3 (1.09%) Dynamics AX
4 1 (0.36%) Cognos Business Intelligence
4 1 (0.36%) Cognos TM1
Cloud Services
1 142 (51.82%) Azure
2 121 (44.16%) Power Platform
3 51 (18.61%) AWS
4 43 (15.69%) Azure Data Factory
5 33 (12.04%) Azure Synapse Analytics
6 17 (6.20%) GCP
7 15 (5.47%) Serverless
8 13 (4.74%) Dynamics 365
9 11 (4.01%) SaaS
10 8 (2.92%) AWS Lambda
10 8 (2.92%) Azure Machine Learning
11 6 (2.19%) Azure Functions
11 6 (2.19%) PaaS
11 6 (2.19%) Power Automate
11 6 (2.19%) Snowflake
12 5 (1.82%) Azure Storage
12 5 (1.82%) Google Sheets
12 5 (1.82%) Matillion
12 5 (1.82%) PowerApps
13 3 (1.09%) Azure Cosmos DB
Database & Business Intelligence
1 121 (44.16%) Power BI
2 108 (39.42%) SQL Server
3 89 (32.48%) SQL Server Integration Services
4 74 (27.01%) SQL Server Reporting Services
5 68 (24.82%) SQL Server Analysis Services
6 61 (22.26%) Data Lake
7 36 (13.14%) Tableau
8 27 (9.85%) Azure SQL Data Warehouse
9 26 (9.49%) Relational Database
10 25 (9.12%) Azure SQL Database
11 23 (8.39%) Big Data
12 21 (7.66%) Enterprise Data Warehouse
13 19 (6.93%) Microsoft Analysis Services
14 18 (6.57%) SQL Server 2016
15 14 (5.11%) Spark SQL
16 12 (4.38%) Delta Lake
17 11 (4.01%) PowerPivot
17 11 (4.01%) SQL Server 2019
18 9 (3.28%) Amazon Athena
18 9 (3.28%) Crystal Reports
Development Applications
1 12 (4.38%) Team Foundation Server
2 8 (2.92%) JIRA
3 3 (1.09%) Visual Studio
4 2 (0.73%) Git (software)
4 2 (0.73%) SQL Server Management Studio (SSMS)
5 1 (0.36%) Gatling
5 1 (0.36%) Selenium
5 1 (0.36%) Subversion
General
1 55 (20.07%) Social Skills
2 46 (16.79%) Finance
3 31 (11.31%) Analytical Skills
4 18 (6.57%) Law
5 15 (5.47%) Manufacturing
6 9 (3.28%) Retail
7 8 (2.92%) Organisational Skills
7 8 (2.92%) Presentation Skills
8 5 (1.82%) Billing
8 5 (1.82%) Marketing
9 4 (1.46%) Automotive
9 4 (1.46%) Publishing
10 2 (0.73%) Electronics
10 2 (0.73%) Inclusion and Diversity
10 2 (0.73%) Legal
10 2 (0.73%) Public Sector
11 1 (0.36%) Banking
11 1 (0.36%) Digital Economy
Job Titles
1 67 (24.45%) Developer
2 57 (20.80%) Architect
3 53 (19.34%) Data Engineer
4 45 (16.42%) Business Intelligence Developer
4 45 (16.42%) Data Architect
5 39 (14.23%) Analyst
6 35 (12.77%) Azure Architect
7 23 (8.39%) AWS Architect
8 22 (8.03%) Azure Engineer
8 22 (8.03%) Business Intelligence Lead
9 19 (6.93%) Business Developer
10 16 (5.84%) Business Intelligence Analyst
11 12 (4.38%) Data Warehouse Developer
11 12 (4.38%) Power BI Analyst
12 10 (3.65%) Data Analyst
12 10 (3.65%) Solutions Architect
12 10 (3.65%) Systems Developer
13 9 (3.28%) AWS Engineer
14 8 (2.92%) Applications Support
14 8 (2.92%) Senior Data Engineer
Libraries, Frameworks & Software Standards
1 17 (6.20%) PySpark
2 12 (4.38%) MDX
3 6 (2.19%) EDI
3 6 (2.19%) JSON
3 6 (2.19%) XML
4 5 (1.82%) Middleware
5 4 (1.46%) HTML
6 3 (1.09%) NumPy
7 2 (0.73%) .NET
8 1 (0.36%) .NET Core
8 1 (0.36%) .NET Framework
8 1 (0.36%) Kafka
8 1 (0.36%) Oracle GoldenGate
8 1 (0.36%) pytest
8 1 (0.36%) REST
8 1 (0.36%) RESTful
8 1 (0.36%) Web Services
Miscellaneous
1 9 (3.28%) Management Information System
2 7 (2.55%) Data Structures
3 6 (2.19%) Enterprise Software
3 6 (2.19%) Taxonomies
4 5 (1.82%) User Experience
5 4 (1.46%) Industry 4.0
5 4 (1.46%) Life Science
5 4 (1.46%) New Media
5 4 (1.46%) Renewable Energy
5 4 (1.46%) Self-Motivation
5 4 (1.46%) Video\Live Streaming
6 3 (1.09%) Cloud Native
7 2 (0.73%) Analytical Mindset
7 2 (0.73%) Blog
7 2 (0.73%) FMCG
7 2 (0.73%) Greenfield Project
7 2 (0.73%) Legacy Systems
7 2 (0.73%) Reference Data
7 2 (0.73%) Tandem
8 1 (0.36%) iSeries
Operating Systems
1 11 (4.01%) Windows
2 1 (0.36%) Android
2 1 (0.36%) Apple iOS
2 1 (0.36%) Linux
2 1 (0.36%) Windows 10
Processes & Methodologies
1 219 (79.93%) Business Intelligence
2 106 (38.69%) Agile Software Development
3 105 (38.32%) ETL
4 86 (31.39%) Analytics
5 75 (27.37%) Data Modelling
6 50 (18.25%) Visualisation
7 42 (15.33%) Data Architecture
8 39 (14.23%) Problem-Solving
9 35 (12.77%) Data Engineering
10 32 (11.68%) DevOps
11 28 (10.22%) Data Management
11 28 (10.22%) Migration
12 27 (9.85%) Data Governance
12 27 (9.85%) Data Visualisation
13 26 (9.49%) ERP
14 25 (9.12%) Machine Learning
15 24 (8.76%) Data Analytics
15 24 (8.76%) DataOps
16 23 (8.39%) Data Strategy
16 23 (8.39%) Release Management
Programming Languages
1 169 (61.68%) SQL
2 59 (21.53%) T-SQL
3 43 (15.69%) Python
4 23 (8.39%) Data Analysis Expressions (DAX)
5 14 (5.11%) Scala
6 9 (3.28%) C#
7 7 (2.55%) PL/SQL
8 5 (1.82%) Java
9 4 (1.46%) R
10 3 (1.09%) X++
11 1 (0.36%) RPG
11 1 (0.36%) VB
11 1 (0.36%) VBA
Qualifications
1 12 (4.38%) Degree
2 4 (1.46%) ISEB
2 4 (1.46%) Numerate Degree
3 2 (0.73%) ISTQB
3 2 (0.73%) ISTQB Foundation Certification
4 1 (0.36%) SC Cleared
4 1 (0.36%) Security Cleared
Quality Assurance & Compliance
1 16 (5.84%) Data Quality
2 10 (3.65%) GDPR
3 5 (1.82%) QA
System Software
1 7 (2.55%) Docker
2 1 (0.36%) Virtual Machines
Systems Management
1 6 (2.19%) Kubernetes
Vendors
1 67 (24.45%) Microsoft
2 35 (12.77%) Databricks
3 13 (4.74%) Oracle
4 12 (4.38%) Google
5 11 (4.01%) SAP
6 10 (3.65%) Sage
7 7 (2.55%) IBM
8 6 (2.19%) Alteryx
8 6 (2.19%) Cognos
9 5 (1.82%) Informatica
10 4 (1.46%) IFS
11 3 (1.09%) Salesforce.com
12 2 (0.73%) NVIDIA
13 1 (0.36%) Ab Initio
13 1 (0.36%) Anaplan
13 1 (0.36%) Capita
13 1 (0.36%) Dell
13 1 (0.36%) ServiceNow
13 1 (0.36%) Talend
13 1 (0.36%) Xamarin