Period
to 19 November 2017

The median annual salary for a Data Warehouse Architect was £85,000 in advertised job vacancies during the 6 months to 19 November 2017.

The first table below provides salary benchmarking and summary statistics including a comparison to same period in the previous 2 years.

Data Warehousing (DWH) Architect
UK
6 months to
19 Nov 2017
Same period 2016 Same period 2015
Rank 1173 1135 1192
Rank change year-on-year -38 +57 +63
Permanent jobs requiring a Data Warehouse Architect 25 83 116
As % of all permanent IT jobs advertised in the UK 0.014% 0.044% 0.053%
As % of the Job Titles category 0.015% 0.046% 0.055%
Number of salaries quoted 20 79 102
UK median annual salary £85,000 £70,000 £72,500
Median salary % change year-on-year +21.43% -3.45% +7.41%
10th Percentile £49,375 £50,000 £52,500
90th Percentile £92,500 £89,000 £90,000
UK excluding London median annual salary £70,000 £65,000 £60,000
% change year-on-year +7.69% +8.33% -11.11%

The following table is for comparison with the above and includes summary statistics for all permanent IT job vacancies. Most job vacancies include a discernible job title that can be normalized. As such, the figures in the second row provide an indication of the number of permanent jobs in our overall sample.

All Permanent IT Job Vacancies
UK
Permanent vacancies in the UK with a recognized job title 170720 182020 210826
% of permanent IT jobs with a recognized job title 95.77% 96.48% 96.45%
Number of salaries quoted 136880 152336 175085
UK median annual salary £48,000 £47,500 £45,000
Median salary % change year-on-year +1.05% +5.56% -
10th Percentile £27,500 £27,000 £26,250
90th Percentile £78,750 £77,500 £75,000
UK excluding London median annual salary £42,500 £42,500 £40,500
% change year-on-year - +4.94% +1.25%

Data Warehouse Architect
Job Vacancy Trend

Job postings that featured Data Warehouse Architect in the job title as a percentage of all IT jobs advertised.

Job vacancy trend for Data Warehouse Architect in the UK

Data Warehouse Architect
Salary Trend

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

Salary trend for Data Warehouse Architect in the UK

Data Warehouse Architect
Salary Histogram

The salary distribution of IT jobs citing Data Warehouse Architect over the 6 months to 19 November 2017.

Salary histogram for Data Warehouse Architect in the UK

Data Warehouse Architect
Top 11 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Data Warehouse Architect within the UK over the 6 months to 19 November 2017. 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
England -18 23 £85,000 +19.30% 1
London -16 15 £85,000 +9.68%
UK excluding London +3 9 £70,000 +7.69% 1
South East +50 4 - -
North of England -18 2 £65,000 +8.33%
East of England +7 1 £70,000 +16.67%
Yorkshire +4 1 £50,000 -16.67%
East Midlands - 1 £47,500 -
Midlands - 1 £47,500 - 1
North West - 1 £80,000 -
Scotland - 1 £72,500 -

Data Warehouse Architect Skill Set
Top 30 Co-occurring IT Skills

For the 6 months to 19 November 2017, Data Warehouse Architect job roles required the following IT skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads featuring Data Warehouse Architect in the job title.

1 25 (100.00%) Data Warehouse
2 19 (76.00%) Business Intelligence
2 19 (76.00%) SQL
3 18 (72.00%) ETL
4 16 (64.00%) SQL Server
5 15 (60.00%) Data Modelling
6 12 (48.00%) SQL Server Integration Services
6 12 (48.00%) Microsoft Azure
7 11 (44.00%) Degree
8 10 (40.00%) Migration
8 10 (40.00%) CRM
9 9 (36.00%) Informatica
9 9 (36.00%) Agile Software Development
9 9 (36.00%) SQL Server Reporting Services
9 9 (36.00%) SQL Server Analysis Services
9 9 (36.00%) Data Architecture
9 9 (36.00%) Big Data
9 9 (36.00%) Analytical Skills
10 8 (32.00%) Kimball Methodology
10 8 (32.00%) Data Strategy
11 7 (28.00%) Talend
11 7 (28.00%) Data Quality
11 7 (28.00%) Hadoop
11 7 (28.00%) Talend Open Studio
11 7 (28.00%) Data Analysis
11 7 (28.00%) Salesforce.com
11 7 (28.00%) Microsoft
12 6 (24.00%) T-SQL
12 6 (24.00%) Software Engineering
12 6 (24.00%) Data Cleansing

