Period
to 21 June 2018

The following table provides summary statistics for contract job vacancies with a requirement for Data Mart skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited Data Mart over the 6 months to 21 June 2018 with a comparison to the same period in the previous 2 years.

Note that daily and hourly rates are treated separately in these statistics. When calculating contractor rate percentiles, daily rates are never derived from quoted hourly rates or vice versa.

Data Mart
UK
6 months to
21 Jun 2018
Same period 2017 Same period 2016
Rank 819 735 755
Rank change year-on-year -84 +20 -47
Contract jobs citing Data Mart 60 111 144
As % of all contract IT jobs advertised in the UK 0.060% 0.12% 0.13%
As % of the Database & Business Intelligence category 0.27% 0.54% 0.61%
Number of daily rates quoted 38 64 98
UK median daily rate £470 £500 £500
Median daily rate % change year-on-year -6.00% - +21.21%
10th Percentile £380 £375 £288
90th Percentile £584 £771 £758
UK excluding London median daily rate £438 £450 £425
% change year-on-year -2.78% +5.88% +10.39%
Number of hourly rates quoted 0 1 0
UK median hourly rate - £62.50 -
UK excluding London median hourly rate - - -

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 contract job vacancies with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
UK
Contract vacancies with a requirement for database or business intelligence skills 22,553 20,605 23,483
As % of all contract IT jobs advertised in the UK 22.54% 22.60% 22.01%
Number of daily rates quoted 15,702 13,719 15,840
UK median daily rate £463 £440 £425
Median daily rate % change year-on-year +5.11% +3.53% +6.25%
10th Percentile £313 £300 £281
90th Percentile £631 £613 £600
UK excluding London median daily rate £413 £400 £375
% change year-on-year +3.13% +6.67% +3.45%
Number of hourly rates quoted 232 267 387
UK median hourly rate £35.00 £29.00 £31.00
Median hourly rate % change year-on-year +20.69% -6.45% +19.23%
10th Percentile £14.00 £9.32 £12.00
90th Percentile £54.88 £52.17 £53.60
UK excluding London median hourly rate £35.00 £27.50 £31.14
% change year-on-year +27.27% -11.67% +22.92%

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
Contractor Daily Rate Trend

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing Data Mart.

Contractor daily rate trend for Data Mart in the UK

Data Mart
Contractor Daily Rate Histogram

The daily rate distribution of IT jobs citing Data Mart over the 6 months to 21 June 2018.

Contractor daily rate histogram for Data Mart in the UK

Data Mart
Contractor Hourly Rate Trend

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing Data Mart.

Contractor hourly rate trend for Data Mart in the UK

Data Mart
Top 12 Contract Locations

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing Data Mart within the UK over the 6 months to 21 June 2018. 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
Contract
IT Job Ads
Median
Daily Rate
Past 6 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
England -100 57 £470 -8.29% 8
UK excluding London +3 34 £438 -2.78% 1
London -91 26 £470 -18.26% 7
Midlands -7 14 £413 -4.29%
East Midlands - 12 £450 -
North of England -26 10 £500 -9.09%
Yorkshire - 9 £470 -
South East -20 5 £500 +2.56% 1
Scotland -37 3 £375 -16.67%
East of England +5 2 £431 +91.67%
West Midlands -18 2 £388 -10.09%
North West -12 1 £525 -4.55%

For the 6 months to 21 June 2018, IT contractor jobs citing Data Mart also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all contract job ads with a requirement for Data Mart.

