Period
to 20 November 2017

The following table provides summary statistics for permanent job vacancies advertised in Lancashire with a requirement for DTS skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited DTS over the 6 months to 20 November 2017 with a comparison to the same period in the previous 2 years.

Microsoft Data Transformation Services (DTS)
North West > Lancashire
6 months to
20 Nov 2017
Same period 2016 Same period 2015
Rank 71 75 -
Rank change year-on-year +4 - +93
Permanent jobs citing DTS 10 8 0
As % of all permanent IT jobs advertised in Lancashire 1.12% 0.89% -
As % of the Database & Business Intelligence category 3.04% 2.42% -
Number of salaries quoted 0 8 0
Lancashire median annual salary - £42,500 -
North West median annual salary £60,000 £42,500 £43,750
% change year-on-year +41.18% -2.86% +13.64%

DTS is in the Databases and Business Intelligence category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Lancashire with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
Lancashire
Permanent vacancies with a requirement for database or business intelligence skills 329 331 366
As % of all permanent IT jobs advertised in Lancashire 36.84% 36.90% 36.31%
Number of salaries quoted 289 292 308
Lancashire median annual salary £35,000 £37,500 £35,000
Median salary % change year-on-year -6.67% +7.14% -
10th Percentile £27,500 £26,250 £26,250
90th Percentile £47,500 £45,000 £45,779
North West median annual salary £42,500 £40,000 £40,000
% change year-on-year +6.25% - +5.26%

DTS
Job Vacancy Trend in Lancashire

Job postings citing DTS as a percentage of all IT jobs advertised in Lancashire.

Job vacancy trend for DTS in Lancashire

DTS
Salary Trend in Lancashire

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

Salary trend for DTS in Lancashire

For the 6 months to 20 November 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 Lancashire region with a requirement for DTS.

1 10 (100.00%) SQL
1 10 (100.00%) SQL Server
1 10 (100.00%) Windows
1 10 (100.00%) Data Warehouse
1 10 (100.00%) Business Intelligence
1 10 (100.00%) Microsoft
1 10 (100.00%) SQL Server Integration Services
2 6 (60.00%) Degree
2 6 (60.00%) Cognos Business Intelligence
2 6 (60.00%) SQL Server 2012
2 6 (60.00%) Windows Server 2012
2 6 (60.00%) SQL Server Reporting Services
2 6 (60.00%) SQL Server 2005
2 6 (60.00%) SQL Server 2016
2 6 (60.00%) BizTalk Server
2 6 (60.00%) IBM
2 6 (60.00%) ETL
2 6 (60.00%) Cognos
2 6 (60.00%) SharePoint
2 6 (60.00%) T-SQL
2 6 (60.00%) VMware
2 6 (60.00%) VMware Infrastructure
2 6 (60.00%) Windows Server 2008
2 6 (60.00%) SQL Server 2008
3 4 (40.00%) Database Tuning
3 4 (40.00%) Team Foundation Server
3 4 (40.00%) Microsoft Azure
3 4 (40.00%) Change Control
3 4 (40.00%) Data Quality
3 4 (40.00%) Microsoft Analysis Services

DTS
Co-occurring IT Skills in Lancashire 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 6 (60.00%) BizTalk Server
1 6 (60.00%) SharePoint
Business Applications
1 6 (60.00%) Cognos Business Intelligence
Cloud Services
1 4 (40.00%) Microsoft Azure
Database & Business Intelligence
1 10 (100.00%) Data Warehouse
1 10 (100.00%) SQL Server
1 10 (100.00%) SQL Server Integration Services
2 6 (60.00%) SQL Server 2005
2 6 (60.00%) SQL Server 2008
2 6 (60.00%) SQL Server 2012
2 6 (60.00%) SQL Server 2016
2 6 (60.00%) SQL Server Reporting Services
3 4 (40.00%) Microsoft Analysis Services
3 4 (40.00%) SQL Server Analysis Services
Development Applications
1 4 (40.00%) Team Foundation Server
1 4 (40.00%) Visual Studio
Job Titles
1 6 (60.00%) Analyst
1 6 (60.00%) Applications Support
1 6 (60.00%) Applications Support Analyst
1 6 (60.00%) SQL Analyst
1 6 (60.00%) SQL Support Analyst
1 6 (60.00%) Support Analyst
2 4 (40.00%) Administrator
2 4 (40.00%) Data Administrator
2 4 (40.00%) DBA
Libraries, Frameworks & Software Standards
1 4 (40.00%) .NET
Operating Systems
1 10 (100.00%) Windows
2 6 (60.00%) Windows Server 2008
2 6 (60.00%) Windows Server 2012
Processes & Methodologies
1 10 (100.00%) Business Intelligence
2 6 (60.00%) ETL
3 4 (40.00%) Change Control
3 4 (40.00%) Customer Requirements
3 4 (40.00%) Database Tuning
3 4 (40.00%) Migration
3 4 (40.00%) Performance Monitoring
3 4 (40.00%) Performance Tuning
Programming Languages
1 10 (100.00%) SQL
2 6 (60.00%) T-SQL
Qualifications
1 6 (60.00%) Degree
Quality Assurance & Compliance
1 4 (40.00%) Data Quality
System Software
1 6 (60.00%) VMware Infrastructure
Systems Management
1 4 (40.00%) Failover Clustering
1 4 (40.00%) Perfmon
Vendors
1 10 (100.00%) Microsoft
2 6 (60.00%) Cognos
2 6 (60.00%) IBM
2 6 (60.00%) VMware
3 4 (40.00%) Oracle