The table below looks at the statistics for DTS skills in IT jobs advertised for the England region. Included is a guide to the salaries offered in IT jobs that have cited DTS over the 3 months to 25 September 2016 with a comparison to the same period over the previous 2 years.

3 months to
25 Sep 2016
Same period 2015 Same period 2014
Microsoft Data Transformation Services (DTS)
Rank 761 827 792
Rank change year-on-year
+66 -35
Permanent jobs citing DTS 121 110 174
As % of all permanent IT jobs located in England 0.14% 0.11% 0.16%
As % of the Database & Business Intelligence category 0.46% 0.35% 0.52%
Number of salaries quoted 105 102 150
Median salary £47,000 £50,000 £40,250
Median salary % change year-on-year
-6.00% +24.22%
90% offered a salary of more than £37,000 £35,000 £30,000
10% offered a salary of more than £65,000 £72,000 £60,000
UK excluding London median salary £46,000 £45,000 £38,250
% change year-on-year
+2.22% +17.64%
DTS
UK

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 England region.

Database & Business Intelligence Category
England
Permanent IT job ads with a match in the
Database & Business Intelligence category
26205 31710 33587
As % of all permanent IT jobs located in England 29.53% 30.95% 31.48%
Number of salaries quoted 22521 27046 28468
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 £42,500 £42,500 £40,000
% change year-on-year
- +6.25%

DTS
Jobs Demand Trend in England

The demand trend of job ads across the England region citing DTS as a proportion of all IT jobs with a match in the Database & Business Intelligence category.

DTS Jobs Demand Trend in England

DTS
Salary Trend in England

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing DTS across the England region.

DTS Salary Trend in England

DTS
Salary Histogram in England

This chart provides a salary histogram for IT jobs citing DTS across the England region over the 3 months to 25 September 2016.

DTS Salary Histogram in England

DTS
Job Locations in England

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing DTS within the England region over the 3 months to 25 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
London +69 51 £48,500 -15.65% 2
South East +65 27 £47,000 +20.51% 3
East of England +5 20 £40,000 -9.09%
North West +23 9 £42,500 +8.97% 1
East Midlands +10 4 £52,500 +75.00%
Yorkshire +7 4 £50,000 -28.05%
South West -2 3 £30,000 -20.00% 1
West Midlands -7 3 £60,000 +140.00%
DTS
UK

DTS
Top 30 Related IT Skills in England

For the 6 months to 25 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 across the England region with a requirement for DTS.

1 194 (96.04%) SQL Server
2 181 (89.60%) SQL
3 149 (73.76%) SQL Server Integration Services
4 127 (62.87%) T-SQL
5 99 (49.01%) SQL Server Reporting Services
6 85 (42.08%) .NET
7 79 (39.11%) SQL Server 2008
8 74 (36.63%) Microsoft
9 72 (35.64%) Business Intelligence
10 71 (35.15%) C#
11 62 (30.69%) Finance
12 59 (29.21%) ETL
13 55 (27.23%) Windows
14 51 (25.25%) SQL Server 2005
15 50 (24.75%) SQL Server Analysis Services
16 45 (22.28%) Data Warehouse
17 44 (21.78%) Replication
17 44 (21.78%) SQL Server 2014
18 42 (20.79%) SQL Server 2000
19 41 (20.30%) VB
19 41 (20.30%) SQL Server 2012
20 37 (18.32%) Oracle
21 35 (17.33%) ASP.NET
21 35 (17.33%) SharePoint
22 34 (16.83%) Performance Tuning
23 30 (14.85%) SDLC
24 28 (13.86%) IIS
25 26 (12.87%) XML
25 26 (12.87%) VB.NET
26 25 (12.38%) High Availability

