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

Location
3 months to
22 Dec 2014
Same period 2013 Same period 2012
Microsoft Data Transformation Services (DTS)
Rank 243 191 193
Rank change year-on-year
-52 +2
Permanent jobs citing DTS 21 49 41
As % of all permanent IT jobs located in Yorkshire 0.30% 0.79% 0.66%
As % of the Database & Business Intelligence category 0.97% 2.24% 1.80%
Number of salaries quoted 16 38 38
Average salary £40,000 £34,500 £35,000
Average salary % change year-on-year
+15.94% -1.42%
90% offered a salary of more than £37,500 £26,000 £26,000
10% offered a salary of more than £46,500 £40,000 £45,000
UK excluding London average salary £38,000 £37,500 £39,000
% change year-on-year
+1.33% -3.84%
DTS
England

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

Database & Business Intelligence Category
Yorkshire
Permanent IT job ads with a match in the
Database & Business Intelligence category
2157 2186 2279
As % of all permanent IT jobs located in Yorkshire 30.31% 35.31% 36.94%
Number of salaries quoted 1810 1784 2004
Average salary £40,000 £37,500 £35,000
Average salary % change year-on-year
+6.66% +7.14%
90% offered a salary of more than £27,000 £27,500 £25,000
10% offered a salary of more than £52,500 £45,000 £50,000
UK excluding London average salary £40,000 £40,000 £39,000
% change year-on-year
- +2.56%

DTS
Jobs Demand Trend in Yorkshire

This chart provides a 3-month moving total of permanent IT jobs citing DTS across the Yorkshire region as a proportion of the total demand within the Database & Business Intelligence category.

DTS Jobs Demand Trend in Yorkshire

DTS
Salary Trend in Yorkshire

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

DTS Salary Trend in Yorkshire

DTS
Salary Histogram in Yorkshire

This chart provides a salary histogram for IT jobs citing DTS across the Yorkshire region over the 3 months to 22 December 2014.

DTS Salary Histogram in Yorkshire

DTS
Job Locations in Yorkshire

The table below looks at the demand and provides a guide to the average salaries quoted in IT jobs citing DTS within the Yorkshire region over the 3 months to 22 December 2014. 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
West Yorkshire -32 17 £40,000 +53.84% 2
South Yorkshire -19 3 - -
East Yorkshire - 1 £50,000 -
DTS
England

DTS
Top 30 Related IT Skills in Yorkshire

For the 6 months to 22 December 2014, IT jobs across the Yorkshire region 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 36 (100.00%) SQL
2 29 (80.56%) SQL Server
3 28 (77.78%) SQL Server Integration Services
4 27 (75.00%) T-SQL
5 23 (63.89%) SQL Server Reporting Services
5 23 (63.89%) Performance Tuning
6 18 (50.00%) Replication
7 16 (44.44%) Microsoft
8 15 (41.67%) Windows
8 15 (41.67%) Database Security
9 13 (36.11%) Dynamics AX
10 10 (27.78%) SQL Server Analysis Services
11 9 (25.00%) SQL Server 2008
11 9 (25.00%) Performance Monitoring
11 9 (25.00%) Clustering
12 8 (22.22%) SQL Server 2012
13 7 (19.44%) Data Management
13 7 (19.44%) SharePoint
13 7 (19.44%) ETL
13 7 (19.44%) Business Intelligence
14 6 (16.67%) Terminal Server
14 6 (16.67%) HP
14 6 (16.67%) MS Excel
14 6 (16.67%) VBA
14 6 (16.67%) IIS
14 6 (16.67%) Firewall
14 6 (16.67%) Hyper-V
14 6 (16.67%) Capacity Planning
14 6 (16.67%) SharePoint 2010
14 6 (16.67%) Change Control

DTS
Top Related IT Skills in Yorkshire by Category

