Period
to 27 September 2020

The following table provides summary statistics for permanent job vacancies advertised in the City of London 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 27 September 2020 with a comparison to the same period in the previous 2 years.

Business Intelligence (BI)
Central London > City of London
6 months to
27 Sep 2020
Same period 2019 Same period 2018
Rank 35 26 39
Rank change year-on-year -9 +13 -16
Permanent jobs citing Business Intelligence 254 847 667
As % of all permanent jobs advertised in the City of London 6.87% 8.37% 6.05%
As % of the Processes & Methodologies category 7.33% 8.96% 6.49%
Number of salaries quoted 213 825 618
Median annual salary £60,000 £62,500 £63,500
Median salary % change year-on-year -4.00% -1.57% +12.39%
10th Percentile £37,500 £41,100 £41,250
90th Percentile £88,750 £86,250 £87,500
Central London median annual salary £60,000 £60,000 £62,500
% change year-on-year - -4.00% +13.64%

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 the City of London with a requirement for process or methodology skills.

All Process and Methodology Skills
City of London
Permanent vacancies with a requirement for process or methodology skills 3,463 9,451 10,273
As % of all permanent IT jobs advertised in the City of London 93.62% 93.43% 93.20%
Number of salaries quoted 3,002 8,282 9,154
Median annual salary £70,000 £67,500 £65,000
Median salary % change year-on-year +3.70% +3.85% +8.33%
10th Percentile £45,000 £37,500 £37,000
90th Percentile £102,500 £97,500 £93,750
Central London median annual salary £70,000 £65,000 £62,500
% change year-on-year +7.69% +4.00% +4.17%

Business Intelligence
Job Vacancy Trend in the City of London

Job postings citing Business Intelligence as a proportion of all IT jobs advertised in the City of London.

Job vacancy trend for Business Intelligence in the City of London

Business Intelligence
Salary Trend in the City of London

3-month moving average salary quoted in jobs citing Business Intelligence in the City of London.

Salary trend for Business Intelligence in the City of London

Business Intelligence
Salary Histogram in the City of London

Salary distribution for jobs citing Business Intelligence in the City of London over the 6 months to 27 September 2020.

Salary histogram for Business Intelligence in the City of London

For the 6 months to 27 September 2020, 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 City of London region with a requirement for Business Intelligence.

1 158 (62.20%) SQL
2 121 (47.64%) Power BI
2 121 (47.64%) Power Platform
3 109 (42.91%) Data Warehouse
4 106 (41.73%) Azure
5 100 (39.37%) Finance
6 88 (34.65%) Agile Software Development
7 86 (33.86%) Microsoft
8 83 (32.68%) SQL Server
9 81 (31.89%) Analytics
10 75 (29.53%) SQL Server Integration Services
11 72 (28.35%) Data Modelling
12 67 (26.38%) SQL Server Analysis Services
13 66 (25.98%) ETL
14 62 (24.41%) SQL Server Reporting Services
15 46 (18.11%) Data Lake
16 44 (17.32%) Tableau
17 43 (16.93%) Python
18 40 (15.75%) Analytical Skills
19 39 (15.35%) Visualisation
20 35 (13.78%) Data Analytics
20 35 (13.78%) Data Analysis
20 35 (13.78%) Problem-Solving
21 33 (12.99%) Microsoft Excel
22 31 (12.20%) SDLC
22 31 (12.20%) Azure SQL Data Warehouse
22 31 (12.20%) Databricks
23 30 (11.81%) Dashboard Development
23 30 (11.81%) Big Data
23 30 (11.81%) Data Visualisation