DTS
Top Related IT Skills in England 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 35 (17.33%) SharePoint
2 28 (13.86%) IIS
3 13 (6.44%) BizTalk Server
4 4 (1.98%) SAS
4 4 (1.98%) WebSphere
4 4 (1.98%) WebSphere Application Server
5 1 (0.50%) SharePoint 2010
5 1 (0.50%) SharePoint 2013
Applications
1 13 (6.44%) MS Office
2 12 (5.94%) MS Excel
3 4 (1.98%) Photoshop
4 2 (0.99%) MS PowerPoint
Business Applications
1 7 (3.47%) Oracle 11i
2 4 (1.98%) Dynamics AX
3 2 (0.99%) Cognos TM1
4 1 (0.50%) Sage X3
Cloud Services
1 12 (5.94%) Microsoft Azure
2 2 (0.99%) SaaS
Communications & Networking
1 17 (8.42%) SAN
2 13 (6.44%) Firewall
3 3 (1.49%) FTP
Database & Business Intelligence
1 194 (96.04%) SQL Server
2 149 (73.76%) SQL Server Integration Services
3 99 (49.01%) SQL Server Reporting Services
4 79 (39.11%) SQL Server 2008
5 51 (25.25%) SQL Server 2005
6 50 (24.75%) SQL Server Analysis Services
7 45 (22.28%) Data Warehouse
8 44 (21.78%) SQL Server 2014
9 42 (20.79%) SQL Server 2000
10 41 (20.30%) SQL Server 2012
11 18 (8.91%) SQL Server 2016
12 17 (8.42%) ProClarity
13 14 (6.93%) Microsoft Analysis Services
14 12 (5.94%) Oracle Database
15 9 (4.46%) Oracle9i Database
16 8 (3.96%) Big Data
16 8 (3.96%) DB2
17 7 (3.47%) Oracle Database 10g
17 7 (3.47%) QlikView
18 5 (2.48%) Relational Database
Development Applications
1 11 (5.45%) SQL Server Management Studio (SSMS)
2 8 (3.96%) Visual Studio
3 5 (2.48%) Team Foundation Server
4 3 (1.49%) Toad
5 1 (0.50%) ERwin
5 1 (0.50%) Git (software)
5 1 (0.50%) Subversion
5 1 (0.50%) Visual Studio Team System
5 1 (0.50%) VSS/SourceSafe
General
1 62 (30.69%) Finance
2 18 (8.91%) Back Office
3 14 (6.93%) Marketing
4 12 (5.94%) Legal
5 8 (3.96%) Retail
6 7 (3.47%) Financial Institution
6 7 (3.47%) French Language
7 5 (2.48%) Banking
7 5 (2.48%) Music Industry
8 2 (0.99%) Telecoms
9 1 (0.50%) Advertising
9 1 (0.50%) Billing
9 1 (0.50%) Investment Banking
Job Titles
1 81 (40.10%) DBA
2 77 (38.12%) SQL DBA
3 65 (32.18%) Developer
4 39 (19.31%) SQL Server DBA
5 33 (16.34%) .NET Developer
6 29 (14.36%) Administrator
7 28 (13.86%) Analyst
7 28 (13.86%) C# Developer
8 27 (13.37%) C# .NET Developer
9 23 (11.39%) SQL Developer
10 22 (10.89%) SQL Analyst
10 22 (10.89%) Support Analyst
11 17 (8.42%) SQL Support Analyst
11 17 (8.42%) SSIS Analyst
12 16 (7.92%) SQL Server Analyst
13 14 (6.93%) Business Intelligence Analyst
13 14 (6.93%) Business Intelligence Support Analyst
14 13 (6.44%) Junior
15 11 (5.45%) Business Intelligence Developer
16 10 (4.95%) Business Support Analyst
Libraries, Frameworks & Software Standards
1 85 (42.08%) .NET
2 35 (17.33%) ASP.NET
3 26 (12.87%) XML
4 23 (11.39%) HTML
5 20 (9.90%) CSS
6 17 (8.42%) Ajax
7 15 (7.43%) jQuery
8 13 (6.44%) Classic ASP
9 10 (4.95%) ASP.NET MVC
10 9 (4.46%) ASP.NET MVC 3
10 9 (4.46%) DHTML
10 9 (4.46%) Web Services
11 7 (3.47%) WCF
11 7 (3.47%) WPF
12 5 (2.48%) .NET Framework
13 4 (1.98%) Entity Framework
13 4 (1.98%) J2EE
14 2 (0.99%) AngularJS
14 2 (0.99%) MDX
14 2 (0.99%) React
Miscellaneous
1 44 (21.78%) Replication
2 24 (11.88%) Clustering
3 16 (7.92%) Data Centre
3 16 (7.92%) Enterprise Software
4 13 (6.44%) Reinsurance
5 11 (5.45%) Analytical Skills
6 6 (2.97%) Symmetrix
7 5 (2.48%) PMI
8 4 (1.98%) AS400
8 4 (1.98%) iSeries
8 4 (1.98%) Mobile App
9 3 (1.49%) Computer Science
9 3 (1.49%) Management Information System
9 3 (1.49%) Mathematics
10 2 (0.99%) Physics
10 2 (0.99%) Statistics
11 1 (0.50%) CLARiiON
11 1 (0.50%) IBM XIV
11 1 (0.50%) User Experience
Operating Systems
1 55 (27.23%) Windows
2 14 (6.93%) Windows Server
3 12 (5.94%) Windows Server 2003
4 11 (5.45%) Windows Server 2008
5 6 (2.97%) Unix
5 6 (2.97%) Windows Server 2012
6 4 (1.98%) Linux
7 1 (0.50%) Windows 2000
7 1 (0.50%) Windows Vista
7 1 (0.50%) Windows XP
Processes & Methodologies
1 72 (35.64%) Business Intelligence
2 59 (29.21%) ETL
3 34 (16.83%) Performance Tuning
4 30 (14.85%) SDLC
5 25 (12.38%) High Availability
6 22 (10.89%) Change Management
7 19 (9.41%) Database Mirroring
8 18 (8.91%) Data Transformation
9 17 (8.42%) Capacity Planning
10 16 (7.92%) MVC
11 15 (7.43%) Database Tuning
11 15 (7.43%) Migration
12 14 (6.93%) Change Control
12 14 (6.93%) Data Management
13 13 (6.44%) Performance Monitoring
13 13 (6.44%) Server Building
14 12 (5.94%) Analytics
15 11 (5.45%) Performance Analysis
16 9 (4.46%) Unit Testing
17 8 (3.96%) TDD
Programming Languages
1 181 (89.60%) SQL
2 127 (62.87%) T-SQL
3 71 (35.15%) C#
4 41 (20.30%) VB
5 26 (12.87%) VB.NET
6 19 (9.41%) PowerShell
7 17 (8.42%) PL/SQL
8 16 (7.92%) JavaScript
9 13 (6.44%) VB6
10 12 (5.94%) Java
11 8 (3.96%) PHP
12 4 (1.98%) FoxPro (VFP)
12 4 (1.98%) VBA
13 2 (0.99%) R
13 2 (0.99%) VBScript
14 1 (0.50%) XPath
Qualifications
1 8 (3.96%) Microsoft Certification
2 5 (2.48%) Degree
2 5 (2.48%) MCITP
2 5 (2.48%) MCTS
2 5 (2.48%) PMI Certification
3 4 (1.98%) DV Cleared
3 4 (1.98%) Security Cleared
Quality Assurance & Compliance
1 20 (9.90%) SLA
2 4 (1.98%) QA
System Software
1 3 (1.49%) Oracle RAC
2 2 (0.99%) Active Directory
2 2 (0.99%) SRDF
3 1 (0.50%) Terminal Server
3 1 (0.50%) VMware Infrastructure
Systems Management
1 12 (5.94%) LiteSpeed
2 9 (4.46%) Perfmon
3 4 (1.98%) Failover Clustering
3 4 (1.98%) SCOM
4 1 (0.50%) EMC NetWorker
Vendors
1 74 (36.63%) Microsoft
2 37 (18.32%) Oracle
3 17 (8.42%) MicroStrategy
4 14 (6.93%) Remedy
5 12 (5.94%) Cisco
6 10 (4.95%) VMware
7 7 (3.47%) Cognos
8 6 (2.97%) EMC
8 6 (2.97%) IBM
9 4 (1.98%) Adobe
9 4 (1.98%) Tableau
10 3 (1.49%) Jaspersoft
11 1 (0.50%) JD Edwards
11 1 (0.50%) OpenText
11 1 (0.50%) RedGate
11 1 (0.50%) Sage
Bath, Avon
Redrock Consulting Ltd
Salary: £40000 - £47000 per annum + Excellent Benefits
Posted: Yesterday
Crawley, West Sussex
Comtecs
Salary: £44000 - £50000 Per Annum + on call + Bonus + Excellent Benefits
Posted: 2 days ago
Chessington, Surrey
Robert Half
Salary: £30000 - £45000 per annum
Posted: 5 days ago
Manchester
Robert Walters UK
Salary: £40000 - £55000 per annum + Benefits
Posted: 11 days ago
Folkestone
Deerfoot IT Resources Ltd
Salary: £30000 - £35000 per annum
Posted: 12 days ago