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

3 months to
23 Jan 2017
Same period 2016 Same period 2015
Microsoft Data Transformation Services (DTS)
England / London
Rank 555 616 569
Rank change year-on-year
+61 -47
Permanent jobs citing DTS 32 25 72
As % of all permanent IT jobs located in London 0.095% 0.062% 0.17%
As % of the Database & Business Intelligence category 0.32% 0.20% 0.58%
Number of salaries quoted 24 20 70
Median salary £67,500 £47,500 £47,000
Median salary % change year-on-year
+42.10% +1.06%
90% offered a salary of more than £37,500 £34,500 £37,400
10% offered a salary of more than £79,000 £69,750 £60,000
UK excluding London median salary £42,500 £38,750 £40,000
% change year-on-year
+9.67% -3.12%

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
10026 12622 12451
As % of all permanent IT jobs located in London 29.88% 31.46% 30.14%
Number of salaries quoted 8836 10928 10716
Median salary £60,000 £55,000 £55,000
Median salary % change year-on-year
+9.09% -
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 £43,000 £42,500 £40,000
% change year-on-year
+1.17% +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 23 January 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 23 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
City of London +21 8 £51,250 -22.34%
Chessington - 2 £37,500 -
DTS
England

DTS
Top 30 Related IT Skills in London

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

