Period
to 18 November 2017

The following table provides summary statistics for contract job vacancies advertised in Cardiff with a requirement for Data Warehouse skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited Data Warehouse over the 6 months to 18 November 2017 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 Warehousing
South Wales > Cardiff
6 months to
18 Nov 2017
Same period 2016 Same period 2015
Rank 36 20 61
Rank change year-on-year -16 +41 -25
Contract jobs citing Data Warehouse 23 40 21
As % of all contract IT jobs advertised in Cardiff 3.74% 7.25% 2.44%
As % of the Database & Business Intelligence category 14.02% 26.85% 7.02%
Number of daily rates quoted 17 31 17
Cardiff median daily rate £300 £375 £310
Median daily rate % change year-on-year -20.00% +20.97% -8.15%
10th Percentile £205 £170 £300
90th Percentile £411 £550 £500
South Wales median daily rate £332 £375 £323
% change year-on-year -11.40% +16.28% -7.86%
Number of hourly rates quoted 0 1 0
Cardiff median hourly rate - £21.50 -
South Wales median hourly rate - £21.50 £16.80
% change year-on-year - +27.98% -

Data Warehouse 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 advertised in Cardiff with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
Cardiff
Contract vacancies with a requirement for database or business intelligence skills 164 149 299
As % of all contract IT jobs advertised in Cardiff 26.67% 26.99% 34.69%
Number of daily rates quoted 101 119 240
Cardiff median daily rate £375 £388 £338
Median daily rate % change year-on-year -3.23% +14.81% +3.85%
10th Percentile £183 £203 £220
90th Percentile £450 £550 £438
South Wales median daily rate £375 £400 £350
% change year-on-year -6.25% +14.29% -
Number of hourly rates quoted 4 2 1
Cardiff median hourly rate £18.75 £27.00 £36.00
Median hourly rate % change year-on-year -30.56% -25.00% +157.14%
South Wales median hourly rate £18.75 £56.25 £29.75
% change year-on-year -66.67% +89.08% +105.17%

Data Warehouse
Job Vacancy Trend in Cardiff

Job postings citing Data Warehouse as a percentage of all IT jobs advertised in Cardiff.

Job vacancy trend for Data Warehouse in Cardiff

Data Warehouse
Contractor Daily Rate Trend in Cardiff

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

Contractor daily rate trend for Data Warehouse in Cardiff

Data Warehouse
Contractor Daily Rate Histogram in Cardiff

The daily rate distribution of IT jobs citing Data Warehouse in Cardiff over the 6 months to 18 November 2017.

Contractor daily rate histogram for Data Warehouse in Cardiff

Data Warehouse
Contractor Hourly Rate Trend in Cardiff

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

Contractor hourly rate trend for Data Warehouse in Cardiff

For the 6 months to 18 November 2017, IT contractor jobs citing Data Warehouse also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all contract ads across the Cardiff region with a requirement for Data Warehouse.

1 19 (82.61%) SQL
2 18 (78.26%) ETL
3 16 (69.57%) SQL Server Integration Services
4 14 (60.87%) Microsoft
5 12 (52.17%) XML
6 9 (39.13%) SQL Server
7 8 (34.78%) XSD
7 8 (34.78%) XML Schema
7 8 (34.78%) Oracle
7 8 (34.78%) SQL Server Management Studio (SSMS)
8 6 (26.09%) Scrum
8 6 (26.09%) Teradata
8 6 (26.09%) Business Intelligence
8 6 (26.09%) ITIL
8 6 (26.09%) Informatica
9 5 (21.74%) T-SQL
9 5 (21.74%) Migration
9 5 (21.74%) Relational Database
10 4 (17.39%) Logical Data Model
10 4 (17.39%) Physical Data Model
10 4 (17.39%) Data Migration
10 4 (17.39%) Data Cleansing
10 4 (17.39%) Kimball Methodology
10 4 (17.39%) Agile Software Development
10 4 (17.39%) SQL Server Reporting Services
10 4 (17.39%) Star Schema
10 4 (17.39%) Linux
10 4 (17.39%) Data Modelling
11 3 (13.04%) NHS
11 3 (13.04%) Windows

