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 28 May 2016 with a comparison to the same period over the previous 2 years.

3 months to
28 May 2016
Same period 2015 Same period 2014
Extract, Transform and Load (ETL)
Rank 54 62 -
Rank change year-on-year
+8 -
Permanent jobs citing ETL 8 3 0
As % of all permanent IT jobs located in Lancashire 1.84% 0.58% -
As % of the Processes & Methodologies category 2.07% 0.68% -
Number of salaries quoted 8 3 0
Median salary £40,000 £30,969 -
Median salary % change year-on-year
+29.16% -
UK excluding London median salary £45,000 £45,000 £44,000
% change year-on-year
- +2.27%
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
386 438 355
As % of all permanent IT jobs located in Lancashire 88.74% 85.38% 85.34%
Number of salaries quoted 317 363 280
Median salary £37,500 £36,000 £35,000
Median salary % change year-on-year
+4.16% +2.85%
90% offered a salary of more than £27,500 £25,000 £25,000
10% offered a salary of more than £62,500 £55,000 £47,500
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 28 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 28 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 - 5 £40,000 -
Skelmersdale - 2 £38,750 -
Chorley - 1 £32,500 -
ETL
North West

ETL
Top 30 Related IT Skills in Lancashire

For the 6 months to 28 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 12 (100.00%) Business Intelligence
2 11 (91.67%) SQL
3 10 (83.33%) SQL Server
3 10 (83.33%) SQL Server Integration Services
4 9 (75.00%) SQL Server Reporting Services
5 8 (66.67%) T-SQL
5 8 (66.67%) Microsoft
6 6 (50.00%) Team Foundation Server
6 6 (50.00%) SQL Server 2012
7 5 (41.67%) Root Cause Analysis
7 5 (41.67%) Data Integration
7 5 (41.67%) Data Warehouse
7 5 (41.67%) Data Modelling
7 5 (41.67%) MS Excel
7 5 (41.67%) Agile Software Development
7 5 (41.67%) SQL Server 2014
8 4 (33.33%) Scrum
8 4 (33.33%) Replication
8 4 (33.33%) Clustering
8 4 (33.33%) SQL Server Analysis Services
8 4 (33.33%) Kanban
8 4 (33.33%) Relational Database
9 3 (25.00%) Change Data Capture
9 3 (25.00%) PowerPivot
9 3 (25.00%) OLAP
10 2 (16.67%) Data Analysis Expressions (DAX)
10 2 (16.67%) .NET
10 2 (16.67%) RDBMS
10 2 (16.67%) NHS
10 2 (16.67%) Project Management

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 1 (8.33%) SharePoint
Applications
1 5 (41.67%) MS Excel
2 1 (8.33%) MS Office
Database & Business Intelligence
1 10 (83.33%) SQL Server
1 10 (83.33%) SQL Server Integration Services
2 9 (75.00%) SQL Server Reporting Services
3 6 (50.00%) SQL Server 2012
4 5 (41.67%) Data Warehouse
4 5 (41.67%) SQL Server 2014
5 4 (33.33%) Relational Database
5 4 (33.33%) SQL Server Analysis Services
6 3 (25.00%) OLAP
6 3 (25.00%) PowerPivot
7 2 (16.67%) Enterprise Data Warehouse
7 2 (16.67%) Microsoft Power View
7 2 (16.67%) OLAP Cube
7 2 (16.67%) Power BI
7 2 (16.67%) RDBMS
8 1 (8.33%) Datazen
8 1 (8.33%) Microsoft Analysis Services
8 1 (8.33%) QlikView
8 1 (8.33%) SQL Server 2016
Development Applications
1 6 (50.00%) Team Foundation Server
2 1 (8.33%) Git (software)
2 1 (8.33%) Subversion
General
1 2 (16.67%) Finance
2 1 (8.33%) Manufacturing
Job Titles
1 10 (83.33%) Developer
2 6 (50.00%) Business Intelligence Developer
3 4 (33.33%) SQL Developer
4 3 (25.00%) Analyst
4 3 (25.00%) Business Intelligence Analyst
4 3 (25.00%) Microsoft BI Developer
4 3 (25.00%) SQL BI Developer
5 2 (16.67%) Microsoft Developer
5 2 (16.67%) Software Developer
6 1 (8.33%) .NET Developer
6 1 (8.33%) Analyst Developer
6 1 (8.33%) ASP.NET Developer
6 1 (8.33%) Business Intelligence Data Analyst
6 1 (8.33%) Data Analyst
6 1 (8.33%) Data Warehouse Developer
6 1 (8.33%) Developer Analyst
6 1 (8.33%) QlikView Analyst
6 1 (8.33%) SQL Server BI Developer
6 1 (8.33%) SQL Server Developer
6 1 (8.33%) Systems Analyst
Libraries, Frameworks & Software Standards
1 2 (16.67%) .NET
1 2 (16.67%) MDX
2 1 (8.33%) .NET Framework
2 1 (8.33%) ASP.NET
Miscellaneous
1 5 (41.67%) Data Integration
2 4 (33.33%) Clustering
2 4 (33.33%) Replication
3 2 (16.67%) Analytical Skills
3 2 (16.67%) NHS
4 1 (8.33%) Data Structures
4 1 (8.33%) Visualisation
Processes & Methodologies
1 12 (100.00%) Business Intelligence
2 5 (41.67%) Agile Software Development
2 5 (41.67%) Data Modelling
2 5 (41.67%) Root Cause Analysis
3 4 (33.33%) Kanban
3 4 (33.33%) Scrum
4 3 (25.00%) Change Data Capture
5 2 (16.67%) Continuous Improvement
5 2 (16.67%) Data Management
5 2 (16.67%) Functional Testing
5 2 (16.67%) Integration Testing
5 2 (16.67%) Mentoring
5 2 (16.67%) Project Management
6 1 (8.33%) Complex ETL
6 1 (8.33%) Data Acquisition
6 1 (8.33%) OOD
6 1 (8.33%) Performance Optimisation
6 1 (8.33%) Refactoring
6 1 (8.33%) User Stories
Programming Languages
1 11 (91.67%) SQL
2 8 (66.67%) T-SQL
3 2 (16.67%) Data Analysis Expressions (DAX)
Vendors
1 8 (66.67%) Microsoft
2 2 (16.67%) Tableau