The table below looks at the statistics for ETL skills in IT jobs advertised for the Lancashire region. Included is a guide to the salaries offered in IT jobs that have cited ETL over the 3 months to 2 May 2016 with a comparison to the same period over the previous 2 years.

3 months to
2 May 2016
Same period 2015 Same period 2014
Extract, Transform and Load (ETL)
Rank 49 56 60
Rank change year-on-year
+7 +4
Permanent jobs citing ETL 10 6 1
As % of all permanent IT jobs located in Lancashire 2.51% 1.28% 0.23%
As % of the Processes & Methodologies category 2.91% 1.52% 0.27%
Number of salaries quoted 10 6 1
Median salary £40,000 £30,969 £45,000
Median salary % change year-on-year
+29.16% -31.18%
UK excluding London median salary £45,000 £45,000 £45,000
ETL
North West

The following table is for comparison with the above and provides statistics for the entire Processes & Methodologies category in permanent jobs advertised in the Lancashire region.

Processes & Methodologies Category
Lancashire
Permanent IT job ads with a match in the
Processes & Methodologies category
344 396 371
As % of all permanent IT jobs located in Lancashire 86.43% 84.43% 83.56%
Number of salaries quoted 289 340 301
Median salary £36,250 £37,500 £37,123
Median salary % change year-on-year
-3.33% +1.01%
90% offered a salary of more than £27,500 £25,000 £26,000
10% offered a salary of more than £50,000 £55,000 £55,000
UK excluding London median salary £45,000 £44,000 £42,500
% change year-on-year
+2.27% +3.52%

ETL
Jobs Demand Trend in Lancashire

The demand trend of job ads across the Lancashire region citing ETL as a proportion of all IT jobs with a match in the Processes & Methodologies category.

ETL Jobs Demand Trend in Lancashire

ETL
Salary Trend in Lancashire

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

ETL Salary Trend in Lancashire

ETL
Salary Histogram in Lancashire

This chart provides a salary histogram for IT jobs citing ETL across the Lancashire region over the 3 months to 2 May 2016.

ETL Salary Histogram in Lancashire

ETL
Job Locations in Lancashire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing ETL within the Lancashire region over the 3 months to 2 May 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
(Click see detailed
statistics and trends)
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
Preston +9 6 £40,000 +45.45% 2
Chorley - 1 £42,500 -
Skelmersdale - 1 £37,500 - 1
ETL
North West

ETL
Top 30 Related IT Skills in Lancashire

For the 6 months to 2 May 2016, IT jobs citing ETL 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 ETL.

1 11 (100.00%) Business Intelligence
2 9 (81.82%) SQL
2 9 (81.82%) SQL Server
2 9 (81.82%) SQL Server Integration Services
3 8 (72.73%) Microsoft
3 8 (72.73%) SQL Server Reporting Services
4 7 (63.64%) Team Foundation Server
4 7 (63.64%) T-SQL
5 5 (45.45%) Data Warehouse
5 5 (45.45%) Data Modelling
5 5 (45.45%) Agile Software Development
5 5 (45.45%) SQL Server 2012
5 5 (45.45%) Data Integration
5 5 (45.45%) Root Cause Analysis
5 5 (45.45%) Relational Database
5 5 (45.45%) SQL Server 2014
6 4 (36.36%) Kanban
6 4 (36.36%) Scrum
6 4 (36.36%) Replication
6 4 (36.36%) Clustering
7 3 (27.27%) Data Management
7 3 (27.27%) MS Excel
7 3 (27.27%) NHS
7 3 (27.27%) RDBMS
7 3 (27.27%) SQL Server Analysis Services
7 3 (27.27%) Change Data Capture
7 3 (27.27%) Tableau
7 3 (27.27%) PowerPivot
7 3 (27.27%) Microsoft Power View
8 2 (18.18%) OLAP Cube

