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

3 months to
21 Feb 2017
Same period 2016 Same period 2015
Microsoft Data Transformation Services (DTS)
England / London
Rank 557 639 582
Rank change year-on-year
+82 -57
Permanent jobs citing DTS 26 10 72
As % of all permanent IT jobs located in London 0.078% 0.025% 0.17%
As % of the Database & Business Intelligence category 0.26% 0.078% 0.57%
Number of salaries quoted 16 10 70
Median salary £65,000 £47,500 £45,000
Median salary % change year-on-year
+36.84% +5.55%
90% offered a salary of more than £37,500 £35,000 £37,400
10% offered a salary of more than £81,000 £60,000 £63,000
UK excluding London median salary £42,500 £45,500 £40,000
% change year-on-year
-6.59% +13.75%

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

Database & Business Intelligence Category
London
Permanent IT job ads with a match in the
Database & Business Intelligence category
10054 12765 12549
As % of all permanent IT jobs located in London 30.09% 31.40% 30.43%
Number of salaries quoted 8783 11066 10801
Median salary £60,000 £55,000 £55,000
Median salary % change year-on-year
+9.09% -
90% offered a salary of more than £39,000 £40,000 £37,500
10% offered a salary of more than £85,000 £75,000 £80,000
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year
- +6.25%

DTS
Jobs Demand Trend in London

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

DTS Jobs Demand Trend in London

DTS
Salary Trend in London

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing DTS across the London region.

DTS Salary Trend in London

DTS
Salary Histogram in London

This chart provides a salary histogram for IT jobs citing DTS across the London region over the 3 months to 21 February 2017.

DTS Salary Histogram in London

DTS
Job Locations in London

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing DTS within the London region over the 3 months to 21 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
City of London +38 9 £65,000 +8.33%
Chessington - 2 £37,500 -
DTS
England

DTS
Top 30 Related IT Skills in London

For the 6 months to 21 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 across the London region with a requirement for DTS.

1 59 (77.63%) SQL Server
2 48 (63.16%) SQL
3 41 (53.95%) SQL Server Integration Services
4 35 (46.05%) SQL Server 2008
5 30 (39.47%) T-SQL
6 27 (35.53%) Windows
7 26 (34.21%) SQL Server Reporting Services
8 23 (30.26%) Microsoft
9 21 (27.63%) SQL Server 2000
9 21 (27.63%) .NET
9 21 (27.63%) Replication
10 20 (26.32%) VMware
10 20 (26.32%) Performance Tuning
11 18 (23.68%) SQL Server Analysis Services
11 18 (23.68%) HTML
11 18 (23.68%) CSS
12 17 (22.37%) Java
12 17 (22.37%) Finance
12 17 (22.37%) Project Management
12 17 (22.37%) SQL Server 2014
13 16 (21.05%) SQL Server 2012
14 15 (19.74%) SQL Server 2005
14 15 (19.74%) Degree
14 15 (19.74%) JavaScript
14 15 (19.74%) IIS
15 14 (18.42%) Jenkins
15 14 (18.42%) Windows Server
16 13 (17.11%) SQL Server Management Studio (SSMS)
16 13 (17.11%) VB
16 13 (17.11%) MS Excel

