The table below looks at the statistics for DTS skills in IT jobs advertised across the UK. 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 784 863 804
Rank change year-on-year
+79 -59
Permanent jobs citing DTS 128 112 183
As % of all permanent IT jobs located in the UK 0.13% 0.10% 0.16%
As % of the Database & Business Intelligence category 0.45% 0.33% 0.51%
Number of salaries quoted 109 102 153
Median salary £47,000 £50,000 £40,000
Median salary % change year-on-year
-6.00% +25.00%
90% offered a salary of more than £37,000 £35,000 £30,000
10% offered a salary of more than £65,000 £72,000 £59,500
UK excluding London median salary £47,000 £45,000 £37,750
% change year-on-year
+4.44% +19.20%

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
28179 33556 35816
As % of all permanent IT jobs located in the UK 29.58% 30.76% 31.31%
Number of salaries quoted 23978 28423 30045
Median salary £50,000 £47,500 £45,000
Median salary % change year-on-year
+5.26% +5.55%
90% offered a salary of more than £32,500 £32,500 £30,000
10% offered a salary of more than £75,000 £67,500 £72,500
UK excluding London median salary £43,000 £42,500 £40,000
% change year-on-year
+1.17% +6.25%

DTS
Jobs Demand Trend

The demand trend of job ads citing DTS as a proportion of all IT jobs with a match in 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 30 September 2016 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 median salaries quoted in IT jobs citing DTS within the UK 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
England +77 123 £47,000 -6.00% 8
London +71 56 £48,500 -15.65% 1
South East +60 30 £47,000 +22.87% 3
East of England +15 18 £40,000 -9.09% 1
Essex +9 16 £40,000 -20.00%
City of London +53 15 £50,000 -30.55%
Crawley - 11 £47,000 - 1
West Sussex - 11 £47,000 - 1
North West - 9 £42,500 - 1
Kent +21 8 £35,000 -22.22% 1
Chelmsford -1 8 £65,000 +47.72%
Chorley - 8 £42,500 -
Lancashire - 8 £42,500 -
Berkshire +17 6 £52,500 +5.00% 1
Wokingham - 6 £52,500 - 1
Folkestone - 5 £35,000 - 1
Leatherhead - 4 £47,750 -
Surrey - 4 £47,750 -
Glasgow +23 3 - -
East Midlands +21 3 £52,500 +75.00%
Scotland +17 3 - - 1
South West -3 3 £30,000 -20.00% 1
West Yorkshire +22 2 £50,000 -9.09%
Cardiff +15 2 £39,500 -12.22%
Hertfordshire +12 2 £37,500 -11.76% 1
Yorkshire +10 2 £50,000 -28.05%
South Wales +8 2 £39,500 +13.66%
Wales +2 2 £39,500 +13.66%
West Midlands -7 2 £60,000 +140.00%
Gloucestershire -11 2 £40,000 +22.13%

DTS
Top 30 Related IT Skills

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 with a requirement for DTS.

1 210 (96.33%) SQL Server
2 195 (89.45%) SQL
3 162 (74.31%) SQL Server Integration Services
4 136 (62.39%) T-SQL
5 106 (48.62%) SQL Server Reporting Services
6 89 (40.83%) .NET
7 86 (39.45%) Microsoft
8 81 (37.16%) SQL Server 2008
9 76 (34.86%) Business Intelligence
10 72 (33.03%) C#
11 62 (28.44%) Finance
12 61 (27.98%) ETL
13 58 (26.61%) Windows
14 57 (26.15%) SQL Server 2005
15 55 (25.23%) SQL Server Analysis Services
16 49 (22.48%) Replication
17 48 (22.02%) Data Warehouse
17 48 (22.02%) SQL Server 2012
18 45 (20.64%) SQL Server 2014
19 43 (19.72%) SQL Server 2000
20 42 (19.27%) VB
21 40 (18.35%) Oracle
22 37 (16.97%) ASP.NET
22 37 (16.97%) SharePoint
22 37 (16.97%) Performance Tuning
23 31 (14.22%) IIS
24 29 (13.30%) Clustering
24 29 (13.30%) SDLC
25 28 (12.84%) High Availability
25 28 (12.84%) XML

