Period
to 24 November 2017

The following table provides summary statistics for permanent job vacancies with a requirement for Data Mart skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited Data Mart over the 6 months to 24 November 2017 with a comparison to the same period in the previous 2 years.

Data Mart
UK
6 months to
24 Nov 2017
Same period 2016 Same period 2015
Rank 1082 1010 1065
Rank change year-on-year -72 +55 -34
Permanent jobs citing Data Mart 129 212 258
As % of all permanent IT jobs advertised in the UK 0.072% 0.11% 0.12%
As % of the Database & Business Intelligence category 0.24% 0.38% 0.37%
Number of salaries quoted 97 196 202
UK median annual salary £52,500 £70,000 £52,500
Median salary % change year-on-year -25.00% +33.33% +9.38%
10th Percentile £37,750 £39,375 £36,250
90th Percentile £90,000 £95,000 £85,000
UK excluding London median annual salary £50,000 £45,000 £42,500
% change year-on-year +11.11% +5.88% -5.56%

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

All Database and Business Intelligence Skills
UK
Permanent vacancies with a requirement for database or business intelligence skills 54460 56137 68974
As % of all permanent IT jobs advertised in the UK 30.23% 29.67% 31.53%
Number of salaries quoted 44807 47978 58120
UK median annual salary £47,500 £47,500 £45,000
Median salary % change year-on-year - +5.56% +2.27%
10th Percentile £30,000 £29,000 £28,250
90th Percentile £77,500 £77,500 £75,000
UK excluding London median annual salary £42,500 £42,500 £40,000
% change year-on-year - +6.25% -

Data Mart
Job Vacancy Trend

Job postings citing Data Mart as a percentage of all IT jobs advertised.

Job vacancy trend for Data Mart in the UK

Data Mart
Salary Trend

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

Salary trend for Data Mart in the UK

Data Mart
Salary Histogram

The salary distribution of IT jobs citing Data Mart over the 6 months to 24 November 2017.

Salary histogram for Data Mart in the UK

Data Mart
Top 8 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Data Mart within the UK over the 6 months to 24 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 -22 129 £52,500 -25.00% 7
London -67 85 £67,500 -10.00% 3
UK excluding London +40 44 £50,000 +11.11% 4
Midlands +55 33 £50,000 +25.00%
West Midlands +38 32 £50,000 +25.00%
South East +55 10 £50,000 -13.04% 3
East of England +11 1 - -
East Midlands - 1 £50,000 -

For the 6 months to 24 November 2017, IT jobs citing Data Mart also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads with a requirement for Data Mart.

1 106 (82.17%) SQL
2 91 (70.54%) Data Warehouse
3 76 (58.91%) Business Intelligence
4 56 (43.41%) Data Quality
5 49 (37.98%) Agile Software Development
6 48 (37.21%) Data Modelling
7 40 (31.01%) Dimensional Modelling
8 37 (28.68%) Oracle
9 33 (25.58%) Scrum
10 32 (24.81%) PL/SQL
11 30 (23.26%) Tableau
12 29 (22.48%) ETL
13 28 (21.71%) Analytics
14 27 (20.93%) Amazon AWS
14 27 (20.93%) Finance
15 26 (20.16%) Kimball Methodology
16 25 (19.38%) Visualisation
16 25 (19.38%) Data Integration
17 24 (18.60%) Microsoft
17 24 (18.60%) SQL Server
18 23 (17.83%) SAS
19 21 (16.28%) Stakeholder Management
19 21 (16.28%) QA
20 20 (15.50%) User Stories
20 20 (15.50%) Performance Tuning
21 19 (14.73%) Data Management
21 19 (14.73%) Oracle Database
21 19 (14.73%) QlikView
22 18 (13.95%) Marketing
22 18 (13.95%) Degree

