Period
to 22 October 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 22 October 2017 with a comparison to the same period in the previous 2 years.

Data Mart
UK
6 months to
22 Oct 2017
Same period 2016 Same period 2015
Rank 1046 1055 1044
Rank change year-on-year +9 -11 -47
Permanent jobs citing Data Mart 138 192 259
As % of all permanent IT jobs advertised in the UK 0.079% 0.10% 0.12%
As % of the Database & Business Intelligence category 0.26% 0.34% 0.38%
Number of salaries quoted 106 179 203
UK median annual salary £52,500 £70,000 £52,500
Median salary % change year-on-year -25.00% +33.33% +9.38%
10th Percentile £36,250 £40,000 £36,250
90th Percentile £90,000 £95,500 £86,250
UK excluding London median annual salary £50,000 £47,500 £42,500
% change year-on-year +5.26% +11.76% -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 53154 56190 69051
As % of all permanent IT jobs advertised in the UK 30.50% 29.63% 31.58%
Number of salaries quoted 43667 47838 58226
UK median annual salary £48,000 £47,500 £45,000
Median salary % change year-on-year +1.05% +5.56% -
10th Percentile £30,000 £28,750 £28,000
90th Percentile £77,500 £76,250 £73,750
UK excluding London median annual salary £42,500 £41,500 £40,000
% change year-on-year +2.41% +3.75% -

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 22 October 2017.

Salary histogram for Data Mart in the UK

Data Mart
Top 7 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 22 October 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 +9 138 £52,500 -25.00% 2
London -45 85 £68,000 -9.33% 1
UK excluding London +52 53 £50,000 +5.26% 2
Midlands +76 43 £50,000 -4.76%
West Midlands +52 42 £50,000 -4.76%
South East +51 10 £50,000 -13.04%
East Midlands - 1 £50,000 -