DTS
Top Related IT Skills in London 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 15 (19.74%) IIS
2 9 (11.84%) Anypoint
2 9 (11.84%) BizTalk Server
2 9 (11.84%) JBoss
3 5 (6.58%) Jetty
3 5 (6.58%) SharePoint
3 5 (6.58%) Tomcat
4 4 (5.26%) Apache Spark
4 4 (5.26%) Confluence
4 4 (5.26%) Elasticsearch
5 2 (2.63%) CMS
6 1 (1.32%) MS Exchange
6 1 (1.32%) Oracle Workflow
6 1 (1.32%) WebSphere
6 1 (1.32%) WebSphere Application Server
Applications
1 13 (17.11%) MS Excel
2 5 (6.58%) MS Office
3 1 (1.32%) Photoshop
Business Applications
1 5 (6.58%) Sage X3
2 4 (5.26%) Cognos TM1
Communications & Networking
1 1 (1.32%) TCP/IP
Database & Business Intelligence
1 59 (77.63%) SQL Server
2 41 (53.95%) SQL Server Integration Services
3 35 (46.05%) SQL Server 2008
4 26 (34.21%) SQL Server Reporting Services
5 21 (27.63%) SQL Server 2000
6 18 (23.68%) SQL Server Analysis Services
7 17 (22.37%) SQL Server 2014
8 16 (21.05%) SQL Server 2012
9 15 (19.74%) SQL Server 2005
10 13 (17.11%) Data Warehouse
11 10 (13.16%) SQL Server 2016
12 9 (11.84%) EDRMS
13 8 (10.53%) Microsoft Analysis Services
14 6 (7.89%) Crystal Reports
14 6 (7.89%) RDBMS
14 6 (7.89%) Relational Database
15 5 (6.58%) Oracle Reports
16 4 (5.26%) Big Data
16 4 (5.26%) Power BI
16 4 (5.26%) QlikView
Development Applications
1 14 (18.42%) Jenkins
2 13 (17.11%) SQL Server Management Studio (SSMS)
3 9 (11.84%) Octopus Deploy
3 9 (11.84%) TeamCity
4 5 (6.58%) JUnit
4 5 (6.58%) Mockito
4 5 (6.58%) Team Foundation Server
4 5 (6.58%) Visual Studio
5 4 (5.26%) Git (software)
General
1 17 (22.37%) Finance
2 9 (11.84%) Retail
3 8 (10.53%) Banking
3 8 (10.53%) Marketing
4 7 (9.21%) Back Office
4 7 (9.21%) Legal
5 6 (7.89%) Music Industry
6 5 (6.58%) Front Office
7 2 (2.63%) Law
7 2 (2.63%) Publishing
Job Titles
1 24 (31.58%) DBA
1 24 (31.58%) SQL DBA
2 17 (22.37%) Developer
3 15 (19.74%) SQL Server DBA
4 12 (15.79%) Architect
4 12 (15.79%) Solutions Architect
5 10 (13.16%) Analyst
5 10 (13.16%) Support Analyst
6 9 (11.84%) TOGAF Architect
7 8 (10.53%) Applications Support
7 8 (10.53%) Applications Support Analyst
8 7 (9.21%) .NET Developer
8 7 (9.21%) C# .NET Developer
8 7 (9.21%) C# Developer
8 7 (9.21%) VB Developer
9 6 (7.89%) ASP.NET MVC Developer
9 6 (7.89%) SQL Analyst
9 6 (7.89%) SQL Support Analyst
9 6 (7.89%) Technical Leader
10 5 (6.58%) Front End Developer (Client-Side Developer)
Libraries, Frameworks & Software Standards
1 21 (27.63%) .NET
2 18 (23.68%) CSS
2 18 (23.68%) HTML
3 10 (13.16%) AngularJS
4 8 (10.53%) ASP.NET
4 8 (10.53%) XML
5 7 (9.21%) Ajax
5 7 (9.21%) ASP.NET MVC
5 7 (9.21%) ASP.NET MVC 3
5 7 (9.21%) Classic ASP
5 7 (9.21%) DHTML
5 7 (9.21%) jQuery
6 5 (6.58%) Hibernate
6 5 (6.58%) React
6 5 (6.58%) Servlets
6 5 (6.58%) Spring
7 4 (5.26%) EDI
7 4 (5.26%) Kafka
7 4 (5.26%) Spark Streaming
8 3 (3.95%) .NET Framework
Miscellaneous
1 21 (27.63%) Replication
2 12 (15.79%) Clustering
3 11 (14.47%) Management Information System
4 9 (11.84%) Enterprise Software
5 8 (10.53%) Analytical Skills
5 8 (10.53%) Mobile App
6 3 (3.95%) User Experience
7 1 (1.32%) iSeries
7 1 (1.32%) N-Tier
Operating Systems
1 27 (35.53%) Windows
2 14 (18.42%) Windows Server
3 6 (7.89%) Linux
4 5 (6.58%) Unix
5 4 (5.26%) Windows Server 2003
6 3 (3.95%) Windows Server 2008
6 3 (3.95%) Windows Server 2012
7 1 (1.32%) Windows 2000
Processes & Methodologies
1 20 (26.32%) Performance Tuning
2 17 (22.37%) Project Management
3 12 (15.79%) OOA/OOD
4 11 (14.47%) DevOps
4 11 (14.47%) Time Management
4 11 (14.47%) TOGAF
5 10 (13.16%) Business Intelligence
5 10 (13.16%) Configuration Management
6 9 (11.84%) Coaching
6 9 (11.84%) Database Mirroring
6 9 (11.84%) ETL
6 9 (11.84%) Mentoring
6 9 (11.84%) OO
6 9 (11.84%) PRINCE2
6 9 (11.84%) SSADM
7 8 (10.53%) Agile Software Development
7 8 (10.53%) MVC
7 8 (10.53%) Scrum
7 8 (10.53%) Server Building
8 7 (9.21%) SDLC
Programming Languages
1 48 (63.16%) SQL
2 30 (39.47%) T-SQL
3 17 (22.37%) Java
4 15 (19.74%) JavaScript
5 13 (17.11%) VB
6 9 (11.84%) C#
7 8 (10.53%) VB.NET
8 7 (9.21%) VB6
9 4 (5.26%) Python
10 3 (3.95%) PowerShell
11 1 (1.32%) VBA
Qualifications
1 15 (19.74%) Degree
2 4 (5.26%) PhD
Quality Assurance & Compliance
1 1 (1.32%) SLA
System Software
1 1 (1.32%) Active Directory
1 1 (1.32%) Oracle RAC
Systems Management
1 10 (13.16%) Perfmon
2 9 (11.84%) Puppet
3 4 (5.26%) SCOM
4 1 (1.32%) Enterprise Manager Cloud Control
4 1 (1.32%) Failover Clustering
Vendors
1 23 (30.26%) Microsoft
2 20 (26.32%) VMware
3 9 (11.84%) Cognos
3 9 (11.84%) Oracle
3 9 (11.84%) webMethods
4 6 (7.89%) Tableau
5 5 (6.58%) IBM
5 5 (6.58%) OpenText
5 5 (6.58%) Sage
6 2 (2.63%) Netezza
6 2 (2.63%) Pega
6 2 (2.63%) Salesforce.com
7 1 (1.32%) Adobe
7 1 (1.32%) Citrix
7 1 (1.32%) Sybase