The table below looks at the statistics for DTS skills in IT jobs advertised across the UK. Included is a guide to the salaries offered in IT jobs that have cited DTS over the 3 months to 24 February 2017 with a comparison to the same period over the previous 2 years.

3 months to
24 Feb 2017
Same period 2016 Same period 2015
Microsoft Data Transformation Services (DTS)
UK
Rank 759 876 806
Rank change year-on-year
+117 -70
Permanent jobs citing DTS 98 70 147
As % of all permanent IT jobs located in the UK 0.12% 0.068% 0.14%
As % of the Database & Business Intelligence category 0.38% 0.22% 0.44%
Number of salaries quoted 75 53 139
Median salary £42,500 £47,000 £42,875
Median salary % change year-on-year
-9.57% +9.62%
90% offered a salary of more than £35,000 £35,000 £33,500
10% offered a salary of more than £67,500 £72,000 £60,000
UK excluding London median salary £42,500 £46,000 £40,000
% change year-on-year
-7.60% +15.00%

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

Database & Business Intelligence Category
UK
Permanent IT job ads with a match in the
Database & Business Intelligence category
25628 32229 33346
As % of all permanent IT jobs located in the UK 30.42% 31.54% 31.22%
Number of salaries quoted 21806 27310 28549
Median salary £50,000 £47,500 £45,000
Median salary % change year-on-year
+5.26% +5.55%
90% offered a salary of more than £32,500 £32,500 £30,750
10% offered a salary of more than £72,500 £70,000 £71,000
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year
- +6.25%

DTS
Jobs Demand Trend

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

DTS Jobs Demand Trend in the UK

DTS
Salary Trend

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing DTS within the UK.

DTS Salary Trend in the UK

DTS
Salary Histogram

This chart provides a salary histogram for IT jobs citing DTS over the 3 months to 24 February 2017 within the UK.

DTS Salary Histogram in the UK

DTS
Top 30 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing DTS within the UK over the 3 months to 24 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
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
England +120 90 £42,500 -10.05% 4
London +95 26 £65,000 +36.84% 1
East of England - 19 £43,000 -
South East +39 15 £37,000 -26.00% 1
Suffolk - 13 £43,000 -
East Midlands +21 10 £40,000 +3.22%
City of London +42 9 £65,000 +8.33%
Scotland +31 8 £40,000 - 2
West Midlands +35 7 £43,250 +2.36%
Northamptonshire +29 7 £42,500 +21.42%
Glasgow +23 7 £40,500 +1.25% 2
Northampton +18 7 £42,500 +21.42%
Kent - 7 £35,000 - 1
Reading +40 5 £37,000 -50.66%
Berkshire +20 5 £37,000 -26.00%
South West +9 5 £42,500 -
North West -21 5 £40,000 -16.66% 1
Liverpool - 5 £40,000 -
Merseyside - 5 £40,000 -
Bury St Edmunds - 5 £43,000 -
Swindon - 4 £42,500 -
Burton-upon-Trent - 4 £44,000 -
Folkestone - 4 £35,000 - 1
Wiltshire - 4 £42,500 -
Staffordshire - 4 £44,000 -
Hertfordshire - 4 £32,500 -
Yorkshire +11 3 £35,000 -12.50% 1
North Yorkshire - 2 £35,000 - 1
Leicestershire - 2 £40,000 -
Leicester - 2 £40,000 -

DTS
Top 30 Related IT Skills

For the 6 months to 24 February 2017, IT jobs citing DTS also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads with a requirement for DTS.

