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 5 December 2016 with a comparison to the same period over the previous 2 years.

3 months to
5 Dec 2016
Same period 2015 Same period 2014
Microsoft Data Transformation Services (DTS)
Rank 543 632 598
Rank change year-on-year
+89 -34
Permanent jobs citing DTS 47 33 68
As % of all permanent IT jobs located in London 0.13% 0.076% 0.15%
As % of the Database & Business Intelligence category 0.45% 0.24% 0.50%
Number of salaries quoted 43 18 66
Median salary £55,000 £47,500 £43,750
Median salary % change year-on-year
+15.78% +8.57%
90% offered a salary of more than £42,500 £33,500 £35,000
10% offered a salary of more than £72,000 £70,250 £60,000
UK excluding London median salary £43,000 £37,000 £38,250
% change year-on-year
+16.21% -3.26%
DTS
England

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
10514 13557 13560
As % of all permanent IT jobs located in London 29.49% 31.35% 29.86%
Number of salaries quoted 9160 11568 11711
Median salary £60,000 £56,000 £55,000
Median salary % change year-on-year
+7.14% +1.81%
90% offered a salary of more than £40,000 £40,000 £37,500
10% offered a salary of more than £85,000 £75,000 £80,000
UK excluding London median salary £45,000 £42,500 £40,000
% change year-on-year
+5.88% +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 5 December 2016.

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 5 December 2016. 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
(Click see detailed
statistics and trends)
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 +34 11 £72,000 -
Chessington - 2 £37,500 -
DTS
England

DTS
Top 30 Related IT Skills in London

