The table below looks at the statistics for DTS skills in IT contracts advertised across the UK. Included is a guide to the contractor rates offered in IT contracts that have cited DTS over the 3 months to 29 May 2016 with a comparison to the same period over the previous 2 years.

Note that daily contractor rates and hourly contractor rates are treated separately. When calculating average contractor rates, daily rates are not derived from quoted hourly rates or vice versa.

3 months to
29 May 2016
Same period 2015 Same period 2014
Microsoft Data Transformation Services (DTS)
Rank 626 547 478
Rank change year-on-year
-79 -69
Contract jobs citing DTS 20 98 145
As % of all contract IT jobs located in the UK 0.037% 0.18% 0.27%
As % of the Database & Business Intelligence category 0.17% 0.76% 1.22%
Number of daily rates quoted 14 73 97
Median daily rate £325 £400 £350
Median daily rate % change year-on-year
-18.75% +14.28%
90% offered a daily rate of more than £281 £275 £250
10% offered a daily rate of more than £434 £598 £540
UK excluding London median daily rate £325 £350 £300
% change year-on-year
-7.14% +16.66%
Number of hourly rates quoted 0 1 0
Median hourly rate - £25.66 -
UK excluding London median hourly rate - £25.66 -

The following table is for comparison with the above and provides statistics for the entire Database & Business Intelligence category in contract jobs advertised across the UK.

Database & Business Intelligence Category
UK
Contract IT job ads with a match in the
Database & Business Intelligence category
11614 12914 11931
As % of all contract IT jobs located in the UK 21.63% 23.06% 22.28%
Number of daily rates quoted 7916 8415 7602
Median daily rate £425 £400 £390
Median daily rate % change year-on-year
+6.25% +2.56%
90% offered a daily rate of more than £300 £275 £270
10% offered a daily rate of more than £600 £550 £525
UK excluding London median daily rate £390 £363 £350
% change year-on-year
+7.58% +3.57%
Number of hourly rates quoted 179 178 201
Median hourly rate £33.08 £26.00 £30.00
Median hourly rate % change year-on-year
+27.22% -13.33%
90% offered a hourly rate of more than £13.50 £15.31 £13.50
10% offered a hourly rate of more than £48.90 £46.09 £55.00
UK excluding London median hourly rate £33.50 £26.00 £31.50
% change year-on-year
+28.84% -17.46%

DTS
Jobs Demand Trend

The demand trend of contract jobs citing DTS as a proportion of all IT contracts with a match in the Database & Business Intelligence category.

DTS Jobs Demand Trend in the UK

DTS
Daily Rate Trend

This chart provides the 3-month moving average for daily rates quoted in IT contract jobs citing DTS within the UK.

DTS Daily Rate Trend in the UK

DTS
Daily Rate Histogram

This chart provides a histogram of daily rates quoted in contract IT jobs citing DTS within the UK over the 3 months to 29 May 2016.

DTS Daily Rate Histogram in the UK

DTS
Hourly Rate Trend

This chart provides the 3-month moving average for hourly rates quoted in IT contractor jobs citing DTS within the UK.

DTS Hourly Rate Trend in the UK

DTS
Top 25 Contract Locations

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing DTS within the UK over the 3 months to 29 May 2016. 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
(Click see detailed
statistics and trends)
Rank Change
on Same Period
Last Year
Matching
Contract
IT Job Ads
Median
Daily Rate
Last 3 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
England -69 14 £375 -6.25% 12
Glasgow +3 5 £319 -36.25% 2
Scotland -18 5 £319 -37.80% 2
South East -1 4 £423 +35.44% 4
East Midlands +8 3 £288 -28.12%
London -48 3 £300 -27.92% 1
West Sussex - 3 £413 - 2
Hertfordshire +12 2 £375 +7.14% 2
East of England +4 2 £375 -0.66% 2
Nottinghamshire +2 2 £300 +9.09%
Surrey -9 2 £380 +21.44%
Nottingham - 2 £300 -
Crawley - 2 £413 - 2
City of London +23 1 - -
Northamptonshire -3 1 £288 -28.12%
South West -4 1 - - 3
Dorset - 1 - -
Yorkshire - 1 - - 2
Kent - 1 £434 -
Bournemouth - 1 - -
Watford - 1 - - 1
Kettering - 1 £288 -
Halifax - 1 - - 1
West Yorkshire - 1 - - 2
Guildford - 1 £325 -

