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 6 March 2015 with a comparison to the same period in the previous 2 years.

Location
3 months to
6 Mar 2015
Same period 2014 Same period 2013
Microsoft Data Transformation Services (DTS)
Rank 713 626 574
Rank change year-on-year
-87 -52
Permanent jobs citing DTS 145 245 311
As % of all permanent IT jobs located in the UK 0.14% 0.23% 0.30%
As % of the Database & Business Intelligence category 0.46% 0.75% 0.92%
Number of salaries quoted 137 209 265
Average salary £44,125 £45,000 £40,000
Average salary % change year-on-year
-1.94% +12.50%
90% offered a salary of more than £33,425 £33,500 £30,100
10% offered a salary of more than £60,000 £60,000 £57,500
UK excluding London average salary £40,000 £42,500 £37,500
% change year-on-year
-5.88% +13.33%

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
31239 32857 33901
As % of all permanent IT jobs located in the UK 30.20% 31.50% 32.31%
Number of salaries quoted 26619 27627 29579
Average salary £45,000 £45,000 £43,000
Average salary % change year-on-year
- +4.65%
90% offered a salary of more than £31,000 £30,000 £30,000
10% offered a salary of more than £70,000 £65,000 £70,000
UK excluding London average salary £40,000 £40,000 £40,000

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 6 March 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 6 March 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 -94 129 £42,500 -5.55% 19
London -21 66 £45,000 -18.18% 9
City of London -14 20 £49,000 -14.78% 3
South East -27 18 £40,000 -8.57% 3
Yorkshire -3 15 £45,000 +12.50% 3
South Wales - 13 £45,000 - 1
Wales - 13 £45,000 - 1
Cardiff - 13 £45,000 - 1
Hampshire +3 11 £39,500 - 1
North Yorkshire +18 8 £45,000 +12.50%
North West -12 8 £38,500 -2.53% 1
West Midlands -31 8 £25,000 -34.21%
Manchester +6 7 £38,500 -3.75% 1
West Yorkshire -3 7 £40,000 -13.51% 3
South West -24 7 £42,000 +6.32% 2
Somerset +8 6 £42,000 +6.32%
Bath +1 6 £42,000 +6.32%
Warwickshire - 6 £25,000 -
Southampton - 5 £39,000 - 1
Leeds +6 4 £29,000 - 2
East of England -34 4 £42,500 -5.55%
Scotland +7 3 £40,000 +9.58%
Norfolk +6 3 £42,500 -
Norwich +3 3 £42,500 -
Portsmouth - 3 £47,500 -
Warwick - 3 £25,000 -
East Midlands +12 2 £36,250 -14.70% 1
Glasgow +11 2 - -
Buckinghamshire +10 2 £40,000 -5.88%
Kent +3 2 £36,000 -28.00%

DTS
Top 30 Related IT Skills

For the 6 months to 6 March 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 300 (92.31%) SQL
2 287 (88.31%) SQL Server
3 272 (83.69%) SQL Server Integration Services
4 218 (67.08%) T-SQL
5 167 (51.38%) SQL Server Reporting Services
6 140 (43.08%) SQL Server 2008
7 119 (36.62%) .NET
8 115 (35.38%) Microsoft
9 99 (30.46%) SQL Server 2005
10 97 (29.85%) Windows
10 97 (29.85%) Data Warehouse
11 96 (29.54%) C#
12 88 (27.08%) SQL Server 2000
13 85 (26.15%) Business Intelligence
14 81 (24.92%) Replication
15 80 (24.62%) ETL
16 73 (22.46%) Clustering
17 72 (22.15%) SQL Server 2012
18 71 (21.85%) SQL Server Analysis Services
19 62 (19.08%) Performance Tuning
20 56 (17.23%) Finance
21 55 (16.92%) Migration
22 52 (16.00%) Relational Database
23 47 (14.46%) ASP.NET
24 43 (13.23%) XML
25 42 (12.92%) SharePoint
26 37 (11.38%) MS Excel
27 36 (11.08%) Degree
28 35 (10.77%) Database Security
28 35 (10.77%) Capacity Planning

