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

Location
3 months to
19 Sep 2014
Same period 2013 Same period 2012
Microsoft Data Transformation Services (DTS)
Rank 557 505 534
Rank change year-on-year
-52 +29
Permanent jobs citing DTS 77 101 116
As % of all permanent IT jobs located in London 0.17% 0.23% 0.23%
As % of the Database & Business Intelligence category 0.55% 0.76% 0.81%
Number of salaries quoted 75 95 103
Average salary £41,500 £55,000 £45,000
Average salary % change year-on-year
-24.54% +22.22%
90% offered a salary of more than £30,000 £38,500 £30,500
10% offered a salary of more than £62,500 £65,000 £58,500
UK excluding London average salary £38,500 £38,000 £38,500
% change year-on-year
+1.31% -1.29%
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
13887 13369 14246
As % of all permanent IT jobs located in London 30.15% 30.03% 28.68%
Number of salaries quoted 12105 11622 12592
Average salary £52,500 £55,000 £50,000
Average salary % change year-on-year
-4.54% +10.00%
90% offered a salary of more than £37,500 £37,000 £35,000
10% offered a salary of more than £75,000 £72,500 £75,000
UK excluding London average salary £40,000 £40,000 £39,500
% change year-on-year
- +1.26%

DTS
Jobs Demand Trend in London

This chart provides a 3-month moving total of permanent IT jobs citing DTS across the London region as a proportion of the total demand within 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 19 September 2014.

DTS Salary Histogram in London

DTS
Job Locations in London

The table below looks at the demand and provides a guide to the average salaries quoted in IT jobs citing DTS within the London region over the 3 months to 19 September 2014. 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
(Use links below to see detailed
statistics and historical trends)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Average Salary
Last 3 Months
Average Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
City of London -4 33 £42,500 -22.01%
Uxbridge - 2 £62,500 -
DTS
England

DTS
Top 30 Related IT Skills in London

For the 6 months to 19 September 2014, IT jobs across the London region citing DTS also mentioned the following IT skills in order of popularity. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited DTS.

1 180 (86.96%) SQL
2 165 (79.71%) SQL Server Integration Services
3 146 (70.53%) SQL Server
4 135 (65.22%) SQL Server Reporting Services
5 110 (53.14%) SQL Server 2008
6 106 (51.21%) T-SQL
7 88 (42.51%) SQL Server 2005
8 84 (40.58%) SQL Server Analysis Services
8 84 (40.58%) ETL
9 66 (31.88%) MS Excel
10 60 (28.99%) Microsoft
11 55 (26.57%) Performance Tuning
12 54 (26.09%) .NET
13 51 (24.64%) SQL Server 2000
13 51 (24.64%) Finance
14 48 (23.19%) Windows
15 44 (21.26%) Marketing
16 43 (20.77%) Analytical Skills
17 40 (19.32%) Business Intelligence
18 34 (16.43%) MS Office
19 33 (15.94%) C#
20 32 (15.46%) OO
20 32 (15.46%) SharePoint
21 30 (14.49%) Replication
22 28 (13.53%) Oracle
23 25 (12.08%) Crystal Reports
23 25 (12.08%) Business Objects
24 24 (11.59%) OLAP
24 24 (11.59%) XML
24 24 (11.59%) Data Warehouse

DTS
Top Related IT Skills in London by Category

For the 6 months to 19 September 2014, IT jobs across the London region citing DTS also mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited DTS. Up to 20 skills are shown per category.