ETL
Top Related 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 2 (18.18%) SharePoint
Applications
1 3 (27.27%) MS Excel
Database & Business Intelligence
1 9 (81.82%) SQL Server
1 9 (81.82%) SQL Server Integration Services
2 8 (72.73%) SQL Server Reporting Services
3 5 (45.45%) Data Warehouse
3 5 (45.45%) Relational Database
3 5 (45.45%) SQL Server 2012
3 5 (45.45%) SQL Server 2014
4 3 (27.27%) Microsoft Power View
4 3 (27.27%) PowerPivot
4 3 (27.27%) RDBMS
4 3 (27.27%) SQL Server Analysis Services
5 2 (18.18%) Enterprise Data Warehouse
5 2 (18.18%) OLAP
5 2 (18.18%) OLAP Cube
6 1 (9.09%) Datazen
6 1 (9.09%) Microsoft Analysis Services
6 1 (9.09%) Power BI
6 1 (9.09%) QlikView
6 1 (9.09%) SQL Server 2016
Development Applications
1 7 (63.64%) Team Foundation Server
2 2 (18.18%) Git (software)
2 2 (18.18%) Subversion
General
1 2 (18.18%) Finance
2 1 (9.09%) Manufacturing
Job Titles
1 10 (90.91%) Developer
2 5 (45.45%) Business Intelligence Developer
3 4 (36.36%) SQL Developer
4 3 (27.27%) Microsoft BI Developer
4 3 (27.27%) SQL BI Developer
5 2 (18.18%) Data Warehouse Developer
5 2 (18.18%) Microsoft Developer
5 2 (18.18%) Software Developer
6 1 (9.09%) .NET Developer
6 1 (9.09%) Analyst
6 1 (9.09%) ASP.NET Developer
6 1 (9.09%) QlikView Analyst
6 1 (9.09%) SQL Analyst
6 1 (9.09%) SQL Server BI Developer
6 1 (9.09%) SQL Server Developer
6 1 (9.09%) SSAS Developer
6 1 (9.09%) SSIS Developer
6 1 (9.09%) SSRS Developer
6 1 (9.09%) Systems Analyst
6 1 (9.09%) T-SQL Developer
Libraries, Frameworks & Software Standards
1 2 (18.18%) .NET
2 1 (9.09%) .NET Framework
2 1 (9.09%) ASP.NET
2 1 (9.09%) MDX
Miscellaneous
1 5 (45.45%) Data Integration
2 4 (36.36%) Clustering
2 4 (36.36%) Replication
3 3 (27.27%) NHS
4 2 (18.18%) Data Structures
5 1 (9.09%) Analytical Skills
5 1 (9.09%) Visualisation
Processes & Methodologies
1 11 (100.00%) Business Intelligence
2 5 (45.45%) Agile Software Development
2 5 (45.45%) Data Modelling
2 5 (45.45%) Root Cause Analysis
3 4 (36.36%) Kanban
3 4 (36.36%) Scrum
4 3 (27.27%) Change Data Capture
4 3 (27.27%) Data Management
5 2 (18.18%) Continuous Improvement
5 2 (18.18%) Functional Testing
5 2 (18.18%) Integration Testing
5 2 (18.18%) Mentoring
5 2 (18.18%) Project Management
6 1 (9.09%) Complex ETL
6 1 (9.09%) OOD
6 1 (9.09%) Performance Optimisation
6 1 (9.09%) Refactoring
6 1 (9.09%) User Stories
Programming Languages
1 9 (81.82%) SQL
2 7 (63.64%) T-SQL
3 1 (9.09%) Data Analysis Expressions (DAX)
Vendors
1 8 (72.73%) Microsoft
2 3 (27.27%) Tableau
Lancashire
Capita plc
Posted: 11 days ago
Skelmersdale
Hays Specialist Recruitment Ltd
Salary: £35000.00 - £40000.00 per annum + Benefits
Posted: 17 days ago