Period
to 3 July 2020

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

Data Warehousing
England > West Midlands
6 months to
3 Jul 2020
Same period 2019 Same period 2018
Rank 72 115 128
Rank change year-on-year +43 +13 -14
Permanent jobs citing Data Warehouse 141 202 227
As % of all permanent jobs advertised in the West Midlands 3.50% 2.54% 2.35%
As % of the Database & Business Intelligence category 13.10% 10.23% 9.05%
Number of salaries quoted 125 190 198
Median annual salary £51,000 £50,000 £47,000
Median salary % change year-on-year +2.00% +6.38% +10.59%
10th Percentile £35,000 £35,988 £30,000
90th Percentile £74,500 £70,000 £62,500
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 West Midlands with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
West Midlands
Permanent vacancies with a requirement for database or business intelligence skills 1,076 1,974 2,507
As % of all permanent IT jobs advertised in the West Midlands 26.69% 24.86% 25.99%
Number of salaries quoted 934 1,579 2,043
Median annual salary £47,500 £42,500 £42,500
Median salary % change year-on-year +11.76% - +6.25%
10th Percentile £30,000 £26,250 £27,000
90th Percentile £67,500 £65,400 £61,250
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 West Midlands

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

Job vacancy trend for Data Warehouse in the West Midlands

Data Warehouse
Salary Trend in the West Midlands

3-month moving average salary quoted in jobs citing Data Warehouse in the West Midlands.

Salary trend for Data Warehouse in the West Midlands

Data Warehouse
Salary Histogram in the West Midlands

Salary distribution for jobs citing Data Warehouse in the West Midlands over the 6 months to 3 July 2020.

Salary histogram for Data Warehouse in the West Midlands

Data Warehouse
Job Locations in the West Midlands

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Data Warehouse within the West Midlands region over the 6 months to 3 July 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
Birmingham +45 46 £60,250 +14.76% 6
Coventry +40 23 £53,000 +24.71% 1
Staffordshire +21 14 £42,500 +21.43% 12
Solihull +10 13 £51,750 +3.50%
Worcestershire +40 9 £40,000 -23.08% 2
Herefordshire -1 9 £50,000 - 1
West Bromwich - 8 £37,500 -
Shropshire +6 7 £50,000 -13.04%
Walsall -7 4 £23,500 -44.71% 1
Wolverhampton +3 3 £54,000 +8.00% 2
Warwickshire +10 2 £42,500 +6.25%
Data Warehouse
England

For the 6 months to 3 July 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 West Midlands region with a requirement for Data Warehouse.

1 96 (68.09%) SQL
2 91 (64.54%) Business Intelligence
3 69 (48.94%) SQL Server
4 61 (43.26%) Microsoft
5 58 (41.13%) SQL Server Reporting Services
6 56 (39.72%) Power BI
6 56 (39.72%) Power Platform
7 55 (39.01%) SQL Server Integration Services
7 55 (39.01%) ETL
8 48 (34.04%) Data Modelling
9 46 (32.62%) Visualisation
10 43 (30.50%) Agile Software Development
11 40 (28.37%) Azure
12 39 (27.66%) Analytics
12 39 (27.66%) T-SQL
13 37 (26.24%) SQL Server Analysis Services
14 35 (24.82%) Data Visualisation
15 34 (24.11%) Migration
16 31 (21.99%) Finance
17 28 (19.86%) Data Lake
18 26 (18.44%) Decision-Making
19 24 (17.02%) Data Science
19 24 (17.02%) Analytical Skills
20 22 (15.60%) Databricks
20 22 (15.60%) DevOps
21 21 (14.89%) BusinessObjects
21 21 (14.89%) Data Architecture
22 19 (13.48%) SAP
22 19 (13.48%) Azure SQL Data Warehouse
23 18 (12.77%) Dimensional Modelling

