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

3 months to
3 Dec 2016
Same period 2015 Same period 2014
Microsoft Data Transformation Services (DTS)
Rank 759 884 804
Rank change year-on-year
+125 -80
Permanent jobs citing DTS 106 85 182
As % of all permanent IT jobs located in the UK 0.12% 0.079% 0.16%
As % of the Database & Business Intelligence category 0.40% 0.25% 0.52%
Number of salaries quoted 91 61 157
Median salary £47,000 £40,000 £40,000
Median salary % change year-on-year
+17.50% -
90% offered a salary of more than £32,500 £30,459 £30,000
10% offered a salary of more than £72,000 £69,500 £56,000
UK excluding London median salary £44,000 £37,000 £38,250
% change year-on-year
+18.91% -3.26%

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
26700 34195 35140
As % of all permanent IT jobs located in the UK 29.88% 31.86% 30.57%
Number of salaries quoted 22878 28793 29983
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 £70,000 £70,000
UK excluding London median salary £45,000 £42,500 £40,000
% change year-on-year
+5.88% +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 3 December 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 3 December 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 +102 103 £47,000 +22.07% 10
London +82 47 £55,000 +15.78%
South East +91 26 £48,000 +29.72% 1
East of England - 16 £32,500 - 2
Hertfordshire - 13 £32,500 - 2
City of London +41 11 £72,000 -
Crawley - 8 £47,000 -
East Midlands - 8 £40,000 - 3
West Sussex - 8 £47,000 -
Kent - 7 £35,000 -
Berkshire +50 6 £53,750 +34.37%
Northamptonshire - 6 £40,000 - 1
Wokingham - 6 £53,750 -
Folkestone - 6 £33,750 -
Northampton - 5 £37,250 -
Leatherhead - 4 £47,750 -
Surrey - 4 £47,750 -
Scotland +27 3 - -
North West -24 3 £42,500 +9.67%
Glasgow - 3 - -
Borehamwood - 3 £45,000 -
Suffolk - 3 £43,000 -
Chorley +3 2 £40,000 -5.88%
Lancashire -1 2 £40,000 -5.88%
West Midlands -20 2 £42,500 +13.33%
Chessington - 2 £37,500 -
South West +11 1 £25,000 - 4
Manchester -22 1 £47,500 +35.71%
Buckinghamshire - 1 £42,500 - 1
Somerset - 1 £25,000 -

DTS
Top 30 Related IT Skills

