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 23 February 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
23 Feb 2017
Same period 2016 Same period 2015
Microsoft Data Transformation Services (DTS)
UK
Rank 573 601 557
Rank change year-on-year
+28 -44
Contract jobs citing DTS 22 27 59
As % of all contract IT jobs located in the UK 0.048% 0.052% 0.11%
As % of the Database & Business Intelligence category 0.22% 0.23% 0.51%
Number of daily rates quoted 20 24 33
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 £293
10% offered a daily rate of more than £448 £550 £474
UK excluding London median daily rate £275 £325 £350
% change year-on-year
-15.38% -7.14%
Number of hourly rates quoted 0 0 0
Median hourly rate - - -
UK excluding London median hourly rate - - -

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
10135 11646 11678
As % of all contract IT jobs located in the UK 22.33% 22.38% 22.24%
Number of daily rates quoted 6867 7837 7548
Median daily rate £438 £425 £400
Median daily rate % change year-on-year
+2.94% +6.25%
90% offered a daily rate of more than £300 £300 £275
10% offered a daily rate of more than £600 £575 £550
UK excluding London median daily rate £400 £375 £370
% change year-on-year
+6.66% +1.35%
Number of hourly rates quoted 138 207 165
Median hourly rate £38.00 £36.75 £32.10
Median hourly rate % change year-on-year
+3.40% +14.48%
90% offered a hourly rate of more than £12.00 £14.00 £15.53
10% offered a hourly rate of more than £45.00 £60.62 £50.75
UK excluding London median hourly rate £38.00 £35.00 £32.50
% change year-on-year
+8.57% +7.69%

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 23 February 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 21 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 23 February 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 +31 20 £275 -36.04% 3
South West +17 7 £275 -
Gloucestershire - 7 £275 -
Cirencester - 7 £275 -
East Midlands -1 5 £125 -54.54%
London +7 4 £450 -10.00%
Derbyshire - 4 £125 -
Alfreton - 3 £125 -
South East +22 2 £406 -5.52% 1
East of England - 2 £413 -
Cambridge - 2 £413 -
Cambridgeshire - 2 £413 -
Scotland +24 1 £205 -36.92% 2
Kent +13 1 £400 -6.97% 1
City of London -7 1 £448 +27.85%
Derby - 1 £136 -
Northamptonshire - 1 £325 -
West Sussex - 1 £413 -
Northampton - 1 £325 -
Crawley - 1 £413 -
Dundee - 1 £205 -

DTS
Top 30 Related IT Skills