DTS
Top 30 Related IT Skills

For the 6 months to 29 May 2016, IT contractor jobs citing DTS also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all contract ads with a requirement for DTS.

1 39 (82.98%) SQL Server Integration Services
2 38 (80.85%) SQL Server
3 34 (72.34%) SQL
4 24 (51.06%) T-SQL
5 21 (44.68%) .NET
6 19 (40.43%) SQL Server Reporting Services
7 17 (36.17%) Migration
7 17 (36.17%) Microsoft
8 16 (34.04%) SQL Server 2005
9 14 (29.79%) SQL Server 2012
10 12 (25.53%) JavaScript
10 12 (25.53%) Web Services
11 11 (23.40%) Windows
11 11 (23.40%) C#
11 11 (23.40%) VBScript
11 11 (23.40%) SQL Server 2008
12 10 (21.28%) SQL Server Analysis Services
12 10 (21.28%) Windows Server
13 9 (19.15%) MS Excel
13 9 (19.15%) SQL Server 2000
13 9 (19.15%) Windows Server 2012
13 9 (19.15%) High Availability
14 8 (17.02%) Performance Monitoring
14 8 (17.02%) CRM
14 8 (17.02%) XML
14 8 (17.02%) Clustering
15 7 (14.89%) .NET Framework
15 7 (14.89%) OLAP
15 7 (14.89%) IIS
15 7 (14.89%) ETL

