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 24 December 2014 with a comparison to the same period in the previous 2 years.

Location
3 months to
24 Dec 2014
Same period 2013 Same period 2012
Data Warehousing (DWH) Analyst
Rank 838 868 854
Rank change year-on-year
+30 -14
Permanent jobs requiring a Data Warehouse Analyst 42 11 40
As % of all permanent IT jobs located in the UK 0.038% 0.010% 0.035%
As % of the Job Titles category 0.040% 0.011% 0.037%
Number of salaries quoted 34 8 34
Average salary £44,500 £50,000 £42,500
Average salary % change year-on-year
-11.00% +17.64%
90% offered a salary of more than £38,150 £41,000 £30,000
10% offered a salary of more than £62,500 £67,500 £56,750
UK excluding London average salary £43,000 £50,000 £42,500
% change year-on-year
-14.00% +17.64%

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
104608 102056 108531
As % of all permanent IT jobs located in the UK 94.68% 94.69% 95.26%
Number of salaries quoted 87149 82785 93534
Average salary £45,000 £45,000 £42,500
Average salary % change year-on-year
- +5.88%
90% offered a salary of more than £26,500 £26,750 £26,500
10% offered a salary of more than £70,000 £65,000 £70,000
UK excluding London average salary £40,000 £40,000 £38,500
% change year-on-year
- +3.89%

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 24 December 2014 within the UK.

Data Warehouse Analyst Salary Histogram in the UK

Data Warehouse Analyst
Top 16 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 24 December 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 +26 39 £45,000 -10.00% 3
London +21 35 £44,500 -34.07% 2
City of London +16 7 £62,500 -7.40%
Scotland - 2 £38,500 -
East of England - 2 £47,500 -
Potters Bar - 2 £47,500 -
Bromley - 2 - -
Edinburgh - 2 £38,500 -
Uxbridge - 2 £44,000 - 1
Hertfordshire - 2 £47,500 -
Surrey -4 1 £60,000 +41.17%
South East -14 1 £60,000 +20.00% 1
North West - 1 £33,500 -
Cheshire - 1 £33,500 -
Knutsford - 1 £33,500 -
Reigate - 1 £60,000 -

Data Warehouse Analyst
Top 30 Related IT Skills

For the 6 months to 24 December 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 69 (100.00%) Data Warehouse
2 55 (79.71%) SQL
3 44 (63.77%) Business Intelligence
4 43 (62.32%) Finance
5 41 (59.42%) ETL
6 38 (55.07%) SQL Server Integration Services
7 32 (46.38%) SQL Server
8 27 (39.13%) SQL Server Analysis Services
9 26 (37.68%) SQL Server Reporting Services
10 19 (27.54%) Microsoft
11 18 (26.09%) Informatica
12 17 (24.64%) T-SQL
12 17 (24.64%) MS Excel
12 17 (24.64%) Banking
12 17 (24.64%) Analytical Skills
13 14 (20.29%) Data Modelling
14 13 (18.84%) Retail
15 12 (17.39%) Cognos
15 12 (17.39%) Agile Software Development
16 11 (15.94%) Star Schema
16 11 (15.94%) Business Analysis
17 10 (14.49%) Project Management
18 9 (13.04%) OLAP
18 9 (13.04%) Business Objects
18 9 (13.04%) Scrum
18 9 (13.04%) Software Testing
18 9 (13.04%) QA
19 8 (11.59%) Degree
19 8 (11.59%) Kimball Methodology
20 7 (10.14%) SQL Server 2008

Data Warehouse Analyst
Top Related IT Skills by Category

