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 1 October 2014 with a comparison to the same period in the previous 2 years.

Location
3 months to
1 Oct 2014
Same period 2013 Same period 2012
Microsoft Data Transformation Services (DTS)
Rank 545 514 518
Rank change year-on-year
-31 +4
Permanent jobs citing DTS 73 101 113
As % of all permanent IT jobs located in London 0.16% 0.22% 0.23%
As % of the Database & Business Intelligence category 0.54% 0.74% 0.79%
Number of salaries quoted 72 93 102
Average salary £42,000 £55,000 £47,500
Average salary % change year-on-year
-23.63% +15.78%
90% offered a salary of more than £30,000 £40,000 £30,050
10% offered a salary of more than £60,000 £65,000 £59,850
UK excluding London average salary £37,250 £37,500 £38,500
% change year-on-year
-0.66% -2.59%
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
13545 13571 14363
As % of all permanent IT jobs located in London 29.98% 30.14% 28.87%
Number of salaries quoted 11789 11831 12634
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,500 £35,000
10% offered a salary of more than £75,000 £72,500 £75,000
UK excluding London average salary £40,000 £40,000 £40,000

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 1 October 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 1 October 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 -3 33 £42,500 -22.72% 2
DTS
England

DTS
Top 30 Related IT Skills in London

For the 6 months to 1 October 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 167 (86.98%) SQL
2 153 (79.69%) SQL Server Integration Services
3 134 (69.79%) SQL Server
4 120 (62.50%) SQL Server Reporting Services
5 102 (53.13%) T-SQL
6 101 (52.60%) SQL Server 2008
7 79 (41.15%) SQL Server 2005
8 73 (38.02%) SQL Server Analysis Services
9 72 (37.50%) ETL
10 56 (29.17%) MS Excel
11 55 (28.65%) Microsoft
11 55 (28.65%) .NET
12 54 (28.13%) SQL Server 2000
13 47 (24.48%) Performance Tuning
14 46 (23.96%) Windows
15 42 (21.88%) Finance
16 40 (20.83%) Marketing
17 39 (20.31%) Analytical Skills
18 37 (19.27%) C#
19 35 (18.23%) Business Intelligence
20 34 (17.71%) OO
21 32 (16.67%) SharePoint
22 27 (14.06%) Replication
22 27 (14.06%) MS Office
23 26 (13.54%) Crystal Reports
24 23 (11.98%) Business Objects
24 23 (11.98%) Oracle
25 22 (11.46%) XML
26 21 (10.94%) Degree
26 21 (10.94%) Data Extraction

DTS
Top Related IT Skills in London by Category

