Period
to 18 January 2018

The following table provides summary statistics for permanent job vacancies advertised in Edinburgh 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 18 January 2018 with a comparison to the same period in the previous 2 years.

Business Intelligence (BI)
Scotland > Edinburgh
6 months to
18 Jan 2018
Same period 2017 Same period 2016
Rank 23 46 25
Rank change year-on-year +23 -21 +32
Permanent jobs citing Business Intelligence 221 89 221
As % of all permanent IT jobs advertised in Edinburgh 8.43% 4.08% 7.98%
As % of the Processes & Methodologies category 9.22% 4.41% 8.71%
Number of salaries quoted 117 58 212
Edinburgh median annual salary £45,000 £47,500 £47,500
Median salary % change year-on-year -5.26% - +7.95%
10th Percentile £31,250 £37,500 £36,825
90th Percentile £66,250 £60,000 £68,750
Scotland median annual salary £45,000 £47,500 £47,500
% change year-on-year -5.26% - +11.76%

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 Edinburgh with a requirement for process or methodology skills.

All Process and Methodology Skills
Edinburgh
Permanent vacancies with a requirement for process or methodology skills 2,398 2,017 2,536
As % of all permanent IT jobs advertised in Edinburgh 91.42% 92.40% 91.52%
Number of salaries quoted 1,494 1,354 1,617
Edinburgh median annual salary £43,500 £45,000 £45,000
Median salary % change year-on-year -3.33% - +5.88%
10th Percentile £27,500 £30,000 £28,750
90th Percentile £66,250 £70,000 £66,250
Scotland median annual salary £45,000 £44,625 £42,500
% change year-on-year +0.84% +5.00% -

Business Intelligence
Job Vacancy Trend in Edinburgh

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

Job vacancy trend for Business Intelligence in Edinburgh

Business Intelligence
Salary Trend in Edinburgh

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

Salary trend for Business Intelligence in Edinburgh

Business Intelligence
Salary Histogram in Edinburgh

The salary distribution of IT jobs citing Business Intelligence in Edinburgh over the 6 months to 18 January 2018.

Salary histogram for Business Intelligence in Edinburgh

For the 6 months to 18 January 2018, IT jobs citing Business Intelligence 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 Edinburgh region with a requirement for Business Intelligence.

1 160 (72.40%) SQL
2 159 (71.95%) Finance
3 84 (38.01%) Banking
4 77 (34.84%) Infrastructure Management
5 74 (33.48%) Analytical Skills
6 70 (31.67%) ETL
6 70 (31.67%) Teradata
7 69 (31.22%) Data Management
8 67 (30.32%) Stakeholder Management
9 62 (28.05%) SAS
10 60 (27.15%) SQL Server
11 58 (26.24%) Analytics
12 55 (24.89%) SQL Server Integration Services
13 50 (22.62%) Oracle
14 49 (22.17%) Retail Banking
15 43 (19.46%) SQL Server Reporting Services
16 41 (18.55%) Cognos
17 39 (17.65%) Tableau
18 38 (17.19%) Informatica
19 37 (16.74%) Data Mining
20 33 (14.93%) T-SQL
21 30 (13.57%) Microsoft
22 29 (13.12%) MicroStrategy
22 29 (13.12%) Data Analysis
22 29 (13.12%) Degree
22 29 (13.12%) Mentoring
23 27 (12.22%) Data Warehouse
24 26 (11.76%) SAP
25 25 (11.31%) QlikView
26 22 (9.95%) People Management

