Period
to 18 January 2019

The following table provides summary statistics for contract job vacancies advertised in Scotland with a requirement for Business Intelligence skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited Business Intelligence over the 6 months to 18 January 2019 with a comparison to the same period in the previous 2 years.

Note that daily and hourly rates are treated separately in these statistics. When calculating contractor rate percentiles, daily rates are never derived from quoted hourly rates or vice versa.

Business Intelligence (BI)
UK > Scotland
6 months to
18 Jan 2019
Same period 2018 Same period 2017
Rank 71 62 56
Rank change year-on-year -9 -6 +11
Contract jobs citing Business Intelligence 130 149 135
As % of all contract IT jobs advertised in Scotland 2.74% 3.13% 3.57%
As % of the Processes & Methodologies category 3.13% 3.63% 4.20%
Number of daily rates quoted 66 98 85
Scotland median daily rate £425 £425 £400
Median daily rate % change year-on-year - +6.25% +6.67%
10th Percentile £304 £301 £313
90th Percentile £575 £541 £578
UK median daily rate £450 £450 £425
% change year-on-year - +5.88% -
Number of hourly rates quoted 2 2 0
Scotland median hourly rate £27.00 £23.75 -
Median hourly rate % change year-on-year +13.68% - -
UK median hourly rate £22.65 £35.00 £32.50
% change year-on-year -35.29% +7.69% -18.75%

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

All Process and Methodology Skills
Scotland
Contract vacancies with a requirement for process or methodology skills 4,158 4,104 3,212
As % of all contract IT jobs advertised in Scotland 87.72% 86.13% 84.95%
Number of daily rates quoted 2,284 2,375 1,857
Scotland median daily rate £413 £400 £375
Median daily rate % change year-on-year +3.13% +6.67% -
10th Percentile £244 £250 £246
90th Percentile £563 £547 £500
UK median daily rate £475 £450 £425
% change year-on-year +5.56% +5.88% +1.19%
Number of hourly rates quoted 97 90 105
Scotland median hourly rate £24.50 £21.00 £21.50
Median hourly rate % change year-on-year +16.67% -2.33% +2.38%
10th Percentile £12.08 £11.24 £10.20
90th Percentile £44.36 £38.67 £52.00
UK median hourly rate £23.50 £23.00 £23.00
% change year-on-year +2.17% - -

Business Intelligence
Job Vacancy Trend in Scotland

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

Job vacancy trend for Business Intelligence in Scotland

Business Intelligence
Contractor Daily Rate Trend in Scotland

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing Business Intelligence in Scotland.

Contractor daily rate trend for Business Intelligence in Scotland

Business Intelligence
Contractor Daily Rate Histogram in Scotland

The daily rate distribution of IT jobs citing Business Intelligence in Scotland over the 6 months to 18 January 2019.

Contractor daily rate histogram for Business Intelligence in Scotland

Business Intelligence
Contractor Hourly Rate Trend in Scotland

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing Business Intelligence in Scotland.

Contractor hourly rate trend for Business Intelligence in Scotland

Business Intelligence
Contractor Hourly Rate Histogram in Scotland

The hourly rate distribution of IT jobs citing Business Intelligence in Scotland over the 6 months to 18 January 2019.

Contractor hourly rate histogram for Business Intelligence in Scotland

Business Intelligence
Contract Job Locations in Scotland

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing Business Intelligence within the Scotland region over the 6 months to 18 January 2019. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Contract
IT Job Ads
Median
Daily Rate
Past 6 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
Edinburgh -15 69 £475 +5.56% 25
Glasgow -1 51 £375 +10.70% 29
Stirling +3 2 £300 -36.84%
West Lothian +5 1 - - 1
Aberdeenshire - 1 £263 -
Fife - 1 - - 3
Lanarkshire - 1 - -
Business Intelligence
UK

For the 6 months to 18 January 2019, IT contractor 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 contract job ads across the Scotland region with a requirement for Business Intelligence.

1 61 (46.92%) SQL
2 52 (40.00%) SQL Server
3 51 (39.23%) Power BI
4 47 (36.15%) Data Warehouse
5 43 (33.08%) ETL
6 41 (31.54%) Finance
7 36 (27.69%) Microsoft
8 34 (26.15%) Agile Software Development
9 31 (23.85%) SQL Server Reporting Services
9 31 (23.85%) Oracle
10 26 (20.00%) Data Integration
11 23 (17.69%) QA
11 23 (17.69%) Unix
12 22 (16.92%) SQL Server Integration Services
13 19 (14.62%) Microsoft Excel
13 19 (14.62%) Analytics
14 18 (13.85%) Data Modelling
14 18 (13.85%) Migration
15 17 (13.08%) Ab Initio
15 17 (13.08%) Teradata
15 17 (13.08%) Banking
15 17 (13.08%) Retail
16 16 (12.31%) User Acceptance Testing
16 16 (12.31%) Shell Script
17 14 (10.77%) BusinessObjects
17 14 (10.77%) Tableau
18 13 (10.00%) SQL Server Analysis Services
18 13 (10.00%) Data Migration
19 12 (9.23%) Microsoft Azure
19 12 (9.23%) SharePoint

