The table below looks at the statistics for the Data Warehouse Analyst role in IT jobs advertised across the UK. Included is a guide to the average salaries offered in IT jobs that have cited Data Warehouse Analyst in their job title over the 3 months to 21 October 2014 with a comparison to the same period in the previous 2 years.

Location
3 months to
21 Oct 2014
Same period 2013 Same period 2012
Data Warehousing (DWH) Analyst
Rank 866 854 849
Rank change year-on-year
-12 -5
Permanent jobs requiring a Data Warehouse Analyst 38 25 59
As % of all permanent IT jobs located in the UK 0.033% 0.023% 0.051%
As % of the Job Titles category 0.035% 0.024% 0.054%
Number of salaries quoted 29 18 42
Average salary £47,500 £50,000 £42,250
Average salary % change year-on-year
-5.00% +18.34%
90% offered a salary of more than £32,500 £39,250 £36,500
10% offered a salary of more than £60,500 £80,000 £48,000
UK excluding London average salary £34,500 £46,250 £38,750
% change year-on-year
-25.40% +19.35%

The following table is for comparison with the above and provides statistics for the entire Job Titles category in permanent jobs advertised across the UK. Most job vacancies include a discernible job title. As such the figures in the first row provide an indication of the total number of permanent jobs in the overall sample.

Job Titles Category
UK
Permanent IT job ads with a match in the
Job Titles category
107528 102254 109513
As % of all permanent IT jobs located in the UK 94.51% 94.52% 95.27%
Number of salaries quoted 87765 84921 93187
Average salary £45,000 £44,000 £42,500
Average salary % change year-on-year
+2.27% +3.52%
90% offered a salary of more than £26,500 £27,000 £26,500
10% offered a salary of more than £70,000 £67,500 £70,000
UK excluding London average salary £40,000 £40,000 £38,000
% change year-on-year
- +5.26%

Data Warehouse Analyst
Jobs Demand Trend

This chart provides the 3-month moving total of permanent IT jobs citing Data Warehouse Analyst in the job title within the UK as a proportion of the total demand within the Job Titles category.

Data Warehouse Analyst Jobs Demand Trend in the UK

Data Warehouse Analyst
Salary Trend

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

Data Warehouse Analyst Salary Trend in the UK

Data Warehouse Analyst
Salary Histogram

This chart provides a salary histogram for IT jobs citing Data Warehouse Analyst over the 3 months to 21 October 2014 within the UK.

Data Warehouse Analyst Salary Histogram in the UK

Data Warehouse Analyst
Top 12 Job Locations

The table below looks at the demand and provides a guide to the average salaries quoted in IT jobs citing Data Warehouse Analyst within the UK over the 3 months to 21 October 2014. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location
(Use links below to see detailed
statistics and historical trends)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Average Salary
Last 3 Months
Average Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
England -1 35 £45,000 -28.00% 6
London +4 26 £51,250 -35.93% 5
City of London +10 7 £55,000 -31.25% 1
North West - 6 £32,500 -
Cheshire - 5 £32,500 -
South East -10 3 £60,000 +20.00%
Surrey -14 3 £60,000 -4.00%
Knutsford - 3 £32,500 -
Reigate - 3 £60,000 -
Bromley - 2 - - 1
Scotland -6 1 £67,500 +68.75% 1
Manchester - 1 £32,500 -

Data Warehouse Analyst
Top 30 Related IT Skills

For the 6 months to 21 October 2014, IT jobs within the UK that cited Data Warehouse Analyst in their job title mentioned the following IT skills in order of popularity. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled with Data Warehouse Analyst in their job title.

1 65 (100.00%) Data Warehouse
2 47 (72.31%) SQL
3 46 (70.77%) Business Intelligence
4 35 (53.85%) ETL
5 32 (49.23%) SQL Server Integration Services
6 25 (38.46%) SQL Server Reporting Services
6 25 (38.46%) Finance
7 24 (36.92%) SQL Server
8 22 (33.85%) Informatica
9 19 (29.23%) Cognos
10 16 (24.62%) SQL Server Analysis Services
11 14 (21.54%) Analytical Skills
12 12 (18.46%) Kimball Methodology
12 12 (18.46%) Data Modelling
13 11 (16.92%) Microsoft
13 11 (16.92%) Business Analysis
13 11 (16.92%) QA
13 11 (16.92%) Degree
14 10 (15.38%) Project Management
14 10 (15.38%) MicroStrategy
14 10 (15.38%) DataStage
15 9 (13.85%) T-SQL
15 9 (13.85%) Banking
15 9 (13.85%) Netezza
16 8 (12.31%) Agile Software Development
16 8 (12.31%) Software Testing
16 8 (12.31%) Oracle
16 8 (12.31%) Business Objects
16 8 (12.31%) MS Excel
16 8 (12.31%) Relational Database

Data Warehouse Analyst
Top Related IT Skills by Category

For the 6 months to 21 October 2014, IT jobs within the UK that cited Data Warehouse Analyst in their job title mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled with Data Warehouse Analyst in their job title. Up to 20 skills are shown per category.

