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

Location
3 months to
3 Jul 2015
Same period 2014 Same period 2013
Microsoft Data Transformation Services (DTS)
Rank 743 642 595
Rank change year-on-year
-101 -47
Permanent jobs citing DTS 159 308 301
As % of all permanent IT jobs located in the UK 0.14% 0.26% 0.28%
As % of the Database & Business Intelligence category 0.45% 0.83% 0.88%
Number of salaries quoted 151 254 246
Average salary £45,000 £45,000 £42,500
Average salary % change year-on-year
- +5.88%
90% offered a salary of more than £25,000 £31,150 £29,000
10% offered a salary of more than £65,000 £62,500 £55,000
UK excluding London average salary £40,500 £43,750 £40,000
% change year-on-year
-7.42% +9.37%

The following table is for comparison with the above and provides statistics for the entire Database & Business Intelligence category in permanent jobs advertised across the UK.

Database & Business Intelligence Category
UK
Permanent IT job ads with a match in the
Database & Business Intelligence category
34976 36903 34218
As % of all permanent IT jobs located in the UK 31.60% 31.25% 31.51%
Number of salaries quoted 29533 31687 29647
Average salary £47,500 £45,000 £42,500
Average salary % change year-on-year
+5.55% +5.88%
90% offered a salary of more than £32,000 £30,000 £30,000
10% offered a salary of more than £70,000 £65,000 £70,000
UK excluding London average salary £42,000 £40,000 £38,500
% change year-on-year
+5.00% +3.89%

DTS
Jobs Demand Trend

This chart provides the 3-month moving total of permanent IT jobs citing DTS within the UK as a proportion of the total demand within the Database & Business Intelligence category.

DTS Jobs Demand Trend in the UK

DTS
Salary Trend

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing DTS within the UK.

DTS Salary Trend in the UK

DTS
Salary Histogram

This chart provides a salary histogram for IT jobs citing DTS over the 3 months to 3 July 2015 within the UK.

DTS Salary Histogram in the UK

DTS
Top 30 Job Locations

The table below looks at the demand and provides a guide to the average salaries quoted in IT jobs citing DTS within the UK over the 3 months to 3 July 2015. 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
England -132 137 £45,000 - 9
London -55 38 £50,000 +8.10% 1
East of England +5 32 £45,000 - 1
West Midlands -1 20 £25,000 -43.18%
South East -35 20 £42,500 - 3
Hertfordshire +18 19 £45,000 - 1
Warwickshire - 16 £25,000 -
North West -10 14 £40,000 +2.56% 1
City of London +9 13 £65,000 +36.84%
Manchester +3 13 £40,000 -36.00% 1
Essex 0 13 £50,000 +14.28%
Cardiff - 11 £45,000 -
South Wales - 11 £45,000 -
Wales - 11 £45,000 -
Glasgow +13 10 £34,500 -1.42% 1
Scotland +6 10 £34,500 -1.42% 1
Chelmsford +3 8 £47,500 +5.55%
Hampshire -8 8 £36,250 -9.37% 1
Yorkshire -8 7 £55,000 -2.22% 3
Reading -12 7 £50,000 +17.64% 1
Berkshire -16 7 £50,000 +17.64% 1
Borehamwood - 7 £40,000 - 1
Warwick - 6 £22,500 -
Portsmouth +26 4 £35,000 -36.36% 1
West Yorkshire -1 4 £55,000 +25.71% 2
East Midlands -9 4 £40,000 +14.28%
Colchester +5 3 £72,000 -15.29%
Leeds +2 3 £55,000 +56.02% 2
Southampton -3 3 £39,000 -2.50%
Kent -6 3 £50,000 +5.26%

DTS
Top 30 Related IT Skills

