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

3 months to
25 Jun 2016
Same period 2015 Same period 2014
Microsoft Data Transformation Services (DTS)
Rank 835 810 682
Rank change year-on-year
-25 -128
Permanent jobs citing DTS 86 154 337
As % of all permanent IT jobs located in the UK 0.089% 0.14% 0.28%
As % of the Database & Business Intelligence category 0.30% 0.43% 0.87%
Number of salaries quoted 63 145 278
Median salary £45,000 £42,500 £44,000
Median salary % change year-on-year
+5.88% -3.40%
90% offered a salary of more than £28,000 £25,000 £30,000
10% offered a salary of more than £50,000 £60,000 £62,500
UK excluding London median salary £42,500 £40,000 £42,500
% change year-on-year
+6.25% -5.88%

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
29097 36092 38893
As % of all permanent IT jobs located in the UK 29.98% 32.61% 32.17%
Number of salaries quoted 24794 30450 33371
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 £31,500 £30,000
10% offered a salary of more than £72,500 £70,000 £70,000
UK excluding London median salary £42,500 £41,500 £40,000
% change year-on-year
+2.40% +3.75%

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 25 June 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 25 June 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 +2 81 £45,500 +7.05% 7
South East +55 19 £40,000 -5.88%
North West +17 15 £47,500 +18.75% 1
London +15 15 £47,500 -2.56% 2
Manchester +1 15 £47,500 +18.75% 1
Yorkshire +28 12 £38,000 +20.74% 1
West Yorkshire +13 11 £42,750 +40.42% 1
Halifax - 9 £38,000 - 1
East of England +21 8 £36,000 -20.00% 2
West Sussex +1 6 £39,250 -7.64%
Crawley - 6 £39,250 -
Kent +21 5 £26,000 -48.00%
East Midlands +11 5 £47,500 -5.00% 1
Chelmsford +8 5 £37,000 -24.10%
Essex +6 5 £37,000 -26.00%
Leicester - 5 £47,500 -
Leicestershire - 5 £47,500 - 1
Birmingham -12 4 - -
West Midlands -40 4 - -
South West +16 3 £22,250 +11.25%
Berkshire +10 3 £50,000 -
Hertfordshire +10 3 £35,000 -22.22% 2
Somerset - 3 £22,250 -
Bath - 3 £22,250 -
Wokingham - 2 £50,000 -
Lewes - 2 £39,525 -
East Sussex - 2 £39,525 -
Redhill - 2 £42,500 -
Surrey - 2 £42,500 -
City of London +36 1 £70,000 +12.00% 1

DTS
Top 30 Related IT Skills

