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

Data Warehousing
England > West Midlands
6 months to
2 Apr 2020
Same period 2019 Same period 2018
Rank 85 126 98
Rank change year-on-year +41 -28 +17
Permanent jobs citing Data Warehouse 203 182 294
As % of all permanent jobs advertised in the West Midlands 3.32% 2.30% 2.98%
As % of the Database & Business Intelligence category 13.07% 9.31% 10.95%
Number of salaries quoted 193 181 266
Median annual salary £47,500 £50,000 £47,500
Median salary % change year-on-year -5.00% +5.26% +11.76%
10th Percentile £33,000 £32,500 £30,188
90th Percentile £72,500 £72,500 £65,000
England median annual salary £60,000 £55,000 £52,000
% change year-on-year +9.09% +5.77% -0.95%

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,553 1,955 2,684
As % of all permanent IT jobs advertised in the West Midlands 25.40% 24.67% 27.20%
Number of salaries quoted 1,368 1,515 2,184
Median annual salary £45,000 £42,500 £40,000
Median salary % change year-on-year +5.88% +6.25% -
10th Percentile £29,000 £26,250 £26,250
90th Percentile £67,500 £65,000 £60,175
England median annual salary £53,869 £52,500 £50,000
% change year-on-year +2.61% +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 2 April 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 2 April 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 +33 66 £60,000 +14.29% 18
Coventry +52 49 £48,931 +3.01% 1
Walsall -7 18 £38,500 -9.41% 4
Staffordshire +9 17 £36,000 +16.13% 9
Shropshire +21 12 £37,500 -23.08% 4
Solihull +7 10 £52,500 +5.00% 6
West Bromwich - 8 £37,500 - 1
Worcestershire +25 7 £40,000 -17.09% 2
Herefordshire +5 7 £55,000 +10.00% 2
Warwickshire -22 4 £42,500 +6.25% 1
Wolverhampton - 3 £54,000 - 11
Data Warehouse
England