Business Intelligence
Co-occurring IT Skills in Edinburgh 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 62 (28.05%) SAS
2 6 (2.71%) SharePoint
3 5 (2.26%) Apache Spark
4 2 (0.90%) Apache
4 2 (0.90%) JBoss
5 1 (0.45%) Oracle SOA Suite
Applications
1 2 (0.90%) Microsoft Excel
Business Applications
1 15 (6.79%) SAP BPC
2 10 (4.52%) Cognos Business Intelligence
3 9 (4.07%) SAP S/4HANA
4 4 (1.81%) SAP GRC
5 2 (0.90%) Cognos TM1
5 2 (0.90%) Dynamics AX
Cloud Services
1 6 (2.71%) Microsoft Azure
2 3 (1.36%) Amazon AWS
3 2 (0.90%) Amazon EMR
3 2 (0.90%) Google Analytics
4 1 (0.45%) Google Cloud Platform
Communications & Networking
1 3 (1.36%) Internet
2 2 (0.90%) SSH
2 2 (0.90%) SSL
Database & Business Intelligence
1 60 (27.15%) SQL Server
2 55 (24.89%) SQL Server Integration Services
3 43 (19.46%) SQL Server Reporting Services
4 37 (16.74%) Data Mining
5 27 (12.22%) Data Warehouse
6 25 (11.31%) QlikView
7 20 (9.05%) Power BI
8 19 (8.60%) SAS Enterprise Guide
9 18 (8.14%) Base SAS
9 18 (8.14%) SQL Server 2012
10 17 (7.69%) BODI
10 17 (7.69%) Oracle OWB
11 12 (5.43%) Big Data
12 11 (4.98%) Cognos Report Studio
12 11 (4.98%) DB2
12 11 (4.98%) Relational Database
13 10 (4.52%) SQL Server 2014
14 9 (4.07%) BusinessObjects Business Intelligence
15 8 (3.62%) Cognos Analysis Studio
15 8 (3.62%) Cognos Framework Manager
Development Applications
1 15 (6.79%) Team Foundation Server
2 2 (0.90%) Git (software)
2 2 (0.90%) GitLab
2 2 (0.90%) Maven
3 1 (0.45%) ERwin
General
1 159 (71.95%) Finance
2 84 (38.01%) Banking
3 49 (22.17%) Retail Banking
4 16 (7.24%) Marketing
5 3 (1.36%) Electronics
5 3 (1.36%) Legal
5 3 (1.36%) Manufacturing
5 3 (1.36%) Telecoms
6 2 (0.90%) Law
6 2 (0.90%) Retail
7 1 (0.45%) Advertising
7 1 (0.45%) Financial Institution
Job Titles
1 76 (34.39%) Analyst
2 64 (28.96%) Consultant
3 62 (28.05%) Developer
4 41 (18.55%) Data Analyst
5 38 (17.19%) SQL Analyst
6 36 (16.29%) Business Intelligence Developer
7 31 (14.03%) Business Analyst
8 30 (13.57%) Senior Analyst
9 27 (12.22%) Technical Analyst
9 27 (12.22%) Technical Business Analyst
10 26 (11.76%) SQL Developer
11 21 (9.50%) SSIS Developer
11 21 (9.50%) Teradata Consultant
12 20 (9.05%) SQL BI Developer
12 20 (9.05%) SQL Data Analyst
13 18 (8.14%) SQL Server Developer
14 16 (7.24%) Senior Data Analyst
15 15 (6.79%) SAP BPC Consultant
15 15 (6.79%) SAP Consultant
15 15 (6.79%) SQL Server BI Developer
Libraries, Frameworks & Software Standards
1 6 (2.71%) .NET
2 4 (1.81%) SAP Basis
3 3 (1.36%) HTML
3 3 (1.36%) MDX
4 2 (0.90%) AngularJS
4 2 (0.90%) CSS
4 2 (0.90%) JDBC
4 2 (0.90%) JSON
4 2 (0.90%) Pandas
4 2 (0.90%) RESTful
4 2 (0.90%) scikit-learn
4 2 (0.90%) SOAP
4 2 (0.90%) Spring
4 2 (0.90%) Spring Security
4 2 (0.90%) Web Services
4 2 (0.90%) XML
5 1 (0.45%) .NET Framework
5 1 (0.45%) ASP.NET
5 1 (0.45%) Kafka
Miscellaneous
1 74 (33.48%) Analytical Skills
2 14 (6.33%) Credit Risk
3 11 (4.98%) Data Structures
4 6 (2.71%) Management Information System
5 4 (1.81%) Computer Science
6 2 (0.90%) Algorithms
6 2 (0.90%) Driving Licence
6 2 (0.90%) Fintech
6 2 (0.90%) Greenfield Project
6 2 (0.90%) Mainframe
7 1 (0.45%) Taxonomies
Operating Systems
1 12 (5.43%) Unix
2 7 (3.17%) Windows
Processes & Methodologies
1 77 (34.84%) Infrastructure Management
2 70 (31.67%) ETL
3 69 (31.22%) Data Management
4 67 (30.32%) Stakeholder Management
5 58 (26.24%) Analytics
6 29 (13.12%) Data Analysis
6 29 (13.12%) Mentoring
7 22 (9.95%) People Management
8 19 (8.60%) Project Management
8 19 (8.60%) Visualisation
9 18 (8.14%) Customer Analytics
10 17 (7.69%) Software Testing
11 13 (5.88%) Business Analytics
11 13 (5.88%) Integration Testing
11 13 (5.88%) System Integration Testing
12 11 (4.98%) Collaborative Working
13 10 (4.52%) Business Analysis
13 10 (4.52%) Data Modelling
14 8 (3.62%) Dashboard Development
14 8 (3.62%) Web Analytics
Programming Languages
1 160 (72.40%) SQL
2 33 (14.93%) T-SQL
3 10 (4.52%) Python
3 10 (4.52%) R
4 9 (4.07%) PowerShell
5 8 (3.62%) C#
6 4 (1.81%) Java
6 4 (1.81%) VBA
7 2 (0.90%) C
7 2 (0.90%) C++
7 2 (0.90%) JavaScript
7 2 (0.90%) Scala
8 1 (0.45%) Data Analysis Expressions (DAX)
8 1 (0.45%) PL/SQL
Qualifications
1 29 (13.12%) Degree
2 6 (2.71%) MCDBA
2 6 (2.71%) MCITP
2 6 (2.71%) Microsoft Certification
3 2 (0.90%) PhD
4 1 (0.45%) SAS Certification
Quality Assurance & Compliance
1 9 (4.07%) IFRS
2 6 (2.71%) Data Quality
3 2 (0.90%) QA
4 1 (0.45%) GDPR
Vendors
1 70 (31.67%) Teradata
2 50 (22.62%) Oracle
3 41 (18.55%) Cognos
4 39 (17.65%) Tableau
5 38 (17.19%) Informatica
6 30 (13.57%) Microsoft
7 29 (13.12%) MicroStrategy
8 26 (11.76%) SAP
9 10 (4.52%) IBM
10 6 (2.71%) Capita
11 5 (2.26%) Hyperion
12 3 (1.36%) Apple
12 3 (1.36%) Facebook
12 3 (1.36%) Google
12 3 (1.36%) Twitter
13 2 (0.90%) Netezza
14 1 (0.45%) Talend
14 1 (0.45%) Workday