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

3 months to
3 Dec 2016
Same period 2015 Same period 2014
Extract, Transform and Load (ETL)
Rank 51 51 55
Rank change year-on-year
0 +4
Permanent jobs citing ETL 9 7 11
As % of all permanent IT jobs located in Lancashire 1.71% 1.54% 2.15%
As % of the Processes & Methodologies category 1.96% 1.90% 2.48%
Number of salaries quoted 9 7 10
Median salary £40,000 £30,459 £42,000
Median salary % change year-on-year
+31.32% -27.47%
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
460 368 443
As % of all permanent IT jobs located in Lancashire 87.62% 80.70% 86.52%
Number of salaries quoted 419 283 382
Median salary £39,750 £37,500 £35,000
Median salary % change year-on-year
+6.00% +7.14%
90% offered a salary of more than £26,000 £29,000 £26,500
10% offered a salary of more than £52,500 £47,500 £56,500
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 3 December 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 3 December 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
Chorley - 5 £37,500 - 2
Burnley - 1 £47,500 -
ETL
North West

ETL
Top 30 Related IT Skills in Lancashire

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

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:

Applications
1 6 (50.00%) MS Excel
Business Applications
1 5 (41.67%) Cognos Business Intelligence
Database & Business Intelligence
1 12 (100.00%) SQL Server Reporting Services
2 11 (91.67%) Data Warehouse
2 11 (91.67%) SQL Server Analysis Services
3 9 (75.00%) QlikView
4 7 (58.33%) SQL Server
4 7 (58.33%) SQL Server Integration Services
5 5 (41.67%) MS Access
6 4 (33.33%) Power BI
7 2 (16.67%) SQL Server 2012
8 1 (8.33%) Enterprise Data Warehouse
8 1 (8.33%) OLAP
8 1 (8.33%) SQL Server 2014
8 1 (8.33%) SQL Server 2016
Development Applications
1 1 (8.33%) Team Foundation Server
General
1 5 (41.67%) Finance
1 5 (41.67%) Manufacturing
2 3 (25.00%) Legal
Job Titles
1 11 (91.67%) 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%) Software Developer
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%) .NET
2 1 (8.33%) ASP.NET
Miscellaneous
1 4 (33.33%) Data Integration
2 3 (25.00%) iPad
3 1 (8.33%) Clustering
3 1 (8.33%) Replication
Processes & Methodologies
1 12 (100.00%) 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%) Agile Software Development
5 1 (8.33%) Change Data Capture
5 1 (8.33%) Continuous Improvement
5 1 (8.33%) Data Modelling
5 1 (8.33%) Data Transformation
5 1 (8.33%) Functional Testing
5 1 (8.33%) Integration Testing
5 1 (8.33%) Kanban
5 1 (8.33%) Kimball Methodology
5 1 (8.33%) Mentoring
5 1 (8.33%) Project Management
5 1 (8.33%) Root Cause Analysis
5 1 (8.33%) Scrum
Programming Languages
1 12 (100.00%) SQL
2 8 (66.67%) VBA
3 4 (33.33%) T-SQL
4 3 (25.00%) VBScript
5 1 (8.33%) Data Analysis Expressions (DAX)
5 1 (8.33%) R
Vendors
1 9 (75.00%) Microsoft
2 5 (41.67%) Cognos
2 5 (41.67%) Oracle
2 5 (41.67%) Tableau
Chorley
Foresight Solutions
Salary: £0 - £55,000 per year
Posted: 3 days ago