Data Warehouse
Co-occurring IT Skills in Cardiff 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 2 (8.70%) SAS
2 1 (4.35%) PowerExchange
Cloud Services
1 2 (8.70%) Microsoft Azure
Database & Business Intelligence
1 16 (69.57%) SQL Server Integration Services
2 9 (39.13%) SQL Server
3 5 (21.74%) Relational Database
4 4 (17.39%) SQL Server Reporting Services
4 4 (17.39%) Star Schema
5 3 (13.04%) Oracle Database
6 2 (8.70%) Azure SQL Database
6 2 (8.70%) Big Data
6 2 (8.70%) Oracle Database 10g
6 2 (8.70%) Oracle Database 11g
6 2 (8.70%) SQL Server 2008
7 1 (4.35%) Power BI
7 1 (4.35%) PowerCenter
7 1 (4.35%) SQL Server 2014
7 1 (4.35%) SQL Server 2016
7 1 (4.35%) SQL Server Analysis Services
Development Applications
1 8 (34.78%) SQL Server Management Studio (SSMS)
2 2 (8.70%) JIRA
2 2 (8.70%) JMeter
2 2 (8.70%) SoapUI
General
1 1 (4.35%) Finance
Job Titles
1 14 (60.87%) Developer
2 10 (43.48%) Data Warehouse Developer
3 5 (21.74%) SQL Developer
3 5 (21.74%) SSIS Developer
4 4 (17.39%) Analyst
5 3 (13.04%) Business Intelligence Developer
5 3 (13.04%) DBA
5 3 (13.04%) ETL Developer
5 3 (13.04%) Informatica Developer
5 3 (13.04%) SQL DBA
6 2 (8.70%) Administrator
6 2 (8.70%) Business Analyst
6 2 (8.70%) Data Business Analyst
6 2 (8.70%) Data Warehouse Analyst
6 2 (8.70%) Data Warehouse Test Analyst
6 2 (8.70%) Test Analyst
6 2 (8.70%) Test Data Analyst
6 2 (8.70%) XML Developer
7 1 (4.35%) SQL Server Data Warehouse Developer
7 1 (4.35%) Teradata Developer
Libraries, Frameworks & Software Standards
1 12 (52.17%) XML
2 8 (34.78%) XML Schema
2 8 (34.78%) XSD
3 1 (4.35%) Web Services
Miscellaneous
1 3 (13.04%) NHS
2 2 (8.70%) Clustering
2 2 (8.70%) iSeries
3 1 (4.35%) Analytical Skills
3 1 (4.35%) Computer Science
3 1 (4.35%) Data Structures
3 1 (4.35%) Management Information System
Operating Systems
1 4 (17.39%) Linux
2 3 (13.04%) Windows
Processes & Methodologies
1 18 (78.26%) ETL
2 6 (26.09%) Business Intelligence
2 6 (26.09%) ITIL
2 6 (26.09%) Scrum
3 5 (21.74%) Migration
4 4 (17.39%) Agile Software Development
4 4 (17.39%) Data Cleansing
4 4 (17.39%) Data Migration
4 4 (17.39%) Data Modelling
4 4 (17.39%) Kimball Methodology
4 4 (17.39%) Logical Data Model
4 4 (17.39%) Physical Data Model
5 3 (13.04%) Data Governance
5 3 (13.04%) SDLC
6 2 (8.70%) Data Strategy
6 2 (8.70%) Defect Tracking
6 2 (8.70%) Dependency Management
6 2 (8.70%) Exploratory Testing
6 2 (8.70%) High Availability
6 2 (8.70%) Regulatory Compliance
Programming Languages
1 19 (82.61%) SQL
2 5 (21.74%) T-SQL
3 2 (8.70%) PowerShell
4 1 (4.35%) Data Analysis Expressions (DAX)
4 1 (4.35%) VB
Qualifications
1 2 (8.70%) ISTQB
1 2 (8.70%) ISTQB Foundation Certification
2 1 (4.35%) BPSS Clearance
2 1 (4.35%) Computer Science Degree
2 1 (4.35%) Degree
Quality Assurance & Compliance
1 1 (4.35%) Disclosure Scotland
1 1 (4.35%) QA
System Software
1 1 (4.35%) Oracle RAC
Systems Management
1 1 (4.35%) Systems Management Server (SMS)
Vendors
1 14 (60.87%) Microsoft
2 8 (34.78%) Oracle
3 6 (26.09%) Informatica
3 6 (26.09%) Teradata
4 2 (8.70%) IBM
4 2 (8.70%) MicroStrategy
5 1 (4.35%) Tableau