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 19 January 2017 with a comparison to the same period over the previous 2 years.

3 months to
19 Jan 2017
Same period 2016 Same period 2015
Microsoft Data Transformation Services (DTS)
UK
Rank 739 860 782
Rank change year-on-year
+121 -78
Permanent jobs citing DTS 106 87 161
As % of all permanent IT jobs located in the UK 0.13% 0.087% 0.15%
As % of the Database & Business Intelligence category 0.42% 0.27% 0.49%
Number of salaries quoted 84 62 148
Median salary £43,000 £40,000 £42,000
Median salary % change year-on-year
+7.50% -4.76%
90% offered a salary of more than £32,500 £34,100 £33,500
10% offered a salary of more than £69,000 £68,550 £54,000
UK excluding London median salary £42,500 £38,000 £40,000
% change year-on-year
+11.84% -5.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
25356 32222 32565
As % of all permanent IT jobs located in the UK 30.20% 32.17% 31.03%
Number of salaries quoted 21804 27238 27955
Median salary £50,000 £48,500 £45,000
Median salary % change year-on-year
+3.09% +7.77%
90% offered a salary of more than £32,500 £32,500 £30,565
10% offered a salary of more than £75,000 £70,000 £72,500
UK excluding London median salary £43,000 £42,500 £40,000
% change year-on-year
+1.17% +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 19 January 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 19 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
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
England +84 100 £43,000 +7.50% 9
London +57 32 £67,500 +42.10% 1
East of England - 28 £43,000 - 3
East Midlands - 15 £40,000 -
South East +59 14 £40,000 - 3
Suffolk - 13 £43,000 - 1
Hertfordshire - 13 £32,500 - 2
Northamptonshire - 11 £41,250 -
Northampton - 10 £42,500 -
City of London +38 8 £51,250 -22.34%
Berkshire +44 7 £37,000 -26.00%
Scotland +26 6 £36,400 -7.84%
Reading +45 5 £37,000 -50.66%
West Midlands +5 5 £44,000 +4.14%
Glasgow - 5 - -
Bury St Edmunds - 5 £43,000 - 1
Burton-upon-Trent - 4 £44,000 -
Staffordshire - 4 £44,000 -
South West +17 3 £42,500 - 1
North West -33 3 £40,000 -9.60% 1
Wiltshire - 3 £42,500 - 1
Merseyside - 3 £40,000 - 1
Liverpool - 3 £40,000 - 1
Kent - 3 £37,500 - 2
Leicestershire - 3 £40,000 -
Leicester - 3 £40,000 -
Swindon - 3 £42,500 - 1
Wokingham +7 2 £55,000 +10.00%
Folkestone - 2 £35,000 - 1
Borehamwood - 2 £45,000 -

DTS
Top 30 Related IT Skills

