Period
to 23 February 2019

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

Data Warehousing
Yorkshire > West Yorkshire
6 months to
23 Feb 2019
Same period 2018 Same period 2017
Rank 98 71 87
Rank change year-on-year -27 +16 -25
Permanent jobs citing Data Warehouse 124 241 235
As % of all permanent IT jobs advertised in West Yorkshire 2.67% 3.49% 3.23%
As % of the Database & Business Intelligence category 11.06% 13.62% 10.60%
Number of salaries quoted 113 201 194
West Yorkshire median annual salary £42,500 £45,000 £45,000
Median salary % change year-on-year -5.56% - -
10th Percentile £32,500 £31,250 £32,500
90th Percentile £72,500 £67,500 £72,500
Yorkshire median annual salary £47,500 £45,000 £42,500
% change year-on-year +5.56% +5.88% -

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 West Yorkshire with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
West Yorkshire
Permanent vacancies with a requirement for database or business intelligence skills 1,121 1,770 2,218
As % of all permanent IT jobs advertised in West Yorkshire 24.17% 25.65% 30.46%
Number of salaries quoted 947 1,551 1,991
West Yorkshire median annual salary £42,500 £42,500 £40,000
Median salary % change year-on-year - +6.25% -
10th Percentile £30,000 £29,750 £27,500
90th Percentile £58,750 £60,000 £56,500
Yorkshire median annual salary £42,500 £42,500 £40,000
% change year-on-year - +6.25% -

Data Warehouse
Job Vacancy Trend in West Yorkshire

Job postings citing Data Warehouse as a percentage of all IT jobs advertised in West Yorkshire.

Job vacancy trend for Data Warehouse in West Yorkshire

Data Warehouse
Salary Trend in West Yorkshire

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing Data Warehouse in West Yorkshire.

Salary trend for Data Warehouse in West Yorkshire

Data Warehouse
Salary Histogram in West Yorkshire

The salary distribution of IT jobs citing Data Warehouse in West Yorkshire over the 6 months to 23 February 2019.

Salary histogram for Data Warehouse in West Yorkshire

Data Warehouse
Job Locations in West 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 West Yorkshire region over the 6 months to 23 February 2019. 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
Leeds -25 74 £47,500 +5.56% 15
Bradford +15 19 £42,500 -15.00% 3
Halifax +17 18 £42,500 +6.25% 2
Wakefield -1 5 £41,500 +0.61%
Bingley +9 2 £47,000 +44.62% 2
Dewsbury - 1 £37,500 -
Data Warehouse
Yorkshire

For the 6 months to 23 February 2019, 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 Yorkshire region with a requirement for Data Warehouse.

1 94 (75.81%) Business Intelligence
2 88 (70.97%) SQL
3 73 (58.87%) SQL Server
4 72 (58.06%) ETL
5 65 (52.42%) SQL Server Integration Services
6 58 (46.77%) T-SQL
7 49 (39.52%) Data Modelling
7 49 (39.52%) Microsoft
8 42 (33.87%) SQL Server Reporting Services
9 36 (29.03%) SQL Server Analysis Services
10 33 (26.61%) Power BI
11 29 (23.39%) Data Quality
12 24 (19.35%) Finance
13 22 (17.74%) Agile Software Development
14 20 (16.13%) Analytics
15 18 (14.52%) Data Integration
16 16 (12.90%) Star Schema
17 15 (12.10%) Microsoft Azure
18 14 (11.29%) Data Architecture
19 13 (10.48%) Dimensional Modelling
20 12 (9.68%) Migration
20 12 (9.68%) C#
20 12 (9.68%) Visualisation
21 11 (8.87%) Data Analytics
21 11 (8.87%) Tableau
21 11 (8.87%) Python
21 11 (8.87%) Cognos
21 11 (8.87%) Analytical Skills
22 10 (8.06%) ETL Development
22 10 (8.06%) SAP

