Period
to 3 April 2020

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

Data Warehousing
England > Midlands
6 months to
3 Apr 2020
Same period 2019 Same period 2018
Rank 98 116 102
Rank change year-on-year +18 -14 +5
Permanent jobs citing Data Warehouse 276 312 445
As % of all permanent jobs advertised in the Midlands 2.92% 2.57% 2.93%
As % of the Database & Business Intelligence category 11.04% 9.74% 9.74%
Number of salaries quoted 253 281 416
Median annual salary £45,000 £45,000 £47,000
Median salary % change year-on-year - -4.26% +6.82%
10th Percentile £32,500 £32,500 £30,000
90th Percentile £72,250 £70,000 £63,750
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 Midlands with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
Midlands
Permanent vacancies with a requirement for database or business intelligence skills 2,499 3,204 4,567
As % of all permanent IT jobs advertised in the Midlands 26.41% 26.44% 30.03%
Number of salaries quoted 2,172 2,472 3,855
Median annual salary £45,000 £42,000 £40,000
Median salary % change year-on-year +7.14% +5.00% -
10th Percentile £28,000 £26,250 £26,250
90th Percentile £70,000 £64,973 £60,000
England median annual salary £53,931 £52,500 £50,000
% change year-on-year +2.73% +5.00% +5.26%

Data Warehouse
Job Vacancy Trend in the Midlands

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

Job vacancy trend for Data Warehouse in the Midlands

Data Warehouse
Salary Trend in the Midlands

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

Salary trend for Data Warehouse in the Midlands

Data Warehouse
Salary Histogram in the Midlands

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

Salary histogram for Data Warehouse in the Midlands

Data Warehouse
Job Locations in the 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 Midlands region over the 6 months to 3 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
West Midlands +49 203 £47,500 -5.00% 57
East Midlands -23 71 £40,000 -5.88% 10
Data Warehouse
England

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

1 189 (68.48%) SQL
2 176 (63.77%) Business Intelligence
3 124 (44.93%) SQL Server
4 107 (38.77%) ETL
4 107 (38.77%) Power BI
4 107 (38.77%) Power Platform
5 105 (38.04%) Microsoft
6 101 (36.59%) SQL Server Integration Services
7 93 (33.70%) SQL Server Reporting Services
8 90 (32.61%) Azure
9 88 (31.88%) Data Modelling
10 78 (28.26%) Agile Software Development
11 70 (25.36%) Analytics
12 61 (22.10%) SQL Server Analysis Services
13 59 (21.38%) Finance
14 58 (21.01%) T-SQL
15 51 (18.48%) Analytical Skills
16 45 (16.30%) Problem-Solving
17 42 (15.22%) Visualisation
18 40 (14.49%) Kimball Methodology
19 38 (13.77%) DevOps
20 37 (13.41%) Oracle
21 34 (12.32%) Azure Data Factory
21 34 (12.32%) Tableau
22 33 (11.96%) Data Visualisation
22 33 (11.96%) AWS
23 32 (11.59%) Python
23 32 (11.59%) Data Analysis
24 28 (10.14%) Azure SQL Database
25 27 (9.78%) Decision-Making