DTS
Top Related 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 7 (14.89%) IIS
2 6 (12.77%) BizTalk Server
2 6 (12.77%) SharePoint
3 4 (8.51%) SharePoint 2010
4 1 (2.13%) CMS
Applications
1 9 (19.15%) MS Excel
2 3 (6.38%) MS Office
3 2 (4.26%) MS PowerPoint
Business Applications
1 4 (8.51%) SAP CRM
1 4 (8.51%) Unica
Cloud Services
1 3 (6.38%) SaaS
2 1 (2.13%) GitHub
2 1 (2.13%) IaaS
2 1 (2.13%) PaaS
Communications & Networking
1 6 (12.77%) Internet
2 1 (2.13%) SAN
Database & Business Intelligence
1 39 (82.98%) SQL Server Integration Services
2 38 (80.85%) SQL Server
3 19 (40.43%) SQL Server Reporting Services
4 16 (34.04%) SQL Server 2005
5 14 (29.79%) SQL Server 2012
6 11 (23.40%) SQL Server 2008
7 10 (21.28%) SQL Server Analysis Services
8 9 (19.15%) SQL Server 2000
9 7 (14.89%) OLAP
10 5 (10.64%) OLTP
10 5 (10.64%) SQL Server 2014
11 4 (8.51%) BusinessObjects
11 4 (8.51%) Microsoft Analysis Services
11 4 (8.51%) SQL Server 2016
12 3 (6.38%) Data Mining
12 3 (6.38%) Oracle Database
12 3 (6.38%) Oracle Reports
12 3 (6.38%) Oracle9i Database
13 2 (4.26%) Data Warehouse
13 2 (4.26%) Relational Database
Development Applications
1 6 (12.77%) Team Foundation Server
2 3 (6.38%) Visual Studio
3 2 (4.26%) SQL Server Management Studio (SSMS)
4 1 (2.13%) Maven
General
1 4 (8.51%) Finance
1 4 (8.51%) Retail
2 3 (6.38%) Banking
3 2 (4.26%) Back Office
3 2 (4.26%) Billing
3 2 (4.26%) Marketing
4 1 (2.13%) Advertising
Job Titles
1 21 (44.68%) Developer
2 15 (31.91%) DBA
2 15 (31.91%) SQL DBA
3 10 (21.28%) SQL Developer
4 9 (19.15%) SQL Server DBA
5 7 (14.89%) .NET Developer
5 7 (14.89%) SSIS Developer
6 6 (12.77%) C# .NET Developer
6 6 (12.77%) C# Developer
6 6 (12.77%) SSRS Developer
7 5 (10.64%) Applications Support
7 5 (10.64%) Architect
7 5 (10.64%) ASP.NET Developer
7 5 (10.64%) C# ASP.NET Developer
7 5 (10.64%) Production DBA
8 4 (8.51%) AS400 Support
9 3 (6.38%) Analyst
9 3 (6.38%) Database Engineer
9 3 (6.38%) Microsoft Engineer
9 3 (6.38%) SQL Server Production DBA
Libraries, Frameworks & Software Standards
1 21 (44.68%) .NET
2 12 (25.53%) Web Services
3 8 (17.02%) XML
4 7 (14.89%) .NET Framework
5 6 (12.77%) ASP.NET
5 6 (12.77%) HTML
6 4 (8.51%) EDI
6 4 (8.51%) HTML5
6 4 (8.51%) REST
6 4 (8.51%) SAP XI
6 4 (8.51%) SOAP
7 2 (4.26%) MDX
8 1 (2.13%) Ajax
8 1 (2.13%) Apache Camel
8 1 (2.13%) Apache Tika
8 1 (2.13%) ASP.NET Web Forms
8 1 (2.13%) CSS
8 1 (2.13%) Itk
8 1 (2.13%) JMS
8 1 (2.13%) Middleware
Miscellaneous
1 8 (17.02%) Clustering
2 6 (12.77%) Computer Science
2 6 (12.77%) Replication
3 5 (10.64%) Data Centre
4 4 (8.51%) AS400
4 4 (8.51%) iSeries
5 2 (4.26%) Analytical Skills
5 2 (4.26%) Enterprise Software
5 2 (4.26%) Reinsurance
6 1 (2.13%) Fixed Income
6 1 (2.13%) NHS
6 1 (2.13%) Social Media
6 1 (2.13%) User Experience
Operating Systems
1 11 (23.40%) Windows
2 10 (21.28%) Windows Server
3 9 (19.15%) Windows Server 2012
4 6 (12.77%) Windows Server 2003
5 4 (8.51%) Windows Server 2008
6 1 (2.13%) Linux
Processes & Methodologies
1 17 (36.17%) Migration
2 9 (19.15%) High Availability
3 8 (17.02%) CRM
3 8 (17.02%) Performance Monitoring
4 7 (14.89%) ETL
4 7 (14.89%) Performance Tuning
5 6 (12.77%) Business Intelligence
5 6 (12.77%) Database Tuning
5 6 (12.77%) Project Management
6 5 (10.64%) E-Commerce
6 5 (10.64%) Server Virtualisation
6 5 (10.64%) User Acceptance Testing
6 5 (10.64%) Workflow
7 4 (8.51%) Data Transformation
7 4 (8.51%) Disaster Recovery
7 4 (8.51%) EAI
7 4 (8.51%) ERP
7 4 (8.51%) SOA
7 4 (8.51%) Web Development
8 3 (6.38%) Service Management
Programming Languages
1 34 (72.34%) SQL
2 24 (51.06%) T-SQL
3 12 (25.53%) JavaScript
4 11 (23.40%) C#
4 11 (23.40%) VBScript
5 6 (12.77%) VB
6 5 (10.64%) Java
6 5 (10.64%) PowerShell
7 4 (8.51%) RPG
7 4 (8.51%) RPG IV
7 4 (8.51%) XPath
8 3 (6.38%) Perl
8 3 (6.38%) Python
9 1 (2.13%) VB.NET
Qualifications
1 4 (8.51%) Degree
Quality Assurance & Compliance
1 5 (10.64%) QA
2 4 (8.51%) Data Quality
System Software
1 5 (10.64%) Hyper-V
2 2 (4.26%) Firmware
2 2 (4.26%) VMware ESX
2 2 (4.26%) VMware ESXi
2 2 (4.26%) VMware Infrastructure
2 2 (4.26%) vSphere
2 2 (4.26%) XenDesktop
3 1 (2.13%) Docker
Systems Management
1 2 (4.26%) Tivoli
2 1 (2.13%) SCOM
Vendors
1 17 (36.17%) Microsoft
2 5 (10.64%) SAP
3 4 (8.51%) Informatica
3 4 (8.51%) Oracle
4 2 (4.26%) Cognos
4 2 (4.26%) IBM
4 2 (4.26%) Sun
4 2 (4.26%) Symantec
4 2 (4.26%) VMware
5 1 (2.13%) PayPal