For the 6 months to 23 February 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 38 (88.37%) SQL Server
2 31 (72.09%) SQL
3 28 (65.12%) SQL Server Integration Services
4 27 (62.79%) SQL Server Reporting Services
5 25 (58.14%) T-SQL
6 22 (51.16%) Microsoft
7 20 (46.51%) SQL Server 2012
8 18 (41.86%) .NET
9 15 (34.88%) SQL Server 2005
10 14 (32.56%) Oracle
10 14 (32.56%) Business Intelligence
11 13 (30.23%) JavaScript
12 12 (27.91%) Oracle Database
12 12 (27.91%) SQL Server Analysis Services
13 11 (25.58%) MS Excel
14 10 (23.26%) MS Office
14 10 (23.26%) SQL Server 2008
15 9 (20.93%) AngularJS
15 9 (20.93%) Windows
15 9 (20.93%) ETL
15 9 (20.93%) Finance
16 8 (18.60%) Data Warehouse
16 8 (18.60%) Oracle Reports
16 8 (18.60%) C#
17 7 (16.28%) VB.NET
17 7 (16.28%) XML
17 7 (16.28%) Oracle9i Database
17 7 (16.28%) Oracle Database 10g
17 7 (16.28%) Workflow
17 7 (16.28%) SQL Server 2014

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 (9.30%) Oracle Workflow
1 4 (9.30%) Tomcat
2 3 (6.98%) BizTalk Server
3 1 (2.33%) Apache Solr
3 1 (2.33%) CMS
3 1 (2.33%) Sitecore CMS
Applications
1 11 (25.58%) MS Excel
2 10 (23.26%) MS Office
3 4 (9.30%) MS PowerPoint
3 4 (9.30%) MS Project
3 4 (9.30%) MS Visio
Business Applications
1 4 (9.30%) Demantra
1 4 (9.30%) Oracle 11i
1 4 (9.30%) Oracle Applications
1 4 (9.30%) SnowdropKCS
2 1 (2.33%) Cognos TM1
Communications & Networking
1 3 (6.98%) TCP/IP
2 1 (2.33%) HTTP
Database & Business Intelligence
1 38 (88.37%) SQL Server
2 28 (65.12%) SQL Server Integration Services
3 27 (62.79%) SQL Server Reporting Services
4 20 (46.51%) SQL Server 2012
5 15 (34.88%) SQL Server 2005
6 12 (27.91%) Oracle Database
6 12 (27.91%) SQL Server Analysis Services
7 10 (23.26%) SQL Server 2008
8 8 (18.60%) Data Warehouse
8 8 (18.60%) Oracle Reports
9 7 (16.28%) Oracle Database 10g
9 7 (16.28%) Oracle9i Database
9 7 (16.28%) SQL Server 2014
10 5 (11.63%) Relational Database
11 4 (9.30%) Crystal Reports
11 4 (9.30%) Data Mining
11 4 (9.30%) Oracle BI Publisher
11 4 (9.30%) Oracle Database 11g
11 4 (9.30%) Oracle Database 12c
11 4 (9.30%) Star Schema
Development Applications
1 6 (13.95%) Visual Studio
2 4 (9.30%) JDeveloper
2 4 (9.30%) Oracle Forms
3 2 (4.65%) Team Foundation Server
4 1 (2.33%) CruiseControl
4 1 (2.33%) Jenkins
4 1 (2.33%) JIRA
4 1 (2.33%) Mercurial
General
1 9 (20.93%) Finance
2 5 (11.63%) Manufacturing
2 5 (11.63%) Retail
3 4 (9.30%) Back Office
3 4 (9.30%) Banking
3 4 (9.30%) Publishing
4 2 (4.65%) Law
5 1 (2.33%) Legal
5 1 (2.33%) Marketing
5 1 (2.33%) Pharmaceutical
5 1 (2.33%) Telecoms
Job Titles
1 21 (48.84%) Developer
2 14 (32.56%) SQL Developer
3 11 (25.58%) SQL Server Developer
4 9 (20.93%) T-SQL Developer
5 8 (18.60%) .NET Developer
5 8 (18.60%) DBA
5 8 (18.60%) SQL DBA
6 7 (16.28%) C# .NET Developer
6 7 (16.28%) C# Developer
7 6 (13.95%) Consultant
8 5 (11.63%) SQL Server DBA
9 4 (9.30%) Analyst
9 4 (9.30%) Applications Support
9 4 (9.30%) Applications Support Analyst
9 4 (9.30%) Business Intelligence Developer
9 4 (9.30%) Development Analyst
9 4 (9.30%) Development Support Analyst
9 4 (9.30%) Oracle DBA
9 4 (9.30%) Support Analyst
10 3 (6.98%) ETL Consultant
Libraries, Frameworks & Software Standards
1 18 (41.86%) .NET
2 9 (20.93%) AngularJS
3 7 (16.28%) Silverlight
3 7 (16.28%) XML
4 3 (6.98%) HTML
5 2 (4.65%) CSS
5 2 (4.65%) Middleware
5 2 (4.65%) React
5 2 (4.65%) Software Packaging
6 1 (2.33%) .NET Framework
6 1 (2.33%) ADO
6 1 (2.33%) ADO.NET
6 1 (2.33%) Ajax
6 1 (2.33%) jQuery
6 1 (2.33%) JSON
6 1 (2.33%) LINQ
6 1 (2.33%) Oracle GoldenGate
6 1 (2.33%) REST
6 1 (2.33%) WCF
6 1 (2.33%) Web Services
Miscellaneous
1 4 (9.30%) Analytical Skills
1 4 (9.30%) Data Centre
2 3 (6.98%) Clustering
2 3 (6.98%) Mobile App
3 2 (4.65%) Computer Science
3 2 (4.65%) Replication
3 2 (4.65%) User Experience
4 1 (2.33%) AS400
4 1 (2.33%) Data Protection Act
4 1 (2.33%) Driving Licence
4 1 (2.33%) Enterprise Software
4 1 (2.33%) Life Science
4 1 (2.33%) Mainframe
4 1 (2.33%) Management Information System
4 1 (2.33%) Reinsurance
4 1 (2.33%) Tandem
Operating Systems
1 9 (20.93%) Windows
2 6 (13.95%) Linux
3 5 (11.63%) Unix
3 5 (11.63%) Windows Server 2003
3 5 (11.63%) Windows Server 2008
4 4 (9.30%) HPUX
4 4 (9.30%) Windows 7
4 4 (9.30%) Windows Server 2012
5 2 (4.65%) Windows Server
Processes & Methodologies
1 14 (32.56%) Business Intelligence
2 9 (20.93%) ETL
3 7 (16.28%) Workflow
4 5 (11.63%) High Availability
5 4 (9.30%) Business Analysis
5 4 (9.30%) Disaster Recovery
5 4 (9.30%) Document Management
5 4 (9.30%) ITIL
5 4 (9.30%) Migration
5 4 (9.30%) Performance Monitoring
6 3 (6.98%) Data Analysis
6 3 (6.98%) Data Modelling
6 3 (6.98%) Database Security
7 2 (4.65%) Analytics
7 2 (4.65%) Change Control
7 2 (4.65%) Data Analytics
7 2 (4.65%) Data Entry
7 2 (4.65%) Data Integration
7 2 (4.65%) QMS
7 2 (4.65%) User Acceptance Testing
Programming Languages
1 31 (72.09%) SQL
2 25 (58.14%) T-SQL
3 13 (30.23%) JavaScript
4 8 (18.60%) C#
5 7 (16.28%) VB.NET
6 5 (11.63%) Java
6 5 (11.63%) PL/SQL
7 3 (6.98%) PowerShell
8 1 (2.33%) VB
Qualifications
1 4 (9.30%) MCDBA
1 4 (9.30%) MCSE
1 4 (9.30%) Microsoft Certification
2 3 (6.98%) OCP
2 3 (6.98%) Oracle Certification
3 2 (4.65%) Degree
4 1 (2.33%) CCNA
4 1 (2.33%) CCNP
4 1 (2.33%) Cisco Certification
4 1 (2.33%) MCP
4 1 (2.33%) Security Cleared
4 1 (2.33%) Six Sigma Black Belt
4 1 (2.33%) Six Sigma Green Belt
Quality Assurance & Compliance
1 2 (4.65%) ISO 9001
1 2 (4.65%) QA
2 1 (2.33%) SLA
System Software
1 1 (2.33%) Oracle RAC
Systems Management
1 3 (6.98%) Data Guard
1 3 (6.98%) Oracle RMAN
2 1 (2.33%) Enterprise Manager Cloud Control
Vendors
1 22 (51.16%) Microsoft
2 14 (32.56%) Oracle
3 7 (16.28%) Xamarin
4 3 (6.98%) Tableau
5 2 (4.65%) SAP
6 1 (2.33%) Brio
6 1 (2.33%) Cognos
6 1 (2.33%) iManage
6 1 (2.33%) Pega
6 1 (2.33%) Salesforce.com
6 1 (2.33%) Sitecore
6 1 (2.33%) Sybase