Business Intelligence
Co-occurring IT Skills in Scotland 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 12 (9.23%) SAS
1 12 (9.23%) SharePoint
2 4 (3.08%) Apache Spark
2 4 (3.08%) MS Exchange
3 3 (2.31%) Tomcat
3 3 (2.31%) WebSphere
4 1 (0.77%) Apache
4 1 (0.77%) Apache Pig
4 1 (0.77%) Apache Solr
4 1 (0.77%) Elasticsearch
4 1 (0.77%) Oracle Workflow
4 1 (0.77%) Umbraco
4 1 (0.77%) WebSphere Application Server
Applications
1 19 (14.62%) Microsoft Excel
2 9 (6.92%) Microsoft PowerPoint
3 6 (4.62%) Microsoft Office
4 3 (2.31%) Spreadsheet
Business Applications
1 4 (3.08%) Dynamics CRM
2 3 (2.31%) Dynamics AX
3 2 (1.54%) Cognos Business Intelligence
3 2 (1.54%) Markit EDM
3 2 (1.54%) thinkFolio
4 1 (0.77%) Cognos TM1
4 1 (0.77%) SAP FI
Cloud Services
1 12 (9.23%) Microsoft Azure
2 6 (4.62%) Amazon AWS
2 6 (4.62%) Dynamics 365
3 5 (3.85%) PaaS
4 4 (3.08%) Office 365
5 3 (2.31%) GitHub
5 3 (2.31%) IaaS
5 3 (2.31%) SaaS
6 2 (1.54%) Cloud Computing
7 1 (0.77%) Amazon EC2
7 1 (0.77%) Azure Data Factory
Communications & Networking
1 6 (4.62%) Firewall
2 4 (3.08%) Skype
2 4 (3.08%) SSL
3 3 (2.31%) BIG-IP
3 3 (2.31%) NetScaler
4 1 (0.77%) Cisco Firepower
4 1 (0.77%) HTTP
4 1 (0.77%) HTTPS
4 1 (0.77%) Kerberos
4 1 (0.77%) VPN
Database & Business Intelligence
1 52 (40.00%) SQL Server
2 51 (39.23%) Power BI
3 47 (36.15%) Data Warehouse
4 31 (23.85%) SQL Server Reporting Services
5 22 (16.92%) SQL Server Integration Services
6 14 (10.77%) BusinessObjects
7 13 (10.00%) SQL Server Analysis Services
8 9 (6.92%) OLAP
8 9 (6.92%) Oracle Database
9 8 (6.15%) QlikView
10 6 (4.62%) Crystal Reports
10 6 (4.62%) Hadoop
10 6 (4.62%) Oracle BI EE
11 5 (3.85%) Big Data
11 5 (3.85%) Electronic Patient Records
11 5 (3.85%) RDBMS
11 5 (3.85%) Relational Database
12 4 (3.08%) Enterprise Data Warehouse
12 4 (3.08%) SAP Data Services
12 4 (3.08%) SQL Server 2016
Development Applications
1 11 (8.46%) Visual Studio
2 4 (3.08%) Team Foundation Server
3 3 (2.31%) SQL Server Management Studio (SSMS)
3 3 (2.31%) Visual Studio Team System
4 2 (1.54%) MorphX
5 1 (0.77%) Eclipse
5 1 (0.77%) Eclipse RCP
5 1 (0.77%) FitNesse
5 1 (0.77%) JIRA
5 1 (0.77%) Maven
General
1 41 (31.54%) Finance
2 17 (13.08%) Banking
2 17 (13.08%) Retail
3 6 (4.62%) Investment Banking
4 3 (2.31%) Manufacturing
5 2 (1.54%) Retail Banking
6 1 (0.77%) Back Office
6 1 (0.77%) Financial Institution
6 1 (0.77%) Law
6 1 (0.77%) Legal
6 1 (0.77%) Marketing
Job Titles
1 57 (43.85%) Developer
2 28 (21.54%) Analyst
3 20 (15.38%) Business Intelligence Developer
4 15 (11.54%) Ab Initio Developer
5 11 (8.46%) Power BI Developer
5 11 (8.46%) SQL Developer
6 10 (7.69%) Business Analyst
6 10 (7.69%) Consultant
7 9 (6.92%) Architect
7 9 (6.92%) Data Analyst
8 8 (6.15%) Project Manager
9 7 (5.38%) Business Intelligence Consultant
10 6 (4.62%) Data Architect
10 6 (4.62%) Report Analyst
11 5 (3.85%) PMO Analyst
11 5 (3.85%) Risk Analyst
11 5 (3.85%) SQL BI Developer
12 4 (3.08%) Business Intelligence Analyst
12 4 (3.08%) Network Engineer
12 4 (3.08%) Technology Risk Analyst
Libraries, Frameworks & Software Standards
1 6 (4.62%) XML
2 5 (3.85%) .NET
3 4 (3.08%) LDAP
3 4 (3.08%) REST
4 3 (2.31%) XML Messaging
5 2 (1.54%) ASP.NET
5 2 (1.54%) JSON
5 2 (1.54%) JSP
5 2 (1.54%) Middleware
5 2 (1.54%) Web Services
6 1 (0.77%) CSS
6 1 (0.77%) FIX Protocol
6 1 (0.77%) HTML
6 1 (0.77%) Java EE
6 1 (0.77%) OAuth
6 1 (0.77%) SAML
6 1 (0.77%) Servlets
6 1 (0.77%) Spark Streaming
Miscellaneous
1 6 (4.62%) Analytical Skills
2 5 (3.85%) e-Health
2 5 (3.85%) LIMS
2 5 (3.85%) PACS
3 2 (1.54%) Data Centre
3 2 (1.54%) Data Structures
3 2 (1.54%) Enterprise Software
3 2 (1.54%) Greenfield Project
3 2 (1.54%) NHS
3 2 (1.54%) PKI
3 2 (1.54%) Private Cloud
3 2 (1.54%) Self-Motivation
4 1 (0.77%) Algorithms
4 1 (0.77%) Management Information System
4 1 (0.77%) Reference Data
4 1 (0.77%) Virtual Team
Operating Systems
1 23 (17.69%) Unix
2 6 (4.62%) Linux
2 6 (4.62%) Windows
Processes & Methodologies
1 43 (33.08%) ETL
2 34 (26.15%) Agile Software Development
3 26 (20.00%) Data Integration
4 19 (14.62%) Analytics
5 18 (13.85%) Data Modelling
5 18 (13.85%) Migration
6 16 (12.31%) User Acceptance Testing
7 13 (10.00%) Data Migration
8 12 (9.23%) Stakeholder Management
9 11 (8.46%) Problem-Solving
9 11 (8.46%) Stakeholder Engagement
9 11 (8.46%) Visualisation
10 10 (7.69%) Data Analysis
10 10 (7.69%) Investment Management
11 9 (6.92%) Asset Management
11 9 (6.92%) Data Visualisation
11 9 (6.92%) Performance Tuning
12 8 (6.15%) ETL Development
12 8 (6.15%) Scrum
13 6 (4.62%) Project Management
Programming Languages
1 61 (46.92%) SQL
2 16 (12.31%) Shell Script
3 11 (8.46%) Java
3 11 (8.46%) T-SQL
4 7 (5.38%) PL/SQL
5 4 (3.08%) C#
5 4 (3.08%) PowerShell
5 4 (3.08%) VBA
6 3 (2.31%) Data Analysis Expressions (DAX)
6 3 (2.31%) X++
7 2 (1.54%) JavaScript
7 2 (1.54%) Python
8 1 (0.77%) C++
8 1 (0.77%) Perl
8 1 (0.77%) SAS Macro
8 1 (0.77%) Scala
Qualifications
1 6 (4.62%) Degree
2 2 (1.54%) BPSS Clearance
2 2 (1.54%) CISSP
3 1 (0.77%) CITP
3 1 (0.77%) PRINCE2 Certification
3 1 (0.77%) PRINCE2 Practitioner
3 1 (0.77%) SC Cleared
3 1 (0.77%) Security Cleared
Quality Assurance & Compliance
1 23 (17.69%) QA
2 9 (6.92%) Data Quality
3 7 (5.38%) PMO
4 5 (3.85%) HL7
5 2 (1.54%) GDPR
6 1 (0.77%) Disclosure Scotland
6 1 (0.77%) IFRS
6 1 (0.77%) ISO/IEC 27001
System Software
1 3 (2.31%) Active Directory
2 1 (0.77%) HDFS
Systems Management
1 5 (3.85%) Ansible
2 2 (1.54%) Control-M
2 2 (1.54%) SCCM
3 1 (0.77%) Ambari
3 1 (0.77%) Hadoop YARN
3 1 (0.77%) Oozie
3 1 (0.77%) Opscode Chef
3 1 (0.77%) Puppet
3 1 (0.77%) Single Sign-On
3 1 (0.77%) Terraform
Vendors
1 36 (27.69%) Microsoft
2 31 (23.85%) Oracle
3 17 (13.08%) Ab Initio
3 17 (13.08%) Teradata
4 14 (10.77%) Tableau
5 8 (6.15%) Informatica
5 8 (6.15%) SAP
6 5 (3.85%) Charles River
6 5 (3.85%) IBM
7 4 (3.08%) Cognos
8 3 (2.31%) F5
9 2 (1.54%) Bloomberg
9 2 (1.54%) MicroStrategy
9 2 (1.54%) Splunk
10 1 (0.77%) BISAM
10 1 (0.77%) Cisco
10 1 (0.77%) Google
10 1 (0.77%) Salesforce.com
10 1 (0.77%) Talend
10 1 (0.77%) Vermilion