1 48 (80.00%) SQL
2 44 (73.33%) Business Intelligence
3 35 (58.33%) SQL Server
4 27 (45.00%) Data Modelling
4 27 (45.00%) Power BI
5 26 (43.33%) ETL
5 26 (43.33%) SQL Server Integration Services
6 22 (36.67%) Data Analysis
7 21 (35.00%) Dimensional Modelling
7 21 (35.00%) Microsoft
7 21 (35.00%) T-SQL
8 20 (33.33%) SQL Server Reporting Services
9 19 (31.67%) Data Warehouse
10 18 (30.00%) Java
11 17 (28.33%) SQL Server Analysis Services
11 17 (28.33%) MDX
12 16 (26.67%) MS Visio
13 15 (25.00%) Requirements Analysis
13 15 (25.00%) Microsoft Analysis Services
13 15 (25.00%) Agile Software Development
13 15 (25.00%) Self-Motivation
13 15 (25.00%) Node.js
13 15 (25.00%) Data Analysis Expressions (DAX)
14 14 (23.33%) Oracle
15 13 (21.67%) Use Case
16 11 (18.33%) Oracle Reports
16 11 (18.33%) ERD
16 11 (18.33%) Root Cause Analysis
17 10 (16.67%) SharePoint
18 9 (15.00%) Finance

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 10 (16.67%) SharePoint
2 2 (3.33%) Apache Spark
3 1 (1.67%) Apache Pig
3 1 (1.67%) Apache Solr
3 1 (1.67%) Elasticsearch
Applications
1 16 (26.67%) MS Visio
2 2 (3.33%) Microsoft Excel
3 1 (1.67%) Microsoft PowerPoint
Business Applications
1 3 (5.00%) Markit EDM
2 2 (3.33%) Dynamics CRM
2 2 (3.33%) Eagle PACE
3 1 (1.67%) Cognos Business Intelligence
3 1 (1.67%) PeopleSoft HRMS
3 1 (1.67%) PolarLake
Cloud Services
1 7 (11.67%) Amazon AWS
2 1 (1.67%) Amazon EMR
2 1 (1.67%) Amazon Kinesis
2 1 (1.67%) Amazon S3
2 1 (1.67%) GitHub
2 1 (1.67%) Google Cloud Platform
2 1 (1.67%) Microsoft Azure
2 1 (1.67%) PaaS
Database & Business Intelligence
1 35 (58.33%) SQL Server
2 27 (45.00%) Power BI
3 26 (43.33%) SQL Server Integration Services
4 20 (33.33%) SQL Server Reporting Services
5 19 (31.67%) Data Warehouse
6 17 (28.33%) SQL Server Analysis Services
7 15 (25.00%) Microsoft Analysis Services
8 11 (18.33%) Oracle Reports
9 6 (10.00%) SSDT
10 4 (6.67%) Big Data
10 4 (6.67%) BusinessObjects
10 4 (6.67%) Relational Database
11 3 (5.00%) Hadoop
11 3 (5.00%) Oracle BI EE
12 2 (3.33%) Amazon Redshift
12 2 (3.33%) Apache Cassandra
12 2 (3.33%) Apache Hive
12 2 (3.33%) NoSQL
12 2 (3.33%) Oracle Database
12 2 (3.33%) SQL Server 2012
Development Applications
1 8 (13.33%) JIRA
2 2 (3.33%) ERwin
2 2 (3.33%) LoadRunner
2 2 (3.33%) Toad
3 1 (1.67%) Bitbucket
3 1 (1.67%) Git (software)
3 1 (1.67%) TeamCity
3 1 (1.67%) Visual Studio
General
1 9 (15.00%) Finance
2 2 (3.33%) Banking
2 2 (3.33%) Billing
2 2 (3.33%) Front Office
2 2 (3.33%) Investment Banking
3 1 (1.67%) Back Office
3 1 (1.67%) Marketing
3 1 (1.67%) Pharmaceutical
Job Titles
1 40 (66.67%) Developer
2 17 (28.33%) Business Intelligence Developer
3 15 (25.00%) SQL Developer
4 12 (20.00%) Analyst
5 9 (15.00%) Data Analyst
5 9 (15.00%) SQL BI Developer
5 9 (15.00%) SSRS Developer
6 8 (13.33%) Data Mart Developer
6 8 (13.33%) Power BI Developer
7 6 (10.00%) ETL Developer
8 4 (6.67%) Analyst Developer
8 4 (6.67%) Developer Analyst
9 3 (5.00%) Architect
9 3 (5.00%) Data Architect
9 3 (5.00%) Report Analyst
10 2 (3.33%) Oracle Developer
10 2 (3.33%) Performance Tester
10 2 (3.33%) PL/SQL Developer
10 2 (3.33%) Project Manager
10 2 (3.33%) Tester
Libraries, Frameworks & Software Standards
1 17 (28.33%) MDX
2 15 (25.00%) Node.js
3 2 (3.33%) Web Services
4 1 (1.67%) J2EE
4 1 (1.67%) Kafka
4 1 (1.67%) Lucene
Miscellaneous
1 15 (25.00%) Self-Motivation
2 3 (5.00%) Analytical Skills
2 3 (5.00%) Data Structures
2 3 (5.00%) Management Information System
3 2 (3.33%) Computer Science
3 2 (3.33%) Derivative
3 2 (3.33%) Reference Data
4 1 (1.67%) Algorithms
4 1 (1.67%) Equities
4 1 (1.67%) Fixed Income
4 1 (1.67%) Foreign Exchange (FX)
4 1 (1.67%) Greenfield Project
4 1 (1.67%) Life Science
4 1 (1.67%) OTC Derivatives
Operating Systems
1 1 (1.67%) Unix
Processes & Methodologies
1 44 (73.33%) Business Intelligence
2 27 (45.00%) Data Modelling
3 26 (43.33%) ETL
4 22 (36.67%) Data Analysis
5 21 (35.00%) Dimensional Modelling
6 15 (25.00%) Agile Software Development
6 15 (25.00%) Requirements Analysis
7 13 (21.67%) Use Case
8 11 (18.33%) ERD
8 11 (18.33%) Root Cause Analysis
9 9 (15.00%) Analytics
9 9 (15.00%) Performance Tuning
10 8 (13.33%) Stakeholder Management
11 7 (11.67%) User Acceptance Testing
12 6 (10.00%) ETL Development
12 6 (10.00%) Migration
13 5 (8.33%) Data Management
13 5 (8.33%) Database Tuning
13 5 (8.33%) SQL Optimisation
14 4 (6.67%) Data Migration
Programming Languages
1 48 (80.00%) SQL
2 21 (35.00%) T-SQL
3 18 (30.00%) Java
4 15 (25.00%) Data Analysis Expressions (DAX)
5 3 (5.00%) PL/SQL
5 3 (5.00%) Python
6 2 (3.33%) R
7 1 (1.67%) Scala
7 1 (1.67%) Shell Script
7 1 (1.67%) VB
7 1 (1.67%) VBA
Qualifications
1 3 (5.00%) Degree
2 2 (3.33%) Computer Science Degree
2 2 (3.33%) PMP
2 2 (3.33%) Security Cleared
3 1 (1.67%) BC Cleared
3 1 (1.67%) Master's Degree
3 1 (1.67%) MCSA
3 1 (1.67%) MCSE
3 1 (1.67%) Microsoft Certification
Quality Assurance & Compliance
1 5 (8.33%) Data Quality
2 1 (1.67%) QA
System Software
1 1 (1.67%) Apache Flume
1 1 (1.67%) Apache ZooKeeper
1 1 (1.67%) HDFS
Systems Management
1 1 (1.67%) Control-M
1 1 (1.67%) Oozie
Vendors
1 21 (35.00%) Microsoft
2 14 (23.33%) Oracle
3 3 (5.00%) SAP
4 2 (3.33%) Cognos
4 2 (3.33%) FactSet
4 2 (3.33%) MicroStrategy
4 2 (3.33%) Tableau
4 2 (3.33%) Talend
4 2 (3.33%) Vermilion
5 1 (1.67%) Bloomberg
5 1 (1.67%) CA Agile Central
5 1 (1.67%) Cloudera
5 1 (1.67%) Google
5 1 (1.67%) Hortonworks
5 1 (1.67%) Hyperion
5 1 (1.67%) Informatica
5 1 (1.67%) Murex
5 1 (1.67%) PeopleSoft
5 1 (1.67%) Salesforce.com