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

Location
3 months to
22 May 2015
Same period 2014 Same period 2013
Extract, Transform and Load (ETL)
Rank 41 48 27
Rank change year-on-year
+7 -21
Permanent jobs citing ETL 6 9 9
As % of all permanent IT jobs located in Portsmouth 2.16% 2.20% 4.39%
As % of the Processes & Methodologies category 2.59% 3.01% 5.63%
Number of salaries quoted 6 5 5
Average salary £60,000 £41,500 £37,500
Average salary % change year-on-year
+44.57% +10.66%
90% offered a salary of more than £35,000 £40,600 £28,500
10% offered a salary of more than £66,250 £41,500 £38,100
UK excluding London average salary £45,000 £45,000 £45,000
ETL
Hampshire

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

Processes & Methodologies Category
Portsmouth
Permanent IT job ads with a match in the
Processes & Methodologies category
232 299 160
As % of all permanent IT jobs located in Portsmouth 83.45% 72.93% 78.05%
Number of salaries quoted 202 256 149
Average salary £45,000 £41,500 £40,000
Average salary % change year-on-year
+8.43% +3.75%
90% offered a salary of more than £25,000 £25,000 £25,000
10% offered a salary of more than £52,500 £60,000 £51,177
UK excluding London average salary £44,485 £42,500 £40,000
% change year-on-year
+4.66% +6.25%

ETL
Jobs Demand Trend in Portsmouth

This chart provides a 3-month moving total of permanent IT jobs citing ETL across the Portsmouth region as a proportion of the total demand within the Processes & Methodologies category.

ETL Jobs Demand Trend in Portsmouth

ETL
Salary Trend in Portsmouth

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

ETL Salary Trend in Portsmouth

ETL
Salary Histogram in Portsmouth

This chart provides a salary histogram for IT jobs citing ETL across the Portsmouth region over the 3 months to 22 May 2015.

ETL Salary Histogram in Portsmouth

ETL
Top 26 Related IT Skills in Portsmouth

For the 6 months to 22 May 2015, IT jobs across the Portsmouth region citing ETL 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 ETL.

1 11 (100.00%) SQL
1 11 (100.00%) Business Intelligence
2 9 (81.82%) Data Warehouse
2 9 (81.82%) Data Modelling
3 6 (54.55%) SQL Server Integration Services
3 6 (54.55%) Analytics
4 5 (45.45%) Oracle
5 4 (36.36%) Cognos
5 4 (36.36%) SQL Server Reporting Services
5 4 (36.36%) Data Governance
6 3 (27.27%) Data Architecture
7 2 (18.18%) WebFOCUS
7 2 (18.18%) JIRA
7 2 (18.18%) Cognos Business Intelligence
7 2 (18.18%) Data Integration
7 2 (18.18%) Knowledge Management
7 2 (18.18%) FTP
7 2 (18.18%) Management Information System
7 2 (18.18%) Finance
7 2 (18.18%) EDI
7 2 (18.18%) Agresso
7 2 (18.18%) Analytical Skills
7 2 (18.18%) Physical Data Model
8 1 (9.09%) Logical Data Model
8 1 (9.09%) Mentoring
8 1 (9.09%) PL/SQL

ETL
Top Related IT Skills in Portsmouth by Category

For the 6 months to 22 May 2015, IT jobs across the Portsmouth region citing ETL 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 ETL. Up to 20 skills are shown per category.

Business Applications
1 2 (18.18%) Cognos Business Intelligence
1 2 (18.18%) Agresso
Communications & Networking
1 2 (18.18%) FTP
Database & Business Intelligence
1 9 (81.82%) Data Warehouse
2 6 (54.55%) SQL Server Integration Services
3 4 (36.36%) SQL Server Reporting Services
4 2 (18.18%) WebFOCUS
Development Applications
1 2 (18.18%) JIRA
General
1 2 (18.18%) Finance
Job Titles
1 6 (54.55%) Administrator
2 4 (36.36%) Database Designer
2 4 (36.36%) DBA
2 4 (36.36%) Solutions Designer
2 4 (36.36%) Senior DBA
2 4 (36.36%) Senior Database Designer
2 4 (36.36%) Designer
2 4 (36.36%) Senior Designer
3 3 (27.27%) Senior Data Modeller
3 3 (27.27%) Data Modeller
4 2 (18.18%) Senior Data Architect
4 2 (18.18%) Business Intelligence Developer
4 2 (18.18%) Senior Architect
4 2 (18.18%) Systems Support
4 2 (18.18%) Architect
4 2 (18.18%) Developer
4 2 (18.18%) Business Developer
4 2 (18.18%) Systems Administrator
4 2 (18.18%) Data Architect
5 1 (9.09%) Senior Business Intelligence Developer
Libraries, Frameworks & Software Standards
1 2 (18.18%) EDI
Miscellaneous
1 2 (18.18%) Data Integration
1 2 (18.18%) Management Information System
1 2 (18.18%) Analytical Skills
Processes & Methodologies
1 11 (100.00%) Business Intelligence
2 9 (81.82%) Data Modelling
3 6 (54.55%) Analytics
4 4 (36.36%) Data Governance
5 3 (27.27%) Data Architecture
6 2 (18.18%) Knowledge Management
6 2 (18.18%) Physical Data Model
7 1 (9.09%) Logical Data Model
7 1 (9.09%) Mentoring
Programming Languages
1 11 (100.00%) SQL
2 1 (9.09%) PL/SQL
Vendors
1 5 (45.45%) Oracle
2 4 (36.36%) Cognos