1 72 (83.72%) SQL Server
2 65 (75.58%) SQL
3 52 (60.47%) SQL Server Integration Services
4 47 (54.65%) SQL Server 2008
5 41 (47.67%) T-SQL
6 32 (37.21%) Windows
7 31 (36.05%) SQL Server 2000
8 30 (34.88%) Replication
8 30 (34.88%) SQL Server Reporting Services
9 23 (26.74%) SQL Server 2014
10 22 (25.58%) Performance Tuning
10 22 (25.58%) Microsoft
11 21 (24.42%) .NET
11 21 (24.42%) SQL Server 2005
12 20 (23.26%) SQL Server Analysis Services
12 20 (23.26%) SQL Server 2012
12 20 (23.26%) VMware
13 19 (22.09%) Clustering
13 19 (22.09%) Database Mirroring
14 18 (20.93%) HTML
14 18 (20.93%) CSS
15 17 (19.77%) Finance
16 16 (18.60%) Data Warehouse
16 16 (18.60%) SQL Server Management Studio (SSMS)
17 15 (17.44%) Windows Server
17 15 (17.44%) ETL
17 15 (17.44%) VB
17 15 (17.44%) JavaScript
18 14 (16.28%) Java
19 13 (15.12%) IIS

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 (15.12%) IIS
2 9 (10.47%) SharePoint
3 6 (6.98%) BizTalk Server
3 6 (6.98%) JBoss
4 4 (4.65%) Apache Spark
4 4 (4.65%) Confluence
4 4 (4.65%) Elasticsearch
4 4 (4.65%) WebSphere
4 4 (4.65%) WebSphere Application Server
5 2 (2.33%) CMS
5 2 (2.33%) Jetty
5 2 (2.33%) Tomcat
6 1 (1.16%) MS Exchange
6 1 (1.16%) Oracle Workflow
Applications
1 11 (12.79%) MS Excel
2 6 (6.98%) MS Office
3 4 (4.65%) Photoshop
Business Applications
1 5 (5.81%) Cognos TM1
2 4 (4.65%) Sage X3
Communications & Networking
1 1 (1.16%) TCP/IP
Database & Business Intelligence
1 72 (83.72%) SQL Server
2 52 (60.47%) SQL Server Integration Services
3 47 (54.65%) SQL Server 2008
4 31 (36.05%) SQL Server 2000
5 30 (34.88%) SQL Server Reporting Services
6 23 (26.74%) SQL Server 2014
7 21 (24.42%) SQL Server 2005
8 20 (23.26%) SQL Server 2012
8 20 (23.26%) SQL Server Analysis Services
9 16 (18.60%) Data Warehouse
10 13 (15.12%) Microsoft Analysis Services
11 11 (12.79%) SQL Server 2016
12 6 (6.98%) EDRMS
12 6 (6.98%) RDBMS
12 6 (6.98%) Relational Database
13 5 (5.81%) Crystal Reports
14 4 (4.65%) Big Data
14 4 (4.65%) DB2
14 4 (4.65%) Oracle Reports
14 4 (4.65%) QlikView
Development Applications
1 16 (18.60%) SQL Server Management Studio (SSMS)
2 8 (9.30%) Jenkins
3 6 (6.98%) Octopus Deploy
3 6 (6.98%) Team Foundation Server
3 6 (6.98%) TeamCity
3 6 (6.98%) Visual Studio
4 4 (4.65%) Git (software)
5 2 (2.33%) JUnit
5 2 (2.33%) Mockito
General
1 17 (19.77%) Finance
2 11 (12.79%) Legal
3 9 (10.47%) Marketing
4 8 (9.30%) Banking
4 8 (9.30%) Retail
5 7 (8.14%) Back Office
6 6 (6.98%) Music Industry
7 2 (2.33%) Front Office
7 2 (2.33%) Law
8 1 (1.16%) Publishing
Job Titles
1 37 (43.02%) DBA
1 37 (43.02%) SQL DBA
2 23 (26.74%) SQL Server DBA
3 22 (25.58%) Developer
4 10 (11.63%) .NET Developer
4 10 (11.63%) C# .NET Developer
4 10 (11.63%) C# Developer
4 10 (11.63%) VB Developer
5 9 (10.47%) Architect
5 9 (10.47%) Solutions Architect
6 8 (9.30%) Analyst
6 8 (9.30%) Support Analyst
7 7 (8.14%) Administrator
7 7 (8.14%) Applications Support
7 7 (8.14%) Applications Support Analyst
8 6 (6.98%) ASP.NET MVC Developer
8 6 (6.98%) SQL Analyst
8 6 (6.98%) SQL Support Analyst
8 6 (6.98%) Technical Leader
8 6 (6.98%) TOGAF Architect
Libraries, Frameworks & Software Standards
1 21 (24.42%) .NET
2 18 (20.93%) CSS
2 18 (20.93%) HTML
3 11 (12.79%) ASP.NET
3 11 (12.79%) XML
4 10 (11.63%) Ajax
4 10 (11.63%) ASP.NET MVC
4 10 (11.63%) ASP.NET MVC 3
4 10 (11.63%) Classic ASP
4 10 (11.63%) DHTML
5 8 (9.30%) jQuery
6 7 (8.14%) AngularJS
7 5 (5.81%) React
8 4 (4.65%) EDI
8 4 (4.65%) J2EE
8 4 (4.65%) Kafka
8 4 (4.65%) Spark Streaming
9 3 (3.49%) .NET Framework
9 3 (3.49%) Middleware
10 2 (2.33%) Hibernate
Miscellaneous
1 30 (34.88%) Replication
2 19 (22.09%) Clustering
3 9 (10.47%) Analytical Skills
4 8 (9.30%) Management Information System
4 8 (9.30%) Mobile App
5 7 (8.14%) Statistics
6 6 (6.98%) Enterprise Software
7 4 (4.65%) Data Integration
7 4 (4.65%) iSeries
7 4 (4.65%) Mathematics
7 4 (4.65%) Visualisation
8 3 (3.49%) User Experience
9 1 (1.16%) N-Tier
Operating Systems
1 32 (37.21%) Windows
2 15 (17.44%) Windows Server
3 5 (5.81%) Linux
4 4 (4.65%) Unix
4 4 (4.65%) Windows Server 2003
5 3 (3.49%) Windows Server 2008
5 3 (3.49%) Windows Server 2012
6 1 (1.16%) Windows 2000
Processes & Methodologies
1 22 (25.58%) Performance Tuning
2 19 (22.09%) Database Mirroring
3 15 (17.44%) ETL
4 13 (15.12%) Project Management
4 13 (15.12%) Server Building
5 11 (12.79%) MVC
6 10 (11.63%) Business Intelligence
6 10 (11.63%) SDLC
7 9 (10.47%) OOA/OOD
8 8 (9.30%) DevOps
8 8 (9.30%) Time Management
8 8 (9.30%) TOGAF
9 7 (8.14%) Configuration Management
10 6 (6.98%) Analytics
10 6 (6.98%) Data Modelling
10 6 (6.98%) Disaster Recovery
10 6 (6.98%) OO
10 6 (6.98%) PRINCE2
10 6 (6.98%) SSADM
10 6 (6.98%) Workflow
Programming Languages
1 65 (75.58%) SQL
2 41 (47.67%) T-SQL
3 15 (17.44%) JavaScript
3 15 (17.44%) VB
4 14 (16.28%) Java
5 12 (13.95%) C#
6 11 (12.79%) VB.NET
7 10 (11.63%) VB6
8 7 (8.14%) PowerShell
9 4 (4.65%) Python
10 1 (1.16%) VBA
Qualifications
1 12 (13.95%) Degree
2 4 (4.65%) PhD
Quality Assurance & Compliance
1 2 (2.33%) SLA
2 1 (1.16%) QA
System Software
1 1 (1.16%) Active Directory
1 1 (1.16%) Oracle RAC
Systems Management
1 13 (15.12%) Perfmon
2 8 (9.30%) SCOM
3 6 (6.98%) Puppet
4 5 (5.81%) Failover Clustering
5 1 (1.16%) Enterprise Manager Cloud Control
Vendors
1 22 (25.58%) Microsoft
2 20 (23.26%) VMware
3 9 (10.47%) Cognos
4 8 (9.30%) Oracle
5 6 (6.98%) webMethods
6 5 (5.81%) Tableau
7 4 (4.65%) Adobe
7 4 (4.65%) IBM
7 4 (4.65%) OpenText
7 4 (4.65%) Sage
8 2 (2.33%) Pega
8 2 (2.33%) Salesforce.com
9 1 (1.16%) Citrix
9 1 (1.16%) Netezza
9 1 (1.16%) Sybase
London
Harvey Nash plc
Salary: £40000 - £50000 per annum
Posted: 2 days ago