Period
to 15 July 2018

The following table provides summary statistics for permanent job vacancies advertised in Portsmouth with a requirement for Business Intelligence skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited Business Intelligence over the 6 months to 15 July 2018 with a comparison to the same period in the previous 2 years.

Business Intelligence (BI)
Hampshire > Portsmouth
6 months to
15 Jul 2018
Same period 2017 Same period 2016
Rank 25 27 20
Rank change year-on-year +2 -7 +9
Permanent jobs citing Business Intelligence 61 69 77
As % of all permanent IT jobs advertised in Portsmouth 10.00% 9.68% 14.92%
As % of the Processes & Methodologies category 10.43% 10.63% 17.07%
Number of salaries quoted 52 50 75
Portsmouth median annual salary £46,500 £41,250 £42,500
Median salary % change year-on-year +12.73% -2.94% +13.33%
10th Percentile £30,729 £31,250 £25,000
90th Percentile £62,500 £53,750 £52,500
Hampshire median annual salary £45,000 £45,000 £45,000

Business Intelligence is in the Processes and Methodologies category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Portsmouth with a requirement for process or methodology skills.

All Process and Methodology Skills
Portsmouth
Permanent vacancies with a requirement for process or methodology skills 585 649 451
As % of all permanent IT jobs advertised in Portsmouth 95.90% 91.02% 87.40%
Number of salaries quoted 455 579 421
Portsmouth median annual salary £42,500 £42,500 £40,000
Median salary % change year-on-year - +6.25% -5.88%
10th Percentile £26,250 £23,500 £26,250
90th Percentile £62,500 £58,000 £55,000
Hampshire median annual salary £45,000 £42,500 £40,500
% change year-on-year +5.88% +4.94% -4.71%

Business Intelligence
Job Vacancy Trend in Portsmouth

Job postings citing Business Intelligence as a percentage of all IT jobs advertised in Portsmouth.

Job vacancy trend for Business Intelligence in Portsmouth

Business Intelligence
Salary Trend in Portsmouth

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing Business Intelligence in Portsmouth.

Salary trend for Business Intelligence in Portsmouth

Business Intelligence
Salary Histogram in Portsmouth

The salary distribution of IT jobs citing Business Intelligence in Portsmouth over the 6 months to 15 July 2018.

Salary histogram for Business Intelligence in Portsmouth

For the 6 months to 15 July 2018, IT jobs citing Business Intelligence also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all permanent job ads across the Portsmouth region with a requirement for Business Intelligence.

1 47 (77.05%) SQL
2 27 (44.26%) SQL Server
3 23 (37.70%) Oracle
4 20 (32.79%) Microsoft
4 20 (32.79%) Analytics
5 19 (31.15%) SC Cleared
5 19 (31.15%) Security Cleared
6 16 (26.23%) Power BI
6 16 (26.23%) SAP
6 16 (26.23%) Data Modelling
7 14 (22.95%) ETL
8 13 (21.31%) SQL Server Reporting Services
8 13 (21.31%) SQL Server Analysis Services
9 12 (19.67%) SQL Server Integration Services
10 11 (18.03%) Big Data
11 10 (16.39%) .NET
11 10 (16.39%) T-SQL
11 10 (16.39%) C#
12 9 (14.75%) VB.NET
12 9 (14.75%) Data Warehouse
12 9 (14.75%) User Acceptance Testing
12 9 (14.75%) Agile Software Development
12 9 (14.75%) Data Analysis
12 9 (14.75%) Enterprise Software
12 9 (14.75%) Analytical Skills
13 8 (13.11%) SuccessFactors
13 8 (13.11%) Performance Tuning
13 8 (13.11%) Team Foundation Server
13 8 (13.11%) SQL Server 2016
13 8 (13.11%) HP ALM

