Lancashire DTS Jobs

The table below looks at the demand for Microsoft Data Transformation Services (DTS) skills within the Lancashire region with a comparison to our Database & Business Intelligence category. Included is a guide to the average salaries offered in IT jobs that have cited DTS over the 3 months to 8 October 2008 with a comparison to the same period last year.

Microsoft Data Transformation Services (DTS)
Location Abingdon Barnet Basingstoke Bath Bedford Bedfordshire Berkshire Birmingham Borehamwood Bracknell Bradford Brentwood Brighton Bristol Buckinghamshire Burton-upon-Trent Bury St Edmunds Cambridge Cambridgeshire Canary Wharf Canterbury Cardiff Chertsey Cheshire Chester Chesterfield Chippenham Chorley Cirencester City of London Clapham Coventry Crawley Croydon Derby Derbyshire Devon Docklands, London Durham East Grinstead East Midlands East of England East Sussex East Yorkshire Edinburgh Ellesmere Port England Essex Exeter Farnborough Folkestone Gatwick Glasgow Gloucestershire Godalming Guildford Hammersmith Hampshire Harrogate Havant Hemel Hempstead Hereford Herefordshire Hertfordshire Hove Hull Isle of Man Kent Knaresborough Lancashire Leamington Spa Leeds Leicester Leicestershire Livingston London Macclesfield Maidenhead Maidstone Manchester Margate Merseyside Middlesex Midlands Milton Keynes Newcastle Newmarket Newport Norfolk North East North West North Yorkshire Norwich Nottingham Nottinghamshire Nuneaton Oldham Oxford Oxfordshire Portsmouth Preston Reading Scarborough Scotland Slough Solihull Somerset South East South Wales South West Southampton Staffordshire Staines Stockport Suffolk Surrey Sussex Swindon Torquay Tyne and Wear UK Wales Wallingford Waltham Abbey Warrington Warwickshire Welwyn Garden City West Lothian West Midlands West Sussex West Yorkshire Wilmslow Wiltshire Winchester Windsor Wirral Woking Wokingham Wolverhampton York Yorkshire	3 months to 8 Oct 2008	Same period last year
Rank	83	66
Rank change on same period last year	-17
Matching permanent IT job ads	11	20
As % of all UK permanent IT job ads sampled	0.006 %	0.009 %
As % of the category below	2.306 %	4.464 %
Salaries quoted	11	14
Average minimum salary	£30,636	£29,429
Average salary	£31,318	£30,321
% change on same period last year	+3.28 %
Average maximum salary	£32,000	£31,214
UK excluding London average salary	£36,724	£37,610
% change on same period last year	-2.35 %
Database & Business Intelligence Lancashire
Matching permanent IT job ads	477	448
As % of all UK permanent IT job ads sampled	0.275 %	0.195 %
Salaries quoted	396	362
Average minimum salary	£27,897	£30,560
Average salary	£30,290	£32,450
% change on same period last year	-6.65 %
Average maximum salary	£32,683	£34,339
UK excluding London average salary	£37,428	£38,458
% change on same period last year	-2.67 %
DTS North West

DTS
Demand Trend

The chart provides a 3-month moving total beginning in 2004 of permanent IT jobs citing DTS across the Lancashire region as a proportion of the total demand within the Database & Business Intelligence category.

DTS
Salary Trend

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

DTS
Salary Histogram

The chart provides a salary histogram for IT jobs citing DTS across the Lancashire region over the 3 months to 8 October 2008.

DTS
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 Lancashire region over the 3 months to 8 October 2008. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year. A positive number indicates a relative increase in demand.

Location	Rank Change on Same Period Last Last	Matching Permanent IT Job Ads	Average Salary Last 3 Months	Average Salary % Change on Same Period Last Year
Preston	-7	7	£34,857	-
Chorley	-3	3	£26,000	+29.99 %

DTS North West

DTS
Top 30 Related IT Skills

For the 6 months to 8 October 2008, IT jobs across the Lancashire 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 16 (88.89 %) SQL Server 2 14 (77.78 %) SQL 3 13 (72.22 %) SQL Server Integration Services 4 10 (55.56 %) Datawarehouse 4 10 (55.56 %) SQL Server Reporting Services 5 9 (50.00 %) SQL Server Analysis Services 6 8 (44.44 %) ETL 7 7 (38.89 %) Business Intelligence 7 7 (38.89 %) Transact-SQL 8 6 (33.33 %) SQL Server 2000 8 6 (33.33 %) Health 8 6 (33.33 %) .NET 8 6 (33.33 %) Microsoft 8 6 (33.33 %) MDX 8 6 (33.33 %) Pensions

