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 18 January 2017 with a comparison to the same period over the previous 2 years.

3 months to
18 Jan 2017
Same period 2016 Same period 2015
Microsoft Data Transformation Services (DTS)
UK / England
Rank 724 818 797
Rank change year-on-year
+94 -21
Permanent jobs citing DTS 98 79 133
As % of all permanent IT jobs located in England 0.12% 0.084% 0.14%
As % of the Database & Business Intelligence category 0.41% 0.26% 0.45%
Number of salaries quoted 82 55 120
Median salary £43,000 £40,000 £42,500
Median salary % change year-on-year
+7.50% -5.88%
90% offered a salary of more than £32,500 £31,875 £34,000
10% offered a salary of more than £69,500 £69,500 £57,500
UK excluding London median salary £42,500 £38,000 £39,500
% change year-on-year
+11.84% -3.79%

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
23693 30285 29785
As % of all permanent IT jobs located in England 30.07% 32.38% 30.91%
Number of salaries quoted 20548 25912 25699
Median salary £50,000 £50,000 £45,000
Median salary % change year-on-year
- +11.11%
90% offered a salary of more than £32,500 £32,500 £31,000
10% offered a salary of more than £75,000 £70,000 £72,500
UK excluding London median salary £43,000 £42,500 £40,000
% change year-on-year
+1.17% +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 18 January 2017.

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 18 January 2017. 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 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 +64 31 £67,500 +42.10% 2
East of England - 28 £43,000 - 2
East Midlands - 15 £40,000 -
South East +51 14 £40,000 - 3
West Midlands +10 5 £44,000 +4.14%
South West +21 3 £42,500 - 1
North West -30 2 £40,000 -5.88% 1
DTS
UK

DTS
Top 30 Related IT Skills in England