For the 6 months to 3 July 2015, IT jobs within the UK 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 299 (89.79%) SQL
1 299 (89.79%) SQL Server
2 247 (74.17%) SQL Server Integration Services
3 229 (68.77%) T-SQL
4 169 (50.75%) SQL Server 2008
5 167 (50.15%) SQL Server Reporting Services
6 157 (47.15%) .NET
7 146 (43.84%) Microsoft
8 128 (38.44%) Data Warehouse
9 117 (35.14%) SQL Server 2005
10 114 (34.23%) C#
11 113 (33.93%) Business Intelligence
12 105 (31.53%) ETL
13 104 (31.23%) SQL Server 2012
14 78 (23.42%) Finance
15 77 (23.12%) Windows
16 76 (22.82%) SQL Server Analysis Services
17 72 (21.62%) SQL Server 2000
18 66 (19.82%) Performance Tuning
19 60 (18.02%) ASP.NET
20 56 (16.82%) XML
20 56 (16.82%) Cognos
21 55 (16.52%) MS Excel
21 55 (16.52%) Replication
22 48 (14.41%) Degree
23 47 (14.11%) Relational Database
24 46 (13.81%) Clustering
25 45 (13.51%) Migration
26 42 (12.61%) JavaScript
27 40 (12.01%) Data Transformation

DTS
Top Related IT Skills by Category