Data Warehouse
Co-occurring IT Skills in West 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 8 (6.45%) SharePoint
2 7 (5.65%) Skype for Business
3 5 (4.03%) IIS
4 4 (3.23%) Exchange Server 2007
4 4 (3.23%) MS Exchange
5 2 (1.61%) SAS
Applications
1 7 (5.65%) Microsoft Excel
2 3 (2.42%) Microsoft Office
3 1 (0.81%) Microsoft Project
3 1 (0.81%) MS Visio
Business Applications
1 4 (3.23%) Cognos TM1
2 2 (1.61%) Cognos Business Intelligence
3 1 (0.81%) Dynamics CRM
Cloud Services
1 15 (12.10%) Microsoft Azure
2 9 (7.26%) Amazon AWS
3 5 (4.03%) Amazon Kinesis
3 5 (4.03%) Amazon SageMaker
4 4 (3.23%) IaaS
4 4 (3.23%) PaaS
5 3 (2.42%) SaaS
6 2 (1.61%) Cloud Computing
7 1 (0.81%) Adobe Analytics
7 1 (0.81%) Azure Active Directory
7 1 (0.81%) Google Analytics
7 1 (0.81%) NuGet
7 1 (0.81%) Office 365
Communications & Networking
1 4 (3.23%) Cisco IOS
1 4 (3.23%) DHCP
1 4 (3.23%) DNS
1 4 (3.23%) MPLS
1 4 (3.23%) VoIP
1 4 (3.23%) WAN
2 3 (2.42%) Firewall
3 2 (1.61%) BGP
3 2 (1.61%) OSPF
3 2 (1.61%) Spanning Tree
3 2 (1.61%) VLAN
4 1 (0.81%) FTP
4 1 (0.81%) SAN
4 1 (0.81%) VPN
Database & Business Intelligence
1 73 (58.87%) SQL Server
2 65 (52.42%) SQL Server Integration Services
3 42 (33.87%) SQL Server Reporting Services
4 36 (29.03%) SQL Server Analysis Services
5 33 (26.61%) Power BI
6 16 (12.90%) Star Schema
7 9 (7.26%) QlikView
7 9 (7.26%) Relational Database
8 8 (6.45%) SQL Server 2008
9 7 (5.65%) Amazon RDS
9 7 (5.65%) BusinessObjects
10 6 (4.84%) Amazon Redshift
10 6 (4.84%) Data Lake
10 6 (4.84%) OLAP
11 5 (4.03%) Amazon Aurora
11 5 (4.03%) Data Mart
11 5 (4.03%) MongoDB
11 5 (4.03%) MySQL
11 5 (4.03%) Pentaho
11 5 (4.03%) Snowflake Schema
Development Applications
1 4 (3.23%) TeamCity
2 3 (2.42%) Atlassian Bamboo
2 3 (2.42%) Git (software)
2 3 (2.42%) Jenkins
2 3 (2.42%) SQL Server Management Studio (SSMS)
3 1 (0.81%) Moq
3 1 (0.81%) NUnit
3 1 (0.81%) Oracle APEX
3 1 (0.81%) SpecFlow
3 1 (0.81%) Visual Studio
General
1 24 (19.35%) Finance
2 8 (6.45%) Retail
3 4 (3.23%) Manufacturing
4 3 (2.42%) Banking
4 3 (2.42%) Legal
5 1 (0.81%) Automotive
5 1 (0.81%) Games
5 1 (0.81%) Marketing
Job Titles
1 62 (50.00%) Developer
2 48 (38.71%) Business Intelligence Developer
3 16 (12.90%) Architect
4 13 (10.48%) Senior Developer
5 9 (7.26%) Senior Business Intelligence Developer
6 7 (5.65%) Analyst
6 7 (5.65%) Business Intelligence Manager
6 7 (5.65%) Data Warehouse Developer
6 7 (5.65%) ETL Developer
6 7 (5.65%) SQL Developer
7 6 (4.84%) Data Engineer
8 5 (4.03%) Business Developer
8 5 (4.03%) DBA
8 5 (4.03%) Software Tester
8 5 (4.03%) Tester
9 4 (3.23%) Administrator
9 4 (3.23%) Data Architect
9 4 (3.23%) Network Engineer
9 4 (3.23%) Project Engineer
9 4 (3.23%) SQL DBA
Libraries, Frameworks & Software Standards
1 8 (6.45%) Web Services
2 7 (5.65%) .NET
3 6 (4.84%) ASP.NET
4 4 (3.23%) XML
5 2 (1.61%) ADO.NET
5 2 (1.61%) JSON
5 2 (1.61%) XSD
6 1 (0.81%) ASP.NET MVC
6 1 (0.81%) ASP.NET MVC 4
6 1 (0.81%) Entity Framework
6 1 (0.81%) HTML
6 1 (0.81%) jQuery
6 1 (0.81%) KnockoutJS
6 1 (0.81%) LESS
6 1 (0.81%) MDX
6 1 (0.81%) RESTful
6 1 (0.81%) Sass
6 1 (0.81%) SignalR
6 1 (0.81%) Twitter Bootstrap
6 1 (0.81%) Unity DI Container
Miscellaneous
1 11 (8.87%) Analytical Skills
2 8 (6.45%) NHS
3 5 (4.03%) Enterprise Software
4 4 (3.23%) Data Centre
5 3 (2.42%) Market Risk
6 2 (1.61%) Greenfield Project
6 2 (1.61%) Hybrid Cloud
6 2 (1.61%) Private Cloud
6 2 (1.61%) Replication
7 1 (0.81%) Algorithms
7 1 (0.81%) Blog
7 1 (0.81%) Fintech
7 1 (0.81%) Management Information System
7 1 (0.81%) User Experience
Operating Systems
1 6 (4.84%) Windows
2 5 (4.03%) Linux
2 5 (4.03%) Windows Server
3 4 (3.23%) Windows Server 2012
4 3 (2.42%) Kali Linux
5 1 (0.81%) Unix
Processes & Methodologies
1 94 (75.81%) Business Intelligence
2 72 (58.06%) ETL
3 49 (39.52%) Data Modelling
4 22 (17.74%) Agile Software Development
5 20 (16.13%) Analytics
6 18 (14.52%) Data Integration
7 14 (11.29%) Data Architecture
8 13 (10.48%) Dimensional Modelling
9 12 (9.68%) Migration
9 12 (9.68%) Visualisation
10 11 (8.87%) Data Analytics
11 10 (8.06%) ETL Development
12 9 (7.26%) Data Transformation
12 9 (7.26%) Performance Tuning
13 8 (6.45%) Change Management
13 8 (6.45%) CRM
13 8 (6.45%) Data Science
14 7 (5.65%) Data Management
14 7 (5.65%) Project Management
14 7 (5.65%) Stakeholder Management
Programming Languages
1 88 (70.97%) SQL
2 58 (46.77%) T-SQL
3 12 (9.68%) C#
4 11 (8.87%) Python
5 6 (4.84%) JavaScript
6 5 (4.03%) Java
6 5 (4.03%) Ruby
6 5 (4.03%) Scala
7 3 (2.42%) Bash Shell
7 3 (2.42%) Tcl
8 1 (0.81%) C
8 1 (0.81%) FoxPro (VFP)
8 1 (0.81%) PL/SQL
8 1 (0.81%) PowerShell
8 1 (0.81%) R
8 1 (0.81%) VB
8 1 (0.81%) VB6
8 1 (0.81%) VBA
Qualifications
1 8 (6.45%) Degree
2 5 (4.03%) AWS Certification
3 3 (2.42%) Computer Science Degree
3 3 (2.42%) DBS Check
3 3 (2.42%) SC Cleared
3 3 (2.42%) Security Cleared
4 2 (1.61%) CCNA
4 2 (1.61%) CCNP
4 2 (1.61%) Cisco Certification
5 1 (0.81%) ISEB
5 1 (0.81%) ISTQB
5 1 (0.81%) ISTQB Foundation Certification
5 1 (0.81%) Microsoft Certification
5 1 (0.81%) TOGAF Certification
Quality Assurance & Compliance
1 29 (23.39%) Data Quality
2 8 (6.45%) PMO
3 3 (2.42%) ISO/IEC 27001
3 3 (2.42%) PCI DSS
4 2 (1.61%) IFRS
4 2 (1.61%) IFRS 9
5 1 (0.81%) QA
System Software
1 8 (6.45%) Active Directory
2 4 (3.23%) Hyper-V
3 1 (0.81%) VMware Infrastructure
Systems Management
1 3 (2.42%) Ansible
1 3 (2.42%) Nessus
1 3 (2.42%) Opscode Chef
1 3 (2.42%) Puppet
Vendors
1 49 (39.52%) Microsoft
2 11 (8.87%) Cognos
2 11 (8.87%) Tableau
3 10 (8.06%) SAP
4 7 (5.65%) Cisco
5 4 (3.23%) IBM
5 4 (3.23%) Oracle
5 4 (3.23%) VMware
6 2 (1.61%) F5
6 2 (1.61%) Informatica
6 2 (1.61%) Salesforce.com
6 2 (1.61%) Teradata
7 1 (0.81%) Adobe
7 1 (0.81%) Alteryx
7 1 (0.81%) Citrix
7 1 (0.81%) Google