For the 6 months to 24 December 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 5 (7.25%) SAS
2 3 (4.35%) SharePoint
Applications
1 17 (24.64%) MS Excel
Business Applications
1 2 (2.90%) Cognos Business Intelligence
Cloud Services
1 1 (1.45%) Google Cloud Platform
Communications & Networking
1 1 (1.45%) HTTP
Database & Business Intelligence
1 69 (100.00%) Data Warehouse
2 38 (55.07%) SQL Server Integration Services
3 32 (46.38%) SQL Server
4 27 (39.13%) SQL Server Analysis Services
5 26 (37.68%) SQL Server Reporting Services
6 11 (15.94%) Star Schema
7 9 (13.04%) OLAP
8 7 (10.14%) SQL Server 2008
9 6 (8.70%) DataStage
9 6 (8.70%) Oracle Database
10 5 (7.25%) Relational Database
11 4 (5.80%) OLAP Cube
11 4 (5.80%) QlikView
12 2 (2.90%) Oracle Reports
12 2 (2.90%) Business Intelligence Development Studio
13 1 (1.45%) Big Data
13 1 (1.45%) SAS Data Integration Studio
13 1 (1.45%) Data Mining
13 1 (1.45%) RDBMS
13 1 (1.45%) BODI
Development Applications
1 2 (2.90%) Team Foundation Server
General
1 43 (62.32%) Finance
2 17 (24.64%) Banking
3 13 (18.84%) Retail
4 5 (7.25%) Aerospace
5 4 (5.80%) Telecoms
6 3 (4.35%) Games
7 2 (2.90%) Retail Banking
8 1 (1.45%) Front Office
8 1 (1.45%) Investment Banking
8 1 (1.45%) General Ledger
Libraries, Frameworks & Software Standards
1 4 (5.80%) MDX
2 1 (1.45%) WCF
2 1 (1.45%) Web Services
Miscellaneous
1 17 (24.64%) Analytical Skills
2 3 (4.35%) Derivative
2 3 (4.35%) Data Integration
3 2 (2.90%) Online Gambling
3 2 (2.90%) Mathematics
3 2 (2.90%) Physics
3 2 (2.90%) Computer Science
3 2 (2.90%) Data Structures
4 1 (1.45%) Credit Risk
4 1 (1.45%) Online Games
4 1 (1.45%) Management Information System
4 1 (1.45%) User Experience
Operating Systems
1 1 (1.45%) UNIX
1 1 (1.45%) Linux
Processes & Methodologies
1 44 (63.77%) Business Intelligence
2 41 (59.42%) ETL
3 14 (20.29%) Data Modelling
4 12 (17.39%) Agile Software Development
5 11 (15.94%) Business Analysis
6 10 (14.49%) Project Management
7 9 (13.04%) Scrum
7 9 (13.04%) Software Testing
8 8 (11.59%) Kimball Methodology
9 6 (8.70%) User Acceptance Testing
9 6 (8.70%) Performance Tuning
9 6 (8.70%) Data Transformation
10 4 (5.80%) Analytics
10 4 (5.80%) Stakeholder Management
11 3 (4.35%) Technical Architecture
11 3 (4.35%) Data Management
11 3 (4.35%) Data Analysis
11 3 (4.35%) Master Data Management
11 3 (4.35%) Inmon Methodology
11 3 (4.35%) Data Architecture
Programming Languages
1 55 (79.71%) SQL
2 17 (24.64%) T-SQL
3 4 (5.80%) C#
4 3 (4.35%) Java
4 3 (4.35%) PL/SQL
5 2 (2.90%) VBA
5 2 (2.90%) Python
6 1 (1.45%) Shell Script
Qualifications
1 8 (11.59%) Degree
2 5 (7.25%) ISTQB Foundation Certification
2 5 (7.25%) ISEB
Quality Assurance & Compliance
1 9 (13.04%) QA
2 5 (7.25%) SLA
3 3 (4.35%) Solvency II
4 1 (1.45%) COREP
Systems Management
1 5 (7.25%) HP Quality Center
Vendors
1 19 (27.54%) Microsoft
2 18 (26.09%) Informatica
3 12 (17.39%) Cognos
4 9 (13.04%) Business Objects
5 6 (8.70%) Oracle
5 6 (8.70%) MicroStrategy
5 6 (8.70%) Teradata
6 5 (7.25%) HP
7 4 (5.80%) Netezza
7 4 (5.80%) Tableau
8 2 (2.90%) Actuate
9 1 (1.45%) Greenplum
9 1 (1.45%) Google
9 1 (1.45%) SAP
Uxbridge
Ampersand Consulting
Salary: £40000 - £48000 per annum + Benefits
Posted: 4 days ago
Brighton
Huxley Banking & Financial Services
Salary: £28000 - £40000 per annum + bonus, pension, 28 days' holiday
Posted: 16 days ago
London
Ampersand Consulting
Salary: £40000 - £48000 per annum + Benefits
Posted: 24 days ago