For the 6 months to 3 July 2015, IT jobs within the UK 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 21 (6.31%) BizTalk Server
2 20 (6.01%) IIS
2 20 (6.01%) SharePoint
3 12 (3.60%) JBoss
4 8 (2.40%) CMS
5 2 (0.60%) SharePoint 2010
6 1 (0.30%) Sitefinity
6 1 (0.30%) SharePoint 2013
6 1 (0.30%) Umbraco
6 1 (0.30%) SAS
Applications
1 55 (16.52%) MS Excel
2 2 (0.60%) MS Office
3 1 (0.30%) MS Project
3 1 (0.30%) MS Visio
3 1 (0.30%) PowerPivot
Business Applications
1 4 (1.20%) Dynamics CRM
2 3 (0.90%) Dynamics NAV
3 2 (0.60%) Cognos Business Intelligence
4 1 (0.30%) SAP Oil and Gas
Cloud Services
1 6 (1.80%) Microsoft Azure
1 6 (1.80%) SaaS
Communications & Networking
1 9 (2.70%) SAN
2 5 (1.50%) Intranet
2 5 (1.50%) Internet
3 3 (0.90%) Extranet
4 1 (0.30%) DAB
4 1 (0.30%) NAS
Database & Business Intelligence
1 299 (89.79%) SQL Server
2 247 (74.17%) SQL Server Integration Services
3 169 (50.75%) SQL Server 2008
4 167 (50.15%) SQL Server Reporting Services
5 128 (38.44%) Data Warehouse
6 117 (35.14%) SQL Server 2005
7 104 (31.23%) SQL Server 2012
8 76 (22.82%) SQL Server Analysis Services
9 72 (21.62%) SQL Server 2000
10 47 (14.11%) Relational Database
11 26 (7.81%) OLTP
12 23 (6.91%) Microsoft Analysis Services
13 18 (5.41%) RDBMS
14 16 (4.80%) OLAP
15 15 (4.50%) Cognos Analysis Studio
15 15 (4.50%) Cognos Report Studio
15 15 (4.50%) Cognos Framework Manager
16 13 (3.90%) EDRMS
17 8 (2.40%) Crystal Reports
18 7 (2.10%) MySQL
Development Applications
1 25 (7.51%) Visual Studio
2 20 (6.01%) Team Foundation Server
3 17 (5.11%) SQL Server Management Studio (SSMS)
4 13 (3.90%) Jenkins
4 13 (3.90%) TeamCity
5 12 (3.60%) Octopus Deploy
6 6 (1.80%) VSS/SourceSafe
7 3 (0.90%) ClearCase
7 3 (0.90%) CruiseControl
7 3 (0.90%) ClearQuest
8 2 (0.60%) ERwin
9 1 (0.30%) MSI
9 1 (0.30%) InstallShield
General
1 78 (23.42%) Finance
2 27 (8.11%) Marketing
3 7 (2.10%) Banking
4 6 (1.80%) Legal
4 6 (1.80%) Financial Institution
5 3 (0.90%) Advertising
6 2 (0.60%) Telecoms
6 2 (0.60%) Manufacturing
6 2 (0.60%) Law
7 1 (0.30%) Pharmaceutical
7 1 (0.30%) Electronics
7 1 (0.30%) Games
7 1 (0.30%) Retail
7 1 (0.30%) Investment Banking
Job Titles
1 129 (38.74%) DBA
2 121 (36.34%) SQL DBA
3 116 (34.83%) Developer
4 70 (21.02%) SQL Developer
5 68 (20.42%) Administrator
6 53 (15.92%) SQL Server DBA
7 38 (11.41%) Analyst
8 32 (9.61%) Applications Support
9 31 (9.31%) Consultant
10 27 (8.11%) Support Consultant
11 26 (7.81%) Applications Support Consultant
11 26 (7.81%) Applications Consultant
12 22 (6.61%) .NET Developer
12 22 (6.61%) C# Developer
12 22 (6.61%) Database Developer
13 19 (5.71%) SQL Database Developer
13 19 (5.71%) C# .NET Developer
14 17 (5.11%) C# ASP.NET Developer
14 17 (5.11%) ASP.NET Developer
15 16 (4.80%) Architect
Libraries, Frameworks & Software Standards
1 157 (47.15%) .NET
2 60 (18.02%) ASP.NET
3 56 (16.82%) XML
4 35 (10.51%) HTML
5 31 (9.31%) CSS
6 30 (9.01%) jQuery
7 25 (7.51%) .NET Framework
8 20 (6.01%) Ajax
8 20 (6.01%) Entity Framework
8 20 (6.01%) LINQ
9 18 (5.41%) ASP.NET Web API
9 18 (5.41%) CSS3
9 18 (5.41%) Web Services
10 12 (3.60%) REST
10 12 (3.60%) SOAP
11 11 (3.30%) ASP.NET MVC
11 11 (3.30%) WCF
12 9 (2.70%) WPF
13 7 (2.10%) Microsoft Enterprise Library
13 7 (2.10%) MDX
Miscellaneous
1 55 (16.52%) Replication
2 46 (13.81%) Clustering
3 35 (10.51%) Analytical Skills
4 23 (6.91%) Management Information System
5 16 (4.80%) Statistics
6 15 (4.50%) Enterprise Software
7 11 (3.30%) Digital Media
8 9 (2.70%) Visualisation
9 8 (2.40%) User Experience
10 7 (2.10%) Data Structures
11 5 (1.50%) Data Extraction
12 4 (1.20%) NHS
13 3 (0.90%) N-Tier
13 3 (0.90%) Mobile App
14 2 (0.60%) AS400
14 2 (0.60%) Client/Server
14 2 (0.60%) Computer Science
15 1 (0.30%) Smartphone
15 1 (0.30%) Data Integration
15 1 (0.30%) CLARiiON
Operating Systems
1 77 (23.12%) Windows
2 19 (5.71%) Windows Server 2008
3 15 (4.50%) Windows Server 2012
4 14 (4.20%) Windows Server 2003
5 11 (3.30%) UNIX
6 1 (0.30%) Windows 2000
Processes & Methodologies
1 113 (33.93%) Business Intelligence
2 105 (31.53%) ETL
3 66 (19.82%) Performance Tuning
4 45 (13.51%) Migration
5 40 (12.01%) Data Transformation
6 37 (11.11%) Project Management
7 36 (10.81%) Time Management
8 34 (10.21%) Disaster Recovery
9 32 (9.61%) Data Management
10 31 (9.31%) Web Development
11 28 (8.41%) Kimball Methodology
12 26 (7.81%) Data Migration
12 26 (7.81%) PRINCE2
13 25 (7.51%) Database Mirroring
14 24 (7.21%) Configuration Management
15 23 (6.91%) SDLC
16 21 (6.31%) Unit Testing
17 20 (6.01%) Data Analysis
17 20 (6.01%) Change Management
18 19 (5.71%) MVC
Programming Languages
1 299 (89.79%) SQL
2 229 (68.77%) T-SQL
3 114 (34.23%) C#
4 42 (12.61%) JavaScript
5 39 (11.71%) VBScript
6 24 (7.21%) VB
7 18 (5.41%) Java
8 15 (4.50%) VB.NET
9 14 (4.20%) PowerShell
10 6 (1.80%) VBA
11 3 (0.90%) VB6
12 2 (0.60%) XPath
12 2 (0.60%) C
12 2 (0.60%) PL/SQL
13 1 (0.30%) Apple Swift
13 1 (0.30%) Objective-C
13 1 (0.30%) PHP
Qualifications
1 48 (14.41%) Degree
2 9 (2.70%) Microsoft Certification
3 6 (1.80%) Security Cleared
4 4 (1.20%) Microsoft Certified Architect
4 4 (1.20%) MCTS
4 4 (1.20%) MCITP
4 4 (1.20%) MCDBA
5 3 (0.90%) ISEB
5 3 (0.90%) SC Cleared
6 2 (0.60%) PMI Certification
6 2 (0.60%) MCP
7 1 (0.30%) HND
7 1 (0.30%) MCSE
7 1 (0.30%) PMP
Quality Assurance & Compliance
1 34 (10.21%) SLA
2 29 (8.71%) QA
3 2 (0.60%) Sarbanes-Oxley
4 1 (0.30%) Data Quality
System Software
1 17 (5.11%) Active Directory
2 1 (0.30%) Veritas Cluster Server
2 1 (0.30%) SRDF
Systems Management
1 13 (3.90%) Puppet
2 7 (2.10%) SCOM
3 1 (0.30%) Opscode Chef
3 1 (0.30%) Systems Management Server (SMS)
3 1 (0.30%) Oracle RMAN
3 1 (0.30%) LiteSpeed
3 1 (0.30%) EMC NetWorker
Vendors
1 146 (43.84%) Microsoft
2 56 (16.82%) Cognos
3 26 (7.81%) VMware
4 22 (6.61%) Oracle
5 12 (3.60%) webMethods
6 10 (3.00%) SAP
7 9 (2.70%) Siebel
8 6 (1.80%) Salesforce.com
8 6 (1.80%) Teradata
8 6 (1.80%) Perforce
9 4 (1.20%) Business Objects
9 4 (1.20%) MicroStrategy
9 4 (1.20%) Tableau
10 3 (0.90%) IBM
11 2 (0.60%) Red Gate
11 2 (0.60%) Remedy
11 2 (0.60%) Alteryx
12 1 (0.30%) Xamarin
12 1 (0.30%) Ektron
12 1 (0.30%) NetApp
Reading, Berkshire
Venturi
Salary: £45000.00 - £55000.00 per annum + 30% bonus/benefits
Posted: 6 hours ago
Leeds, West Yorkshire
4it Recruitment Ltd
Salary: Up to £55,000 (dependent on experiance)
Posted: 6 hours ago
Portsmouth, Hampshire
Colston Consulting
Salary: £25k - 33k per year
Posted: 4 days ago
East London
Affinity Recruitment Ltd
Salary: From £45,000 to £55,000 per annum
Posted: 5 days ago
Borehamwood, Hertfordshire
Understanding Recruitment
Salary: £35000 - £45000 per annum + benefits
Posted: 5 days ago
Crawley, West Sussex
Ace European Group
Salary: £40000 per annum
Posted: 15 days ago