Data Warehouse
Co-occurring IT Skills in the West Midlands 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 3 (2.13%) SAS
2 2 (1.42%) Apache Spark
2 2 (1.42%) BizTalk Server
2 2 (1.42%) IIS
3 1 (0.71%) Elasticsearch
3 1 (0.71%) Tomcat
Applications
1 11 (7.80%) Microsoft Excel
2 6 (4.26%) SPSS
3 5 (3.55%) Microsoft Office
Business Applications
1 3 (2.13%) SAP IS-U
Cloud Services
1 56 (39.72%) Power Platform
2 40 (28.37%) Azure
3 15 (10.64%) Azure Data Factory
4 10 (7.09%) AWS
5 4 (2.84%) Office 365
6 3 (2.13%) Azure Active Directory
6 3 (2.13%) Azure Machine Learning
7 2 (1.42%) Amazon S3
7 2 (1.42%) SaaS
8 1 (0.71%) Amazon EC2
8 1 (0.71%) Amazon Kinesis
8 1 (0.71%) Azure Stack
8 1 (0.71%) Google Analytics
Communications & Networking
1 9 (6.38%) Broadband
2 2 (1.42%) Internet
3 1 (0.71%) Skype
Database & Business Intelligence
1 69 (48.94%) SQL Server
2 58 (41.13%) SQL Server Reporting Services
3 56 (39.72%) Power BI
4 55 (39.01%) SQL Server Integration Services
5 37 (26.24%) SQL Server Analysis Services
6 28 (19.86%) Data Lake
7 21 (14.89%) BusinessObjects
8 19 (13.48%) Azure SQL Data Warehouse
9 18 (12.77%) Big Data
10 17 (12.06%) OLTP
11 16 (11.35%) Enterprise Data Warehouse
12 12 (8.51%) Microsoft Analysis Services
13 9 (6.38%) Crystal Reports
14 8 (5.67%) Azure SQL Database
14 8 (5.67%) OLAP
14 8 (5.67%) SAP BW
15 7 (4.96%) SSDT
16 5 (3.55%) Snowflake Schema
17 4 (2.84%) IBM InfoSphere
17 4 (2.84%) Relational Database
Development Applications
1 7 (4.96%) Git (software)
1 7 (4.96%) Visual Studio
2 4 (2.84%) ERwin
3 2 (1.42%) SQL Server Management Studio (SSMS)
4 1 (0.71%) Team Foundation Server
General
1 31 (21.99%) Finance
2 14 (9.93%) Back Office
3 4 (2.84%) Banking
3 4 (2.84%) Law
4 2 (1.42%) Retail
5 1 (0.71%) Automotive
5 1 (0.71%) Games
5 1 (0.71%) Legal
5 1 (0.71%) Manufacturing
5 1 (0.71%) Marketing
5 1 (0.71%) Retail Banking
Job Titles
1 34 (24.11%) Analyst
1 34 (24.11%) Developer
2 24 (17.02%) Business Intelligence Developer
3 23 (16.31%) Data Engineer
4 22 (15.60%) Architect
5 18 (12.77%) Data Architect
6 12 (8.51%) SQL Developer
7 10 (7.09%) Data Analyst
8 8 (5.67%) Azure Engineer
8 8 (5.67%) Senior Analyst
9 7 (4.96%) Business Developer
9 7 (4.96%) Data Warehouse Architect
9 7 (4.96%) Database Architect
9 7 (4.96%) Systems Analyst
10 6 (4.26%) Business Analyst
10 6 (4.26%) Consultant
10 6 (4.26%) Crystal Reports Writer
10 6 (4.26%) Report Writer
10 6 (4.26%) Senior Data Analyst
10 6 (4.26%) Senior Developer
Libraries, Frameworks & Software Standards
1 12 (8.51%) .NET
2 8 (5.67%) ASP.NET
3 5 (3.55%) ASP.NET Web API
3 5 (3.55%) CSS
3 5 (3.55%) HTML
4 4 (2.84%) HTML5
5 3 (2.13%) .NET Framework
5 3 (2.13%) AngularJS
5 3 (2.13%) ASP.NET Core
5 3 (2.13%) Entity Framework
5 3 (2.13%) Razor View Engine
5 3 (2.13%) Web Services
6 1 (0.71%) Apache Flex
6 1 (0.71%) JMS
6 1 (0.71%) MDX
6 1 (0.71%) Natural Language Processing
6 1 (0.71%) REST
6 1 (0.71%) SOAP
6 1 (0.71%) XML
Miscellaneous
1 24 (17.02%) Analytical Skills
2 6 (4.26%) Data Structures
2 6 (4.26%) Self-Motivation
3 3 (2.13%) Management Information System
4 1 (0.71%) Analytical Mindset
4 1 (0.71%) FMCG
4 1 (0.71%) Linux Command Line
4 1 (0.71%) Mobile App
Operating Systems
1 6 (4.26%) Windows
2 2 (1.42%) Linux
3 1 (0.71%) MVS
Processes & Methodologies
1 91 (64.54%) Business Intelligence
2 55 (39.01%) ETL
3 48 (34.04%) Data Modelling
4 46 (32.62%) Visualisation
5 43 (30.50%) Agile Software Development
6 39 (27.66%) Analytics
7 35 (24.82%) Data Visualisation
8 34 (24.11%) Migration
9 26 (18.44%) Decision-Making
10 24 (17.02%) Data Science
11 22 (15.60%) DevOps
12 21 (14.89%) Data Architecture
13 18 (12.77%) Continuous Improvement
13 18 (12.77%) Data Analysis
13 18 (12.77%) Dimensional Modelling
13 18 (12.77%) User Stories
14 17 (12.06%) Data-Driven Decision Making
15 16 (11.35%) Data Management
15 16 (11.35%) ITIL
16 14 (9.93%) Stakeholder Management
Programming Languages
1 96 (68.09%) SQL
2 39 (27.66%) T-SQL
3 16 (11.35%) Python
4 6 (4.26%) PL/SQL
5 5 (3.55%) ABAP
5 5 (3.55%) Data Analysis Expressions (DAX)
6 4 (2.84%) C#
6 4 (2.84%) Java
7 3 (2.13%) TypeScript
8 2 (1.42%) R
9 1 (0.71%) C
9 1 (0.71%) C++
9 1 (0.71%) Scala
Qualifications
1 14 (9.93%) Degree
2 6 (4.26%) Microsoft Certification
3 2 (1.42%) Computer Science Degree
4 1 (0.71%) MCSA
4 1 (0.71%) PhD
4 1 (0.71%) Security Cleared
Quality Assurance & Compliance
1 12 (8.51%) Data Quality
2 11 (7.80%) GDPR
3 1 (0.71%) QA
3 1 (0.71%) Sarbanes-Oxley
System Software
1 5 (3.55%) Active Directory
Systems Management
1 1 (0.71%) Kibana
Vendors
1 61 (43.26%) Microsoft
2 22 (15.60%) Databricks
3 19 (13.48%) SAP
4 17 (12.06%) Tableau
5 10 (7.09%) Oracle
6 4 (2.84%) IBM
7 3 (2.13%) Birst
7 3 (2.13%) Infor
8 2 (1.42%) Ab Initio
8 2 (1.42%) Cognos
8 2 (1.42%) TIBCO
9 1 (0.71%) Google
9 1 (0.71%) StreamSets
9 1 (0.71%) Talend