Application Platforms
1 3 (4.62%) SAS
2 1 (1.54%) SharePoint
Applications
1 8 (12.31%) MS Excel
Communications & Networking
1 2 (3.08%) FTP
1 2 (3.08%) HTTP
Database & Business Intelligence
1 65 (100.00%) Data Warehouse
2 32 (49.23%) SQL Server Integration Services
3 25 (38.46%) SQL Server Reporting Services
4 24 (36.92%) SQL Server
5 16 (24.62%) SQL Server Analysis Services
6 10 (15.38%) DataStage
7 8 (12.31%) Relational Database
8 7 (10.77%) SQL Server 2008
9 6 (9.23%) Oracle Database
10 5 (7.69%) IBM InfoSphere
10 5 (7.69%) Cognos Query Studio
10 5 (7.69%) Cognos Analysis Studio
10 5 (7.69%) Cognos Report Studio
10 5 (7.69%) Cognos Framework Manager
11 4 (6.15%) OLAP
11 4 (6.15%) QlikView
11 4 (6.15%) Oracle BI EE
12 3 (4.62%) Star Schema
13 2 (3.08%) Oracle Reports
13 2 (3.08%) Business Intelligence Development Studio
General
1 25 (38.46%) Finance
2 9 (13.85%) Banking
3 7 (10.77%) Telecoms
4 5 (7.69%) Retail
5 2 (3.08%) Games
6 1 (1.54%) Marketing
6 1 (1.54%) Investment Banking
6 1 (1.54%) General Ledger
6 1 (1.54%) Front Office
Libraries, Frameworks & Software Standards
1 2 (3.08%) MDX
2 1 (1.54%) WCF
2 1 (1.54%) Web Services
Miscellaneous
1 14 (21.54%) Analytical Skills
2 3 (4.62%) Data Integration
2 3 (4.62%) Computer Science
2 3 (4.62%) Mathematics
2 3 (4.62%) Derivative
3 2 (3.08%) Physics
3 2 (3.08%) Data Structures
4 1 (1.54%) Algorithms
4 1 (1.54%) User Experience
4 1 (1.54%) Visualisation
4 1 (1.54%) Open Source
4 1 (1.54%) Credit Risk
4 1 (1.54%) Online Gambling
4 1 (1.54%) Data Protection Act
4 1 (1.54%) Management Information System
Operating Systems
1 2 (3.08%) UNIX
2 1 (1.54%) Linux
Processes & Methodologies
1 46 (70.77%) Business Intelligence
2 35 (53.85%) ETL
3 12 (18.46%) Kimball Methodology
3 12 (18.46%) Data Modelling
4 11 (16.92%) Business Analysis
5 10 (15.38%) Project Management
6 8 (12.31%) Agile Software Development
6 8 (12.31%) Software Testing
7 6 (9.23%) Data Management
7 6 (9.23%) Performance Tuning
7 6 (9.23%) Data Transformation
8 5 (7.69%) Analytics
8 5 (7.69%) Waterfall
8 5 (7.69%) User Acceptance Testing
8 5 (7.69%) Validation
8 5 (7.69%) Scrum
8 5 (7.69%) ERP
9 4 (6.15%) Data Validation
9 4 (6.15%) Master Data Management
10 3 (4.62%) Data Architecture
Programming Languages
1 47 (72.31%) SQL
2 9 (13.85%) T-SQL
3 3 (4.62%) Java
4 2 (3.08%) Python
4 2 (3.08%) PL/SQL
4 2 (3.08%) C#
4 2 (3.08%) VBA
5 1 (1.54%) Shell Script
Qualifications
1 11 (16.92%) Degree
2 3 (4.62%) ISTQB
2 3 (4.62%) ISEB
Quality Assurance & Compliance
1 11 (16.92%) QA
2 5 (7.69%) SLA
3 1 (1.54%) COREP
Vendors
1 22 (33.85%) Informatica
2 19 (29.23%) Cognos
3 11 (16.92%) Microsoft
4 10 (15.38%) MicroStrategy
5 9 (13.85%) Netezza
6 8 (12.31%) Oracle
6 8 (12.31%) Business Objects
7 6 (9.23%) Teradata
8 5 (7.69%) IBM
9 4 (6.15%) Tableau
10 2 (3.08%) Actuate
10 2 (3.08%) Ab Initio
11 1 (1.54%) Greenplum
11 1 (1.54%) Google
Central London / West End
Ampersand Consulting
Salary: £40000 - £48000 per annum + Benefits
Posted: 8 hours ago
London
Clearwater People Solutions
Salary: £40000 - £50000 Per Annum + excellent benefits
Posted: Yesterday
Bromley, Kent
Experis Ltd
Posted: 5 days ago
City, London
McGregor Boyall
Salary: £55000 - £60000 per annum + Bonus and Benefits
Posted: 6 days ago
Glasgow
Huxley Associates
Salary: competitive
Posted: 8 days ago
London
Huxley Associates
Salary: competitive
Posted: 12 days ago