For the 6 months to 2 April 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 134 (66.01%) SQL
2 122 (60.10%) Business Intelligence
3 89 (43.84%) SQL Server
4 88 (43.35%) Microsoft
5 81 (39.90%) ETL
6 73 (35.96%) Data Modelling
7 71 (34.98%) Power BI
7 71 (34.98%) Power Platform
8 62 (30.54%) SQL Server Integration Services
9 61 (30.05%) Agile Software Development
10 60 (29.56%) SQL Server Reporting Services
11 58 (28.57%) Analytics
12 53 (26.11%) Azure
13 49 (24.14%) Finance
14 42 (20.69%) Visualisation
15 40 (19.70%) SQL Server Analysis Services
16 36 (17.73%) T-SQL
16 36 (17.73%) Analytical Skills
17 34 (16.75%) DevOps
18 33 (16.26%) Data Visualisation
19 30 (14.78%) Tableau
20 28 (13.79%) Kimball Methodology
20 28 (13.79%) Problem-Solving
20 28 (13.79%) Data Analysis
21 26 (12.81%) AWS
22 25 (12.32%) Oracle
22 25 (12.32%) Decision-Making
23 24 (11.82%) BusinessObjects
24 22 (10.84%) Data Science
25 21 (10.34%) IBM

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 17 (8.37%) SAS
2 12 (5.91%) IIS
3 4 (1.97%) Confluence
3 4 (1.97%) SharePoint
4 3 (1.48%) Apache Spark
5 2 (0.99%) Apache Pig
5 2 (0.99%) BizTalk Server
5 2 (0.99%) Jupyter
6 1 (0.49%) Elasticsearch
6 1 (0.49%) Oracle SOA Suite
6 1 (0.49%) Tomcat
6 1 (0.49%) WebSphere
6 1 (0.49%) WebSphere Application Server
Applications
1 20 (9.85%) Microsoft Excel
2 6 (2.96%) SPSS
3 3 (1.48%) Microsoft Office
4 1 (0.49%) Microsoft PowerPoint
Business Applications
1 5 (2.46%) Dynamics GP
2 1 (0.49%) Cognos Business Intelligence
2 1 (0.49%) Oracle EBS
2 1 (0.49%) SAP IS-U
Cloud Services
1 71 (34.98%) Power Platform
2 53 (26.11%) Azure
3 26 (12.81%) AWS
4 18 (8.87%) Azure Data Factory
5 4 (1.97%) Office 365
6 3 (1.48%) Azure Active Directory
7 2 (0.99%) Amazon S3
7 2 (0.99%) PaaS
7 2 (0.99%) SaaS
8 1 (0.49%) Amazon EC2
8 1 (0.49%) Amazon Kinesis
8 1 (0.49%) Azure Stack
8 1 (0.49%) Cloud Computing
8 1 (0.49%) Google Analytics
8 1 (0.49%) IaaS
8 1 (0.49%) Microsoft Flow
8 1 (0.49%) PowerApps
Communications & Networking
1 12 (5.91%) Internet
2 3 (1.48%) Broadband
3 1 (0.49%) Skype
Database & Business Intelligence
1 89 (43.84%) SQL Server
2 71 (34.98%) Power BI
3 62 (30.54%) SQL Server Integration Services
4 60 (29.56%) SQL Server Reporting Services
5 40 (19.70%) SQL Server Analysis Services
6 24 (11.82%) BusinessObjects
7 17 (8.37%) Azure SQL Database
8 16 (7.88%) Azure SQL Data Warehouse
8 16 (7.88%) Big Data
9 13 (6.40%) Crystal Reports
9 13 (6.40%) Data Lake
10 12 (5.91%) Enterprise Data Warehouse
11 11 (5.42%) Microsoft Analysis Services
12 10 (4.93%) Hadoop
12 10 (4.93%) Snowflake Schema
13 8 (3.94%) OLTP
13 8 (3.94%) Relational Database
14 7 (3.45%) SAS Data Integration Studio
15 6 (2.96%) OLAP
16 4 (1.97%) SAP BW
Development Applications
1 9 (4.43%) Team Foundation Server
2 6 (2.96%) Git (software)
3 5 (2.46%) SQL Server Management Studio (SSMS)
4 4 (1.97%) JIRA
5 2 (0.99%) Artifactory
5 2 (0.99%) Bitbucket
5 2 (0.99%) Jenkins
5 2 (0.99%) JMeter
5 2 (0.99%) Maven
5 2 (0.99%) Postman
5 2 (0.99%) Selenium
6 1 (0.49%) ERwin
General
1 49 (24.14%) Finance
2 10 (4.93%) Back Office
3 8 (3.94%) Automotive
4 7 (3.45%) Billing
5 6 (2.96%) Retail
6 5 (2.46%) Manufacturing
7 3 (1.48%) Public Sector
8 1 (0.49%) Games
8 1 (0.49%) Marketing
Job Titles
1 50 (24.63%) Developer
2 40 (19.70%) Analyst
3 38 (18.72%) Business Intelligence Developer
4 24 (11.82%) Data Engineer
5 18 (8.87%) Architect
6 16 (7.88%) SQL Developer
7 13 (6.40%) Data Architect
8 12 (5.91%) Consultant
8 12 (5.91%) Data Warehouse Specialist
8 12 (5.91%) Senior Data Warehouse Specialist
9 11 (5.42%) Senior Technical Specialist
9 11 (5.42%) Senior Unix Technical Specialist
9 11 (5.42%) Technical Specialist
10 10 (4.93%) Business Developer
10 10 (4.93%) Business Intelligence Manager
10 10 (4.93%) Crystal Reports Writer
10 10 (4.93%) Report Writer
10 10 (4.93%) Senior Analyst
11 9 (4.43%) Business Manager
11 9 (4.43%) Data Analyst
Libraries, Frameworks & Software Standards
1 8 (3.94%) .NET
2 6 (2.96%) Web Services
3 5 (2.46%) MDX
4 4 (1.97%) ASP.NET
5 3 (1.48%) .NET Framework
5 3 (1.48%) AngularJS
5 3 (1.48%) ASP.NET Core
5 3 (1.48%) Entity Framework
5 3 (1.48%) Razor View Engine
6 2 (0.99%) Middleware
6 2 (0.99%) scikit-learn
7 1 (0.49%) Apache Flex
7 1 (0.49%) ASP.NET Web API
7 1 (0.49%) CSS
7 1 (0.49%) HTML
7 1 (0.49%) Java EE
7 1 (0.49%) JMS
7 1 (0.49%) Natural Language Processing
7 1 (0.49%) SOAP
7 1 (0.49%) XML
Miscellaneous
1 36 (17.73%) Analytical Skills
2 19 (9.36%) Management Information System
3 11 (5.42%) Linux Command Line
4 10 (4.93%) Data Structures
5 8 (3.94%) Self-Motivation
6 7 (3.45%) Credit Risk
7 3 (1.48%) Public Cloud
7 3 (1.48%) Replication
7 3 (1.48%) User Experience
8 2 (0.99%) Client/Server
9 1 (0.49%) Analytical Mindset
9 1 (0.49%) Data Centre
9 1 (0.49%) FMCG
9 1 (0.49%) Mainframe
Operating Systems
1 19 (9.36%) Linux
2 17 (8.37%) Windows
3 6 (2.96%) Unix
4 2 (0.99%) Windows 7
5 1 (0.49%) MVS
Processes & Methodologies
1 122 (60.10%) Business Intelligence
2 81 (39.90%) ETL
3 73 (35.96%) Data Modelling
4 61 (30.05%) Agile Software Development
5 58 (28.57%) Analytics
6 42 (20.69%) Visualisation
7 34 (16.75%) DevOps
8 33 (16.26%) Data Visualisation
9 28 (13.79%) Data Analysis
9 28 (13.79%) Kimball Methodology
9 28 (13.79%) Problem-Solving
10 25 (12.32%) Decision-Making
11 22 (10.84%) Data Science
12 20 (9.85%) Migration
12 20 (9.85%) Performance Tuning
13 18 (8.87%) Data Architecture
13 18 (8.87%) SDLC
14 17 (8.37%) Data Analytics
14 17 (8.37%) High Availability
15 16 (7.88%) Mentoring
Programming Languages
1 134 (66.01%) SQL
2 36 (17.73%) T-SQL
3 19 (9.36%) Python
4 9 (4.43%) Data Analysis Expressions (DAX)
4 9 (4.43%) PL/SQL
5 6 (2.96%) Java
6 4 (1.97%) C#
7 3 (1.48%) ABAP
7 3 (1.48%) TypeScript
7 3 (1.48%) VBA
8 1 (0.49%) PowerShell
8 1 (0.49%) R
8 1 (0.49%) Scala
8 1 (0.49%) VB
Qualifications
1 17 (8.37%) Degree
2 6 (2.96%) ISTQB
3 4 (1.97%) Computer Science Degree
4 3 (1.48%) Microsoft Certification
5 2 (0.99%) ISTQB Foundation Certification
6 1 (0.49%) ISEB
6 1 (0.49%) PhD
6 1 (0.49%) Security Cleared
Quality Assurance & Compliance
1 13 (6.40%) Data Quality
2 10 (4.93%) QA
3 8 (3.94%) GDPR
4 5 (2.46%) Solvency II
5 1 (0.49%) PMO
5 1 (0.49%) Sarbanes-Oxley
System Software
1 15 (7.39%) Active Directory
2 3 (1.48%) Hyper-V
2 3 (1.48%) VMware Infrastructure
3 2 (0.99%) Microsoft App-V
Systems Management
1 2 (0.99%) Ansible
1 2 (0.99%) SCCM
1 2 (0.99%) Terraform
2 1 (0.49%) Kibana
Vendors
1 88 (43.35%) Microsoft
2 30 (14.78%) Tableau
3 25 (12.32%) Oracle
4 21 (10.34%) IBM
5 18 (8.87%) Cognos
5 18 (8.87%) SAP
6 11 (5.42%) Databricks
7 6 (2.96%) Ab Initio
8 5 (2.46%) Netezza
9 4 (1.97%) Informatica
10 3 (1.48%) Google
10 3 (1.48%) VMware
11 2 (0.99%) Birst
11 2 (0.99%) Cisco
11 2 (0.99%) Cloudera
11 2 (0.99%) EMC
11 2 (0.99%) Infor
11 2 (0.99%) TIBCO
12 1 (0.49%) StreamSets