DTS
Top Related IT Skills by Category

For the 6 months to 6 March 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 42 (12.92%) SharePoint
2 26 (8.00%) IIS
3 8 (2.46%) SharePoint 2010
4 7 (2.15%) GlassFish
5 4 (1.23%) BizTalk Server
6 3 (0.92%) WorkSite
7 2 (0.62%) CMS
7 2 (0.62%) Umbraco
7 2 (0.62%) Sitefinity
8 1 (0.31%) JBoss
8 1 (0.31%) IBM Notes
Applications
1 37 (11.38%) MS Excel
2 4 (1.23%) MS Office
3 1 (0.31%) MS Visio
Business Applications
1 13 (4.00%) Dynamics AX
2 12 (3.69%) Cognos Business Intelligence
3 2 (0.62%) Dynamics CRM
4 1 (0.31%) CSG Singleview
4 1 (0.31%) Remedy ITSM
Cloud Services
1 1 (0.31%) SaaS
Communications & Networking
1 6 (1.85%) Intranet
1 6 (1.85%) Firewall
2 4 (1.23%) Wireless
2 4 (1.23%) Internet
2 4 (1.23%) HTTP
2 4 (1.23%) SAN
3 2 (0.62%) Extranet
4 1 (0.31%) 3G
4 1 (0.31%) 2G
4 1 (0.31%) GGSN
4 1 (0.31%) SGSN
4 1 (0.31%) LTE
4 1 (0.31%) FTP
Database & Business Intelligence
1 287 (88.31%) SQL Server
2 272 (83.69%) SQL Server Integration Services
3 167 (51.38%) SQL Server Reporting Services
4 140 (43.08%) SQL Server 2008
5 99 (30.46%) SQL Server 2005
6 97 (29.85%) Data Warehouse
7 88 (27.08%) SQL Server 2000
8 72 (22.15%) SQL Server 2012
9 71 (21.85%) SQL Server Analysis Services
10 52 (16.00%) Relational Database
11 26 (8.00%) OLTP
12 21 (6.46%) Crystal Reports
13 17 (5.23%) Microsoft Analysis Services
14 14 (4.31%) MS Access
15 13 (4.00%) RDBMS
16 8 (2.46%) IDOL
17 7 (2.15%) MySQL
17 7 (2.15%) OLAP
18 6 (1.85%) Oracle Database
19 5 (1.54%) QlikView
Development Applications
1 28 (8.62%) Visual Studio
2 23 (7.08%) Team Foundation Server
3 11 (3.38%) VSS/SourceSafe
4 8 (2.46%) SQL Server Management Studio (SSMS)
5 7 (2.15%) Eclipse
6 2 (0.62%) ERwin
6 2 (0.62%) Subversion
6 2 (0.62%) JIRA
7 1 (0.31%) TeamCity
7 1 (0.31%) Jenkins
General
1 56 (17.23%) Finance
2 30 (9.23%) Marketing
3 12 (3.69%) Banking
4 6 (1.85%) Retail
4 6 (1.85%) Financial Institution
5 5 (1.54%) Law
6 4 (1.23%) Legal
6 4 (1.23%) Manufacturing
7 3 (0.92%) Electronics
7 3 (0.92%) Military
8 2 (0.62%) Advertising
9 1 (0.31%) Telecoms
9 1 (0.31%) Billing
Job Titles
1 151 (46.46%) DBA
2 131 (40.31%) SQL DBA
3 117 (36.00%) Developer
4 66 (20.31%) Administrator
5 61 (18.77%) SQL Server DBA
6 59 (18.15%) SQL Developer
7 37 (11.38%) Analyst
8 25 (7.69%) Server Administrator
9 19 (5.85%) Database Developer
9 19 (5.85%) Applications Support
10 16 (4.92%) SQL Database Developer
11 13 (4.00%) Consultant
11 13 (4.00%) Data Analyst
12 12 (3.69%) .NET Developer
12 12 (3.69%) SQL Server Developer
13 8 (2.46%) Support Consultant
13 8 (2.46%) Programmer
14 7 (2.15%) Support Analyst
14 7 (2.15%) Server Support
14 7 (2.15%) Support Engineer
Libraries, Frameworks & Software Standards
1 119 (36.62%) .NET
2 47 (14.46%) ASP.NET
3 43 (13.23%) XML
4 21 (6.46%) .NET Framework
5 19 (5.85%) HTML
6 17 (5.23%) ODBC
7 14 (4.31%) Web Services
8 12 (3.69%) WCF
9 9 (2.77%) ASP.NET MVC
10 8 (2.46%) JSON
10 8 (2.46%) CSS
11 7 (2.15%) ActiveX
11 7 (2.15%) ADO
11 7 (2.15%) OLE
11 7 (2.15%) WinForms
11 7 (2.15%) DAO
12 6 (1.85%) ADO.NET Entity Framework
13 5 (1.54%) jQuery
13 5 (1.54%) ADO.NET
14 4 (1.23%) COM
Miscellaneous
1 81 (24.92%) Replication
2 73 (22.46%) Clustering
3 29 (8.92%) Analytical Skills
4 20 (6.15%) Client/Server
5 16 (4.92%) Digital Media
6 13 (4.00%) Statistics
7 11 (3.38%) Data Extraction
7 11 (3.38%) Management Information System
8 8 (2.46%) NHS
9 6 (1.85%) Data Conversion
9 6 (1.85%) e-Health
9 6 (1.85%) Mobile App
9 6 (1.85%) User Experience
10 4 (1.23%) Visualisation
10 4 (1.23%) Enterprise Software
11 3 (0.92%) Data Integration
12 2 (0.62%) Computer Science
12 2 (0.62%) Smartphone
12 2 (0.62%) Data Structures
13 1 (0.31%) AS400
Operating Systems
1 97 (29.85%) Windows
2 22 (6.77%) Windows Server 2008
3 19 (5.85%) Windows Server 2012
4 11 (3.38%) Windows Server 2003
5 10 (3.08%) UNIX
Processes & Methodologies
1 85 (26.15%) Business Intelligence
2 80 (24.62%) ETL
3 62 (19.08%) Performance Tuning
4 55 (16.92%) Migration
5 35 (10.77%) Capacity Planning
5 35 (10.77%) Database Security
6 34 (10.46%) Data Transformation
6 34 (10.46%) Disaster Recovery
7 32 (9.85%) Data Management
8 30 (9.23%) Project Management
9 29 (8.92%) Change Management
10 28 (8.62%) Data Migration
11 23 (7.08%) Time Management
12 22 (6.77%) Unit Testing
13 21 (6.46%) Data Analysis
14 20 (6.15%) Agile Software Development
14 20 (6.15%) Continuous Improvement
14 20 (6.15%) Web Development
15 19 (5.85%) OO
16 18 (5.54%) Kimball Methodology
Programming Languages
1 300 (92.31%) SQL
2 218 (67.08%) T-SQL
3 96 (29.54%) C#
4 35 (10.77%) JavaScript
5 31 (9.54%) VB
6 28 (8.62%) VBScript
7 25 (7.69%) VB.NET
8 22 (6.77%) PowerShell
9 11 (3.38%) VBA
10 9 (2.77%) PL/SQL
11 8 (2.46%) Java
12 6 (1.85%) PHP
13 4 (1.23%) C
13 4 (1.23%) C++
13 4 (1.23%) MapBasic
14 2 (0.62%) XPath
14 2 (0.62%) Objective-C
15 1 (0.31%) Shell Script
15 1 (0.31%) Delphi
Qualifications
1 36 (11.08%) Degree
2 12 (3.69%) Microsoft Certification
3 11 (3.38%) VCP4
4 7 (2.15%) MCITP
5 6 (1.85%) MCTS
6 4 (1.23%) MCDBA
6 4 (1.23%) Microsoft Certified Architect
7 3 (0.92%) MCP
7 3 (0.92%) PMI Certification
8 2 (0.62%) PMP
8 2 (0.62%) Security Cleared
9 1 (0.31%) SC Cleared
9 1 (0.31%) MCSE
9 1 (0.31%) MCT
Quality Assurance & Compliance
1 24 (7.38%) SLA
2 21 (6.46%) QA
3 2 (0.62%) Data Quality
System Software
1 19 (5.85%) Active Directory
2 6 (1.85%) Terminal Server
2 6 (1.85%) Hyper-V
3 2 (0.62%) Firmware
4 1 (0.31%) Oracle RMAN
4 1 (0.31%) Veritas Cluster Server
Systems Management
1 7 (2.15%) SCOM
2 1 (0.31%) Puppet
2 1 (0.31%) Opscode Chef
Vendors
1 115 (35.38%) Microsoft
2 35 (10.77%) Cognos
3 30 (9.23%) Oracle
4 14 (4.31%) Business Objects
5 9 (2.77%) HP
6 4 (1.23%) VMware
6 4 (1.23%) Teradata
7 3 (0.92%) Red Gate
7 3 (0.92%) NetApp
8 2 (0.62%) Informatica
8 2 (0.62%) MicroStrategy
8 2 (0.62%) Baan
8 2 (0.62%) Citrix
8 2 (0.62%) Siebel
8 2 (0.62%) IBM
8 2 (0.62%) Ektron
8 2 (0.62%) SAP
8 2 (0.62%) Xamarin
9 1 (0.31%) hybris
9 1 (0.31%) Comverse
Cardiff
Hays IT - Uk Posting account
Salary: £35000.00 - £42000.00 per annum
Posted: 18 hours ago
Southampton
Spectrum IT
Salary: £28000 - £50000 per annum
Posted: 18 hours ago
London
NFP Group Ltd
Salary: £35000 - £50000 per annum
Posted: Yesterday
Leeds, West Yorkshire
Sanderson
Salary: £35000.00 - £38000.00 per annum + Bonus+Benefits
Posted: 3 days ago
Bournemouth, Dorset
Computer People
Salary: £45000.00 - £50000.00 per annum
Posted: 3 days ago
East London
Clear Edge Consulting
Salary: From £35,000 to £45,000 per annum
Posted: 4 days ago
Sowerby Bridge, West Yorkshire
Senitor Associates
Salary: £30000 - £40000 per annum + Benefits
Posted: 6 days ago
Greater Manchester
Comtecs
Salary: £33000 - £34000 Per Annum +Bonus +Benefits
Posted: 6 days ago
London
Comtecs
Salary: £33000 - £34000 Per Annum +Bonus +Benefits
Posted: 6 days ago
Nottingham, Nottinghamshire
TDX Group
Salary: Competitive + pension, healthcare
Posted: 6 days ago
City of London
Interquest - ITQ Financial - Tunbridge Wells
Salary: £38000 - £43000 per annum + Excellent Benefits
Posted: 6 days ago
London
Brightred Resourcing
Salary: £30,000 - £40,000 per year
Posted: 7 days ago
City of London
Hays IT - Uk Posting account
Salary: £300.00 - £450.00 per annum
Posted: 15 days ago
City of London
NFP Group Ltd
Salary: £45000 - £55000 per annum
Posted: 21 days ago
London
Hays IT - Uk Posting account
Salary: £60000.00 - £75000.00 per annum + Benefits & Bonus
Posted: 23 days ago
Leeds, West Yorkshire
Virtonei Ltd
Salary: From £26,000 to £40,000 per annum depending on candidate & experience
Posted: 24 days ago