For the 6 months to 3 December 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 219 (93.99%) SQL Server
2 205 (87.98%) SQL
3 175 (75.11%) SQL Server Integration Services
4 139 (59.66%) T-SQL
5 102 (43.78%) .NET
5 102 (43.78%) SQL Server Reporting Services
6 98 (42.06%) Microsoft
7 97 (41.63%) SQL Server 2008
8 86 (36.91%) Business Intelligence
9 83 (35.62%) C#
10 76 (32.62%) Finance
11 62 (26.61%) SQL Server 2005
11 62 (26.61%) ETL
12 60 (25.75%) SQL Server Analysis Services
12 60 (25.75%) SQL Server 2014
13 51 (21.89%) Windows
14 50 (21.46%) SQL Server 2000
15 46 (19.74%) Data Warehouse
15 46 (19.74%) Replication
16 44 (18.88%) SQL Server 2012
17 41 (17.60%) VB
18 37 (15.88%) ASP.NET
19 34 (14.59%) CSS
19 34 (14.59%) HTML
19 34 (14.59%) SharePoint
20 32 (13.73%) IIS
21 30 (12.88%) Performance Tuning
22 29 (12.45%) Clustering
22 29 (12.45%) MVC
23 27 (11.59%) SQL Server 2016

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 34 (14.59%) SharePoint
2 32 (13.73%) IIS
3 19 (8.15%) BizTalk Server
4 6 (2.58%) JBoss
5 4 (1.72%) WebSphere
5 4 (1.72%) WebSphere Application Server
6 2 (0.86%) Apache
6 2 (0.86%) CMS
6 2 (0.86%) Oracle 10gAS
6 2 (0.86%) Oracle Application Server
7 1 (0.43%) MS Exchange
7 1 (0.43%) SAS
7 1 (0.43%) WordPress
Applications
1 25 (10.73%) MS Excel
2 12 (5.15%) MS Office
3 4 (1.72%) Photoshop
Business Applications
1 5 (2.15%) Dynamics AX
2 3 (1.29%) Cognos TM1
3 2 (0.86%) Sage X3
4 1 (0.43%) SAP ERP
Cloud Services
1 5 (2.15%) Microsoft Azure
2 3 (1.29%) SaaS
Communications & Networking
1 9 (3.86%) SAN
2 5 (2.15%) Firewall
2 5 (2.15%) Intranet
3 1 (0.43%) FTP
3 1 (0.43%) TCP/IP
Database & Business Intelligence
1 219 (93.99%) SQL Server
2 175 (75.11%) SQL Server Integration Services
3 102 (43.78%) SQL Server Reporting Services
4 97 (41.63%) SQL Server 2008
5 62 (26.61%) SQL Server 2005
6 60 (25.75%) SQL Server 2014
6 60 (25.75%) SQL Server Analysis Services
7 50 (21.46%) SQL Server 2000
8 46 (19.74%) Data Warehouse
9 44 (18.88%) SQL Server 2012
10 27 (11.59%) SQL Server 2016
11 16 (6.87%) Microsoft Analysis Services
11 16 (6.87%) ProClarity
12 15 (6.44%) Relational Database
13 14 (6.01%) RDBMS
14 11 (4.72%) QlikView
15 10 (4.29%) DB2
16 8 (3.43%) OLAP
16 8 (3.43%) Power BI
17 7 (3.00%) Big Data
Development Applications
1 19 (8.15%) SQL Server Management Studio (SSMS)
2 10 (4.29%) Visual Studio
3 6 (2.58%) Jenkins
3 6 (2.58%) Octopus Deploy
3 6 (2.58%) TeamCity
4 5 (2.15%) Visual Studio Team System
5 4 (1.72%) Team Foundation Server
6 3 (1.29%) Oracle Forms
7 2 (0.86%) MorphX
7 2 (0.86%) PVCS
8 1 (0.43%) Bitbucket
8 1 (0.43%) JIRA
8 1 (0.43%) Toad
General
1 76 (32.62%) Finance
2 22 (9.44%) Back Office
3 21 (9.01%) Legal
4 15 (6.44%) Marketing
5 12 (5.15%) Retail
6 8 (3.43%) Banking
7 6 (2.58%) Music Industry
8 3 (1.29%) Billing
8 3 (1.29%) Financial Institution
9 1 (0.43%) Advertising
9 1 (0.43%) Investment Banking
9 1 (0.43%) Law
9 1 (0.43%) Manufacturing
Job Titles
1 89 (38.20%) Developer
2 72 (30.90%) DBA
3 71 (30.47%) SQL DBA
4 42 (18.03%) Analyst
5 41 (17.60%) SQL Server DBA
6 35 (15.02%) .NET Developer
7 34 (14.59%) SQL Analyst
8 32 (13.73%) C# Developer
8 32 (13.73%) SQL Developer
9 28 (12.02%) C# .NET Developer
10 26 (11.16%) SSIS Analyst
11 21 (9.01%) Support Analyst
12 19 (8.15%) Administrator
12 19 (8.15%) SQL Support Analyst
13 18 (7.73%) SSIS Developer
14 16 (6.87%) Business Intelligence Analyst
14 16 (6.87%) SQL Server Analyst
15 15 (6.44%) Architect
15 15 (6.44%) T-SQL Developer
16 13 (5.58%) Business Intelligence Support Analyst
Libraries, Frameworks & Software Standards
1 102 (43.78%) .NET
2 37 (15.88%) ASP.NET
3 34 (14.59%) CSS
3 34 (14.59%) HTML
4 25 (10.73%) XML
5 20 (8.58%) Ajax
6 19 (8.15%) jQuery
7 16 (6.87%) WCF
8 14 (6.01%) Web Services
9 12 (5.15%) ASP.NET MVC
10 11 (4.72%) Classic ASP
11 10 (4.29%) ASP.NET MVC 3
11 10 (4.29%) DHTML
11 10 (4.29%) WPF
12 6 (2.58%) REST
13 5 (2.15%) AngularJS
13 5 (2.15%) React
14 4 (1.72%) .NET Framework
14 4 (1.72%) J2EE
14 4 (1.72%) JSON
Miscellaneous
1 46 (19.74%) Replication
2 29 (12.45%) Clustering
3 23 (9.87%) Enterprise Software
4 17 (7.30%) Data Centre
5 15 (6.44%) Reinsurance
6 14 (6.01%) Analytical Skills
7 13 (5.58%) Management Information System
8 10 (4.29%) PMI
9 8 (3.43%) Mobile App
10 7 (3.00%) Computer Science
11 6 (2.58%) AS400
12 5 (2.15%) Data Integration
12 5 (2.15%) Visualisation
13 4 (1.72%) iSeries
13 4 (1.72%) Mathematics
14 3 (1.29%) Physics
14 3 (1.29%) Statistics
14 3 (1.29%) Symmetrix
14 3 (1.29%) User Experience
15 1 (0.43%) Data Extraction
Operating Systems
1 51 (21.89%) Windows
2 15 (6.44%) Windows Server
3 12 (5.15%) Windows Server 2003
4 10 (4.29%) Windows Server 2008
5 7 (3.00%) Windows Server 2012
6 2 (0.86%) Linux
6 2 (0.86%) Unix
6 2 (0.86%) Windows 2000
7 1 (0.43%) Windows Vista
7 1 (0.43%) Windows XP
Processes & Methodologies
1 86 (36.91%) Business Intelligence
2 62 (26.61%) ETL
3 30 (12.88%) Performance Tuning
4 29 (12.45%) MVC
5 24 (10.30%) SDLC
6 21 (9.01%) Change Management
6 21 (9.01%) Database Mirroring
7 20 (8.58%) Data Transformation
8 18 (7.73%) High Availability
9 17 (7.30%) Project Management
10 15 (6.44%) PRINCE2
11 14 (6.01%) Data Management
11 14 (6.01%) Server Building
12 13 (5.58%) Analytics
12 13 (5.58%) Time Management
13 12 (5.15%) Case Management
14 11 (4.72%) Agile Software Development
14 11 (4.72%) TDD
14 11 (4.72%) Workflow
15 10 (4.29%) Mentoring
Programming Languages
1 205 (87.98%) SQL
2 139 (59.66%) T-SQL
3 83 (35.62%) C#
4 41 (17.60%) VB
5 26 (11.16%) JavaScript
6 22 (9.44%) Java
7 17 (7.30%) VB.NET
8 16 (6.87%) PowerShell
9 13 (5.58%) PHP
9 13 (5.58%) PL/SQL
10 11 (4.72%) VB6
11 4 (1.72%) R
12 3 (1.29%) VBA
13 2 (0.86%) X++
14 1 (0.43%) C
14 1 (0.43%) FoxPro (VFP)
14 1 (0.43%) PHP 5
14 1 (0.43%) VBScript
Qualifications
1 18 (7.73%) Microsoft Certification
2 17 (7.30%) Degree
3 10 (4.29%) PMI Certification
4 6 (2.58%) MCITP
4 6 (2.58%) MCTS
5 4 (1.72%) DV Cleared
5 4 (1.72%) Security Cleared
6 1 (0.43%) ISEB
Quality Assurance & Compliance
1 20 (8.58%) SLA
2 4 (1.72%) QA
System Software
1 3 (1.29%) Active Directory
2 1 (0.43%) Oracle RAC
2 1 (0.43%) VMware Infrastructure
Systems Management
1 14 (6.01%) Perfmon
2 7 (3.00%) SCOM
3 6 (2.58%) Puppet
4 5 (2.15%) Failover Clustering
4 5 (2.15%) LiteSpeed
5 1 (0.43%) Control-M
Vendors
1 98 (42.06%) Microsoft
2 27 (11.59%) Oracle
3 22 (9.44%) VMware
4 16 (6.87%) MicroStrategy
5 9 (3.86%) Cognos
6 8 (3.43%) Remedy
6 8 (3.43%) Tableau
7 6 (2.58%) webMethods
8 5 (2.15%) Cisco
8 5 (2.15%) IBM
8 5 (2.15%) SAP
9 4 (1.72%) Adobe
10 3 (1.29%) EMC
11 2 (0.86%) OpenText
11 2 (0.86%) Pega
11 2 (0.86%) Sage
11 2 (0.86%) Salesforce.com
11 2 (0.86%) Serena
12 1 (0.43%) Citrix
12 1 (0.43%) JD Edwards
Hertfordshire
Venturi
Salary: £30000 - £35000 per annum + Plus Benefits
Posted: Yesterday
Milton Keynes, Buckinghamshire
IT Retail People Ltd
Salary: Unspecified Excellent Package, 28 days paid holiday
Posted: Yesterday
Leicester, Leicestershire
ReThink Recruitment
Posted: 5 days ago
Chippenham, Wiltshire
Aximis (West) Limited
Salary: Up to £40K + Excellent Benefits
Posted: 5 days ago
Bristol, Avon
Aximis (West) Limited
Salary: Up to £40K + Excellent Benefits
Posted: 5 days ago
Swindon, Wiltshire
Aximis (West) Limited
Salary: Up to £40K + Excellent Benefits
Posted: 5 days ago
Cheltenham, Gloucestershire
Aximis (West) Limited
Salary: Up to £40K + Excellent Benefits
Posted: 5 days ago
Hertfordshire
Venturi
Salary: £18000.00 - £25000.00 per annum + Plus Benefits
Posted: 16 days ago
Northamptonshire
Deerfoot IT Resources Ltd
Salary: £35000 - £45000 per annum
Posted: 19 days ago