For the 6 months to 19 January 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 212 (91.77%) SQL Server
2 193 (83.55%) SQL
3 176 (76.19%) SQL Server Integration Services
4 139 (60.17%) T-SQL
5 105 (45.45%) .NET
6 103 (44.59%) SQL Server 2008
7 96 (41.56%) Microsoft
8 91 (39.39%) SQL Server Reporting Services
9 85 (36.80%) C#
10 77 (33.33%) Business Intelligence
11 74 (32.03%) Finance
12 61 (26.41%) SQL Server 2005
13 57 (24.68%) SQL Server 2014
14 56 (24.24%) SQL Server Analysis Services
15 50 (21.65%) SQL Server 2012
16 49 (21.21%) SQL Server 2000
17 47 (20.35%) Windows
18 46 (19.91%) Oracle
19 41 (17.75%) ETL
20 40 (17.32%) Replication
21 37 (16.02%) VB
22 36 (15.58%) HTML
22 36 (15.58%) ASP.NET
22 36 (15.58%) CSS
22 36 (15.58%) MVC
23 33 (14.29%) IIS
23 33 (14.29%) Data Warehouse
23 33 (14.29%) SQL Server 2016
24 31 (13.42%) SDLC
25 30 (12.99%) SharePoint

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 33 (14.29%) IIS
2 30 (12.99%) SharePoint
3 20 (8.66%) BizTalk Server
4 6 (2.60%) JBoss
5 4 (1.73%) Apache Spark
5 4 (1.73%) Confluence
5 4 (1.73%) Elasticsearch
5 4 (1.73%) WebSphere
5 4 (1.73%) WebSphere Application Server
6 3 (1.30%) FormScape
7 2 (0.87%) CMS
7 2 (0.87%) Jetty
7 2 (0.87%) Tomcat
8 1 (0.43%) MS Exchange
8 1 (0.43%) Oracle Workflow
8 1 (0.43%) SAS
8 1 (0.43%) WordPress
Applications
1 23 (9.96%) MS Excel
2 14 (6.06%) MS Office
3 4 (1.73%) Photoshop
Business Applications
1 5 (2.16%) Cognos TM1
2 4 (1.73%) Sage X3
3 3 (1.30%) Dynamics NAV
4 1 (0.43%) SAP ERP
Cloud Services
1 4 (1.73%) SaaS
Communications & Networking
1 13 (5.63%) Intranet
2 5 (2.16%) Network Security
3 3 (1.30%) SAN
4 2 (0.87%) FTP
5 1 (0.43%) TCP/IP
Database & Business Intelligence
1 212 (91.77%) SQL Server
2 176 (76.19%) SQL Server Integration Services
3 103 (44.59%) SQL Server 2008
4 91 (39.39%) SQL Server Reporting Services
5 61 (26.41%) SQL Server 2005
6 57 (24.68%) SQL Server 2014
7 56 (24.24%) SQL Server Analysis Services
8 50 (21.65%) SQL Server 2012
9 49 (21.21%) SQL Server 2000
10 33 (14.29%) Data Warehouse
10 33 (14.29%) SQL Server 2016
11 23 (9.96%) Relational Database
12 22 (9.52%) OLAP
13 21 (9.09%) Microsoft Analysis Services
14 18 (7.79%) Oracle OLAP
15 17 (7.36%) RDBMS
16 11 (4.76%) DB2
17 9 (3.90%) Oracle Reports
17 9 (3.90%) Power BI
18 8 (3.46%) ProClarity
Development Applications
1 24 (10.39%) SQL Server Management Studio (SSMS)
2 19 (8.23%) Visual Studio
3 13 (5.63%) Visual Studio Team System
4 8 (3.46%) Jenkins
5 6 (2.60%) Octopus Deploy
5 6 (2.60%) Team Foundation Server
5 6 (2.60%) TeamCity
6 4 (1.73%) Git (software)
7 3 (1.30%) ERwin
8 2 (0.87%) JUnit
8 2 (0.87%) Mockito
8 2 (0.87%) Toad
9 1 (0.43%) Bitbucket
9 1 (0.43%) JIRA
9 1 (0.43%) Oracle Forms
General
1 74 (32.03%) Finance
2 24 (10.39%) Legal
3 21 (9.09%) Back Office
4 14 (6.06%) Retail
5 10 (4.33%) Marketing
6 8 (3.46%) Banking
7 6 (2.60%) Music Industry
8 4 (1.73%) Billing
9 2 (0.87%) Front Office
9 2 (0.87%) Law
10 1 (0.43%) Advertising
10 1 (0.43%) Manufacturing
10 1 (0.43%) Publishing
Job Titles
1 99 (42.86%) Developer
2 61 (26.41%) DBA
3 60 (25.97%) SQL DBA
4 46 (19.91%) Analyst
5 41 (17.75%) SQL Server DBA
6 37 (16.02%) .NET Developer
7 34 (14.72%) C# Developer
8 31 (13.42%) SQL Analyst
9 29 (12.55%) C# .NET Developer
10 27 (11.69%) SQL Developer
11 26 (11.26%) Senior Developer
12 18 (7.79%) SSIS Analyst
13 16 (6.93%) SSIS Developer
13 16 (6.93%) Support Analyst
14 15 (6.49%) Software Developer
14 15 (6.49%) T-SQL Developer
15 13 (5.63%) Integration Analyst
15 13 (5.63%) Senior Systems Developer
15 13 (5.63%) SQL Support Analyst
15 13 (5.63%) Systems Developer
Libraries, Frameworks & Software Standards
1 105 (45.45%) .NET
2 36 (15.58%) ASP.NET
2 36 (15.58%) CSS
2 36 (15.58%) HTML
3 29 (12.55%) XML
4 22 (9.52%) WCF
5 18 (7.79%) Ajax
6 17 (7.36%) jQuery
7 13 (5.63%) ASP.NET MVC
8 12 (5.19%) REST
8 12 (5.19%) Web Services
9 11 (4.76%) Classic ASP
10 10 (4.33%) ASP.NET MVC 3
10 10 (4.33%) DHTML
10 10 (4.33%) WPF
11 7 (3.03%) AngularJS
11 7 (3.03%) EDI
12 5 (2.16%) React
13 4 (1.73%) Kafka
13 4 (1.73%) Spark Streaming
Miscellaneous
1 40 (17.32%) Replication
2 29 (12.55%) Clustering
3 23 (9.96%) Analytical Skills
4 20 (8.66%) Enterprise Software
5 14 (6.06%) Data Centre
5 14 (6.06%) Management Information System
5 14 (6.06%) Reinsurance
6 13 (5.63%) Statistics
7 10 (4.33%) PMI
8 9 (3.90%) Mathematics
9 8 (3.46%) Mobile App
10 7 (3.03%) AS400
11 5 (2.16%) Computer Science
11 5 (2.16%) NHS
11 5 (2.16%) Visualisation
12 4 (1.73%) Data Integration
12 4 (1.73%) iSeries
12 4 (1.73%) Physics
13 3 (1.30%) User Experience
14 1 (0.43%) Data Extraction
Operating Systems
1 47 (20.35%) Windows
2 16 (6.93%) Windows Server
3 7 (3.03%) Linux
4 6 (2.60%) Unix
4 6 (2.60%) Windows Server 2003
5 5 (2.16%) AIX
6 4 (1.73%) Windows Server 2008
6 4 (1.73%) Windows Server 2012
7 2 (0.87%) Windows 2000
8 1 (0.43%) Windows Vista
8 1 (0.43%) Windows XP
Processes & Methodologies
1 77 (33.33%) Business Intelligence
2 41 (17.75%) ETL
3 36 (15.58%) MVC
4 31 (13.42%) SDLC
5 30 (12.99%) Agile Software Development
6 29 (12.55%) Performance Tuning
7 27 (11.69%) Project Management
8 23 (9.96%) Time Management
9 20 (8.66%) Data Transformation
9 20 (8.66%) Database Mirroring
10 18 (7.79%) Case Management
10 18 (7.79%) PRINCE2
11 17 (7.36%) Unit Testing
12 16 (6.93%) High Availability
12 16 (6.93%) Workflow
13 14 (6.06%) TDD
14 13 (5.63%) Change Management
14 13 (5.63%) ITIL
14 13 (5.63%) Server Building
15 11 (4.76%) Data Modelling
Programming Languages
1 193 (83.55%) SQL
2 139 (60.17%) T-SQL
3 85 (36.80%) C#
4 37 (16.02%) VB
5 27 (11.69%) JavaScript
6 24 (10.39%) Java
7 18 (7.79%) VB.NET
8 15 (6.49%) PL/SQL
9 11 (4.76%) PHP
9 11 (4.76%) PowerShell
9 11 (4.76%) VB6
10 6 (2.60%) VBA
11 5 (2.16%) R
12 4 (1.73%) Python
12 4 (1.73%) VBScript
13 1 (0.43%) C
13 1 (0.43%) FoxPro (VFP)
13 1 (0.43%) PHP 5
Qualifications
1 24 (10.39%) Degree
2 14 (6.06%) Microsoft Certification
3 10 (4.33%) PMI Certification
4 4 (1.73%) DV Cleared
4 4 (1.73%) PhD
4 4 (1.73%) Security Cleared
5 1 (0.43%) ISEB
5 1 (0.43%) MCDBA
5 1 (0.43%) MCITP
5 1 (0.43%) MCSA
5 1 (0.43%) MCSE
Quality Assurance & Compliance
1 15 (6.49%) SLA
2 5 (2.16%) Data Quality
3 4 (1.73%) QA
System Software
1 8 (3.46%) Active Directory
2 2 (0.87%) Oracle RAC
3 1 (0.43%) VMware Infrastructure
Systems Management
1 14 (6.06%) Perfmon
2 8 (3.46%) SCOM
3 6 (2.60%) Puppet
4 5 (2.16%) Failover Clustering
5 2 (0.87%) Microsoft Clustering
6 1 (0.43%) Control-M
6 1 (0.43%) Enterprise Manager Cloud Control
6 1 (0.43%) LiteSpeed
Vendors
1 96 (41.56%) Microsoft
2 46 (19.91%) Oracle
3 22 (9.52%) VMware
4 11 (4.76%) SAP
5 9 (3.90%) Cognos
6 8 (3.46%) MicroStrategy
7 7 (3.03%) Tableau
8 6 (2.60%) webMethods
9 4 (1.73%) Adobe
9 4 (1.73%) IBM
9 4 (1.73%) OpenText
9 4 (1.73%) Sage
10 3 (1.30%) JD Edwards
11 2 (0.87%) Pega
11 2 (0.87%) Salesforce.com
12 1 (0.43%) Citrix
12 1 (0.43%) Netezza
12 1 (0.43%) Remedy
12 1 (0.43%) Sybase
Bury St. Edmunds, Suffolk
Proactive Appointments
Salary: £40000 - £46000 per annum + great benefits
Posted: 3 hours ago
London
Nigel Frank International
Salary: £50000 - £60000 per annum + benefits
Posted: Yesterday
Liverpool, Merseyside
Oho Group Ltd.
Salary: £40000 - £45000 per annum
Posted: 2 days ago
Royston, Hertfordshire
Hotel Chocolat
Salary: £competitive + Bonus + Bens
Posted: Yesterday
Swindon, Wiltshire
Sanderson
Salary: £45000.00 per annum
Posted: 2 days ago
Kent
Logic Engagements Ltd
Salary: £25000 - £30000 per annum + Benefits
Posted: 5 days ago
Lewes
Hays Specialist Recruitment
Salary: £35000 - £45000 per annum + benefits
Posted: 8 days ago
Folkestone
Deerfoot IT Resources Ltd
Salary: £28000 - £42000 per annum
Posted: 9 days ago
Hertfordshire
Venturi
Salary: £30000 - £35000 per annum + Plus Benefits
Posted: 16 days ago