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 20 January 2017 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
20 Jan 2017
Same period 2016 Same period 2015
Microsoft Data Transformation Services (DTS)
UK
Rank 579 595 547
Rank change year-on-year
+16 -48
Contract jobs citing DTS 18 27 57
As % of all contract IT jobs located in the UK 0.040% 0.053% 0.11%
As % of the Database & Business Intelligence category 0.18% 0.23% 0.51%
Number of daily rates quoted 16 24 34
Median daily rate £275 £428 £350
Median daily rate % change year-on-year
-35.67% +22.14%
90% offered a daily rate of more than £125 £275 £254
10% offered a daily rate of more than £444 £575 £450
UK excluding London median daily rate £275 £430 £350
% change year-on-year
-36.04% +22.85%
Number of hourly rates quoted 0 0 1
Median hourly rate - - £36.00
UK excluding London median hourly rate - - £36.00

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
9957 11618 11170
As % of all contract IT jobs located in the UK 22.25% 22.87% 21.95%
Number of daily rates quoted 6656 7799 7305
Median daily rate £450 £425 £400
Median daily rate % change year-on-year
+5.88% +6.25%
90% offered a daily rate of more than £310 £300 £275
10% offered a daily rate of more than £600 £575 £550
UK excluding London median daily rate £400 £380 £363
% change year-on-year
+5.26% +4.82%
Number of hourly rates quoted 132 220 163
Median hourly rate £36.75 £28.00 £30.50
Median hourly rate % change year-on-year
+31.25% -8.19%
90% offered a hourly rate of more than £12.01 £14.10 £15.51
10% offered a hourly rate of more than £47.00 £52.63 £50.00
UK excluding London median hourly rate £38.00 £26.50 £32.50
% change year-on-year
+43.39% -18.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 20 January 2017.

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 15 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 20 January 2017. 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 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 +21 17 £275 -35.29% 10
South West +17 7 £275 - 1
Cirencester - 7 £275 -
Gloucestershire - 7 £275 -
East Midlands +2 4 £125 -54.54%
London +1 4 £440 +35.38% 1
Derbyshire - 4 £125 -
Alfreton - 3 £125 -
Manchester - 2 £475 -
North West - 2 £475 - 1
Scotland +26 1 £205 -65.83%
City of London -4 1 £448 +27.85%
Bury - 1 - -
Derby - 1 £136 -
Dundee - 1 £205 -

DTS
Top 30 Related IT Skills