Application Platforms
1 32 (15.46%) SharePoint
2 19 (9.18%) IIS
3 3 (1.45%) WebSphere
3 3 (1.45%) Oracle Service Bus
3 3 (1.45%) Oracle SOA Suite
4 2 (0.97%) Oracle Workflow
5 1 (0.48%) BizTalk Server
Applications
1 66 (31.88%) MS Excel
2 34 (16.43%) MS Office
3 1 (0.48%) MS PowerPoint
Business Applications
1 4 (1.93%) RMDS
2 2 (0.97%) Dynamics NAV
2 2 (0.97%) Oracle BPM
3 1 (0.48%) Markit EDM
3 1 (0.48%) Oracle ERP
Cloud Services
1 11 (5.31%) SaaS
Communications & Networking
1 2 (0.97%) Intranet
2 1 (0.48%) HTTPS
Database & Business Intelligence
1 165 (79.71%) SQL Server Integration Services
2 146 (70.53%) SQL Server
3 135 (65.22%) SQL Server Reporting Services
4 110 (53.14%) SQL Server 2008
5 88 (42.51%) SQL Server 2005
6 84 (40.58%) SQL Server Analysis Services
7 51 (24.64%) SQL Server 2000
8 25 (12.08%) Crystal Reports
9 24 (11.59%) OLAP
9 24 (11.59%) Data Warehouse
10 22 (10.63%) Microsoft Analysis Services
11 19 (9.18%) MS Access
12 17 (8.21%) Oracle OLAP
13 16 (7.73%) BusinessObjects Web Intelligence
14 15 (7.25%) BusinessObjects XI
14 15 (7.25%) Sybase ASE
14 15 (7.25%) RDBMS
14 15 (7.25%) Relational Database
15 11 (5.31%) SQL Server 2012
16 9 (4.35%) OLTP
Development Applications
1 21 (10.14%) SQL Server Management Studio (SSMS)
2 12 (5.80%) Visual Studio
3 9 (4.35%) TeamCity
3 9 (4.35%) Jenkins
4 4 (1.93%) Team Foundation Server
5 3 (1.45%) Talend Open Studio
6 1 (0.48%) Toad
General
1 51 (24.64%) Finance
2 44 (21.26%) Marketing
3 15 (7.25%) Investment Banking
3 15 (7.25%) Banking
4 5 (2.42%) Law
5 4 (1.93%) Advertising
6 3 (1.45%) Retail
6 3 (1.45%) Billing
7 2 (0.97%) Legal
Job Titles
1 99 (47.83%) Developer
2 70 (33.82%) DBA
3 67 (32.37%) SQL DBA
4 55 (26.57%) SQL Developer
5 40 (19.32%) Analyst
6 32 (15.46%) Administrator
7 30 (14.49%) SQL Server DBA
8 17 (8.21%) SQL Server Developer
9 14 (6.76%) Microsoft Developer
10 13 (6.28%) Business Intelligence Developer
11 12 (5.80%) Analyst Developer
12 11 (5.31%) Business Analyst
12 11 (5.31%) Junior
12 11 (5.31%) Business Developer
12 11 (5.31%) Junior Developer
13 10 (4.83%) Server Administrator
14 9 (4.35%) Team Leader
15 8 (3.86%) Server Analyst
15 8 (3.86%) Senior DBA
15 8 (3.86%) SQL Server Analyst
Libraries, Frameworks & Software Standards
1 54 (26.09%) .NET
2 24 (11.59%) XML
3 15 (7.25%) MDX
4 12 (5.80%) ASP.NET
5 9 (4.35%) JRules
6 8 (3.86%) Java EE
7 7 (3.38%) Middleware
7 7 (3.38%) HTML
8 5 (2.42%) Web Services
8 5 (2.42%) .NET Framework
9 4 (1.93%) WinForms
9 4 (1.93%) Rendezvous
9 4 (1.93%) CSS
10 3 (1.45%) Oracle Fusion
11 2 (0.97%) Spring Integration
11 2 (0.97%) Spring
11 2 (0.97%) J2EE
12 1 (0.48%) SOAP
12 1 (0.48%) XML Messaging
Miscellaneous
1 43 (20.77%) Analytical Skills
2 30 (14.49%) Replication
3 20 (9.66%) Data Extraction
4 15 (7.25%) Credit Risk
5 12 (5.80%) Clustering
6 8 (3.86%) Data Integration
6 8 (3.86%) Enterprise Software
7 5 (2.42%) Computer Science
8 3 (1.45%) Derivative
8 3 (1.45%) Mathematics
8 3 (1.45%) Physics
9 2 (0.97%) Foreign Exchange (FX)
10 1 (0.48%) Digital Media
10 1 (0.48%) Equities
Operating Systems
1 48 (23.19%) Windows
2 17 (8.21%) Windows Server 2008
3 10 (4.83%) Windows Server 2003
4 6 (2.90%) UNIX
4 6 (2.90%) Windows Server 2012
5 5 (2.42%) Windows 2000
5 5 (2.42%) Windows 2000 Server
6 3 (1.45%) Linux
7 1 (0.48%) Android
Processes & Methodologies
1 84 (40.58%) ETL
2 55 (26.57%) Performance Tuning
3 40 (19.32%) Business Intelligence
4 32 (15.46%) OO
5 22 (10.63%) Agile Software Development
6 18 (8.70%) Migration
6 18 (8.70%) B2B
7 16 (7.73%) ITIL
8 15 (7.25%) OOP
8 15 (7.25%) E-Commerce
8 15 (7.25%) Software Architecture
8 15 (7.25%) Mentoring
9 14 (6.76%) Analytics
10 12 (5.80%) Database Tuning
10 12 (5.80%) ERP
10 12 (5.80%) Data Modelling
11 11 (5.31%) Change Management
12 10 (4.83%) Disaster Recovery
12 10 (4.83%) Data Analysis
12 10 (4.83%) Database Security
Programming Languages
1 180 (86.96%) SQL
2 106 (51.21%) T-SQL
3 33 (15.94%) C#
4 18 (8.70%) Java
5 10 (4.83%) VB.NET
6 9 (4.35%) Data Analysis Expressions (DAX)
7 8 (3.86%) PL/SQL
8 7 (3.38%) VBScript
8 7 (3.38%) C++
8 7 (3.38%) PowerShell
9 4 (1.93%) C
10 3 (1.45%) JavaScript
11 2 (0.97%) R
11 2 (0.97%) Shell Script
Qualifications
1 21 (10.14%) Degree
2 10 (4.83%) Microsoft Certification
3 6 (2.90%) MCTS
3 6 (2.90%) MCITP
4 2 (0.97%) Security Cleared
5 1 (0.48%) MCP
5 1 (0.48%) MCDBA
5 1 (0.48%) PhD
Quality Assurance & Compliance
1 6 (2.90%) QA
2 5 (2.42%) ISO 9001
System Software
1 4 (1.93%) Active Directory
2 2 (0.97%) Oracle RMAN
2 2 (0.97%) Oracle RAC
3 1 (0.48%) VMware Infrastructure
Systems Management
1 9 (4.35%) Puppet
1 9 (4.35%) Opscode Chef
2 4 (1.93%) ITRS Geneos
3 2 (0.97%) Data Guard
Vendors
1 60 (28.99%) Microsoft
2 28 (13.53%) Oracle
3 25 (12.08%) Business Objects
4 19 (9.18%) Sybase
5 16 (7.73%) VMware
6 9 (4.35%) Red Gate
6 9 (4.35%) JBoss
6 9 (4.35%) webMethods
7 6 (2.90%) Siebel
7 6 (2.90%) Teradata
8 4 (1.93%) TIBCO
8 4 (1.93%) SAP
8 4 (1.93%) Reuters
8 4 (1.93%) Bloomberg
8 4 (1.93%) CQG
9 3 (1.45%) Citrix
9 3 (1.45%) IBM
9 3 (1.45%) Talend
10 2 (0.97%) Tableau
10 2 (0.97%) Informatica