DTS
Top Related IT Skills 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 37 (16.97%) SharePoint
2 31 (14.22%) IIS
3 15 (6.88%) BizTalk Server
4 4 (1.83%) SAS
4 4 (1.83%) WebSphere
4 4 (1.83%) WebSphere Application Server
5 2 (0.92%) Apache
5 2 (0.92%) JBoss
5 2 (0.92%) Oracle 10gAS
5 2 (0.92%) Oracle Application Server
6 1 (0.46%) SharePoint 2010
6 1 (0.46%) SharePoint 2013
Applications
1 19 (8.72%) MS Excel
2 14 (6.42%) MS Office
3 4 (1.83%) Photoshop
4 2 (0.92%) MS PowerPoint
Business Applications
1 6 (2.75%) Dynamics AX
1 6 (2.75%) Oracle 11i
2 2 (0.92%) Cognos TM1
3 1 (0.46%) Cerner Millennium
3 1 (0.46%) Sage X3
Cloud Services
1 12 (5.50%) Microsoft Azure
2 2 (0.92%) SaaS
Communications & Networking
1 16 (7.34%) SAN
2 13 (5.96%) Firewall
3 3 (1.38%) FTP
4 2 (0.92%) Intranet
Database & Business Intelligence
1 210 (96.33%) SQL Server
2 162 (74.31%) SQL Server Integration Services
3 106 (48.62%) SQL Server Reporting Services
4 81 (37.16%) SQL Server 2008
5 57 (26.15%) SQL Server 2005
6 55 (25.23%) SQL Server Analysis Services
7 48 (22.02%) Data Warehouse
7 48 (22.02%) SQL Server 2012
8 45 (20.64%) SQL Server 2014
9 43 (19.72%) SQL Server 2000
10 19 (8.72%) SQL Server 2016
11 17 (7.80%) ProClarity
12 14 (6.42%) Microsoft Analysis Services
12 14 (6.42%) Oracle Database
13 9 (4.13%) DB2
14 8 (3.67%) Big Data
14 8 (3.67%) Oracle Database 10g
14 8 (3.67%) Oracle9i Database
14 8 (3.67%) QlikView
15 6 (2.75%) Relational Database
Development Applications
1 12 (5.50%) SQL Server Management Studio (SSMS)
2 9 (4.13%) Visual Studio
3 4 (1.83%) Team Foundation Server
4 3 (1.38%) Toad
4 3 (1.38%) Visual Studio Team System
5 2 (0.92%) Jenkins
5 2 (0.92%) MorphX
5 2 (0.92%) Octopus Deploy
5 2 (0.92%) Oracle Forms
5 2 (0.92%) PVCS
5 2 (0.92%) TeamCity
6 1 (0.46%) ERwin
6 1 (0.46%) Git (software)
6 1 (0.46%) Subversion
6 1 (0.46%) VSS/SourceSafe
General
1 62 (28.44%) Finance
2 19 (8.72%) Back Office
3 14 (6.42%) Marketing
4 11 (5.05%) Legal
5 8 (3.67%) Retail
6 7 (3.21%) Financial Institution
7 6 (2.75%) French Language
7 6 (2.75%) Music Industry
8 4 (1.83%) Banking
9 2 (0.92%) Telecoms
10 1 (0.46%) Advertising
10 1 (0.46%) Billing
10 1 (0.46%) Investment Banking
Job Titles
1 85 (38.99%) DBA
2 81 (37.16%) SQL DBA
3 72 (33.03%) Developer
4 40 (18.35%) SQL Server DBA
5 35 (16.06%) .NET Developer
6 31 (14.22%) Analyst
7 29 (13.30%) Administrator
7 29 (13.30%) C# Developer
8 28 (12.84%) C# .NET Developer
9 25 (11.47%) SQL Analyst
10 24 (11.01%) SQL Developer
11 23 (10.55%) Support Analyst
12 18 (8.26%) SQL Support Analyst
13 17 (7.80%) SSIS Analyst
14 16 (7.34%) Business Intelligence Analyst
14 16 (7.34%) SQL Server Analyst
15 14 (6.42%) Business Intelligence Support Analyst
15 14 (6.42%) Junior
16 11 (5.05%) Business Intelligence Developer
17 10 (4.59%) Business Support Analyst
Libraries, Frameworks & Software Standards
1 89 (40.83%) .NET
2 37 (16.97%) ASP.NET
3 28 (12.84%) XML
4 26 (11.93%) HTML
5 24 (11.01%) CSS
6 20 (9.17%) Ajax
7 18 (8.26%) jQuery
8 14 (6.42%) Classic ASP
9 11 (5.05%) ASP.NET MVC
9 11 (5.05%) Web Services
10 10 (4.59%) ASP.NET MVC 3
10 10 (4.59%) DHTML
11 7 (3.21%) WCF
11 7 (3.21%) WPF
12 5 (2.29%) .NET Framework
13 4 (1.83%) Entity Framework
13 4 (1.83%) J2EE
14 3 (1.38%) HTML5
14 3 (1.38%) SOAP
15 2 (0.92%) JSON
Miscellaneous
1 49 (22.48%) Replication
2 29 (13.30%) Clustering
3 19 (8.72%) Enterprise Software
4 17 (7.80%) Data Centre
5 14 (6.42%) Reinsurance
6 11 (5.05%) Analytical Skills
7 6 (2.75%) Computer Science
7 6 (2.75%) PMI
7 6 (2.75%) Symmetrix
8 5 (2.29%) AS400
8 5 (2.29%) Management Information System
9 4 (1.83%) iSeries
9 4 (1.83%) Mobile App
10 3 (1.38%) Mathematics
11 2 (0.92%) Data Integration
11 2 (0.92%) Physics
11 2 (0.92%) Statistics
12 1 (0.46%) CLARiiON
12 1 (0.46%) NHS
12 1 (0.46%) User Experience
Operating Systems
1 58 (26.61%) Windows
2 16 (7.34%) Windows Server
3 11 (5.05%) Windows Server 2003
4 10 (4.59%) Windows Server 2008
5 6 (2.75%) Unix
6 5 (2.29%) Windows Server 2012
7 4 (1.83%) Linux
8 1 (0.46%) Windows 2000
8 1 (0.46%) Windows Vista
8 1 (0.46%) Windows XP
Processes & Methodologies
1 76 (34.86%) Business Intelligence
2 61 (27.98%) ETL
3 37 (16.97%) Performance Tuning
4 29 (13.30%) SDLC
5 28 (12.84%) High Availability
6 22 (10.09%) Change Management
7 20 (9.17%) Database Mirroring
7 20 (9.17%) MVC
8 19 (8.72%) Data Transformation
8 19 (8.72%) Database Tuning
9 16 (7.34%) Capacity Planning
10 15 (6.88%) Data Management
10 15 (6.88%) Migration
11 14 (6.42%) Change Control
11 14 (6.42%) Server Building
12 12 (5.50%) Analytics
12 12 (5.50%) Performance Monitoring
12 12 (5.50%) Project Management
13 10 (4.59%) Performance Analysis
13 10 (4.59%) PRINCE2
Programming Languages
1 195 (89.45%) SQL
2 136 (62.39%) T-SQL
3 72 (33.03%) C#
4 42 (19.27%) VB
5 26 (11.93%) VB.NET
6 20 (9.17%) JavaScript
7 19 (8.72%) PL/SQL
8 18 (8.26%) PowerShell
9 14 (6.42%) Java
9 14 (6.42%) VB6
10 10 (4.59%) PHP
11 4 (1.83%) FoxPro (VFP)
11 4 (1.83%) VBA
12 2 (0.92%) R
12 2 (0.92%) VBScript
12 2 (0.92%) X++
13 1 (0.46%) XPath
Qualifications
1 11 (5.05%) Degree
2 9 (4.13%) Microsoft Certification
3 6 (2.75%) MCITP
3 6 (2.75%) MCTS
3 6 (2.75%) PMI Certification
4 4 (1.83%) DV Cleared
4 4 (1.83%) Security Cleared
Quality Assurance & Compliance
1 20 (9.17%) SLA
2 5 (2.29%) QA
System Software
1 3 (1.38%) Oracle RAC
2 2 (0.92%) Active Directory
2 2 (0.92%) SRDF
3 1 (0.46%) Terminal Server
3 1 (0.46%) VMware Infrastructure
Systems Management
1 11 (5.05%) LiteSpeed
2 10 (4.59%) Perfmon
3 4 (1.83%) Failover Clustering
3 4 (1.83%) SCOM
4 2 (0.92%) Puppet
5 1 (0.46%) EMC NetWorker
Vendors
1 86 (39.45%) Microsoft
2 40 (18.35%) Oracle
3 17 (7.80%) MicroStrategy
4 14 (6.42%) Remedy
5 13 (5.96%) VMware
6 12 (5.50%) Cisco
7 7 (3.21%) Cognos
8 6 (2.75%) EMC
8 6 (2.75%) IBM
9 4 (1.83%) Adobe
9 4 (1.83%) Tableau
10 3 (1.38%) Jaspersoft
11 2 (0.92%) Serena
11 2 (0.92%) webMethods
12 1 (0.46%) Cerner
12 1 (0.46%) Cognizant
12 1 (0.46%) JD Edwards
12 1 (0.46%) OpenText
12 1 (0.46%) RedGate
12 1 (0.46%) Sage
Hertfordshire
Venturi
Salary: £30000.00 - £35000.00 per annum + Plus Benefits
Posted: Yesterday
Crawley, West Sussex
Comtecs
Salary: £42000 - £50000 Per Annum
Posted: 3 days ago
Bath, Avon
Redrock Consulting Ltd
Salary: £40000 - £47000 per annum + Excellent Benefits
Posted: 6 days ago
London
Marcus Donald People
Salary: £70000 - £80000 per annum
Posted: 3 days ago
Ayrshire
NSK International Consultants Ltd
Salary: From £40,000 to £47,000 per annum
Posted: 3 days ago
Manchester
Robert Walters UK
Salary: £40000 - £55000 per annum + Benefits
Posted: 16 days ago
Folkestone
Deerfoot IT Resources Ltd
Salary: £30000 - £35000 per annum
Posted: 17 days ago