For the 6 months to 22 October 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 115 (83.33%) SQL
2 93 (67.39%) Data Warehouse
3 83 (60.14%) Business Intelligence
4 57 (41.30%) Data Quality
5 47 (34.06%) Agile Software Development
6 43 (31.16%) Data Modelling
6 43 (31.16%) Oracle
7 40 (28.99%) PL/SQL
8 38 (27.54%) Dimensional Modelling
9 34 (24.64%) Finance
10 33 (23.91%) Scrum
11 32 (23.19%) ETL
11 32 (23.19%) SQL Server
12 30 (21.74%) Microsoft
12 30 (21.74%) Tableau
13 29 (21.01%) Analytics
13 29 (21.01%) Visualisation
14 27 (19.57%) Kimball Methodology
14 27 (19.57%) Stakeholder Management
15 26 (18.84%) SAS
16 25 (18.12%) Oracle Database
17 24 (17.39%) QA
18 23 (16.67%) Data Integration
19 22 (15.94%) Performance Tuning
20 21 (15.22%) Oracle Database 12c
20 21 (15.22%) User Stories
21 20 (14.49%) Microsoft Excel
21 20 (14.49%) Time Management
22 19 (13.77%) PROC SQL
22 19 (13.77%) ProC

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 26 (18.84%) SAS
2 4 (2.90%) Apache Spark
3 3 (2.17%) Apache Pig
4 2 (1.45%) Apache
5 1 (0.72%) Apache Solr
5 1 (0.72%) Drupal
Applications
1 20 (14.49%) Microsoft Excel
2 16 (11.59%) Microsoft Office
2 16 (11.59%) Microsoft PowerPoint
3 15 (10.87%) MS Visio
4 1 (0.72%) SPSS
4 1 (0.72%) SPSS Modeler
Business Applications
1 2 (1.45%) SAP ERP
Cloud Services
1 18 (13.04%) Amazon AWS
2 16 (11.59%) Microsoft Azure
3 2 (1.45%) Cortana Intelligence Suite
3 2 (1.45%) Google Cloud Platform
4 1 (0.72%) Azure Data Factory
Communications & Networking
1 1 (0.72%) HTTP
1 1 (0.72%) NetScaler
Database & Business Intelligence
1 93 (67.39%) Data Warehouse
2 32 (23.19%) SQL Server
3 25 (18.12%) Oracle Database
4 21 (15.22%) Oracle Database 12c
5 18 (13.04%) BusinessObjects
6 17 (12.32%) Enterprise Data Warehouse
7 16 (11.59%) Base SAS
8 14 (10.14%) SQL Server Integration Services
9 13 (9.42%) QlikView
9 13 (9.42%) SQL Server Reporting Services
10 12 (8.70%) OLAP
11 11 (7.97%) Qlik Sense
12 10 (7.25%) Amazon RDS
12 10 (7.25%) Amazon Redshift
12 10 (7.25%) PostgreSQL
13 9 (6.52%) Star Schema
14 7 (5.07%) Big Data
14 7 (5.07%) SQL Server 2016
15 6 (4.35%) Oracle BI EE
15 6 (4.35%) Relational Database
Development Applications
1 19 (13.77%) ProC
2 12 (8.70%) Talend Open Studio
3 2 (1.45%) ERwin
3 2 (1.45%) SQL Server Management Studio (SSMS)
3 2 (1.45%) WiX
4 1 (0.72%) Git (software)
4 1 (0.72%) Oracle Forms
4 1 (0.72%) Subversion
4 1 (0.72%) Visual Studio
General
1 34 (24.64%) Finance
2 18 (13.04%) Marketing
3 10 (7.25%) Banking
4 7 (5.07%) Games
5 3 (2.17%) Front Office
6 2 (1.45%) Retail
7 1 (0.72%) Advertising
7 1 (0.72%) Back Office
7 1 (0.72%) Financial Institution
7 1 (0.72%) Legal
Job Titles
1 73 (52.90%) Developer
2 35 (25.36%) Analyst
3 21 (15.22%) Data Warehouse Analyst
3 21 (15.22%) Data Warehouse Developer
4 19 (13.77%) Business Analyst
4 19 (13.77%) Data Warehouse Business Analyst
5 18 (13.04%) Data Analyst
6 17 (12.32%) Data Business Analyst
6 17 (12.32%) SAS Developer
7 14 (10.14%) Oracle Developer
8 13 (9.42%) SQL Developer
9 12 (8.70%) Business Intelligence Developer
9 12 (8.70%) Oracle Data Warehouse Developer
10 11 (7.97%) Business Intelligence Manager
10 11 (7.97%) Business Intelligence Project Manager
10 11 (7.97%) Project Manager
11 10 (7.25%) Consultant
12 9 (6.52%) PL/SQL Developer
13 8 (5.80%) Murex Consultant
13 8 (5.80%) Senior Developer
Libraries, Frameworks & Software Standards
1 16 (11.59%) Murex MxML
2 10 (7.25%) XML
3 5 (3.62%) .NET
4 3 (2.17%) Middleware
4 3 (2.17%) Spring
5 2 (1.45%) JMS
5 2 (1.45%) MDX
5 2 (1.45%) WCF
5 2 (1.45%) Web Services
6 1 (0.72%) .NET Framework
6 1 (0.72%) AngularJS
6 1 (0.72%) CSS
6 1 (0.72%) HTML
6 1 (0.72%) Java EE
6 1 (0.72%) Spark Streaming
6 1 (0.72%) Spring Boot
6 1 (0.72%) XSLT
Miscellaneous
1 18 (13.04%) Data Structures
2 11 (7.97%) PMI
3 9 (6.52%) Analytical Skills
3 9 (6.52%) Credit Derivative
3 9 (6.52%) Derivative
4 3 (2.17%) Computer Science
4 3 (2.17%) Fintech
4 3 (2.17%) Foreign Exchange (FX)
4 3 (2.17%) Greenfield Project
4 3 (2.17%) Mashup
5 2 (1.45%) Enterprise Software
5 2 (1.45%) Fixed Income
5 2 (1.45%) Hedge funds
5 2 (1.45%) Management Information System
5 2 (1.45%) Wiki
Operating Systems
1 15 (10.87%) Unix
2 10 (7.25%) Linux
3 1 (0.72%) Windows
Processes & Methodologies
1 83 (60.14%) Business Intelligence
2 47 (34.06%) Agile Software Development
3 43 (31.16%) Data Modelling
4 38 (27.54%) Dimensional Modelling
5 33 (23.91%) Scrum
6 32 (23.19%) ETL
7 29 (21.01%) Analytics
7 29 (21.01%) Visualisation
8 27 (19.57%) Kimball Methodology
8 27 (19.57%) Stakeholder Management
9 23 (16.67%) Data Integration
10 22 (15.94%) Performance Tuning
11 21 (15.22%) User Stories
12 20 (14.49%) Time Management
13 18 (13.04%) Data Management
14 17 (12.32%) Quantitative Analysis
15 16 (11.59%) Project Management
16 14 (10.14%) User Acceptance Testing
17 13 (9.42%) Business Analytics
18 12 (8.70%) Information Management
Programming Languages
1 115 (83.33%) SQL
2 40 (28.99%) PL/SQL
3 19 (13.77%) PROC SQL
4 17 (12.32%) Java
5 15 (10.87%) T-SQL
6 10 (7.25%) C
7 5 (3.62%) C#
8 2 (1.45%) PowerShell
8 2 (1.45%) Python
8 2 (1.45%) R
8 2 (1.45%) Scala
8 2 (1.45%) Shell Script
9 1 (0.72%) JavaScript
9 1 (0.72%) Perl
9 1 (0.72%) PHP
Qualifications
1 17 (12.32%) SAS Certification
2 16 (11.59%) Degree
3 11 (7.97%) PMI Certification
3 11 (7.97%) PMP
4 3 (2.17%) Computer Science Degree
5 2 (1.45%) Master's Degree
5 2 (1.45%) SC Cleared
5 2 (1.45%) Security Cleared
6 1 (0.72%) MCITP
6 1 (0.72%) MCTS
6 1 (0.72%) Microsoft Certification
Quality Assurance & Compliance
1 57 (41.30%) Data Quality
2 24 (17.39%) QA
3 1 (0.72%) SLA
System Software
1 3 (2.17%) HDFS
2 1 (0.72%) Apache Flume
Systems Management
1 1 (0.72%) ITRS Geneos
1 1 (0.72%) Oozie
1 1 (0.72%) Tivoli
Vendors
1 43 (31.16%) Oracle
2 30 (21.74%) Microsoft
2 30 (21.74%) Tableau
3 16 (11.59%) Murex
4 12 (8.70%) Talend
5 4 (2.90%) Alteryx
6 3 (2.17%) Cognos
7 2 (1.45%) Google
7 2 (1.45%) Informatica
7 2 (1.45%) SAP
7 2 (1.45%) Sybase
8 1 (0.72%) Cloudera
8 1 (0.72%) LANSA
8 1 (0.72%) RedGate
8 1 (0.72%) SunGard