1 188 (89.52%) SQL Server
2 168 (80.00%) SQL
3 161 (76.67%) SQL Server Integration Services
4 125 (59.52%) T-SQL
5 101 (48.10%) Microsoft
6 95 (45.24%) .NET
7 90 (42.86%) SQL Server Reporting Services
8 85 (40.48%) SQL Server 2008
9 71 (33.81%) C#
10 68 (32.38%) Business Intelligence
11 61 (29.05%) Finance
12 55 (26.19%) SQL Server Analysis Services
13 51 (24.29%) Oracle
14 50 (23.81%) SQL Server 2014
15 47 (22.38%) SQL Server 2012
16 45 (21.43%) SQL Server 2005
17 38 (18.10%) ETL
18 37 (17.62%) MVC
19 36 (17.14%) CSS
19 36 (17.14%) HTML
19 36 (17.14%) Windows
20 35 (16.67%) SQL Server 2000
21 34 (16.19%) Agile Software Development
22 32 (15.24%) Project Management
23 31 (14.76%) ASP.NET
23 31 (14.76%) IIS
24 30 (14.29%) MS Excel
24 30 (14.29%) SQL Server 2016
25 29 (13.81%) Replication
26 28 (13.33%) Time Management

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 31 (14.76%) IIS
2 23 (10.95%) BizTalk Server
3 19 (9.05%) SharePoint
4 9 (4.29%) Anypoint
4 9 (4.29%) JBoss
5 5 (2.38%) Jetty
5 5 (2.38%) Tomcat
6 4 (1.90%) Apache Spark
6 4 (1.90%) Confluence
6 4 (1.90%) Elasticsearch
7 3 (1.43%) FormScape
8 2 (0.95%) CMS
9 1 (0.48%) MS Exchange
9 1 (0.48%) Oracle Workflow
9 1 (0.48%) SAS
9 1 (0.48%) WebSphere
9 1 (0.48%) WebSphere Application Server
9 1 (0.48%) WordPress
Applications
1 30 (14.29%) MS Excel
2 10 (4.76%) MS Office
3 1 (0.48%) Photoshop
Business Applications
1 5 (2.38%) Sage X3
2 4 (1.90%) Cognos TM1
3 3 (1.43%) Dynamics NAV
4 1 (0.48%) SAP ERP
Cloud Services
1 4 (1.90%) SaaS
Communications & Networking
1 14 (6.67%) Intranet
2 6 (2.86%) Network Security
3 2 (0.95%) SAN
4 1 (0.48%) FTP
4 1 (0.48%) TCP/IP
Database & Business Intelligence
1 188 (89.52%) SQL Server
2 161 (76.67%) SQL Server Integration Services
3 90 (42.86%) SQL Server Reporting Services
4 85 (40.48%) SQL Server 2008
5 55 (26.19%) SQL Server Analysis Services
6 50 (23.81%) SQL Server 2014
7 47 (22.38%) SQL Server 2012
8 45 (21.43%) SQL Server 2005
9 35 (16.67%) SQL Server 2000
10 30 (14.29%) SQL Server 2016
11 26 (12.38%) Data Warehouse
12 24 (11.43%) OLAP
13 22 (10.48%) Relational Database
14 19 (9.05%) Oracle OLAP
15 16 (7.62%) Microsoft Analysis Services
15 16 (7.62%) RDBMS
16 10 (4.76%) DB2
16 10 (4.76%) Oracle Reports
17 9 (4.29%) EDRMS
17 9 (4.29%) Power BI
Development Applications
1 23 (10.95%) SQL Server Management Studio (SSMS)
2 21 (10.00%) Visual Studio
3 14 (6.67%) Jenkins
3 14 (6.67%) Visual Studio Team System
4 9 (4.29%) Octopus Deploy
4 9 (4.29%) TeamCity
5 5 (2.38%) ERwin
5 5 (2.38%) JUnit
5 5 (2.38%) Mockito
5 5 (2.38%) Team Foundation Server
6 4 (1.90%) Git (software)
7 1 (0.48%) Bitbucket
7 1 (0.48%) JIRA
7 1 (0.48%) Oracle Forms
7 1 (0.48%) Toad
General
1 61 (29.05%) Finance
2 20 (9.52%) Legal
3 17 (8.10%) Back Office
4 14 (6.67%) Retail
5 8 (3.81%) Banking
5 8 (3.81%) Marketing
6 5 (2.38%) Front Office
6 5 (2.38%) Music Industry
7 4 (1.90%) Billing
8 2 (0.95%) Law
8 2 (0.95%) Manufacturing
8 2 (0.95%) Publishing
9 1 (0.48%) Advertising
Job Titles
1 97 (46.19%) Developer
2 44 (20.95%) Analyst
3 42 (20.00%) DBA
3 42 (20.00%) SQL DBA
4 31 (14.76%) .NET Developer
5 29 (13.81%) Senior Developer
5 29 (13.81%) SQL Server DBA
6 28 (13.33%) SQL Developer
7 27 (12.86%) SQL Analyst
8 26 (12.38%) C# Developer
9 20 (9.52%) C# .NET Developer
10 17 (8.10%) SSIS Developer
11 16 (7.62%) T-SQL Developer
12 14 (6.67%) Architect
12 14 (6.67%) Senior Systems Developer
12 14 (6.67%) SSIS Analyst
12 14 (6.67%) Systems Developer
13 13 (6.19%) Integration Analyst
13 13 (6.19%) Support Analyst
14 12 (5.71%) Software Developer
Libraries, Frameworks & Software Standards
1 95 (45.24%) .NET
2 36 (17.14%) CSS
2 36 (17.14%) HTML
3 31 (14.76%) ASP.NET
4 24 (11.43%) XML
5 19 (9.05%) WCF
6 13 (6.19%) jQuery
7 12 (5.71%) REST
8 11 (5.24%) Ajax
8 11 (5.24%) AngularJS
8 11 (5.24%) ASP.NET MVC
9 9 (4.29%) Web Services
10 7 (3.33%) Classic ASP
10 7 (3.33%) EDI
10 7 (3.33%) WPF
11 6 (2.86%) ASP.NET MVC 3
11 6 (2.86%) DHTML
12 5 (2.38%) React
12 5 (2.38%) Servlets
12 5 (2.38%) Spring
Miscellaneous
1 29 (13.81%) Replication
2 24 (11.43%) Analytical Skills
3 21 (10.00%) Clustering
4 19 (9.05%) Enterprise Software
5 18 (8.57%) Management Information System
6 10 (4.76%) Data Centre
6 10 (4.76%) Reinsurance
7 9 (4.29%) AS400
8 8 (3.81%) Mobile App
9 7 (3.33%) PMI
10 5 (2.38%) Computer Science
10 5 (2.38%) NHS
11 3 (1.43%) User Experience
12 1 (0.48%) iSeries
12 1 (0.48%) Mainframe
12 1 (0.48%) N-Tier
Operating Systems
1 36 (17.14%) Windows
2 15 (7.14%) Windows Server
3 7 (3.33%) Linux
4 6 (2.86%) AIX
4 6 (2.86%) Unix
5 5 (2.38%) Windows Server 2003
6 4 (1.90%) Windows Server 2008
6 4 (1.90%) Windows Server 2012
7 1 (0.48%) Windows 2000
Processes & Methodologies
1 68 (32.38%) Business Intelligence
2 38 (18.10%) ETL
3 37 (17.62%) MVC
4 34 (16.19%) Agile Software Development
5 32 (15.24%) Project Management
6 28 (13.33%) Time Management
7 25 (11.90%) Performance Tuning
8 24 (11.43%) SDLC
9 20 (9.52%) Unit Testing
10 18 (8.57%) PRINCE2
10 18 (8.57%) TDD
11 17 (8.10%) Data Transformation
12 16 (7.62%) Workflow
13 15 (7.14%) Case Management
13 15 (7.14%) Statistics
14 14 (6.67%) ITIL
14 14 (6.67%) Software Engineering
15 12 (5.71%) High Availability
15 12 (5.71%) OOA/OOD
16 11 (5.24%) Front End Development
Programming Languages
1 168 (80.00%) SQL
2 125 (59.52%) T-SQL
3 71 (33.81%) C#
4 24 (11.43%) Java
4 24 (11.43%) JavaScript
5 23 (10.95%) VB
6 18 (8.57%) PL/SQL
7 14 (6.67%) VB.NET
8 8 (3.81%) PHP
9 7 (3.33%) PowerShell
9 7 (3.33%) R
9 7 (3.33%) VB6
10 6 (2.86%) VBA
11 4 (1.90%) Python
12 3 (1.43%) VBScript
13 1 (0.48%) C
13 1 (0.48%) FoxPro (VFP)
13 1 (0.48%) PHP 5
Qualifications
1 25 (11.90%) Degree
2 14 (6.67%) Microsoft Certification
3 7 (3.33%) PMI Certification
4 4 (1.90%) DV Cleared
4 4 (1.90%) PhD
4 4 (1.90%) Security Cleared
5 1 (0.48%) ISEB
5 1 (0.48%) MCDBA
5 1 (0.48%) MCITP
5 1 (0.48%) MCSA
5 1 (0.48%) MCSE
Quality Assurance & Compliance
1 6 (2.86%) SLA
2 5 (2.38%) Data Quality
3 3 (1.43%) QA
System Software
1 8 (3.81%) Active Directory
2 1 (0.48%) Oracle RAC
Systems Management
1 9 (4.29%) Perfmon
1 9 (4.29%) Puppet
2 4 (1.90%) SCOM
3 3 (1.43%) Microsoft Clustering
4 1 (0.48%) Control-M
4 1 (0.48%) Enterprise Manager Cloud Control
4 1 (0.48%) Failover Clustering
4 1 (0.48%) LiteSpeed
4 1 (0.48%) SQL Sentry
Vendors
1 101 (48.10%) Microsoft
2 51 (24.29%) Oracle
3 19 (9.05%) VMware
4 11 (5.24%) SAP
5 9 (4.29%) Cognos
5 9 (4.29%) webMethods
6 8 (3.81%) Tableau
7 5 (2.38%) IBM
7 5 (2.38%) OpenText
7 5 (2.38%) Sage
8 3 (1.43%) JD Edwards
9 2 (0.95%) Netezza
9 2 (0.95%) Pega
9 2 (0.95%) Progress
9 2 (0.95%) Salesforce.com
10 1 (0.48%) Adobe
10 1 (0.48%) Citrix
10 1 (0.48%) Remedy
10 1 (0.48%) Sybase
Glasgow, Lanarkshire
Proactive Appointments
Salary: Competitive + Benefits
Posted: Yesterday
Glasgow, Lanarkshire
Proactive Appointments
Salary: Competitive Salary + Bonus + Brilliant Benefits
Posted: 2 days ago
Manchester, Lancashire
Proactive Appointments
Salary: Competitive Salary + Bonus + Brilliant Benefits
Posted: 2 days ago
York, North Yorkshire
Fruition IT Resources Limited
Salary: £30000 - £40000 per annum + bonus + on site gym + free parking
Posted: 4 days ago
Folkestone
Deerfoot IT Resources Ltd
Salary: £28000 - £42000 per annum
Posted: 7 days ago