Data Mart
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 23 (17.83%) SAS
2 3 (2.33%) Apache Spark
3 2 (1.55%) Apache
3 2 (1.55%) Apache Pig
4 1 (0.78%) Apache Solr
4 1 (0.78%) Drupal
Applications
1 18 (13.95%) Microsoft Excel
2 14 (10.85%) Microsoft Office
2 14 (10.85%) Microsoft PowerPoint
3 13 (10.08%) MS Visio
4 1 (0.78%) SPSS
4 1 (0.78%) SPSS Modeler
Business Applications
1 2 (1.55%) SAP ERP
2 1 (0.78%) SAP MDG
2 1 (0.78%) SAP MDM
Cloud Services
1 27 (20.93%) Amazon AWS
2 16 (12.40%) Microsoft Azure
3 4 (3.10%) Google Cloud Platform
4 2 (1.55%) Cortana Intelligence Suite
5 1 (0.78%) Azure Data Factory
Communications & Networking
1 1 (0.78%) HTTP
1 1 (0.78%) NetScaler
Database & Business Intelligence
1 91 (70.54%) Data Warehouse
2 24 (18.60%) SQL Server
3 19 (14.73%) Oracle Database
3 19 (14.73%) QlikView
4 17 (13.18%) Amazon RDS
4 17 (13.18%) Amazon Redshift
4 17 (13.18%) Enterprise Data Warehouse
4 17 (13.18%) Qlik Sense
5 16 (12.40%) BusinessObjects
5 16 (12.40%) PostgreSQL
6 14 (10.85%) Base SAS
6 14 (10.85%) Oracle Database 12c
7 12 (9.30%) OLAP
8 11 (8.53%) SQL Server Integration Services
9 10 (7.75%) SQL Server Reporting Services
10 8 (6.20%) Big Data
10 8 (6.20%) Star Schema
11 7 (5.43%) SQL Server 2016
12 5 (3.88%) Data Lake
12 5 (3.88%) SQL Server Analysis Services
Development Applications
1 16 (12.40%) ProC
2 14 (10.85%) Talend Open Studio
3 3 (2.33%) ERwin
4 2 (1.55%) SQL Server Management Studio (SSMS)
5 1 (0.78%) Git (software)
5 1 (0.78%) Oracle Forms
5 1 (0.78%) Subversion
5 1 (0.78%) Visual Studio
General
1 27 (20.93%) Finance
2 18 (13.95%) Marketing
3 10 (7.75%) Banking
4 7 (5.43%) Games
5 3 (2.33%) Back Office
5 3 (2.33%) Front Office
6 2 (1.55%) Retail
7 1 (0.78%) Financial Institution
7 1 (0.78%) Legal
Job Titles
1 64 (49.61%) Developer
2 36 (27.91%) Analyst
3 22 (17.05%) Data Warehouse Developer
4 20 (15.50%) Data Warehouse Analyst
5 19 (14.73%) Business Analyst
5 19 (14.73%) Data Warehouse Business Analyst
6 18 (13.95%) Data Analyst
7 17 (13.18%) Data Business Analyst
8 15 (11.63%) SAS Developer
9 13 (10.08%) Oracle Developer
9 13 (10.08%) QlikView Developer
9 13 (10.08%) SQL Developer
10 11 (8.53%) Business Intelligence Manager
10 11 (8.53%) Business Intelligence Project Manager
10 11 (8.53%) Oracle Data Warehouse Developer
10 11 (8.53%) Project Manager
11 10 (7.75%) PL/SQL Developer
12 8 (6.20%) Consultant
12 8 (6.20%) Murex Consultant
13 7 (5.43%) Senior Manager
Libraries, Frameworks & Software Standards
1 17 (13.18%) Murex MxML
2 9 (6.98%) XML
3 3 (2.33%) Spring
3 3 (2.33%) Web Services
4 2 (1.55%) .NET
4 2 (1.55%) JMS
4 2 (1.55%) MDX
4 2 (1.55%) Middleware
5 1 (0.78%) .NET Framework
5 1 (0.78%) AngularJS
5 1 (0.78%) CSS
5 1 (0.78%) HTML
5 1 (0.78%) Java EE
5 1 (0.78%) Spring Boot
Miscellaneous
1 15 (11.63%) Data Structures
2 11 (8.53%) Derivative
2 11 (8.53%) PMI
3 10 (7.75%) Credit Derivative
4 9 (6.98%) Analytical Skills
5 5 (3.88%) Foreign Exchange (FX)
5 5 (3.88%) Greenfield Project
6 3 (2.33%) Computer Science
6 3 (2.33%) Mashup
7 2 (1.55%) Enterprise Software
7 2 (1.55%) Fintech
7 2 (1.55%) Fixed Income
7 2 (1.55%) Hedge funds
7 2 (1.55%) Management Information System
8 1 (0.78%) Interest Rate Derivative
Operating Systems
1 15 (11.63%) Unix
2 10 (7.75%) Linux
3 1 (0.78%) Windows
Processes & Methodologies
1 76 (58.91%) Business Intelligence
2 49 (37.98%) Agile Software Development
3 48 (37.21%) Data Modelling
4 40 (31.01%) Dimensional Modelling
5 33 (25.58%) Scrum
6 29 (22.48%) ETL
7 28 (21.71%) Analytics
8 26 (20.16%) Kimball Methodology
9 25 (19.38%) Data Integration
9 25 (19.38%) Visualisation
10 21 (16.28%) Stakeholder Management
11 20 (15.50%) Performance Tuning
11 20 (15.50%) User Stories
12 19 (14.73%) Data Management
13 17 (13.18%) Quantitative Analysis
14 16 (12.40%) Project Management
15 15 (11.63%) Business Analytics
15 15 (11.63%) Time Management
15 15 (11.63%) User Acceptance Testing
16 12 (9.30%) PRINCE
Programming Languages
1 106 (82.17%) SQL
2 32 (24.81%) PL/SQL
3 16 (12.40%) PROC SQL
4 15 (11.63%) Java
5 14 (10.85%) T-SQL
6 10 (7.75%) C
7 3 (2.33%) C#
8 2 (1.55%) Perl
8 2 (1.55%) Python
8 2 (1.55%) R
8 2 (1.55%) Shell Script
9 1 (0.78%) JavaScript
9 1 (0.78%) PHP
9 1 (0.78%) Scala
Qualifications
1 18 (13.95%) Degree
2 15 (11.63%) SAS Certification
3 11 (8.53%) PMI Certification
3 11 (8.53%) PMP
4 3 (2.33%) Computer Science Degree
5 2 (1.55%) Master's Degree
5 2 (1.55%) SC Cleared
5 2 (1.55%) Security Cleared
6 1 (0.78%) MCITP
6 1 (0.78%) MCTS
6 1 (0.78%) Microsoft Certification
Quality Assurance & Compliance
1 56 (43.41%) Data Quality
2 21 (16.28%) QA
3 1 (0.78%) SLA
System Software
1 2 (1.55%) HDFS
Systems Management
1 2 (1.55%) ITRS Geneos
2 1 (0.78%) Tivoli
Vendors
1 37 (28.68%) Oracle
2 30 (23.26%) Tableau
3 24 (18.60%) Microsoft
4 17 (13.18%) Murex
5 14 (10.85%) Talend
6 4 (3.10%) Google
7 3 (2.33%) Alteryx
7 3 (2.33%) Cognos
7 3 (2.33%) Informatica
7 3 (2.33%) SAP
8 1 (0.78%) ION Trading
8 1 (0.78%) LANSA
8 1 (0.78%) RedGate
8 1 (0.78%) SunGard
8 1 (0.78%) Sybase
8 1 (0.78%) Wallstreet Suite