8 6 (33.33 %) SQL Server 2005 9 5 (27.78 %) Microsoft Analysis Services 9 5 (27.78 %) Crystal Reports 9 5 (27.78 %) OLAP 9 5 (27.78 %) Data Analysis 10 4 (22.22 %) MS Excel 10 4 (22.22 %) SharePoint 11 3 (16.67 %) MCSE 11 3 (16.67 %) Windows 11 3 (16.67 %) Microsoft Certification 11 3 (16.67 %) VB 11 3 (16.67 %) VB.NET 11 3 (16.67 %) ASP.NET 11 3 (16.67 %) Business Analysis 11 3 (16.67 %) Finance

DTS
Top Related IT Skills by Category

For the 6 months to 8 October 2008, IT jobs across the Lancashire 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 Development 1 6 (33.33 %) .NET 1 6 (33.33 %) MDX 2 3 (16.67 %) ASP.NET 3 2 (11.11 %) ASP 3 2 (11.11 %) ActiveX 3 2 (11.11 %) XML 4 1 (5.556 %) XSLT 4 1 (5.556 %) ASP.NET 2.0 4 1 (5.556 %) XHTML 4 1 (5.556 %) AJAX 4 1 (5.556 %) .NET Framework 4 1 (5.556 %) WebServices	Application Platforms 1 4 (22.22 %) SharePoint 2 1 (5.556 %) BizTalk Server
Applications 1 4 (22.22 %) MS Excel 2 1 (5.556 %) MS Visio 2 1 (5.556 %) Photoshop	Communications & Networking 1 2 (11.11 %) FTP 2 1 (5.556 %) Intranet
Database & Business Intelligence 1 16 (88.89 %) SQL Server 2 13 (72.22 %) SQL Server Integration Services 3 10 (55.56 %) SQL Server Reporting Services 3 10 (55.56 %) Datawarehouse 4 9 (50.00 %) SQL Server Analysis Services 5 8 (44.44 %) ETL 6 6 (33.33 %) SQL Server 2000 6 6 (33.33 %) SQL Server 2005 7 5 (27.78 %) Microsoft Analysis Services 7 5 (27.78 %) OLAP 7 5 (27.78 %) Crystal Reports 8 2 (11.11 %) Crystal Enterprise 8 2 (11.11 %) BusinessObjects	Development Applications 1 1 (5.556 %) Visual Studio 1 1 (5.556 %) VSS/SourceSafe 1 1 (5.556 %) Dreamweaver
General 1 6 (33.33 %) Health 1 6 (33.33 %) Pensions 2 3 (16.67 %) Finance	Job Titles 1 7 (38.89 %) Analyst 2 6 (33.33 %) Developer 3 5 (27.78 %) DBA 4 4 (22.22 %) SQL DBA 5 3 (16.67 %) Business Analyst 6 2 (11.11 %) Systems Analyst 6 2 (11.11 %) Administrator 6 2 (11.11 %) .NET Developer 6 2 (11.11 %) Technical Analyst 6 2 (11.11 %) Business Intelligence Analyst 6 2 (11.11 %) MI Analyst 7 1 (5.556 %) VB.NET/ASP.NET Developer 7 1 (5.556 %) C#/ASP.NET Developer 7 1 (5.556 %) Lead Developer 7 1 (5.556 %) ASP Developer 7 1 (5.556 %) ASP.NET Developer 7 1 (5.556 %) SQL Developer 7 1 (5.556 %) SQL Server Developer 7 1 (5.556 %) Intranet Developer 7 1 (5.556 %) Server Administrator
Miscellaneous 1 1 (5.556 %) Replication	Operating Systems 1 3 (16.67 %) Windows 1 3 (16.67 %) Windows Server 2003
Processes & Methodologies 1 7 (38.89 %) Business Intelligence 2 5 (27.78 %) Data Analysis 3 3 (16.67 %) Business Analysis 4 1 (5.556 %) Technical Architecture 4 1 (5.556 %) SEO 4 1 (5.556 %) OO 4 1 (5.556 %) E-Commerce	Programming Languages 1 14 (77.78 %) SQL 2 7 (38.89 %) Transact-SQL 3 3 (16.67 %) VB 3 3 (16.67 %) VB.NET 3 3 (16.67 %) VB6 4 2 (11.11 %) C# 5 1 (5.556 %) Java 5 1 (5.556 %) JavaScript 5 1 (5.556 %) VC++
Qualifications 1 3 (16.67 %) MCSE 1 3 (16.67 %) Microsoft Certification	Vendors 1 6 (33.33 %) Microsoft 2 2 (11.11 %) Business Objects