Data Warehouse Architect Skill Set
Co-occurring IT Skills 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 4 (16.00%) SharePoint
2 2 (8.00%) Apache Spark
3 1 (4.00%) Oracle SOA Suite
Business Applications
1 1 (4.00%) Salesforce.com CRM
Cloud Services
1 12 (48.00%) Microsoft Azure
2 6 (24.00%) Salesforce Service Cloud
3 5 (20.00%) Amazon AWS
Communications & Networking
1 1 (4.00%) Kerberos
Database & Business Intelligence
1 25 (100.00%) Data Warehouse
2 16 (64.00%) SQL Server
3 12 (48.00%) SQL Server Integration Services
4 9 (36.00%) Big Data
4 9 (36.00%) SQL Server Analysis Services
4 9 (36.00%) SQL Server Reporting Services
5 7 (28.00%) Hadoop
6 6 (24.00%) SQL Server 2012
7 4 (16.00%) OLAP
8 2 (8.00%) Azure SQL Data Warehouse
8 2 (8.00%) InterSystems Cache
8 2 (8.00%) Power BI
8 2 (8.00%) Relational Database
8 2 (8.00%) SQL Server 2014
9 1 (4.00%) Apache Hive
9 1 (4.00%) Azure SQL Database
9 1 (4.00%) Impala
9 1 (4.00%) NoSQL
9 1 (4.00%) OLAP Cube
9 1 (4.00%) SAP Data Services
Development Applications
1 7 (28.00%) Talend Open Studio
2 2 (8.00%) Team Foundation Server
General
1 5 (20.00%) Finance
2 4 (16.00%) Marketing
3 3 (12.00%) Retail
4 1 (4.00%) Banking
4 1 (4.00%) Investment Banking
4 1 (4.00%) Manufacturing
Libraries, Frameworks & Software Standards
1 5 (20.00%) MDX
2 1 (4.00%) Middleware
2 1 (4.00%) RESTful
2 1 (4.00%) SAML
Miscellaneous
1 9 (36.00%) Analytical Skills
2 6 (24.00%) Computer Science
3 2 (8.00%) Replication
4 1 (4.00%) Fintech
4 1 (4.00%) Management Information System
4 1 (4.00%) Virtual Team
Processes & Methodologies
1 19 (76.00%) Business Intelligence
2 18 (72.00%) ETL
3 15 (60.00%) Data Modelling
4 10 (40.00%) CRM
4 10 (40.00%) Migration
5 9 (36.00%) Agile Software Development
5 9 (36.00%) Data Architecture
6 8 (32.00%) Data Strategy
6 8 (32.00%) Kimball Methodology
7 7 (28.00%) Data Analysis
8 6 (24.00%) Data Cleansing
8 6 (24.00%) Data Conversion
8 6 (24.00%) Software Engineering
9 5 (20.00%) Analytics
9 5 (20.00%) Data Management
9 5 (20.00%) Dimensional Modelling
9 5 (20.00%) Mentoring
9 5 (20.00%) Project Management
10 4 (16.00%) Data Migration
10 4 (16.00%) Waterfall
Programming Languages
1 19 (76.00%) SQL
2 6 (24.00%) T-SQL
3 2 (8.00%) C#
4 1 (4.00%) C
4 1 (4.00%) Java
4 1 (4.00%) JavaScript
4 1 (4.00%) Python
Qualifications
1 11 (44.00%) Degree
2 6 (24.00%) Computer Science Degree
3 4 (16.00%) MBA
Quality Assurance & Compliance
1 7 (28.00%) Data Quality
Vendors
1 9 (36.00%) Informatica
2 7 (28.00%) Microsoft
2 7 (28.00%) Salesforce.com
2 7 (28.00%) Talend
3 5 (20.00%) Cognos
3 5 (20.00%) Tableau
4 2 (8.00%) Oracle
5 1 (4.00%) Ab Initio
5 1 (4.00%) Alteryx
5 1 (4.00%) Atlassian
5 1 (4.00%) Cloudera
5 1 (4.00%) IBM
5 1 (4.00%) SAP
5 1 (4.00%) Teradata