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 17 January 2017 with a comparison to the same period over the previous 2 years.

3 months to
17 Jan 2017
Same period 2016 Same period 2015
Extract, Transform and Load (ETL)
North West / Lancashire
Rank 59 46 51
Rank change year-on-year
-13 +5
Permanent jobs citing ETL 5 3 12
As % of all permanent IT jobs located in Lancashire 1.01% 0.85% 2.48%
As % of the Processes & Methodologies category 1.14% 1.00% 2.80%
Number of salaries quoted 4 3 10
Median salary £41,250 £40,000 £42,000
Median salary % change year-on-year
+3.12% -4.76%
UK excluding London median salary £45,000 £44,897 £45,000
% change year-on-year
+0.22% -0.22%

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
439 300 428
As % of all permanent IT jobs located in Lancashire 88.51% 85.23% 88.43%
Number of salaries quoted 397 248 370
Median salary £37,500 £35,625 £35,000
Median salary % change year-on-year
+5.26% +1.78%
90% offered a salary of more than £22,000 £27,500 £24,500
10% offered a salary of more than £47,500 £50,000 £45,000
UK excluding London median salary £45,000 £45,000 £42,500
% change year-on-year
- +5.88%

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 17 January 2017.

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 17 January 2017. 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 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
Chorley - 2 £33,750 -
Burnley - 1 £47,500 -
Preston - 1 - -
ETL
North West

ETL
Top 30 Related IT Skills in Lancashire

For the 6 months to 17 January 2017, 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%) SQL
2 11 (91.67%) Business Intelligence
2 11 (91.67%) Data Warehouse
2 11 (91.67%) SQL Server Reporting Services
2 11 (91.67%) SQL Server Analysis Services
3 9 (75.00%) QlikView
4 8 (66.67%) Microsoft
4 8 (66.67%) VBA
5 6 (50.00%) SQL Server
5 6 (50.00%) SQL Server Integration Services
6 5 (41.67%) Dimensional Modelling
6 5 (41.67%) Cognos Business Intelligence
6 5 (41.67%) Tableau
6 5 (41.67%) Oracle
6 5 (41.67%) MS Excel
6 5 (41.67%) MS Access
6 5 (41.67%) Cognos
6 5 (41.67%) Manufacturing
6 5 (41.67%) Finance
7 4 (33.33%) Data Analysis
8 3 (25.00%) Legal
8 3 (25.00%) T-SQL
8 3 (25.00%) VBScript
8 3 (25.00%) Power BI
8 3 (25.00%) Customer Insight
8 3 (25.00%) iPad
8 3 (25.00%) Data Integration
8 3 (25.00%) Business Analysis
9 2 (16.67%) MDX
10 1 (8.33%) JIRA

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%) Confluence
1 1 (8.33%) JBoss
1 1 (8.33%) Tomcat
Applications
1 5 (41.67%) MS Excel
Business Applications
1 5 (41.67%) Cognos Business Intelligence
Database & Business Intelligence
1 11 (91.67%) Data Warehouse
1 11 (91.67%) SQL Server Analysis Services
1 11 (91.67%) SQL Server Reporting Services
2 9 (75.00%) QlikView
3 6 (50.00%) SQL Server
3 6 (50.00%) SQL Server Integration Services
4 5 (41.67%) MS Access
5 3 (25.00%) Power BI
6 1 (8.33%) Enterprise Data Warehouse
6 1 (8.33%) GIS
6 1 (8.33%) MongoDB
6 1 (8.33%) MySQL
6 1 (8.33%) OLAP
6 1 (8.33%) SQL Server 2012
Development Applications
1 1 (8.33%) Ant
1 1 (8.33%) JIRA
1 1 (8.33%) Selenium
1 1 (8.33%) TestRail
General
1 5 (41.67%) Finance
1 5 (41.67%) Manufacturing
2 3 (25.00%) Legal
Job Titles
1 10 (83.33%) Developer
2 8 (66.67%) QlikView Developer
3 5 (41.67%) Analyst
3 5 (41.67%) Analyst Developer
3 5 (41.67%) Business Intelligence Developer
3 5 (41.67%) QlikView Analyst
4 1 (8.33%) Report Manager
4 1 (8.33%) SQL BI Developer
4 1 (8.33%) SQL Developer
4 1 (8.33%) SSAS Developer
4 1 (8.33%) SSIS Developer
4 1 (8.33%) SSRS Developer
Libraries, Frameworks & Software Standards
1 2 (16.67%) MDX
2 1 (8.33%) JMS
2 1 (8.33%) OpenID
2 1 (8.33%) REST
2 1 (8.33%) SAML
2 1 (8.33%) SOAP
2 1 (8.33%) Spring
2 1 (8.33%) Web Services
2 1 (8.33%) XSLT
Miscellaneous
1 3 (25.00%) Data Integration
1 3 (25.00%) iPad
Operating Systems
1 1 (8.33%) Unix
1 1 (8.33%) Windows
Processes & Methodologies
1 11 (91.67%) Business Intelligence
2 5 (41.67%) Dimensional Modelling
3 4 (33.33%) Data Analysis
4 3 (25.00%) Business Analysis
4 3 (25.00%) Customer Insight
5 1 (8.33%) AOP
5 1 (8.33%) Data Modelling
5 1 (8.33%) Data Transformation
5 1 (8.33%) Kimball Methodology
5 1 (8.33%) MVC
5 1 (8.33%) SDLC
5 1 (8.33%) Service Design
5 1 (8.33%) Translating Business Requirements
Programming Languages
1 12 (100.00%) SQL
2 8 (66.67%) VBA
3 3 (25.00%) T-SQL
3 3 (25.00%) VBScript
4 1 (8.33%) Data Analysis Expressions (DAX)
4 1 (8.33%) Java
Vendors
1 8 (66.67%) Microsoft
2 5 (41.67%) Cognos
2 5 (41.67%) Oracle
2 5 (41.67%) Tableau
3 1 (8.33%) TIBCO