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 13 February 2016 with a comparison to the same period in the previous 2 years.

Location
3 months to
13 Feb 2016
Same period 2015 Same period 2014
Microsoft Data Transformation Services (DTS)
Rank 862 799 700
Rank change year-on-year
-63 -99
Permanent jobs citing DTS 68 156 259
As % of all permanent IT jobs located in the UK 0.068% 0.15% 0.25%
As % of the Database & Business Intelligence category 0.21% 0.48% 0.75%
Number of salaries quoted 52 146 230
Average salary £45,250 £42,500 £45,000
Average salary % change year-on-year
+6.47% -5.55%
90% offered a salary of more than £35,000 £34,000 £33,500
10% offered a salary of more than £59,550 £58,750 £60,000
UK excluding London average salary £42,500 £40,000 £40,000
% change year-on-year
+6.25% -

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
31749 32557 34481
As % of all permanent IT jobs located in the UK 31.67% 31.02% 32.67%
Number of salaries quoted 26906 27945 29142
Average salary £47,500 £45,000 £45,000
Average salary % change year-on-year
+5.55% -
90% offered a salary of more than £32,500 £31,000 £30,000
10% offered a salary of more than £72,500 £70,000 £70,000
UK excluding London average salary £42,500 £40,000 £40,000
% change year-on-year
+6.25% -

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 13 February 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 average salaries quoted in IT jobs citing DTS within the UK over the 3 months to 13 February 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
(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 -56 65 £46,000 +8.23% 9
South East +12 18 £50,000 +28.20% 5
North West +41 16 £46,000 +22.66% 1
Manchester +32 15 £46,000 +19.48%
Berkshire +16 15 £50,000 -31.50% 2
West Yorkshire +4 13 £40,000 - 1
Yorkshire -1 13 £40,000 -3.90% 1
London -40 12 £47,500 +5.55%
Reading +6 7 £75,000 +2.73% 1
Halifax -3 7 £35,500 -11.25% 1
Wokingham - 5 £50,000 - 1
Leeds +6 4 £40,000 +37.93%
Lewes - 3 £36,000 - 1
East Sussex - 3 £36,000 - 1
City of London +41 2 £60,000 +22.44%
Scotland -2 2 £35,000 -12.50% 1
West Midlands -28 2 £42,250 +56.48%
West Lothian - 2 £35,000 -
North East - 2 £35,229 -
Livingston - 2 £35,000 -
Huddersfield +13 1 £40,000 -
Nottinghamshire +11 1 £42,500 +9.67% 1
Nottingham +5 1 £42,500 +9.67%
East Midlands -1 1 £42,500 +13.33% 2
Birmingham -3 1 £47,000 +6.81%
Wales -5 1 £37,500 -16.66%
Worcestershire -8 1 £37,500 +31.58%
South West -11 1 - -
Lancashire - 1 £42,500 -
Dorset - 1 - -

DTS
Top 30 Related IT Skills

For the 6 months to 13 February 2016, 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 138 (94.52%) SQL Server
2 118 (80.82%) SQL
3 107 (73.29%) SQL Server Integration Services
4 69 (47.26%) SQL Server Reporting Services
5 67 (45.89%) T-SQL
6 63 (43.15%) Windows
7 62 (42.47%) Microsoft
8 50 (34.25%) SQL Server 2008
9 49 (33.56%) .NET
10 40 (27.40%) SQL Server 2005
11 38 (26.03%) Replication
12 37 (25.34%) SAN
12 37 (25.34%) High Availability
13 35 (23.97%) Capacity Planning
13 35 (23.97%) Oracle
13 35 (23.97%) MS Excel
14 33 (22.60%) Windows Server 2008
15 32 (21.92%) Business Intelligence
15 32 (21.92%) Java
15 32 (21.92%) Windows Server 2003
15 32 (21.92%) SQL Server 2014
16 31 (21.23%) SQL Server 2000
17 29 (19.86%) Data Warehouse
17 29 (19.86%) PowerShell
18 28 (19.18%) Performance Monitoring
19 27 (18.49%) SQL Server 2012
20 26 (17.81%) ETL
20 26 (17.81%) SQL Server Analysis Services
21 24 (16.44%) Degree
21 24 (16.44%) XML

DTS
Top Related IT Skills by Category

For the 6 months to 13 February 2016, 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 22 (15.07%) SharePoint
2 21 (14.38%) BizTalk Server
2 21 (14.38%) IIS
3 13 (8.90%) JBoss
4 11 (7.53%) SharePoint 2010
5 3 (2.05%) SharePoint 2013
6 2 (1.37%) Tomcat
Applications
1 35 (23.97%) MS Excel
2 2 (1.37%) MS Office
Business Applications
1 5 (3.42%) Oracle 11i
2 3 (2.05%) 3000 Xtra
2 3 (2.05%) Eikon
2 3 (2.05%) Infor M3
2 3 (2.05%) RMDS
3 2 (1.37%) Cerner Millennium
3 2 (1.37%) Dynamics AX
3 2 (1.37%) Dynamics CRM
4 1 (0.68%) Infor CRM
4 1 (0.68%) Markit EDM
4 1 (0.68%) Sage CRM
Cloud Services
1 3 (2.05%) Microsoft Azure
1 3 (2.05%) Office 365
Communications & Networking
1 37 (25.34%) SAN
2 7 (4.79%) FTP
3 3 (2.05%) Firewall
4 2 (1.37%) Internet
4 2 (1.37%) Intranet
4 2 (1.37%) SSL
Database & Business Intelligence
1 138 (94.52%) SQL Server
2 107 (73.29%) SQL Server Integration Services
3 69 (47.26%) SQL Server Reporting Services
4 50 (34.25%) SQL Server 2008
5 40 (27.40%) SQL Server 2005
6 32 (21.92%) SQL Server 2014
7 31 (21.23%) SQL Server 2000
8 29 (19.86%) Data Warehouse
9 27 (18.49%) SQL Server 2012
10 26 (17.81%) SQL Server Analysis Services
11 24 (16.44%) Oracle Database
12 17 (11.64%) Relational Database
13 13 (8.90%) EDRMS
14 12 (8.22%) RDBMS
15 9 (6.16%) Microsoft Analysis Services
16 8 (5.48%) Oracle Database 10g
16 8 (5.48%) Oracle9i Database
17 6 (4.11%) OLAP
18 5 (3.42%) Oracle Reports
18 5 (3.42%) SQL Server 7
Development Applications
1 14 (9.59%) Visual Studio
2 13 (8.90%) Jenkins
2 13 (8.90%) Octopus Deploy
2 13 (8.90%) TeamCity
3 8 (5.48%) Team Foundation Server
4 7 (4.79%) Toad
5 2 (1.37%) ERwin
6 1 (0.68%) Dreamweaver
6 1 (0.68%) JIRA
6 1 (0.68%) SQL Server Management Studio (SSMS)
General
1 21 (14.38%) Finance
2 18 (12.33%) Banking
3 7 (4.79%) Legal
4 5 (3.42%) French Language
4 5 (3.42%) German Language
5 4 (2.74%) Manufacturing
6 3 (2.05%) Advertising
6 3 (2.05%) Retail
7 2 (1.37%) Front Office
7 2 (1.37%) Publishing
8 1 (0.68%) Law
8 1 (0.68%) Local Government
8 1 (0.68%) Marketing
Job Titles
1 60 (41.10%) DBA
2 44 (30.14%) Administrator
3 42 (28.77%) SQL DBA
4 28 (19.18%) Developer
5 26 (17.81%) SQL Server DBA
6 18 (12.33%) Architect
6 18 (12.33%) Systems Administrator
7 17 (11.64%) SQL Developer
8 15 (10.27%) Analyst
9 13 (8.90%) Solutions Architect
10 12 (8.22%) .NET Developer
10 12 (8.22%) C# Developer
10 12 (8.22%) TOGAF Architect
11 11 (7.53%) C# .NET Developer
11 11 (7.53%) Database Engineer
12 10 (6.85%) Software Developer
13 9 (6.16%) Senior Database Engineer
13 9 (6.16%) SQL Analyst
14 8 (5.48%) Applications Support
14 8 (5.48%) Consultant
Libraries, Frameworks & Software Standards
1 49 (33.56%) .NET
2 24 (16.44%) XML
3 17 (11.64%) HTML
4 13 (8.90%) Web Services
5 8 (5.48%) WCF
6 7 (4.79%) HTML5
6 7 (4.79%) WPF
7 6 (4.11%) ASP.NET
7 6 (4.11%) SOAP
8 5 (3.42%) EDI
8 5 (3.42%) jQuery
8 5 (3.42%) REST
9 4 (2.74%) CSS
10 3 (2.05%) .NET Framework
10 3 (2.05%) AngularJS
10 3 (2.05%) CSS3
10 3 (2.05%) MDX
11 2 (1.37%) Entity Framework
11 2 (1.37%) ODBC
12 1 (0.68%) ADO
Miscellaneous
1 38 (26.03%) Replication
2 24 (16.44%) Management Information System
3 23 (15.75%) Analytical Skills
4 22 (15.07%) Clustering
5 13 (8.90%) Enterprise Software
5 13 (8.90%) NHS
6 5 (3.42%) Statistics
6 5 (3.42%) Symmetrix
7 3 (2.05%) IBM XIV
8 2 (1.37%) CLARiiON
8 2 (1.37%) Data Integration
8 2 (1.37%) Enterprise Cloud
8 2 (1.37%) N-Tier
9 1 (0.68%) Data Extraction
9 1 (0.68%) W3C
Operating Systems
1 63 (43.15%) Windows
2 33 (22.60%) Windows Server 2008
3 32 (21.92%) Windows Server 2003
4 22 (15.07%) Windows Server 2012
5 14 (9.59%) Windows Server
6 12 (8.22%) Linux
7 10 (6.85%) Unix
Processes & Methodologies
1 37 (25.34%) High Availability
2 35 (23.97%) Capacity Planning
3 32 (21.92%) Business Intelligence
4 28 (19.18%) Performance Monitoring
5 26 (17.81%) ETL
6 24 (16.44%) Project Management
7 23 (15.75%) Performance Analysis
8 22 (15.07%) Mentoring
8 22 (15.07%) Time Management
9 19 (13.01%) SDLC
10 18 (12.33%) Migration
11 17 (11.64%) Disaster Recovery
12 16 (10.96%) Data Transformation
12 16 (10.96%) OO
12 16 (10.96%) PRINCE2
13 14 (9.59%) Coaching
13 14 (9.59%) Validation
14 13 (8.90%) Configuration Management
14 13 (8.90%) OOA/OOD
14 13 (8.90%) TOGAF
Programming Languages
1 118 (80.82%) SQL
2 67 (45.89%) T-SQL
3 32 (21.92%) Java
4 29 (19.86%) PowerShell
5 22 (15.07%) C#
6 18 (12.33%) PL/SQL
7 15 (10.27%) VB.NET
8 13 (8.90%) JavaScript
8 13 (8.90%) PHP
8 13 (8.90%) VB
9 5 (3.42%) XPath
10 4 (2.74%) C
10 4 (2.74%) VBA
10 4 (2.74%) VBScript
11 3 (2.05%) Shell Script
12 1 (0.68%) VB6
Qualifications
1 24 (16.44%) Degree
2 12 (8.22%) Microsoft Certification
3 1 (0.68%) MCP
3 1 (0.68%) MCSA
3 1 (0.68%) MCSE
Quality Assurance & Compliance
1 3 (2.05%) SLA
2 2 (1.37%) HL7
3 1 (0.68%) ISO 9001
System Software
1 9 (6.16%) Oracle RAC
1 9 (6.16%) VMware ESX
2 5 (3.42%) SRDF
3 2 (1.37%) Active Directory
4 1 (0.68%) Terminal Server
Systems Management
1 21 (14.38%) LiteSpeed
2 13 (8.90%) Puppet
3 4 (2.74%) Oracle RMAN
4 2 (1.37%) EMC NetWorker
5 1 (0.68%) Perfmon
Vendors
1 62 (42.47%) Microsoft
2 35 (23.97%) Oracle
3 23 (15.75%) VMware
4 14 (9.59%) EMC
5 13 (8.90%) webMethods
6 9 (6.16%) HP
6 9 (6.16%) Red Gate
7 6 (4.11%) Cognos
8 3 (2.05%) Baan
8 3 (2.05%) Bloomberg
8 3 (2.05%) IBM
8 3 (2.05%) Infor
8 3 (2.05%) Remedy
8 3 (2.05%) Reuters
9 2 (1.37%) Cerner
9 2 (1.37%) Cisco
9 2 (1.37%) McKesson
10 1 (0.68%) Infragistics
10 1 (0.68%) JD Edwards
10 1 (0.68%) Sage
Derbyshire
Redrock Consulting Ltd
Salary: £30000 - £40000 per annum
Posted: 22 hours ago
Gillingham, Kent
CV Screen Ltd
Salary: £32k - 35k per year + Pension
Posted: 22 hours ago
Glasgow, Lanarkshire
Net Talent
Posted: Yesterday
Reading, Berkshire
Venturi
Salary: £45000 - £55000 per annum + 30% bonus and benefits
Posted: Yesterday
Wokingham, Berkshire
Venturi
Salary: £45000 - £55000 per annum + 30% bonus and benefits
Posted: Yesterday
Halifax, West Yorkshire
4it Recruitment Ltd
Salary: Up to £40,000 + £6500 on call (dependent on experience)
Posted: 2 days ago
Gillingham, Kent
CV Screen Ltd
Salary: £33k - 35k per year + Pension
Posted: 2 days ago
Lewes
Hays Specialist Recruitment
Salary: £34000 - £40000 per annum + benefits
Posted: 23 days ago