Period
to 29 May 2020

The following table provides summary statistics for permanent job vacancies advertised in the North of England 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 29 May 2020 with a comparison to the same period in the previous 2 years.

Data Warehousing
England > North of England
6 months to
29 May 2020
Same period 2019 Same period 2018
Rank 100 127 112
Rank change year-on-year +27 -15 -20
Permanent jobs citing Data Warehouse 328 494 686
As % of all permanent jobs advertised in the North of England 2.77% 2.61% 2.91%
As % of the Database & Business Intelligence category 10.06% 9.67% 9.30%
Number of salaries quoted 266 419 598
Median annual salary £52,500 £45,000 £45,000
Median salary % change year-on-year +16.67% - +5.88%
10th Percentile £34,875 £35,200 £31,250
90th Percentile £76,250 £64,300 £63,750
England median annual salary £60,000 £55,000 £52,500
% change year-on-year +9.09% +4.76% +5.00%

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 the North of England with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
North of England
Permanent vacancies with a requirement for database or business intelligence skills 3,260 5,111 7,374
As % of all permanent IT jobs advertised in the North of England 27.56% 27.05% 31.33%
Number of salaries quoted 2,689 4,182 6,317
Median annual salary £46,000 £43,800 £42,500
Median salary % change year-on-year +5.02% +3.06% +6.25%
10th Percentile £31,250 £28,750 £27,500
90th Percentile £67,500 £65,000 £62,500
England median annual salary £55,000 £52,500 £50,000
% change year-on-year +4.76% +5.00% +5.26%

Data Warehouse
Job Vacancy Trend in the North of England

Job postings citing Data Warehouse as a proportion of all IT jobs advertised in the North of England.

Job vacancy trend for Data Warehouse in the North of England

Data Warehouse
Salary Trend in the North of England

3-month moving average salary quoted in jobs citing Data Warehouse in the North of England.

Salary trend for Data Warehouse in the North of England

Data Warehouse
Salary Histogram in the North of England

Salary distribution for jobs citing Data Warehouse in the North of England over the 6 months to 29 May 2020.

Salary histogram for Data Warehouse in the North of England

Data Warehouse
Job Locations in the North of England

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Data Warehouse within the North of England region over the 6 months to 29 May 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
North West +36 200 £50,000 +11.11% 17
Yorkshire +23 100 £53,750 +13.16% 2
North East +15 28 £39,000 -17.89% 2
Data Warehouse
England

For the 6 months to 29 May 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 North of England region with a requirement for Data Warehouse.

1 207 (63.11%) Business Intelligence
2 194 (59.15%) SQL
3 133 (40.55%) ETL
4 124 (37.80%) SQL Server
5 118 (35.98%) Power BI
5 118 (35.98%) Power Platform
6 113 (34.45%) SQL Server Integration Services
7 94 (28.66%) SQL Server Reporting Services
8 91 (27.74%) Azure
9 90 (27.44%) Microsoft
10 87 (26.52%) Agile Software Development
11 82 (25.00%) Analytics
12 81 (24.70%) Data Modelling
13 74 (22.56%) SQL Server Analysis Services
14 66 (20.12%) Analytical Skills
15 59 (17.99%) Migration
16 58 (17.68%) T-SQL
17 52 (15.85%) Finance
18 45 (13.72%) Tableau
19 41 (12.50%) Data Analytics
20 40 (12.20%) Visualisation
21 39 (11.89%) AWS
22 37 (11.28%) Big Data
22 37 (11.28%) Kimball Methodology
23 36 (10.98%) BusinessObjects
24 35 (10.67%) Microsoft Excel
24 35 (10.67%) DevOps
25 33 (10.06%) Stakeholder Management
25 33 (10.06%) Data Analysis
25 33 (10.06%) Business Analysis