For the 6 months to 1 October 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 (16.67%) SharePoint
2 19 (9.90%) IIS
3 2 (1.04%) Oracle Service Bus
3 2 (1.04%) WebSphere
3 2 (1.04%) Oracle SOA Suite
4 1 (0.52%) WorkSite
4 1 (0.52%) Oracle Workflow
Applications
1 56 (29.17%) MS Excel
2 27 (14.06%) MS Office
3 1 (0.52%) MS PowerPoint
Business Applications
1 4 (2.08%) RMDS
2 1 (0.52%) Markit EDM
2 1 (0.52%) Oracle BPM
2 1 (0.52%) Oracle ERP
Cloud Services
1 10 (5.21%) SaaS
Communications & Networking
1 1 (0.52%) HTTPS
1 1 (0.52%) Intranet
Database & Business Intelligence
1 153 (79.69%) SQL Server Integration Services
2 134 (69.79%) SQL Server
3 120 (62.50%) SQL Server Reporting Services
4 101 (52.60%) SQL Server 2008
5 79 (41.15%) SQL Server 2005
6 73 (38.02%) SQL Server Analysis Services
7 54 (28.13%) SQL Server 2000
8 26 (13.54%) Crystal Reports
9 19 (9.90%) OLAP
9 19 (9.90%) Data Warehouse
10 18 (9.38%) Relational Database
11 17 (8.85%) Microsoft Analysis Services
12 15 (7.81%) MS Access
12 15 (7.81%) RDBMS
13 14 (7.29%) Oracle OLAP
14 13 (6.77%) BusinessObjects Web Intelligence
15 12 (6.25%) BusinessObjects XI
15 12 (6.25%) Sybase ASE
16 9 (4.69%) EDRMS
17 8 (4.17%) OLTP
Development Applications
1 17 (8.85%) SQL Server Management Studio (SSMS)
2 14 (7.29%) Visual Studio
3 9 (4.69%) Jenkins
3 9 (4.69%) TeamCity
4 4 (2.08%) Team Foundation Server
5 2 (1.04%) Talend Open Studio
6 1 (0.52%) Toad
General
1 42 (21.88%) Finance
2 40 (20.83%) Marketing
3 12 (6.25%) Banking
3 12 (6.25%) Investment Banking
4 6 (3.13%) Law
5 3 (1.56%) Billing
6 2 (1.04%) Legal
6 2 (1.04%) Advertising
7 1 (0.52%) Retail
Job Titles
1 90 (46.88%) Developer
2 66 (34.38%) DBA
3 63 (32.81%) SQL DBA
4 53 (27.60%) SQL Developer
5 37 (19.27%) Analyst
6 29 (15.10%) Administrator
7 26 (13.54%) SQL Server DBA
8 14 (7.29%) SQL Server Developer
9 12 (6.25%) Analyst Developer
10 11 (5.73%) Microsoft Developer
10 11 (5.73%) .NET Developer
11 10 (5.21%) Server Administrator
12 9 (4.69%) Senior DBA
12 9 (4.69%) Junior Developer
12 9 (4.69%) Team Leader
12 9 (4.69%) Business Analyst
12 9 (4.69%) Junior
13 8 (4.17%) Programmer
13 8 (4.17%) Support Analyst
13 8 (4.17%) Senior SQL DBA
Libraries, Frameworks & Software Standards
1 55 (28.65%) .NET
2 22 (11.46%) XML
3 13 (6.77%) ASP.NET
4 11 (5.73%) MDX
5 9 (4.69%) JRules
6 8 (4.17%) Java EE
7 6 (3.13%) Middleware
7 6 (3.13%) HTML
8 5 (2.60%) .NET Framework
8 5 (2.60%) Web Services
9 4 (2.08%) WinForms
9 4 (2.08%) Rendezvous
9 4 (2.08%) CSS
10 2 (1.04%) Oracle Fusion
10 2 (1.04%) WCF
10 2 (1.04%) jQuery
10 2 (1.04%) NHibernate
11 1 (0.52%) Spring Integration
11 1 (0.52%) Spring
11 1 (0.52%) J2EE
Miscellaneous
1 39 (20.31%) Analytical Skills
2 27 (14.06%) Replication
3 21 (10.94%) Data Extraction
4 15 (7.81%) Clustering
5 12 (6.25%) Credit Risk
6 8 (4.17%) Enterprise Software
7 6 (3.13%) Data Integration
8 5 (2.60%) Computer Science
9 3 (1.56%) Mathematics
9 3 (1.56%) Physics
9 3 (1.56%) Client/Server
10 2 (1.04%) Derivative
11 1 (0.52%) Digital Media
11 1 (0.52%) Foreign Exchange (FX)
11 1 (0.52%) Equities
Operating Systems
1 46 (23.96%) Windows
2 16 (8.33%) Windows Server 2008
3 10 (5.21%) Windows Server 2003
4 6 (3.13%) UNIX
5 5 (2.60%) Windows Server 2012
5 5 (2.60%) Windows 2000 Server
5 5 (2.60%) Windows 2000
6 3 (1.56%) Linux
7 1 (0.52%) Android
Processes & Methodologies
1 72 (37.50%) ETL
2 47 (24.48%) Performance Tuning
3 35 (18.23%) Business Intelligence
4 34 (17.71%) OO
5 19 (9.90%) Agile Software Development
5 19 (9.90%) Migration
6 15 (7.81%) OOP
7 14 (7.29%) B2B
7 14 (7.29%) ITIL
7 14 (7.29%) Mentoring
8 13 (6.77%) Analytics
9 12 (6.25%) E-Commerce
9 12 (6.25%) Software Architecture
10 11 (5.73%) Database Tuning
10 11 (5.73%) ERP
10 11 (5.73%) Change Management
11 10 (5.21%) Coaching
12 9 (4.69%) Database Security
12 9 (4.69%) People Management
12 9 (4.69%) Line Management
Programming Languages
1 167 (86.98%) SQL
2 102 (53.13%) T-SQL
3 37 (19.27%) C#
4 15 (7.81%) Java
5 13 (6.77%) VB.NET
6 8 (4.17%) VBScript
6 8 (4.17%) PowerShell
6 8 (4.17%) Data Analysis Expressions (DAX)
7 6 (3.13%) PL/SQL
7 6 (3.13%) JavaScript
8 5 (2.60%) C++
9 4 (2.08%) C
10 2 (1.04%) Shell Script
10 2 (1.04%) PHP
10 2 (1.04%) R
11 1 (0.52%) VB
Qualifications
1 21 (10.94%) Degree
2 9 (4.69%) Microsoft Certification
3 5 (2.60%) MCITP
3 5 (2.60%) MCTS
4 2 (1.04%) Security Cleared
5 1 (0.52%) MCP
5 1 (0.52%) MCDBA
5 1 (0.52%) PhD
Quality Assurance & Compliance
1 5 (2.60%) QA
1 5 (2.60%) ISO 9001
System Software
1 3 (1.56%) Active Directory
2 2 (1.04%) Oracle RMAN
2 2 (1.04%) Oracle RAC
3 1 (0.52%) VMware Infrastructure
Systems Management
1 9 (4.69%) Opscode Chef
1 9 (4.69%) Puppet
2 4 (2.08%) ITRS Geneos
3 2 (1.04%) Data Guard
Vendors
1 55 (28.65%) Microsoft
2 23 (11.98%) Business Objects
2 23 (11.98%) Oracle
3 16 (8.33%) Sybase
4 15 (7.81%) VMware
5 9 (4.69%) webMethods
5 9 (4.69%) JBoss
6 8 (4.17%) Red Gate
7 5 (2.60%) Siebel
7 5 (2.60%) Teradata
8 4 (2.08%) CQG
8 4 (2.08%) Reuters
8 4 (2.08%) Bloomberg
8 4 (2.08%) TIBCO
8 4 (2.08%) SAP
9 2 (1.04%) Citrix
9 2 (1.04%) MicroStrategy
9 2 (1.04%) Sun
9 2 (1.04%) IBM
9 2 (1.04%) Talend
City of London
Hudson - London
Salary: £50000 - £65000 per annum + extensive benefits package
Posted: 14 hours ago
London
Scott-Merrick LLP
Posted: 5 days ago
City, London
Venturi
Salary: £50000 - £65000.00 per annum + benefits
Posted: 6 days ago