Business Intelligence
Co-occurring IT Skills in the City of London 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 15 (5.91%) Apache Spark
2 9 (3.54%) SharePoint
3 8 (3.15%) SAS
4 5 (1.97%) Confluence
5 3 (1.18%) CMS
5 3 (1.18%) Oracle Workflow
6 2 (0.79%) Apache
7 1 (0.39%) Apache Airflow
7 1 (0.39%) Apache Synapse
7 1 (0.39%) BizTalk Server
7 1 (0.39%) SharePoint 2010
Applications
1 33 (12.99%) Microsoft Excel
2 9 (3.54%) Microsoft Office
3 2 (0.79%) MS Visio
4 1 (0.39%) Microsoft PowerPoint
4 1 (0.39%) Microsoft Project
Business Applications
1 6 (2.36%) Oracle Internet Expenses
1 6 (2.36%) Oracle iProcurement
2 4 (1.57%) SAP Business One
3 3 (1.18%) Oracle AGIS
3 3 (1.18%) Oracle Assets
3 3 (1.18%) Oracle EBS
3 3 (1.18%) Oracle EBS R12
3 3 (1.18%) Oracle General Ledger
3 3 (1.18%) Oracle Payables
3 3 (1.18%) Oracle Procure-to-Pay
3 3 (1.18%) Oracle Receivables
3 3 (1.18%) Temenos T24
4 1 (0.39%) Cognos TM1
4 1 (0.39%) Dynamics AX
4 1 (0.39%) Elite 3E
4 1 (0.39%) Salesforce.com CRM
Cloud Services
1 121 (47.64%) Power Platform
2 106 (41.73%) Azure
3 29 (11.42%) Azure Data Factory
4 26 (10.24%) AWS
5 13 (5.12%) Office 365
6 10 (3.94%) GCP
6 10 (3.94%) SaaS
7 6 (2.36%) Amazon S3
7 6 (2.36%) PowerApps
8 5 (1.97%) Amazon Kinesis
9 4 (1.57%) Heroku
9 4 (1.57%) Logic Apps
10 3 (1.18%) Dynamics 365
11 2 (0.79%) Amazon ElastiCache
11 2 (0.79%) Amazon EMR
11 2 (0.79%) Azure Active Directory
11 2 (0.79%) Cloud Computing
11 2 (0.79%) OneDrive
11 2 (0.79%) ShareGate
12 1 (0.39%) PaaS
Communications & Networking
1 5 (1.97%) Firewall
1 5 (1.97%) Internet
2 2 (0.79%) HTTPS
Database & Business Intelligence
1 121 (47.64%) Power BI
2 109 (42.91%) Data Warehouse
3 83 (32.68%) SQL Server
4 75 (29.53%) SQL Server Integration Services
5 67 (26.38%) SQL Server Analysis Services
6 62 (24.41%) SQL Server Reporting Services
7 46 (18.11%) Data Lake
8 31 (12.20%) Azure SQL Data Warehouse
9 30 (11.81%) Big Data
10 28 (11.02%) OLAP
11 23 (9.06%) Azure SQL Database
11 23 (9.06%) Microsoft Analysis Services
12 18 (7.09%) OLAP Cube
13 17 (6.69%) OLTP
14 16 (6.30%) Hadoop
15 15 (5.91%) MySQL
16 14 (5.51%) Relational Database
17 12 (4.72%) Snowflake Schema
18 10 (3.94%) MS Access
19 9 (3.54%) SQL Server 2017
Development Applications
1 20 (7.87%) Selenium
2 10 (3.94%) Git (software)
3 9 (3.54%) Cypress.io
3 9 (3.54%) JIRA
4 4 (1.57%) Cucumber
5 3 (1.18%) Team Foundation Server
6 2 (0.79%) Eclipse
6 2 (0.79%) Jenkins
6 2 (0.79%) PHPUnit
6 2 (0.79%) PowerDesigner
6 2 (0.79%) SpecFlow
6 2 (0.79%) Visual Studio
6 2 (0.79%) WebDriver
7 1 (0.39%) Visual Studio Team System
General
1 100 (39.37%) Finance
2 19 (7.48%) Marketing
3 17 (6.69%) Banking
3 17 (6.69%) Public Sector
4 16 (6.30%) Electronics
4 16 (6.30%) Manufacturing
4 16 (6.30%) Telecoms
5 14 (5.51%) Retail
6 5 (1.97%) Front Office
6 5 (1.97%) Law
7 4 (1.57%) Legal
8 3 (1.18%) General Ledger
8 3 (1.18%) Pharmaceutical
9 2 (0.79%) Investment Banking
10 1 (0.39%) Billing
10 1 (0.39%) Games
10 1 (0.39%) Mandarin Language
Job Titles
1 98 (38.58%) Developer
2 67 (26.38%) Business Intelligence Developer
3 60 (23.62%) Analyst
4 34 (13.39%) Azure Developer
5 29 (11.42%) Senior Developer
6 27 (10.63%) SQL Developer
7 23 (9.06%) Data Warehouse Developer
7 23 (9.06%) Senior Business Intelligence Developer
8 22 (8.66%) SSAS Developer
8 22 (8.66%) SSIS Developer
9 21 (8.27%) SQL BI Developer
10 20 (7.87%) Data Engineer
11 19 (7.48%) OLAP Developer
12 18 (7.09%) Data Analyst
13 16 (6.30%) ETL Developer
13 16 (6.30%) Excel Developer
13 16 (6.30%) Microsoft BI Developer
13 16 (6.30%) SQL Server BI Developer
13 16 (6.30%) SQL Server Developer
14 15 (5.91%) Junior
Libraries, Frameworks & Software Standards
1 23 (9.06%) MDX
2 22 (8.66%) REST
3 19 (7.48%) JSON
4 17 (6.69%) XML
5 16 (6.30%) SOAP
6 13 (5.12%) .NET
7 9 (3.54%) Matplotlib
7 9 (3.54%) NumPy
7 9 (3.54%) Pandas
7 9 (3.54%) scikit-learn
7 9 (3.54%) TensorFlow
8 7 (2.76%) AngularJS
8 7 (2.76%) Natural Language Processing
9 6 (2.36%) Keras
9 6 (2.36%) NetworkX
9 6 (2.36%) PySpark
9 6 (2.36%) React
9 6 (2.36%) SciPy
9 6 (2.36%) SpaCy
9 6 (2.36%) XGBoost
Miscellaneous
1 40 (15.75%) Analytical Skills
2 17 (6.69%) Management Information System
3 10 (3.94%) Algorithms
4 8 (3.15%) Replication
5 6 (2.36%) Data Structures
6 5 (1.97%) Analytical Mindset
6 5 (1.97%) Greenfield Project
6 5 (1.97%) Mobile App
6 5 (1.97%) Reinsurance
7 4 (1.57%) Data Centre
7 4 (1.57%) Self-Motivation
8 3 (1.18%) EPoS
8 3 (1.18%) Public Cloud
8 3 (1.18%) SWIFT
8 3 (1.18%) User Experience
9 2 (0.79%) Hedge funds
9 2 (0.79%) Media Streaming
9 2 (0.79%) NHS
9 2 (0.79%) Video\Live Streaming
10 1 (0.39%) Social Media
Operating Systems
1 9 (3.54%) Windows
2 5 (1.97%) Linux
2 5 (1.97%) Windows 10
3 4 (1.57%) Mac OS
4 1 (0.39%) Unix
Processes & Methodologies
1 88 (34.65%) Agile Software Development
2 81 (31.89%) Analytics
3 72 (28.35%) Data Modelling
4 66 (25.98%) ETL
5 39 (15.35%) Visualisation
6 35 (13.78%) Data Analysis
6 35 (13.78%) Data Analytics
6 35 (13.78%) Problem-Solving
7 31 (12.20%) SDLC
8 30 (11.81%) Dashboard Development
8 30 (11.81%) Data Visualisation
9 29 (11.42%) Test Automation
10 25 (9.84%) DevOps
10 25 (9.84%) Insurtech
10 25 (9.84%) Migration
11 24 (9.45%) Data Science
11 24 (9.45%) Performance Tuning
12 19 (7.48%) Business Analysis
12 19 (7.48%) Stakeholder Management
13 17 (6.69%) Digital Marketing
Programming Languages
1 158 (62.20%) SQL
2 43 (16.93%) Python
3 23 (9.06%) T-SQL
4 20 (7.87%) Data Analysis Expressions (DAX)
5 19 (7.48%) C#
6 15 (5.91%) JavaScript
7 14 (5.51%) R
8 12 (4.72%) Java
9 6 (2.36%) MATLAB
9 6 (2.36%) VBA
10 3 (1.18%) PL/SQL
11 2 (0.79%) PHP
11 2 (0.79%) Scala
12 1 (0.39%) C
12 1 (0.39%) PowerShell
12 1 (0.39%) TypeScript
12 1 (0.39%) VB
12 1 (0.39%) VB.NET
Qualifications
1 21 (8.27%) Degree
2 8 (3.15%) Computer Science Degree
3 6 (2.36%) Master's Degree
4 5 (1.97%) ISEB
4 5 (1.97%) SANS
5 3 (1.18%) ISTQB
6 1 (0.39%) Microsoft Certification
6 1 (0.39%) PRINCE2 Practitioner
6 1 (0.39%) Six Sigma Black Belt
6 1 (0.39%) Six Sigma Green Belt
Quality Assurance & Compliance
1 10 (3.94%) QA
2 6 (2.36%) Data Quality
2 6 (2.36%) ISO/IEC 27001
3 4 (1.57%) GDPR
4 1 (0.39%) IFRS
System Software
1 8 (3.15%) Docker
2 5 (1.97%) Active Directory
Systems Management
1 5 (1.97%) QRadar
2 4 (1.57%) HP Quality Center
2 4 (1.57%) Kubernetes
Vendors
1 86 (33.86%) Microsoft
2 44 (17.32%) Tableau
3 31 (12.20%) Databricks
4 26 (10.24%) Oracle
5 21 (8.27%) SAP
6 8 (3.15%) Splunk
7 7 (2.76%) Cloudera
8 6 (2.36%) Salesforce.com
9 5 (1.97%) ArcSight
9 5 (1.97%) BeyondTrust
9 5 (1.97%) Bomgar
9 5 (1.97%) CheckPoint
9 5 (1.97%) Cisco
9 5 (1.97%) CyberArk
9 5 (1.97%) IBM
9 5 (1.97%) LogRhythm
9 5 (1.97%) NetWitness
9 5 (1.97%) Palo Alto
9 5 (1.97%) Thycotic
10 3 (1.18%) Alteryx