Data Warehouse
Co-occurring IT Skills in the 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 19 (6.88%) SAS
2 11 (3.99%) IIS
3 6 (2.17%) Apache Spark
3 6 (2.17%) SharePoint
4 4 (1.45%) Confluence
5 2 (0.72%) Apache Pig
5 2 (0.72%) BizTalk Server
5 2 (0.72%) Jupyter
6 1 (0.36%) Apache
6 1 (0.36%) Apache Synapse
6 1 (0.36%) Elasticsearch
6 1 (0.36%) Oracle SOA Suite
6 1 (0.36%) Tomcat
6 1 (0.36%) WebSphere
6 1 (0.36%) WebSphere Application Server
Applications
1 20 (7.25%) Microsoft Excel
2 6 (2.17%) SPSS
3 3 (1.09%) Microsoft Office
4 1 (0.36%) Microsoft PowerPoint
Business Applications
1 5 (1.81%) Dynamics GP
2 2 (0.72%) Dynamics AX
2 2 (0.72%) NetSuite
3 1 (0.36%) Cognos Business Intelligence
3 1 (0.36%) Oracle EBS
3 1 (0.36%) SAP BPC
3 1 (0.36%) SAP IS-U
Cloud Services
1 107 (38.77%) Power Platform
2 90 (32.61%) Azure
3 34 (12.32%) Azure Data Factory
4 33 (11.96%) AWS
5 9 (3.26%) SaaS
6 6 (2.17%) PaaS
7 5 (1.81%) IaaS
8 4 (1.45%) Office 365
9 3 (1.09%) Azure Active Directory
9 3 (1.09%) Azure Stack
10 2 (0.72%) Amazon S3
10 2 (0.72%) Dynamics 365
11 1 (0.36%) Amazon EC2
11 1 (0.36%) Amazon Kinesis
11 1 (0.36%) Cloud Computing
11 1 (0.36%) GCP
11 1 (0.36%) Google Analytics
11 1 (0.36%) Microsoft Flow
11 1 (0.36%) PowerApps
Communications & Networking
1 11 (3.99%) Internet
2 3 (1.09%) Broadband
3 1 (0.36%) Skype
Database & Business Intelligence
1 124 (44.93%) SQL Server
2 107 (38.77%) Power BI
3 101 (36.59%) SQL Server Integration Services
4 93 (33.70%) SQL Server Reporting Services
5 61 (22.10%) SQL Server Analysis Services
6 28 (10.14%) Azure SQL Database
7 25 (9.06%) BusinessObjects
8 23 (8.33%) Microsoft Analysis Services
9 22 (7.97%) Azure SQL Data Warehouse
10 21 (7.61%) Relational Database
11 18 (6.52%) Big Data
11 18 (6.52%) Data Lake
11 18 (6.52%) Snowflake Schema
12 14 (5.07%) OLAP
13 13 (4.71%) Crystal Reports
14 12 (4.35%) Enterprise Data Warehouse
15 11 (3.99%) Hadoop
15 11 (3.99%) OLTP
16 7 (2.54%) MongoDB
16 7 (2.54%) RDBMS
Development Applications
1 11 (3.99%) Team Foundation Server
2 10 (3.62%) Git (software)
3 6 (2.17%) JIRA
4 5 (1.81%) Jenkins
4 5 (1.81%) SQL Server Management Studio (SSMS)
5 4 (1.45%) ERwin
5 4 (1.45%) Oracle Forms
5 4 (1.45%) Selenium
6 3 (1.09%) PowerDesigner
7 2 (0.72%) Artifactory
7 2 (0.72%) Bitbucket
7 2 (0.72%) JMeter
7 2 (0.72%) Maven
7 2 (0.72%) Postman
8 1 (0.36%) Liquibase
8 1 (0.36%) Subversion
8 1 (0.36%) Visual Studio
General
1 59 (21.38%) Finance
2 14 (5.07%) Retail
3 10 (3.62%) Back Office
4 8 (2.90%) Automotive
5 7 (2.54%) Billing
5 7 (2.54%) Marketing
6 5 (1.81%) Manufacturing
7 4 (1.45%) Public Sector
8 2 (0.72%) Banking
8 2 (0.72%) Law
9 1 (0.36%) Advertising
9 1 (0.36%) Games
Job Titles
1 96 (34.78%) Developer
2 73 (26.45%) Business Intelligence Developer
3 50 (18.12%) Analyst
4 31 (11.23%) Architect
5 29 (10.51%) Data Engineer
6 22 (7.97%) Data Architect
6 22 (7.97%) SQL Developer
7 21 (7.61%) Business Developer
8 15 (5.43%) Data Analyst
9 14 (5.07%) Consultant
10 12 (4.35%) Solutions Architect
11 11 (3.99%) Data Warehouse Specialist
11 11 (3.99%) Senior Data Warehouse Specialist
12 10 (3.62%) Business Intelligence Analyst
12 10 (3.62%) Business Intelligence Consultant
12 10 (3.62%) Crystal Reports Writer
12 10 (3.62%) Senior Analyst
12 10 (3.62%) Senior Technical Specialist
12 10 (3.62%) Senior Unix Technical Specialist
12 10 (3.62%) Technical Specialist
Libraries, Frameworks & Software Standards
1 17 (6.16%) .NET
2 10 (3.62%) ASP.NET
3 9 (3.26%) MDX
4 7 (2.54%) .NET Framework
4 7 (2.54%) Entity Framework
4 7 (2.54%) WinForms
5 6 (2.17%) Kafka
5 6 (2.17%) Web Services
6 5 (1.81%) JSON
7 4 (1.45%) CSS
7 4 (1.45%) HTML
7 4 (1.45%) LINQ
7 4 (1.45%) Middleware
7 4 (1.45%) XML
8 3 (1.09%) Ajax
8 3 (1.09%) AngularJS
8 3 (1.09%) ASP.NET Web Forms
8 3 (1.09%) CSS3
8 3 (1.09%) FIX Protocol
8 3 (1.09%) HTML5
Miscellaneous
1 51 (18.48%) Analytical Skills
2 23 (8.33%) Data Structures
3 21 (7.61%) Management Information System
4 10 (3.62%) Linux Command Line
5 9 (3.26%) Self-Motivation
6 7 (2.54%) Credit Risk
7 3 (1.09%) Public Cloud
7 3 (1.09%) Reference Data
7 3 (1.09%) Replication
7 3 (1.09%) User Experience
8 2 (0.72%) Client/Server
9 1 (0.36%) Analytical Mindset
9 1 (0.36%) Data Centre
9 1 (0.36%) EPoS
9 1 (0.36%) FMCG
9 1 (0.36%) Mainframe
Operating Systems
1 19 (6.88%) Linux
2 18 (6.52%) Windows
3 7 (2.54%) Unix
4 4 (1.45%) Windows 7
5 1 (0.36%) Android
5 1 (0.36%) Apple iOS
5 1 (0.36%) MVS
Processes & Methodologies
1 176 (63.77%) Business Intelligence
2 107 (38.77%) ETL
3 88 (31.88%) Data Modelling
4 78 (28.26%) Agile Software Development
5 70 (25.36%) Analytics
6 45 (16.30%) Problem-Solving
7 42 (15.22%) Visualisation
8 40 (14.49%) Kimball Methodology
9 38 (13.77%) DevOps
10 33 (11.96%) Data Visualisation
11 32 (11.59%) Data Analysis
12 27 (9.78%) Decision-Making
12 27 (9.78%) Migration
13 24 (8.70%) Data Science
14 23 (8.33%) Data Governance
15 21 (7.61%) Data Architecture
15 21 (7.61%) Performance Tuning
16 20 (7.25%) Data Analytics
17 19 (6.88%) Scrum
17 19 (6.88%) SDLC
Programming Languages
1 189 (68.48%) SQL
2 58 (21.01%) T-SQL
3 32 (11.59%) Python
4 26 (9.42%) Data Analysis Expressions (DAX)
5 17 (6.16%) C#
5 17 (6.16%) PL/SQL
6 11 (3.99%) Java
7 8 (2.90%) R
8 6 (2.17%) VB.NET
9 5 (1.81%) Scala
9 5 (1.81%) VBA
10 4 (1.45%) TypeScript
11 3 (1.09%) ABAP
11 3 (1.09%) JavaScript
12 2 (0.72%) PowerShell
12 2 (0.72%) VB
13 1 (0.36%) C
13 1 (0.36%) C++
Qualifications
1 27 (9.78%) Degree
2 11 (3.99%) Computer Science Degree
3 6 (2.17%) ISTQB
4 5 (1.81%) Microsoft Certification
5 3 (1.09%) AWS Certification
5 3 (1.09%) Master's Degree
6 2 (0.72%) ISTQB Foundation Certification
7 1 (0.36%) ISEB
7 1 (0.36%) PhD
7 1 (0.36%) Security Cleared
Quality Assurance & Compliance
1 23 (8.33%) Data Quality
2 15 (5.43%) QA
3 12 (4.35%) GDPR
4 5 (1.81%) Solvency II
5 1 (0.36%) PMO
5 1 (0.36%) Sarbanes-Oxley
System Software
1 14 (5.07%) Active Directory
2 4 (1.45%) Microsoft App-V
3 3 (1.09%) Hyper-V
3 3 (1.09%) VMware Infrastructure
4 1 (0.36%) Apache Flume
Systems Management
1 4 (1.45%) SCCM
2 2 (0.72%) Ansible
2 2 (0.72%) Terraform
3 1 (0.36%) Kibana
Vendors
1 105 (38.04%) Microsoft
2 37 (13.41%) Oracle
3 34 (12.32%) Tableau
4 22 (7.97%) IBM
5 21 (7.61%) SAP
6 19 (6.88%) Cognos
6 19 (6.88%) Databricks
7 6 (2.17%) Ab Initio
8 5 (1.81%) Google
9 4 (1.45%) Cisco
9 4 (1.45%) EMC
9 4 (1.45%) Informatica
9 4 (1.45%) Netezza
10 3 (1.09%) VMware
11 2 (0.72%) Atlassian
11 2 (0.72%) Birst
11 2 (0.72%) Cloudera
11 2 (0.72%) Infor
11 2 (0.72%) JD Edwards
11 2 (0.72%) TIBCO