Data Warehouse
Co-occurring IT Skills in the North of England 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 12 (3.66%) Apache Spark
2 6 (1.83%) CMS
2 6 (1.83%) SharePoint
3 5 (1.52%) Apache
4 3 (0.91%) Confluence
4 3 (0.91%) SAS
5 2 (0.61%) Elasticsearch
6 1 (0.30%) OpenStack
Applications
1 35 (10.67%) Microsoft Excel
2 6 (1.83%) Microsoft Office
3 4 (1.22%) Microsoft PowerPoint
4 2 (0.61%) Chatbot
Business Applications
1 9 (2.74%) Dynamics GP
2 8 (2.44%) Dynamics CRM
3 3 (0.91%) Teamcenter
4 1 (0.30%) Dynamics AX
Cloud Services
1 118 (35.98%) Power Platform
2 91 (27.74%) Azure
3 39 (11.89%) AWS
4 20 (6.10%) Azure Data Factory
5 14 (4.27%) PaaS
6 13 (3.96%) Dynamics 365
6 13 (3.96%) IaaS
7 11 (3.35%) Azure Stack
8 10 (3.05%) GCP
9 6 (1.83%) SaaS
10 5 (1.52%) Serverless
11 4 (1.22%) AWS CloudFormation
11 4 (1.22%) AWS Lambda
12 3 (0.91%) Amazon Kinesis
12 3 (0.91%) Office 365
12 3 (0.91%) PowerApps
13 2 (0.61%) Amazon EC2
13 2 (0.61%) Amazon SageMaker
14 1 (0.30%) Azure Active Directory
14 1 (0.30%) Cloud Computing
Communications & Networking
1 4 (1.22%) Internet
2 2 (0.61%) Network Security
2 2 (0.61%) Software-Defined Networking
3 1 (0.30%) SMS
3 1 (0.30%) TCP/IP
Database & Business Intelligence
1 124 (37.80%) SQL Server
2 118 (35.98%) Power BI
3 113 (34.45%) SQL Server Integration Services
4 94 (28.66%) SQL Server Reporting Services
5 74 (22.56%) SQL Server Analysis Services
6 37 (11.28%) Big Data
7 36 (10.98%) BusinessObjects
8 30 (9.15%) QlikView
9 28 (8.54%) Azure SQL Database
10 22 (6.71%) Azure SQL Data Warehouse
10 22 (6.71%) Snowflake Schema
11 14 (4.27%) OLAP
11 14 (4.27%) SQL Server 2014
12 13 (3.96%) Data Lake
13 12 (3.66%) SSDT
14 10 (3.05%) PowerPivot
14 10 (3.05%) Relational Database
15 9 (2.74%) NoSQL
16 8 (2.44%) Biml
16 8 (2.44%) Data Mining
Development Applications
1 21 (6.40%) Git (software)
2 18 (5.49%) ERwin
2 18 (5.49%) JIRA
3 9 (2.74%) Visual Studio
4 7 (2.13%) Octopus Deploy
4 7 (2.13%) TeamCity
5 5 (1.52%) IBM UrbanCode
6 4 (1.22%) SQL Server Management Studio (SSMS)
7 2 (0.61%) Bitbucket
7 2 (0.61%) Jenkins
7 2 (0.61%) Visual Studio Team System
8 1 (0.30%) Cucumber
8 1 (0.30%) MSTest
8 1 (0.30%) NUnit
8 1 (0.30%) Oracle APEX
8 1 (0.30%) Postman
8 1 (0.30%) Selenium
8 1 (0.30%) SoapUI
8 1 (0.30%) SpecFlow
General
1 52 (15.85%) Finance
2 20 (6.10%) Retail
3 5 (1.52%) Banking
4 4 (1.22%) Law
5 3 (0.91%) Games
5 3 (0.91%) Legal
5 3 (0.91%) Public Sector
6 2 (0.61%) Local Government
6 2 (0.61%) Manufacturing
6 2 (0.61%) Marketing
7 1 (0.30%) Advertising
7 1 (0.30%) Aerospace
7 1 (0.30%) Housing Association
Job Titles
1 100 (30.49%) Developer
2 67 (20.43%) Business Intelligence Developer
3 50 (15.24%) Analyst
4 39 (11.89%) Architect
5 23 (7.01%) Business Intelligence Lead
5 23 (7.01%) Data Engineer
6 22 (6.71%) Data Manager
7 18 (5.49%) Data Architect
8 17 (5.18%) Business Intelligence Analyst
9 16 (4.88%) Business Analyst
10 14 (4.27%) DBA
11 13 (3.96%) Business Developer
12 12 (3.66%) Business Systems Analyst
12 12 (3.66%) Data Warehouse Developer
12 12 (3.66%) Operations Manager
12 12 (3.66%) SQL Developer
12 12 (3.66%) Systems Analyst
13 11 (3.35%) Business Intelligence Manager
13 11 (3.35%) Data Analyst
13 11 (3.35%) Solutions Architect
Libraries, Frameworks & Software Standards
1 19 (5.79%) MDX
2 18 (5.49%) .NET
3 6 (1.83%) AngularJS
3 6 (1.83%) CSS
3 6 (1.83%) HTML
3 6 (1.83%) HTML5
3 6 (1.83%) React
4 5 (1.52%) Apache Flex
4 5 (1.52%) ASP.NET
4 5 (1.52%) Elastic Stack
4 5 (1.52%) PySpark
4 5 (1.52%) WCF
4 5 (1.52%) Web Services
4 5 (1.52%) WPF
5 4 (1.22%) Middleware
6 3 (0.91%) .NET Framework
6 3 (0.91%) Kafka
7 2 (0.61%) .NET Core
7 2 (0.61%) JSON
7 2 (0.61%) REST
Miscellaneous
1 66 (20.12%) Analytical Skills
2 28 (8.54%) Data Structures
3 14 (4.27%) User Experience
4 12 (3.66%) Clustering
4 12 (3.66%) Data Centre
5 8 (2.44%) Greenfield Project
6 7 (2.13%) Management Information System
7 6 (1.83%) NHS
7 6 (1.83%) Social Media
8 5 (1.52%) Self-Motivation
9 3 (0.91%) Internet of Things
9 3 (0.91%) Private Cloud
9 3 (0.91%) Reinsurance
10 2 (0.61%) Algorithms
10 2 (0.61%) CCTV
10 2 (0.61%) Embedded Systems
10 2 (0.61%) Mobile App
10 2 (0.61%) Replication
11 1 (0.30%) Blog
11 1 (0.30%) Video Conferencing
Operating Systems
1 15 (4.57%) Windows
2 11 (3.35%) Linux
2 11 (3.35%) Windows Server
3 2 (0.61%) Android
3 2 (0.61%) Apple iOS
3 2 (0.61%) Windows 7
4 1 (0.30%) Unix
Processes & Methodologies
1 207 (63.11%) Business Intelligence
2 133 (40.55%) ETL
3 87 (26.52%) Agile Software Development
4 82 (25.00%) Analytics
5 81 (24.70%) Data Modelling
6 59 (17.99%) Migration
7 41 (12.50%) Data Analytics
8 40 (12.20%) Visualisation
9 37 (11.28%) Kimball Methodology
10 35 (10.67%) DevOps
11 33 (10.06%) Business Analysis
11 33 (10.06%) Data Analysis
11 33 (10.06%) Stakeholder Management
12 32 (9.76%) Data Science
12 32 (9.76%) Problem-Solving
13 31 (9.45%) Data Integration
14 30 (9.15%) SDLC
15 27 (8.23%) Data Management
16 25 (7.62%) Data Migration
17 23 (7.01%) Data Transformation
Programming Languages
1 194 (59.15%) SQL
2 58 (17.68%) T-SQL
3 29 (8.84%) Python
4 15 (4.57%) JavaScript
5 14 (4.27%) C#
6 10 (3.05%) Data Analysis Expressions (DAX)
6 10 (3.05%) Java
7 9 (2.74%) VBA
8 8 (2.44%) Ruby
9 7 (2.13%) PowerShell
10 6 (1.83%) Scala
11 5 (1.52%) Bash Shell
12 4 (1.22%) PL/SQL
13 2 (0.61%) R
14 1 (0.30%) C++
14 1 (0.30%) Go
14 1 (0.30%) MATLAB
14 1 (0.30%) VB.NET
14 1 (0.30%) X++
Qualifications
1 16 (4.88%) Degree
2 5 (1.52%) Computer Science Degree
3 4 (1.22%) AWS Certification
4 2 (0.61%) ISTQB
5 1 (0.30%) Master's Degree
Quality Assurance & Compliance
1 21 (6.40%) Data Quality
2 19 (5.79%) QA
3 9 (2.74%) GDPR
3 9 (2.74%) Solvency II
4 2 (0.61%) SLA
System Software
1 12 (3.66%) Active Directory
2 11 (3.35%) Hyper-V
2 11 (3.35%) Virtual Machines
3 5 (1.52%) Tivoli Workload Scheduler
4 2 (0.61%) Microsoft App-V
5 1 (0.30%) Docker
Systems Management
1 11 (3.35%) SCVMM
2 5 (1.52%) Tivoli
3 2 (0.61%) SCCM
4 1 (0.30%) Ansible
4 1 (0.30%) Kubernetes
4 1 (0.30%) Microsoft Clustering
4 1 (0.30%) Terraform
Vendors
1 90 (27.44%) Microsoft
2 45 (13.72%) Tableau
3 22 (6.71%) SAP
4 20 (6.10%) Databricks
5 14 (4.27%) Oracle
6 13 (3.96%) Sage
7 12 (3.66%) Google
7 12 (3.66%) IBM
8 11 (3.35%) PlateSpin
8 11 (3.35%) VirtaMove
9 8 (2.44%) Netezza
10 6 (1.83%) Cognos
11 5 (1.52%) Informatica
11 5 (1.52%) Jitterbit
11 5 (1.52%) Vertica
12 3 (0.91%) Alteryx
13 2 (0.61%) Cisco
13 2 (0.61%) EMC
13 2 (0.61%) Salesforce.com
13 2 (0.61%) SnapLogic