For the 6 months to 5 December 2016, 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 78 (89.66%) SQL Server
2 73 (83.91%) SQL
3 59 (67.82%) SQL Server Integration Services
4 47 (54.02%) T-SQL
5 45 (51.72%) SQL Server 2008
6 40 (45.98%) SQL Server Reporting Services
7 31 (35.63%) Replication
7 31 (35.63%) SQL Server 2000
8 28 (32.18%) Windows
9 25 (28.74%) ETL
10 23 (26.44%) .NET
11 22 (25.29%) SQL Server Analysis Services
11 22 (25.29%) SQL Server 2012
11 22 (25.29%) SQL Server 2014
12 21 (24.14%) SQL Server 2005
12 21 (24.14%) Microsoft
12 21 (24.14%) VMware
13 20 (22.99%) Clustering
13 20 (22.99%) Performance Tuning
13 20 (22.99%) Database Mirroring
14 19 (21.84%) Data Warehouse
15 18 (20.69%) Finance
16 16 (18.39%) Business Intelligence
16 16 (18.39%) HTML
16 16 (18.39%) CSS
16 16 (18.39%) SQL Server Management Studio (SSMS)
17 14 (16.09%) Server Building
17 14 (16.09%) Perfmon
17 14 (16.09%) Windows Server
17 14 (16.09%) C#

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 13 (14.94%) IIS
2 8 (9.20%) SharePoint
3 6 (6.90%) BizTalk Server
3 6 (6.90%) JBoss
4 4 (4.60%) WebSphere
4 4 (4.60%) WebSphere Application Server
5 2 (2.30%) CMS
6 1 (1.15%) MS Exchange
Applications
1 14 (16.09%) MS Excel
2 4 (4.60%) MS Office
2 4 (4.60%) Photoshop
Business Applications
1 3 (3.45%) Cognos TM1
2 2 (2.30%) Sage X3
Communications & Networking
1 1 (1.15%) TCP/IP
Database & Business Intelligence
1 78 (89.66%) SQL Server
2 59 (67.82%) SQL Server Integration Services
3 45 (51.72%) SQL Server 2008
4 40 (45.98%) SQL Server Reporting Services
5 31 (35.63%) SQL Server 2000
6 22 (25.29%) SQL Server 2012
6 22 (25.29%) SQL Server 2014
6 22 (25.29%) SQL Server Analysis Services
7 21 (24.14%) SQL Server 2005
8 19 (21.84%) Data Warehouse
9 11 (12.64%) QlikView
10 10 (11.49%) Microsoft Analysis Services
11 8 (9.20%) Power BI
11 8 (9.20%) SQL Server 2016
12 6 (6.90%) EDRMS
12 6 (6.90%) RDBMS
12 6 (6.90%) Relational Database
13 4 (4.60%) DB2
14 3 (3.45%) Crystal Reports
15 2 (2.30%) Oracle Reports
Development Applications
1 16 (18.39%) SQL Server Management Studio (SSMS)
2 6 (6.90%) Jenkins
2 6 (6.90%) Octopus Deploy
2 6 (6.90%) TeamCity
3 5 (5.75%) Visual Studio
4 4 (4.60%) Team Foundation Server
General
1 18 (20.69%) Finance
2 9 (10.34%) Legal
3 8 (9.20%) Banking
3 8 (9.20%) Marketing
4 7 (8.05%) Back Office
5 6 (6.90%) Music Industry
6 5 (5.75%) Retail
7 1 (1.15%) Investment Banking
7 1 (1.15%) Law
Job Titles
1 37 (42.53%) DBA
1 37 (42.53%) SQL DBA
2 28 (32.18%) Developer
3 24 (27.59%) SQL Server DBA
4 13 (14.94%) Architect
5 12 (13.79%) C# Developer
6 11 (12.64%) .NET Developer
6 11 (12.64%) C# .NET Developer
7 10 (11.49%) VB Developer
8 9 (10.34%) Solutions Architect
9 7 (8.05%) Administrator
9 7 (8.05%) Business Intelligence Developer
9 7 (8.05%) SQL Developer
10 6 (6.90%) ASP.NET MVC Developer
10 6 (6.90%) SSIS Developer
10 6 (6.90%) Technical Leader
10 6 (6.90%) TOGAF Architect
11 5 (5.75%) Business Intelligence Lead
11 5 (5.75%) Junior SQL Developer
11 5 (5.75%) SQL Analyst
Libraries, Frameworks & Software Standards
1 23 (26.44%) .NET
2 16 (18.39%) CSS
2 16 (18.39%) HTML
3 11 (12.64%) ASP.NET
3 11 (12.64%) XML
4 10 (11.49%) Ajax
4 10 (11.49%) ASP.NET MVC
4 10 (11.49%) ASP.NET MVC 3
4 10 (11.49%) Classic ASP
4 10 (11.49%) DHTML
5 8 (9.20%) jQuery
6 5 (5.75%) AngularJS
6 5 (5.75%) React
7 4 (4.60%) J2EE
8 3 (3.45%) .NET Framework
8 3 (3.45%) Middleware
9 1 (1.15%) EDI
9 1 (1.15%) JSON
9 1 (1.15%) Microsoft Enterprise Library
9 1 (1.15%) SOAP
Miscellaneous
1 31 (35.63%) Replication
2 20 (22.99%) Clustering
3 8 (9.20%) Management Information System
3 8 (9.20%) Mobile App
4 6 (6.90%) Analytical Skills
4 6 (6.90%) Enterprise Software
5 4 (4.60%) Data Integration
5 4 (4.60%) iSeries
5 4 (4.60%) Visualisation
6 3 (3.45%) User Experience
7 2 (2.30%) Statistics
8 1 (1.15%) Computer Science
8 1 (1.15%) N-Tier
Operating Systems
1 28 (32.18%) Windows
2 14 (16.09%) Windows Server
3 3 (3.45%) Windows Server 2003
4 2 (2.30%) Windows Server 2008
4 2 (2.30%) Windows Server 2012
5 1 (1.15%) Linux
5 1 (1.15%) Unix
5 1 (1.15%) Windows 2000
Processes & Methodologies
1 25 (28.74%) ETL
2 20 (22.99%) Database Mirroring
2 20 (22.99%) Performance Tuning
3 16 (18.39%) Business Intelligence
4 14 (16.09%) Server Building
5 11 (12.64%) MVC
5 11 (12.64%) Project Management
5 11 (12.64%) SDLC
6 10 (11.49%) Analytics
7 9 (10.34%) OOA/OOD
8 8 (9.20%) DevOps
8 8 (9.20%) Time Management
8 8 (9.20%) TOGAF
9 7 (8.05%) Configuration Management
9 7 (8.05%) Workflow
10 6 (6.90%) CRM
10 6 (6.90%) Disaster Recovery
10 6 (6.90%) OO
10 6 (6.90%) PRINCE2
10 6 (6.90%) SSADM
Programming Languages
1 73 (83.91%) SQL
2 47 (54.02%) T-SQL
3 14 (16.09%) C#
4 13 (14.94%) JavaScript
4 13 (14.94%) VB
5 12 (13.79%) Java
6 11 (12.64%) VB.NET
7 10 (11.49%) VB6
8 6 (6.90%) PowerShell
9 1 (1.15%) VBA
Qualifications
1 9 (10.34%) Degree
Quality Assurance & Compliance
1 5 (5.75%) SLA
2 4 (4.60%) QA
System Software
1 1 (1.15%) Active Directory
Systems Management
1 14 (16.09%) Perfmon
2 7 (8.05%) SCOM
3 6 (6.90%) Puppet
4 5 (5.75%) Failover Clustering
Vendors
1 21 (24.14%) Microsoft
1 21 (24.14%) VMware
2 9 (10.34%) Cognos
3 8 (9.20%) Tableau
4 6 (6.90%) webMethods
5 5 (5.75%) Oracle
6 4 (4.60%) Adobe
7 2 (2.30%) IBM
7 2 (2.30%) OpenText
7 2 (2.30%) Pega
7 2 (2.30%) Sage
7 2 (2.30%) Salesforce.com
8 1 (1.15%) Citrix