For the 6 months to 22 December 2014, IT jobs across the Yorkshire region 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 7 (19.44%) SharePoint
2 6 (16.67%) IIS
2 6 (16.67%) SharePoint 2010
3 2 (5.56%) BizTalk Server
Applications
1 6 (16.67%) MS Excel
Business Applications
1 13 (36.11%) Dynamics AX
Communications & Networking
1 6 (16.67%) Firewall
Database & Business Intelligence
1 29 (80.56%) SQL Server
2 28 (77.78%) SQL Server Integration Services
3 23 (63.89%) SQL Server Reporting Services
4 10 (27.78%) SQL Server Analysis Services
5 9 (25.00%) SQL Server 2008
6 8 (22.22%) SQL Server 2012
7 5 (13.89%) SQL Server 2000
8 4 (11.11%) MS Access
9 3 (8.33%) Data Warehouse
9 3 (8.33%) Microsoft Analysis Services
9 3 (8.33%) Relational Database
9 3 (8.33%) SQL Server 2005
Development Applications
1 4 (11.11%) Visual Studio
2 2 (5.56%) SQL Server Management Studio (SSMS)
General
1 3 (8.33%) Electronics
1 3 (8.33%) Military
2 2 (5.56%) Finance
3 1 (2.78%) Law
3 1 (2.78%) Legal
3 1 (2.78%) Manufacturing
3 1 (2.78%) Advertising
3 1 (2.78%) Retail
Job Titles
1 29 (80.56%) DBA
2 23 (63.89%) SQL DBA
3 13 (36.11%) Administrator
4 11 (30.56%) SQL Server DBA
5 5 (13.89%) Senior DBA
6 4 (11.11%) Applications Support
6 4 (11.11%) Server Administrator
6 4 (11.11%) Senior SQL DBA
6 4 (11.11%) Data Manager
7 3 (8.33%) Analyst
7 3 (8.33%) Server Support
8 2 (5.56%) Support Analyst
8 2 (5.56%) Data Architect
8 2 (5.56%) Architect
8 2 (5.56%) Senior SQL Server DBA
9 1 (2.78%) Senior Data Analyst
9 1 (2.78%) Applications Support Analyst
9 1 (2.78%) Team Leader
9 1 (2.78%) Senior Analyst
9 1 (2.78%) Data Analyst
Libraries, Frameworks & Software Standards
1 2 (5.56%) HTML
1 2 (5.56%) CSS
2 1 (2.78%) .NET
2 1 (2.78%) ASP.NET
Miscellaneous
1 18 (50.00%) Replication
2 9 (25.00%) Clustering
3 6 (16.67%) Statistics
4 5 (13.89%) Management Information System
5 1 (2.78%) FMCG
Operating Systems
1 15 (41.67%) Windows
2 1 (2.78%) Windows Server 2003
2 1 (2.78%) Windows Server 2008
2 1 (2.78%) Windows 2000 Server
Processes & Methodologies
1 23 (63.89%) Performance Tuning
2 15 (41.67%) Database Security
3 9 (25.00%) Performance Monitoring
4 7 (19.44%) ETL
4 7 (19.44%) Business Intelligence
4 7 (19.44%) Data Management
5 6 (16.67%) Capacity Planning
5 6 (16.67%) Change Control
6 5 (13.89%) Change Management
7 4 (11.11%) Mentoring
8 3 (8.33%) Disaster Recovery
8 3 (8.33%) Network Load Balancing
8 3 (8.33%) Release Management
8 3 (8.33%) Fault Management
8 3 (8.33%) ERP
8 3 (8.33%) Data Architecture
9 2 (5.56%) Root Cause Analysis
9 2 (5.56%) Performance Management
9 2 (5.56%) Agile Software Development
10 1 (2.78%) User Acceptance Testing
Programming Languages
1 36 (100.00%) SQL
2 27 (75.00%) T-SQL
3 6 (16.67%) VBA
4 2 (5.56%) C#
5 1 (2.78%) PowerShell
Qualifications
1 3 (8.33%) Microsoft Certification
2 2 (5.56%) MCTS
2 2 (5.56%) MCITP
3 1 (2.78%) MCP
Quality Assurance & Compliance
1 4 (11.11%) SLA
System Software
1 6 (16.67%) Terminal Server
1 6 (16.67%) Hyper-V
Systems Management
1 2 (5.56%) SCOM
Vendors
1 16 (44.44%) Microsoft
2 6 (16.67%) HP
3 2 (5.56%) Baan
4 1 (2.78%) Oracle
North Yorkshire
The Bridge Ltd
Salary: Up to £45,000 per annum + Good Benefits
Posted: 3 days ago
West Yorkshire
Experis Ltd
Salary: £40000 - £46500.00 per annum + Excellent Benefits
Posted: 4 days ago
Halifax, West Yorkshire
4it Recruitment Ltd
Salary: From £35,000 to £40,000 per annum £6,500 on call rota
Posted: 5 days ago