Business Intelligence
Co-occurring IT Skills in Portsmouth 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 8 (13.11%) SharePoint
2 2 (3.28%) Confluence
3 1 (1.64%) Drupal
Applications
1 3 (4.92%) Microsoft Excel
2 2 (3.28%) MS Visio
3 1 (1.64%) Photoshop
Business Applications
1 4 (6.56%) SAP ERP
2 2 (3.28%) Oracle EBS
2 2 (3.28%) Oracle EBS R12
2 2 (3.28%) Oracle ERP
Cloud Services
1 8 (13.11%) SuccessFactors
2 2 (3.28%) Amazon AWS
2 2 (3.28%) Amazon S3
2 2 (3.28%) Microsoft Azure
Database & Business Intelligence
1 27 (44.26%) SQL Server
2 16 (26.23%) Power BI
3 13 (21.31%) SQL Server Analysis Services
3 13 (21.31%) SQL Server Reporting Services
4 12 (19.67%) SQL Server Integration Services
5 11 (18.03%) Big Data
6 9 (14.75%) Data Warehouse
7 8 (13.11%) QlikView
7 8 (13.11%) SQL Server 2016
8 4 (6.56%) Crystal Reports
8 4 (6.56%) Data Mart
8 4 (6.56%) OLAP
8 4 (6.56%) OLAP Cube
8 4 (6.56%) SAP BW
8 4 (6.56%) SAP Data Services
9 2 (3.28%) Apache Hive
9 2 (3.28%) Hadoop
9 2 (3.28%) OLTP
9 2 (3.28%) Oracle Reports
9 2 (3.28%) Qlik Sense
Development Applications
1 8 (13.11%) Team Foundation Server
2 7 (11.48%) HP UFT
3 1 (1.64%) Git (software)
3 1 (1.64%) SQL Server Management Studio (SSMS)
General
1 8 (13.11%) Finance
2 5 (8.20%) Advertising
2 5 (8.20%) Retail
3 4 (6.56%) Legal
4 2 (3.28%) Manufacturing
4 2 (3.28%) Marketing
5 1 (1.64%) Back Office
Job Titles
1 29 (47.54%) Developer
2 11 (18.03%) SQL Developer
3 10 (16.39%) Business Intelligence Developer
4 5 (8.20%) Analyst
5 4 (6.56%) .NET Developer
5 4 (6.56%) C# .NET Developer
5 4 (6.56%) C# Developer
5 4 (6.56%) Data Migration Lead
5 4 (6.56%) Head of Business Intelligence
5 4 (6.56%) SAP BW Developer
5 4 (6.56%) SAP Developer
5 4 (6.56%) Software Developer
5 4 (6.56%) SQL BI Developer
5 4 (6.56%) Team Leader
5 4 (6.56%) Test Manager
6 3 (4.92%) .NET Software Developer
6 3 (4.92%) Automation Test Lead
6 3 (4.92%) C# VB.NET Developer
6 3 (4.92%) Tableau Developer
6 3 (4.92%) Test Leader
Libraries, Frameworks & Software Standards
1 10 (16.39%) .NET
2 7 (11.48%) SAP Fiori
3 6 (9.84%) CSS
3 6 (9.84%) HTML
4 5 (8.20%) ASP.NET
4 5 (8.20%) ASP.NET MVC
4 5 (8.20%) CSS3
4 5 (8.20%) HTML5
5 1 (1.64%) AngularJS
5 1 (1.64%) Middleware
5 1 (1.64%) Node.js
Miscellaneous
1 9 (14.75%) Analytical Skills
1 9 (14.75%) Enterprise Software
2 4 (6.56%) Management Information System
3 2 (3.28%) Driving Licence
4 1 (1.64%) Clustering
4 1 (1.64%) Computer Science
4 1 (1.64%) Digital Media
4 1 (1.64%) Replication
4 1 (1.64%) Social Media
4 1 (1.64%) User Experience
Processes & Methodologies
1 20 (32.79%) Analytics
2 16 (26.23%) Data Modelling
3 14 (22.95%) ETL
4 9 (14.75%) Agile Software Development
4 9 (14.75%) Data Analysis
4 9 (14.75%) User Acceptance Testing
5 8 (13.11%) Performance Tuning
5 8 (13.11%) Regression Testing
6 7 (11.48%) Test Automation
6 7 (11.48%) Test Scripting
6 7 (11.48%) Waterfall
7 6 (9.84%) Balanced Scorecard
7 6 (9.84%) Data Governance
7 6 (9.84%) ERP
7 6 (9.84%) Scorecard
7 6 (9.84%) Visualisation
8 5 (8.20%) CRM
8 5 (8.20%) E-Commerce
8 5 (8.20%) MVC
8 5 (8.20%) Web Analytics
Programming Languages
1 47 (77.05%) SQL
2 10 (16.39%) C#
2 10 (16.39%) T-SQL
3 9 (14.75%) VB.NET
4 7 (11.48%) PL/SQL
5 6 (9.84%) JavaScript
6 4 (6.56%) C
6 4 (6.56%) Java
7 3 (4.92%) VB
7 3 (4.92%) VB6
8 1 (1.64%) PHP
Qualifications
1 19 (31.15%) SC Cleared
1 19 (31.15%) Security Cleared
2 4 (6.56%) Degree
3 1 (1.64%) Computer Science Degree
3 1 (1.64%) ITIL Certification
3 1 (1.64%) Microsoft Certification
Quality Assurance & Compliance
1 7 (11.48%) QA
2 4 (6.56%) Data Quality
3 1 (1.64%) ISO/IEC 20000
3 1 (1.64%) ISO/IEC 27001
Systems Management
1 8 (13.11%) HP ALM
2 2 (3.28%) Oracle Enterprise Manager
2 2 (3.28%) SQL Sentry
Vendors
1 23 (37.70%) Oracle
2 20 (32.79%) Microsoft
3 16 (26.23%) SAP
4 8 (13.11%) HP
5 5 (8.20%) Tableau
6 2 (3.28%) Cognos
7 1 (1.64%) IFS