For the 6 months to 20 January 2017, 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 46 (90.20%) SQL Server
2 39 (76.47%) SQL
3 34 (66.67%) SQL Server Integration Services
4 30 (58.82%) SQL Server Reporting Services
5 28 (54.90%) T-SQL
6 25 (49.02%) Microsoft
7 21 (41.18%) .NET
8 18 (35.29%) SQL Server 2005
8 18 (35.29%) SQL Server 2012
9 14 (27.45%) Oracle
10 13 (25.49%) JavaScript
10 13 (25.49%) Business Intelligence
11 12 (23.53%) ETL
11 12 (23.53%) MS Excel
11 12 (23.53%) Oracle Database
12 11 (21.57%) SQL Server Analysis Services
12 11 (21.57%) XML
13 10 (19.61%) Windows
13 10 (19.61%) MS Office
13 10 (19.61%) Data Warehouse
13 10 (19.61%) SQL Server 2008
14 9 (17.65%) AngularJS
14 9 (17.65%) Oracle Reports
14 9 (17.65%) Finance
15 8 (15.69%) Workflow
15 8 (15.69%) C#
16 7 (13.73%) VB.NET
16 7 (13.73%) Oracle9i Database
16 7 (13.73%) Windows Server 2003
16 7 (13.73%) Silverlight

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 4 (7.84%) Oracle Workflow
1 4 (7.84%) Tomcat
2 2 (3.92%) BizTalk Server
3 1 (1.96%) Apache Solr
3 1 (1.96%) CMS
3 1 (1.96%) Sitecore CMS
Applications
1 12 (23.53%) MS Excel
2 10 (19.61%) MS Office
3 4 (7.84%) MS PowerPoint
3 4 (7.84%) MS Project
3 4 (7.84%) MS Visio
Business Applications
1 4 (7.84%) Demantra
1 4 (7.84%) Oracle 11i
1 4 (7.84%) Oracle Applications
Cloud Services
1 2 (3.92%) Microsoft Azure
2 1 (1.96%) SaaS
Communications & Networking
1 3 (5.88%) TCP/IP
2 1 (1.96%) HTTP
Database & Business Intelligence
1 46 (90.20%) SQL Server
2 34 (66.67%) SQL Server Integration Services
3 30 (58.82%) SQL Server Reporting Services
4 18 (35.29%) SQL Server 2005
4 18 (35.29%) SQL Server 2012
5 12 (23.53%) Oracle Database
6 11 (21.57%) SQL Server Analysis Services
7 10 (19.61%) Data Warehouse
7 10 (19.61%) SQL Server 2008
8 9 (17.65%) Oracle Reports
9 7 (13.73%) Oracle9i Database
9 7 (13.73%) Relational Database
10 6 (11.76%) Oracle Database 10g
11 5 (9.80%) Data Mining
12 4 (7.84%) Crystal Reports
12 4 (7.84%) Oracle BI Publisher
12 4 (7.84%) SQL Server 2014
12 4 (7.84%) Star Schema
13 3 (5.88%) Oracle Database 11g
13 3 (5.88%) Oracle Database 12c
Development Applications
1 6 (11.76%) Visual Studio
2 4 (7.84%) JDeveloper
2 4 (7.84%) Oracle Forms
3 1 (1.96%) CruiseControl
3 1 (1.96%) Jenkins
3 1 (1.96%) JIRA
3 1 (1.96%) Mercurial
3 1 (1.96%) SQL Server Management Studio (SSMS)
3 1 (1.96%) Team Foundation Server
General
1 9 (17.65%) Finance
2 5 (9.80%) Banking
2 5 (9.80%) Manufacturing
2 5 (9.80%) Marketing
2 5 (9.80%) Retail
3 4 (7.84%) Publishing
4 3 (5.88%) Back Office
5 2 (3.92%) Law
6 1 (1.96%) Legal
6 1 (1.96%) Pharmaceutical
6 1 (1.96%) Telecoms
Job Titles
1 27 (52.94%) Developer
2 20 (39.22%) SQL Developer
3 13 (25.49%) SQL Server Developer
4 11 (21.57%) T-SQL Developer
5 9 (17.65%) DBA
5 9 (17.65%) SQL DBA
6 8 (15.69%) .NET Developer
7 7 (13.73%) C# .NET Developer
7 7 (13.73%) C# Developer
8 6 (11.76%) Consultant
9 4 (7.84%) Analyst
9 4 (7.84%) Applications Support
9 4 (7.84%) Applications Support Analyst
9 4 (7.84%) Development Analyst
9 4 (7.84%) Development Support Analyst
9 4 (7.84%) Support Analyst
10 3 (5.88%) Business Intelligence Developer
10 3 (5.88%) ETL Consultant
10 3 (5.88%) SSIS Developer
10 3 (5.88%) SSRS Developer
Libraries, Frameworks & Software Standards
1 21 (41.18%) .NET
2 11 (21.57%) XML
3 9 (17.65%) AngularJS
4 7 (13.73%) Silverlight
5 3 (5.88%) HTML
6 2 (3.92%) CSS
6 2 (3.92%) Middleware
6 2 (3.92%) React
6 2 (3.92%) Software Packaging
7 1 (1.96%) .NET Framework
7 1 (1.96%) ADO
7 1 (1.96%) Ajax
7 1 (1.96%) jQuery
7 1 (1.96%) JSON
7 1 (1.96%) LINQ
7 1 (1.96%) MDX
7 1 (1.96%) Oracle GoldenGate
7 1 (1.96%) REST
7 1 (1.96%) WCF
7 1 (1.96%) Web Services
Miscellaneous
1 5 (9.80%) Analytical Skills
2 4 (7.84%) Management Information System
2 4 (7.84%) Replication
3 3 (5.88%) Clustering
3 3 (5.88%) Mobile App
4 2 (3.92%) Computer Science
4 2 (3.92%) Data Centre
4 2 (3.92%) User Experience
5 1 (1.96%) AS400
5 1 (1.96%) Data Integration
5 1 (1.96%) Life Science
5 1 (1.96%) Mainframe
5 1 (1.96%) NHS
5 1 (1.96%) Tandem
Operating Systems
1 10 (19.61%) Windows
2 7 (13.73%) Windows Server 2003
3 6 (11.76%) Linux
4 5 (9.80%) Unix
4 5 (9.80%) Windows Server 2008
5 4 (7.84%) HPUX
5 4 (7.84%) Windows 7
5 4 (7.84%) Windows Server 2012
6 2 (3.92%) Windows 2000
6 2 (3.92%) Windows Server
6 2 (3.92%) Windows Vista
6 2 (3.92%) Windows XP
Processes & Methodologies
1 13 (25.49%) Business Intelligence
2 12 (23.53%) ETL
3 8 (15.69%) Workflow
4 6 (11.76%) Migration
4 6 (11.76%) Translating Business Requirements
4 6 (11.76%) Web Development
5 5 (9.80%) Direct Marketing
5 5 (9.80%) Performance Monitoring
6 4 (7.84%) Business Analysis
6 4 (7.84%) Document Management
7 3 (5.88%) Data Analysis
7 3 (5.88%) Data Modelling
7 3 (5.88%) Database Mirroring
7 3 (5.88%) Disaster Recovery
7 3 (5.88%) High Availability
7 3 (5.88%) ITIL
7 3 (5.88%) Performance Tuning
8 2 (3.92%) Agile Software Development
8 2 (3.92%) Configuration Management
8 2 (3.92%) SOA
Programming Languages
1 39 (76.47%) SQL
2 28 (54.90%) T-SQL
3 13 (25.49%) JavaScript
4 8 (15.69%) C#
5 7 (13.73%) VB.NET
6 5 (9.80%) Java
6 5 (9.80%) PL/SQL
7 2 (3.92%) PowerShell
8 1 (1.96%) VB
Qualifications
1 5 (9.80%) Microsoft Certification
2 3 (5.88%) Degree
2 3 (5.88%) MCDBA
2 3 (5.88%) MCSE
3 2 (3.92%) MCITP
3 2 (3.92%) MCTS
3 2 (3.92%) OCP
3 2 (3.92%) Oracle Certification
4 1 (1.96%) CCNA
4 1 (1.96%) CCNP
4 1 (1.96%) Cisco Certification
4 1 (1.96%) MCP
4 1 (1.96%) Security Cleared
4 1 (1.96%) Six Sigma Black Belt
4 1 (1.96%) Six Sigma Green Belt
Quality Assurance & Compliance
1 6 (11.76%) QA
2 2 (3.92%) ISO 9001
3 1 (1.96%) SLA
System Software
1 1 (1.96%) Oracle RAC
Systems Management
1 2 (3.92%) Data Guard
1 2 (3.92%) Oracle RMAN
2 1 (1.96%) Enterprise Manager Cloud Control
Vendors
1 25 (49.02%) Microsoft
2 14 (27.45%) Oracle
3 7 (13.73%) Xamarin
4 3 (5.88%) Tableau
5 2 (3.92%) SAP
6 1 (1.96%) Brio
6 1 (1.96%) iManage
6 1 (1.96%) Pega
6 1 (1.96%) Salesforce.com
6 1 (1.96%) Sitecore
6 1 (1.96%) Sybase