For the 6 months to 18 January 2017, 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 204 (91.89%) SQL Server
2 185 (83.33%) SQL
3 168 (75.68%) SQL Server Integration Services
4 130 (58.56%) T-SQL
5 105 (47.30%) .NET
6 103 (46.40%) SQL Server 2008
7 92 (41.44%) SQL Server Reporting Services
8 89 (40.09%) Microsoft
9 85 (38.29%) C#
10 77 (34.68%) Business Intelligence
11 74 (33.33%) Finance
12 57 (25.68%) SQL Server 2005
12 57 (25.68%) SQL Server 2014
13 56 (25.23%) SQL Server Analysis Services
14 49 (22.07%) SQL Server 2000
15 47 (21.17%) Windows
16 42 (18.92%) ETL
17 41 (18.47%) Oracle
17 41 (18.47%) SQL Server 2012
18 37 (16.67%) VB
19 36 (16.22%) ASP.NET
19 36 (16.22%) MVC
19 36 (16.22%) Replication
20 35 (15.77%) CSS
20 35 (15.77%) HTML
21 33 (14.86%) IIS
21 33 (14.86%) Data Warehouse
21 33 (14.86%) SQL Server 2016
22 31 (13.96%) SDLC
23 30 (13.51%) SharePoint

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 33 (14.86%) IIS
2 30 (13.51%) SharePoint
3 20 (9.01%) BizTalk Server
4 6 (2.70%) JBoss
5 4 (1.80%) Apache Spark
5 4 (1.80%) Confluence
5 4 (1.80%) Elasticsearch
5 4 (1.80%) WebSphere
5 4 (1.80%) WebSphere Application Server
6 3 (1.35%) FormScape
7 2 (0.90%) CMS
8 1 (0.45%) Jetty
8 1 (0.45%) MS Exchange
8 1 (0.45%) Oracle Workflow
8 1 (0.45%) SAS
8 1 (0.45%) Tomcat
8 1 (0.45%) WordPress
Applications
1 24 (10.81%) MS Excel
2 14 (6.31%) MS Office
3 4 (1.80%) Photoshop
Business Applications
1 5 (2.25%) Cognos TM1
2 4 (1.80%) Sage X3
3 3 (1.35%) Dynamics NAV
4 1 (0.45%) SAP ERP
Cloud Services
1 4 (1.80%) SaaS
Communications & Networking
1 13 (5.86%) Intranet
2 3 (1.35%) SAN
3 2 (0.90%) FTP
4 1 (0.45%) TCP/IP
Database & Business Intelligence
1 204 (91.89%) SQL Server
2 168 (75.68%) SQL Server Integration Services
3 103 (46.40%) SQL Server 2008
4 92 (41.44%) SQL Server Reporting Services
5 57 (25.68%) SQL Server 2005
5 57 (25.68%) SQL Server 2014
6 56 (25.23%) SQL Server Analysis Services
7 49 (22.07%) SQL Server 2000
8 41 (18.47%) SQL Server 2012
9 33 (14.86%) Data Warehouse
9 33 (14.86%) SQL Server 2016
10 23 (10.36%) Relational Database
11 22 (9.91%) OLAP
12 21 (9.46%) Microsoft Analysis Services
13 18 (8.11%) Oracle OLAP
14 17 (7.66%) RDBMS
15 11 (4.95%) DB2
16 9 (4.05%) Oracle Reports
16 9 (4.05%) Power BI
17 8 (3.60%) ProClarity
Development Applications
1 23 (10.36%) SQL Server Management Studio (SSMS)
2 19 (8.56%) Visual Studio
3 13 (5.86%) Visual Studio Team System
4 7 (3.15%) Jenkins
5 6 (2.70%) Octopus Deploy
5 6 (2.70%) Team Foundation Server
5 6 (2.70%) TeamCity
6 4 (1.80%) Git (software)
7 2 (0.90%) ERwin
7 2 (0.90%) Toad
8 1 (0.45%) Bitbucket
8 1 (0.45%) JIRA
8 1 (0.45%) JUnit
8 1 (0.45%) Mockito
8 1 (0.45%) Oracle Forms
General
1 74 (33.33%) Finance
2 24 (10.81%) Legal
3 21 (9.46%) Back Office
4 14 (6.31%) Retail
5 11 (4.95%) Marketing
6 8 (3.60%) Banking
7 6 (2.70%) Music Industry
8 4 (1.80%) Billing
9 2 (0.90%) Law
10 1 (0.45%) Advertising
10 1 (0.45%) Front Office
10 1 (0.45%) Manufacturing
10 1 (0.45%) Publishing
Job Titles
1 97 (43.69%) Developer
2 60 (27.03%) DBA
3 59 (26.58%) SQL DBA
4 41 (18.47%) Analyst
4 41 (18.47%) SQL Server DBA
5 37 (16.67%) .NET Developer
6 34 (15.32%) C# Developer
7 29 (13.06%) C# .NET Developer
8 26 (11.71%) SQL Analyst
9 25 (11.26%) SQL Developer
10 22 (9.91%) Senior Developer
11 18 (8.11%) SSIS Analyst
12 16 (7.21%) SSIS Developer
12 16 (7.21%) Support Analyst
13 15 (6.76%) Software Developer
13 15 (6.76%) T-SQL Developer
14 13 (5.86%) Integration Analyst
14 13 (5.86%) Senior Systems Developer
14 13 (5.86%) SQL Support Analyst
14 13 (5.86%) Systems Developer
Libraries, Frameworks & Software Standards
1 105 (47.30%) .NET
2 36 (16.22%) ASP.NET
3 35 (15.77%) CSS
3 35 (15.77%) HTML
4 29 (13.06%) XML
5 22 (9.91%) WCF
6 18 (8.11%) Ajax
7 17 (7.66%) jQuery
8 13 (5.86%) ASP.NET MVC
9 12 (5.41%) REST
9 12 (5.41%) Web Services
10 11 (4.95%) Classic ASP
11 10 (4.50%) ASP.NET MVC 3
11 10 (4.50%) DHTML
11 10 (4.50%) WPF
12 7 (3.15%) EDI
13 6 (2.70%) AngularJS
14 5 (2.25%) React
15 4 (1.80%) Kafka
15 4 (1.80%) Spark Streaming
Miscellaneous
1 36 (16.22%) Replication
2 25 (11.26%) Clustering
3 20 (9.01%) Enterprise Software
4 18 (8.11%) Analytical Skills
5 14 (6.31%) Data Centre
5 14 (6.31%) Management Information System
5 14 (6.31%) Reinsurance
6 10 (4.50%) PMI
7 9 (4.05%) Mathematics
8 8 (3.60%) Mobile App
8 8 (3.60%) Statistics
9 7 (3.15%) AS400
10 5 (2.25%) Computer Science
10 5 (2.25%) NHS
10 5 (2.25%) Visualisation
11 4 (1.80%) Data Integration
11 4 (1.80%) iSeries
11 4 (1.80%) Physics
12 3 (1.35%) User Experience
13 1 (0.45%) Data Extraction
Operating Systems
1 47 (21.17%) Windows
2 16 (7.21%) Windows Server
3 7 (3.15%) Linux
4 6 (2.70%) Unix
4 6 (2.70%) Windows Server 2003
5 4 (1.80%) Windows Server 2008
5 4 (1.80%) Windows Server 2012
6 2 (0.90%) Windows 2000
7 1 (0.45%) Windows Vista
7 1 (0.45%) Windows XP
Processes & Methodologies
1 77 (34.68%) Business Intelligence
2 42 (18.92%) ETL
3 36 (16.22%) MVC
4 31 (13.96%) SDLC
5 29 (13.06%) Agile Software Development
5 29 (13.06%) Performance Tuning
6 27 (12.16%) Project Management
7 23 (10.36%) Time Management
8 20 (9.01%) Data Transformation
8 20 (9.01%) Database Mirroring
9 18 (8.11%) Case Management
9 18 (8.11%) PRINCE2
10 17 (7.66%) Workflow
11 16 (7.21%) Unit Testing
12 14 (6.31%) TDD
13 13 (5.86%) Change Management
13 13 (5.86%) Server Building
14 12 (5.41%) High Availability
15 11 (4.95%) Analytics
15 11 (4.95%) Data Modelling
Programming Languages
1 185 (83.33%) SQL
2 130 (58.56%) T-SQL
3 85 (38.29%) C#
4 37 (16.67%) VB
5 26 (11.71%) JavaScript
6 23 (10.36%) Java
7 18 (8.11%) VB.NET
8 15 (6.76%) PL/SQL
9 11 (4.95%) PHP
9 11 (4.95%) PowerShell
9 11 (4.95%) VB6
10 6 (2.70%) VBA
11 5 (2.25%) R
12 4 (1.80%) Python
12 4 (1.80%) VBScript
13 1 (0.45%) C
13 1 (0.45%) FoxPro (VFP)
13 1 (0.45%) PHP 5
Qualifications
1 24 (10.81%) Degree
2 14 (6.31%) Microsoft Certification
3 10 (4.50%) PMI Certification
4 4 (1.80%) DV Cleared
4 4 (1.80%) PhD
4 4 (1.80%) Security Cleared
5 1 (0.45%) ISEB
5 1 (0.45%) MCDBA
5 1 (0.45%) MCITP
5 1 (0.45%) MCSA
5 1 (0.45%) MCSE
Quality Assurance & Compliance
1 16 (7.21%) SLA
2 5 (2.25%) Data Quality
2 5 (2.25%) QA
System Software
1 3 (1.35%) Active Directory
2 2 (0.90%) Oracle RAC
3 1 (0.45%) VMware Infrastructure
Systems Management
1 14 (6.31%) Perfmon
2 8 (3.60%) SCOM
3 6 (2.70%) Puppet
4 5 (2.25%) Failover Clustering
5 2 (0.90%) Microsoft Clustering
6 1 (0.45%) Control-M
6 1 (0.45%) Enterprise Manager Cloud Control
6 1 (0.45%) LiteSpeed
Vendors
1 89 (40.09%) Microsoft
2 41 (18.47%) Oracle
3 22 (9.91%) VMware
4 11 (4.95%) SAP
5 9 (4.05%) Cognos
6 8 (3.60%) MicroStrategy
7 7 (3.15%) Tableau
8 6 (2.70%) webMethods
9 4 (1.80%) Adobe
9 4 (1.80%) IBM
9 4 (1.80%) OpenText
9 4 (1.80%) Sage
10 3 (1.35%) JD Edwards
11 2 (0.90%) Pega
11 2 (0.90%) Salesforce.com
12 1 (0.45%) Citrix
12 1 (0.45%) Netezza
12 1 (0.45%) Remedy
12 1 (0.45%) Sybase
London
Nigel Frank International
Salary: £50000 - £60000 per annum + benefits
Posted: 18 hours ago
Liverpool, Merseyside
Oho Group Ltd.
Salary: £40000 - £45000 per annum
Posted: Yesterday
Royston, Hertfordshire
Hotel Chocolat
Salary: £competitive + Bonus + Bens
Posted: 12 hours ago
Swindon, Wiltshire
Sanderson
Salary: £45000.00 per annum
Posted: 2 days ago
Kent
Logic Engagements Ltd
Salary: £25000 - £30000 per annum + Benefits
Posted: 5 days ago
Lewes
Hays Specialist Recruitment
Salary: £35000 - £45000 per annum + benefits
Posted: 7 days ago
Folkestone
Deerfoot IT Resources Ltd
Salary: £28000 - £42000 per annum
Posted: 8 days ago
Hertfordshire
Venturi
Salary: £30000 - £35000 per annum + Plus Benefits
Posted: 15 days ago
London
DIGITAL TO STORE
Salary: Depending on applicant
Posted: Yesterday