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

3 months to
30 Sep 2016
Same period 2015 Same period 2014
Microsoft Data Transformation Services (DTS)
Rank 554 625 589
Rank change year-on-year
+71 -36
Permanent jobs citing DTS 56 32 74
As % of all permanent IT jobs located in London 0.15% 0.073% 0.16%
As % of the Database & Business Intelligence category 0.50% 0.24% 0.52%
Number of salaries quoted 47 27 73
Median salary £48,500 £57,500 £41,500
Median salary % change year-on-year
-15.65% +38.55%
90% offered a salary of more than £42,500 £40,250 £30,000
10% offered a salary of more than £72,000 £72,000 £62,000
UK excluding London median salary £47,000 £45,000 £37,750
% change year-on-year
+4.44% +19.20%
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
11195 13101 14115
As % of all permanent IT jobs located in London 29.49% 29.82% 30.72%
Number of salaries quoted 9761 11116 12247
Median salary £60,000 £57,500 £52,500
Median salary % change year-on-year
+4.34% +9.52%
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 30 September 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 30 September 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 +53 15 £50,000 -30.55%
Chessington - 2 £36,250 -
DTS
England

DTS
Top 30 Related IT Skills in London

For the 6 months to 30 September 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 67 (94.37%) SQL Server
2 66 (92.96%) SQL
3 55 (77.46%) SQL Server Integration Services
4 46 (64.79%) T-SQL
5 39 (54.93%) SQL Server 2008
6 38 (53.52%) SQL Server Reporting Services
7 26 (36.62%) Replication
8 25 (35.21%) SQL Server 2000
8 25 (35.21%) ETL
8 25 (35.21%) SQL Server 2012
9 21 (29.58%) .NET
10 19 (26.76%) C#
10 19 (26.76%) Windows
10 19 (26.76%) Database Mirroring
11 18 (25.35%) Data Warehouse
12 17 (23.94%) SDLC
12 17 (23.94%) SQL Server 2014
13 16 (22.54%) SQL Server Analysis Services
13 16 (22.54%) XML
13 16 (22.54%) VB.NET
14 15 (21.13%) Clustering
14 15 (21.13%) SQL Server 2005
15 14 (19.72%) Server Building
16 13 (18.31%) Business Intelligence
17 12 (16.90%) HTML
17 12 (16.90%) CSS
17 12 (16.90%) VMware
17 12 (16.90%) Performance Tuning
18 11 (15.49%) VB
18 11 (15.49%) Microsoft

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 9 (12.68%) IIS
2 4 (5.63%) SharePoint
2 4 (5.63%) WebSphere
2 4 (5.63%) WebSphere Application Server
3 2 (2.82%) BizTalk Server
3 2 (2.82%) JBoss
Applications
1 10 (14.08%) MS Excel
2 5 (7.04%) MS Office
3 4 (5.63%) Photoshop
4 2 (2.82%) MS PowerPoint
Business Applications
1 6 (8.45%) Oracle 11i
2 2 (2.82%) Cognos TM1
3 1 (1.41%) Sage X3
Database & Business Intelligence
1 67 (94.37%) SQL Server
2 55 (77.46%) SQL Server Integration Services
3 39 (54.93%) SQL Server 2008
4 38 (53.52%) SQL Server Reporting Services
5 25 (35.21%) SQL Server 2000
5 25 (35.21%) SQL Server 2012
6 18 (25.35%) Data Warehouse
7 17 (23.94%) SQL Server 2014
8 16 (22.54%) SQL Server Analysis Services
9 15 (21.13%) SQL Server 2005
10 9 (12.68%) Oracle Database
11 8 (11.27%) Oracle9i Database
12 7 (9.86%) QlikView
13 6 (8.45%) Microsoft Analysis Services
13 6 (8.45%) Oracle Database 10g
14 4 (5.63%) DB2
14 4 (5.63%) Power BI
15 3 (4.23%) Data Mining
15 3 (4.23%) Oracle Reports
16 2 (2.82%) EDRMS
Development Applications
1 10 (14.08%) SQL Server Management Studio (SSMS)
2 6 (8.45%) Visual Studio
3 3 (4.23%) Team Foundation Server
4 2 (2.82%) Jenkins
4 2 (2.82%) Octopus Deploy
4 2 (2.82%) TeamCity
5 1 (1.41%) Git (software)
5 1 (1.41%) Subversion
5 1 (1.41%) Visual Studio Team System
5 1 (1.41%) VSS/SourceSafe
General
1 8 (11.27%) Finance
2 6 (8.45%) French Language
2 6 (8.45%) Music Industry
3 5 (7.04%) Marketing
4 4 (5.63%) Legal
5 3 (4.23%) Banking
6 2 (2.82%) Back Office
6 2 (2.82%) Telecoms
7 1 (1.41%) Investment Banking
Job Titles
1 30 (42.25%) DBA
1 30 (42.25%) SQL DBA
2 26 (36.62%) Developer
3 20 (28.17%) SQL Server DBA
4 12 (16.90%) C# Developer
5 11 (15.49%) .NET Developer
5 11 (15.49%) C# .NET Developer
6 10 (14.08%) VB Developer
7 8 (11.27%) Business Intelligence Developer
7 8 (11.27%) SQL Developer
8 7 (9.86%) Architect
9 6 (8.45%) Administrator
9 6 (8.45%) ASP.NET MVC Developer
9 6 (8.45%) Consultant
9 6 (8.45%) Oracle Consultant
9 6 (8.45%) Oracle Technical Consultant
9 6 (8.45%) SSIS Developer
9 6 (8.45%) Technical Consultant
10 5 (7.04%) Junior SQL Developer
10 5 (7.04%) T-SQL Developer
Libraries, Frameworks & Software Standards
1 21 (29.58%) .NET
2 16 (22.54%) XML
3 12 (16.90%) CSS
3 12 (16.90%) HTML
4 10 (14.08%) Ajax
4 10 (14.08%) ASP.NET
4 10 (14.08%) ASP.NET MVC
4 10 (14.08%) ASP.NET MVC 3
4 10 (14.08%) Classic ASP
4 10 (14.08%) DHTML
5 7 (9.86%) jQuery
6 4 (5.63%) J2EE
7 2 (2.82%) AngularJS
7 2 (2.82%) React
8 1 (1.41%) Middleware
Miscellaneous
1 26 (36.62%) Replication
2 15 (21.13%) Clustering
3 5 (7.04%) Analytical Skills
4 4 (5.63%) iSeries
5 3 (4.23%) Management Information System
5 3 (4.23%) Mobile App
6 2 (2.82%) Enterprise Software
7 1 (1.41%) Computer Science
7 1 (1.41%) User Experience
Operating Systems
1 19 (26.76%) Windows
2 7 (9.86%) Windows Server
Processes & Methodologies
1 25 (35.21%) ETL
2 19 (26.76%) Database Mirroring
3 17 (23.94%) SDLC
4 14 (19.72%) Server Building
5 13 (18.31%) Business Intelligence
6 12 (16.90%) Performance Tuning
7 10 (14.08%) Migration
7 10 (14.08%) MVC
8 9 (12.68%) Analytics
9 7 (9.86%) Workflow
10 6 (8.45%) Data Migration
11 5 (7.04%) Data Analytics
11 5 (7.04%) Disaster Recovery
11 5 (7.04%) Project Management
11 5 (7.04%) Time Management
12 4 (5.63%) Continuous Improvement
12 4 (5.63%) High Availability
12 4 (5.63%) Inmon Methodology
12 4 (5.63%) Kimball Methodology
12 4 (5.63%) Line Management
Programming Languages
1 66 (92.96%) SQL
2 46 (64.79%) T-SQL
3 19 (26.76%) C#
4 16 (22.54%) VB.NET
5 11 (15.49%) VB
6 10 (14.08%) JavaScript
6 10 (14.08%) VB6
7 6 (8.45%) Java
7 6 (8.45%) PL/SQL
7 6 (8.45%) PowerShell
Qualifications
1 3 (4.23%) Degree
Quality Assurance & Compliance
1 4 (5.63%) QA
1 4 (5.63%) SLA
Systems Management
1 10 (14.08%) Perfmon
2 4 (5.63%) Failover Clustering
2 4 (5.63%) SCOM
3 2 (2.82%) Puppet
Vendors
1 12 (16.90%) VMware
2 11 (15.49%) Microsoft
3 10 (14.08%) Oracle
4 7 (9.86%) Cognos
5 4 (5.63%) Adobe
5 4 (5.63%) Tableau
6 2 (2.82%) webMethods
7 1 (1.41%) IBM
7 1 (1.41%) OpenText
7 1 (1.41%) Sage
London
Marcus Donald People
Salary: £70000 - £80000 per annum
Posted: 4 days ago