For the 6 months to 25 June 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 149 (97.39%) SQL Server
2 141 (92.16%) SQL
3 102 (66.67%) SQL Server Integration Services
4 91 (59.48%) T-SQL
5 90 (58.82%) SQL Server Reporting Services
6 72 (47.06%) Microsoft
7 66 (43.14%) .NET
8 65 (42.48%) SQL Server 2008
9 61 (39.87%) Windows
10 47 (30.72%) Oracle
10 47 (30.72%) Business Intelligence
11 43 (28.10%) Replication
11 43 (28.10%) High Availability
12 40 (26.14%) Finance
13 38 (24.84%) ETL
13 38 (24.84%) Capacity Planning
14 37 (24.18%) SQL Server 2005
14 37 (24.18%) C#
15 35 (22.88%) SQL Server 2012
15 35 (22.88%) SQL Server 2014
16 32 (20.92%) XML
17 31 (20.26%) SAN
17 31 (20.26%) Performance Tuning
18 30 (19.61%) SDLC
19 29 (18.95%) SharePoint
19 29 (18.95%) PowerShell
20 28 (18.30%) SQL Server 2000
20 28 (18.30%) Performance Monitoring
21 26 (16.99%) Windows Server 2008
21 26 (16.99%) Clustering

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 29 (18.95%) SharePoint
2 22 (14.38%) BizTalk Server
3 17 (11.11%) IIS
4 7 (4.58%) SharePoint 2010
5 3 (1.96%) SAS
6 1 (0.65%) SharePoint 2013
Applications
1 14 (9.15%) MS Excel
2 5 (3.27%) MS Office
3 2 (1.31%) MS PowerPoint
Business Applications
1 9 (5.88%) Oracle 11i
2 3 (1.96%) Dynamics AX
3 2 (1.31%) Remedy ITSM
4 1 (0.65%) Cerner Millennium
4 1 (0.65%) Infor CRM
4 1 (0.65%) Sage CRM
Cloud Services
1 16 (10.46%) Microsoft Azure
2 1 (0.65%) Office 365
2 1 (0.65%) SaaS
Communications & Networking
1 31 (20.26%) SAN
2 16 (10.46%) Firewall
3 7 (4.58%) FTP
Database & Business Intelligence
1 149 (97.39%) SQL Server
2 102 (66.67%) SQL Server Integration Services
3 90 (58.82%) SQL Server Reporting Services
4 65 (42.48%) SQL Server 2008
5 37 (24.18%) SQL Server 2005
6 35 (22.88%) SQL Server 2012
6 35 (22.88%) SQL Server 2014
7 28 (18.30%) SQL Server 2000
8 24 (15.69%) Data Warehouse
8 24 (15.69%) SQL Server Analysis Services
9 22 (14.38%) Oracle Database
10 11 (7.19%) Oracle9i Database
11 10 (6.54%) Microsoft Analysis Services
12 9 (5.88%) Oracle Database 10g
13 5 (3.27%) Big Data
13 5 (3.27%) MySQL
13 5 (3.27%) Relational Database
14 4 (2.61%) OLAP
14 4 (2.61%) RDBMS
14 4 (2.61%) SQL Server 2016
Development Applications
1 18 (11.76%) Visual Studio
2 14 (9.15%) Team Foundation Server
3 7 (4.58%) Toad
4 3 (1.96%) ERwin
5 1 (0.65%) Git (software)
5 1 (0.65%) SQL Server Management Studio (SSMS)
5 1 (0.65%) Subversion
5 1 (0.65%) Visual Studio Team System
5 1 (0.65%) VSS/SourceSafe
General
1 40 (26.14%) Finance
2 18 (11.76%) Legal
3 13 (8.50%) Banking
4 9 (5.88%) French Language
4 9 (5.88%) Marketing
5 8 (5.23%) Financial Institution
6 7 (4.58%) Back Office
7 6 (3.92%) Retail
8 2 (1.31%) Advertising
8 2 (1.31%) Manufacturing
8 2 (1.31%) Telecoms
9 1 (0.65%) German Language
Job Titles
1 79 (51.63%) DBA
2 70 (45.75%) SQL DBA
3 41 (26.80%) Administrator
4 40 (26.14%) Developer
5 32 (20.92%) SQL Server DBA
6 27 (17.65%) SQL Developer
7 20 (13.07%) Analyst
8 15 (9.80%) .NET Developer
8 15 (9.80%) Software Developer
8 15 (9.80%) SQL Analyst
9 14 (9.15%) C# .NET Developer
9 14 (9.15%) C# Developer
10 12 (7.84%) .NET Software Developer
10 12 (7.84%) C# Software Developer
10 12 (7.84%) C# WCF Developer
10 12 (7.84%) WCF Developer
11 11 (7.19%) Junior
11 11 (7.19%) Support Analyst
12 10 (6.54%) Consultant
13 9 (5.88%) Technical Consultant
Libraries, Frameworks & Software Standards
1 66 (43.14%) .NET
2 32 (20.92%) XML
3 21 (13.73%) Web Services
4 20 (13.07%) HTML
5 12 (7.84%) ASP.NET
5 12 (7.84%) WCF
5 12 (7.84%) WPF
6 7 (4.58%) EDI
6 7 (4.58%) HTML5
6 7 (4.58%) REST
6 7 (4.58%) SOAP
7 4 (2.61%) .NET Framework
8 3 (1.96%) Classic ASP
8 3 (1.96%) Entity Framework
8 3 (1.96%) jQuery
9 2 (1.31%) MDX
10 1 (0.65%) ASP.NET MVC
10 1 (0.65%) CSS
10 1 (0.65%) WinForms
Miscellaneous
1 43 (28.10%) Replication
2 26 (16.99%) Clustering
3 11 (7.19%) Symmetrix
4 6 (3.92%) Data Centre
4 6 (3.92%) Enterprise Software
5 4 (2.61%) Analytical Skills
5 4 (2.61%) IBM XIV
5 4 (2.61%) Statistics
6 3 (1.96%) CLARiiON
6 3 (1.96%) Reinsurance
7 2 (1.31%) Computer Science
7 2 (1.31%) Data Integration
8 1 (0.65%) Driving Licence
8 1 (0.65%) Mathematics
8 1 (0.65%) Mobile App
8 1 (0.65%) NHS
8 1 (0.65%) Physics
Operating Systems
1 61 (39.87%) Windows
2 26 (16.99%) Windows Server 2008
3 25 (16.34%) Windows Server 2003
4 19 (12.42%) Windows Server 2012
5 11 (7.19%) Unix
5 11 (7.19%) Windows Server
6 10 (6.54%) Linux
Processes & Methodologies
1 47 (30.72%) Business Intelligence
2 43 (28.10%) High Availability
3 38 (24.84%) Capacity Planning
3 38 (24.84%) ETL
4 31 (20.26%) Performance Tuning
5 30 (19.61%) SDLC
6 28 (18.30%) Performance Monitoring
7 26 (16.99%) Performance Analysis
8 22 (14.38%) Database Tuning
9 19 (12.42%) Change Control
10 18 (11.76%) Migration
11 11 (7.19%) Data Migration
12 10 (6.54%) Analytics
12 10 (6.54%) Mentoring
13 9 (5.88%) CRM
13 9 (5.88%) Disaster Recovery
14 8 (5.23%) ERP
14 8 (5.23%) Software Architecture
14 8 (5.23%) Validation
15 7 (4.58%) Data Transformation
Programming Languages
1 141 (92.16%) SQL
2 91 (59.48%) T-SQL
3 37 (24.18%) C#
4 29 (18.95%) PowerShell
5 26 (16.99%) VB
6 25 (16.34%) VB.NET
7 19 (12.42%) Java
7 19 (12.42%) PHP
8 17 (11.11%) PL/SQL
9 8 (5.23%) JavaScript
10 7 (4.58%) XPath
11 3 (1.96%) FoxPro (VFP)
11 3 (1.96%) VB6
11 3 (1.96%) VBA
11 3 (1.96%) VBScript
12 1 (0.65%) R
Qualifications
1 9 (5.88%) Microsoft Certification
2 5 (3.27%) MCITP
2 5 (3.27%) MCTS
3 3 (1.96%) Degree
4 1 (0.65%) MCSA
4 1 (0.65%) MCSE
Quality Assurance & Compliance
1 5 (3.27%) SLA
2 2 (1.31%) QA
System Software
1 7 (4.58%) Oracle RAC
1 7 (4.58%) SRDF
2 1 (0.65%) Terminal Server
Systems Management
1 25 (16.34%) LiteSpeed
2 3 (1.96%) EMC NetWorker
Vendors
1 72 (47.06%) Microsoft
2 47 (30.72%) Oracle
3 19 (12.42%) Remedy
4 15 (9.80%) Cisco
5 11 (7.19%) EMC
6 8 (5.23%) IBM
7 4 (2.61%) Jaspersoft
8 2 (1.31%) Baan
8 2 (1.31%) BMC
8 2 (1.31%) Cognos
8 2 (1.31%) MicroStrategy
9 1 (0.65%) Cerner
9 1 (0.65%) Cognizant
9 1 (0.65%) JD Edwards
9 1 (0.65%) RedGate
9 1 (0.65%) Sage
Halifax, West Yorkshire
Fruition IT Resources Limited
Salary: £45000.00 - £55000.00 per annum + on call + bonus
Posted: Yesterday
City, London
Lawrence Harvey Enterprise
Salary: £65000.00 - £80000.00 per annum
Posted: 4 days ago
Hertfordshire
Venturi
Salary: £30000.00 - £40000.00 per annum + Benefits
Posted: 10 days ago
Leicestershire
Executive Resource Group
Salary: £50k - 55k per year + Benefits
Posted: 4 days ago
Hertfordshire
Venturi
Salary: £25000.00 - £30000.00 per annum + Benefits
Posted: 16 days ago
Central London / West End
Sothebys Institute
Salary: From £60,000 to £65,000 per annum 4% Pension contribution/Life Cover/2
Posted: 9 days ago
Manchester
Robert Walters UK
Salary: £40000 - £55000 per annum + Benefits
Posted: 24 days ago