Period
to 21 October 2019

The following table provides summary statistics for contract job vacancies with a requirement for SQL Server Analysis Services skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited SQL Server Analysis Services over the 6 months to 21 October 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.

Microsoft SQL Server Analysis Services (SSAS)
UK
6 months to
21 Oct 2019
Same period 2018 Same period 2017
Rank 287 324 323
Rank change year-on-year +37 -1 -50
Contract jobs citing SQL Server Analysis Services 747 798 792
As % of all contract IT jobs advertised in the UK 0.88% 0.78% 0.80%
As % of the Database & Business Intelligence category 4.06% 3.45% 3.59%
Number of daily rates quoted 563 613 574
UK median daily rate £450 £450 £425
Median daily rate % change year-on-year - +5.88% +6.25%
10th Percentile £319 £319 £313
90th Percentile £638 £600 £575
UK excluding London median daily rate £425 £400 £375
% change year-on-year +6.25% +6.67% -
Number of hourly rates quoted 6 4 11
UK median hourly rate £24.93 £23.04 £24.00
Median hourly rate % change year-on-year +8.18% -4.00% -45.45%
10th Percentile £22.62 £21.00 £20.75
90th Percentile £37.50 £40.47 £48.75
UK excluding London median hourly rate £35.00 £45.00 £27.00
% change year-on-year -22.22% +66.67% -38.64%

SQL Server Analysis Services is in the Databases and Business Intelligence category. The following table is for comparison with the above and provides summary statistics for all contract job vacancies with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
UK
Contract vacancies with a requirement for database or business intelligence skills 18,379 23,135 22,069
As % of all contract IT jobs advertised in the UK 21.64% 22.60% 22.21%
Number of daily rates quoted 12,538 16,135 14,921
UK median daily rate £475 £475 £450
Median daily rate % change year-on-year - +5.56% +5.88%
10th Percentile £325 £313 £308
90th Percentile £654 £638 £625
UK excluding London median daily rate £438 £425 £400
% change year-on-year +2.94% +6.25% +6.67%
Number of hourly rates quoted 257 227 276
UK median hourly rate £35.00 £30.00 £30.00
Median hourly rate % change year-on-year +16.67% - +1.69%
10th Percentile £12.58 £12.37 £13.70
90th Percentile £60.00 £56.55 £54.38
UK excluding London median hourly rate £31.50 £33.00 £33.00
% change year-on-year -4.55% - +15.79%

SQL Server Analysis Services
Job Vacancy Trend

Job postings citing SQL Server Analysis Services as a percentage of all IT jobs advertised.

Job vacancy trend for SQL Server Analysis Services in the UK

SQL Server Analysis Services
Contractor Daily Rate Trend

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing SQL Server Analysis Services.

Contractor daily rate trend for SQL Server Analysis Services in the UK

SQL Server Analysis Services
Contractor Daily Rate Histogram

The daily rate distribution of IT jobs citing SQL Server Analysis Services over the 6 months to 21 October 2019.

Contractor daily rate histogram for SQL Server Analysis Services in the UK

SQL Server Analysis Services
Contractor Hourly Rate Trend

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing SQL Server Analysis Services.

Contractor hourly rate trend for SQL Server Analysis Services in the UK

SQL Server Analysis Services
Contractor Hourly Rate Histogram

The hourly rate distribution of IT jobs citing SQL Server Analysis Services over the 6 months to 21 October 2019.

Contractor hourly rate histogram for SQL Server Analysis Services in the UK

SQL Server Analysis Services
Top 16 Contract Locations

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing SQL Server Analysis Services within the UK over the 6 months to 21 October 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
England +38 717 £450 - 236
London +26 383 £500 +3.31% 60
UK excluding London +57 352 £425 +6.25% 184
South East +67 113 £425 +3.03% 40
North of England +45 82 £388 -1.59% 71
South West +13 58 £425 +4.94% 8
Midlands +57 54 £350 -17.65% 36
Yorkshire +38 39 £375 -6.25% 21
North West +29 39 £400 +3.90% 47
West Midlands +43 38 £394 -1.56% 27
East of England -19 22 £475 +15.15% 21
East Midlands +24 16 £325 -23.53% 9
Scotland +23 12 £425 +18.88% 4
Wales +28 8 £413 -0.60% 4
North East +14 4 £450 +63.64% 3
Northern Ireland +8 3 £325 -

For the 6 months to 21 October 2019, IT contractor jobs citing SQL Server Analysis Services 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 with a requirement for SQL Server Analysis Services.

1 587 (78.58%) Business Intelligence
2 573 (76.71%) SQL Server Integration Services
3 555 (74.30%) SQL
4 542 (72.56%) SQL Server Reporting Services
5 527 (70.55%) SQL Server
6 399 (53.41%) Power Platform
7 396 (53.01%) Power BI
8 369 (49.40%) Data Warehouse
9 345 (46.18%) Microsoft
10 272 (36.41%) ETL
11 268 (35.88%) Azure
12 223 (29.85%) T-SQL
13 179 (23.96%) Finance
14 162 (21.69%) Agile Software Development
15 134 (17.94%) Data Analysis Expressions (DAX)
16 132 (17.67%) Tableau
17 128 (17.14%) Data Modelling
18 126 (16.87%) Microsoft Analysis Services
19 121 (16.20%) C#
20 118 (15.80%) Analytics
21 111 (14.86%) MDX
22 100 (13.39%) Migration
23 98 (13.12%) Azure Data Factory
24 95 (12.72%) .NET
25 90 (12.05%) Visualisation
26 88 (11.78%) Data Lake
27 76 (10.17%) PowerShell
28 75 (10.04%) Azure SQL Data Warehouse
29 74 (9.91%) Azure SQL Database
30 71 (9.50%) Kimball Methodology

SQL Server Analysis Services
Co-occurring IT Skills 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 41 (5.49%) SharePoint
2 14 (1.87%) IIS
3 13 (1.74%) BizTalk Server
4 11 (1.47%) SharePoint 2013
5 8 (1.07%) SAS
6 7 (0.94%) Apache
6 7 (0.94%) Apache Spark
7 6 (0.80%) CMS
7 6 (0.80%) WebLogic
7 6 (0.80%) WebLogic Integration
8 4 (0.54%) Confluence
8 4 (0.54%) SharePoint 2010
9 2 (0.27%) Oracle SOA Suite
9 2 (0.27%) Skype for Business
10 1 (0.13%) Apache Airflow
10 1 (0.13%) Oracle Workflow
Applications
1 67 (8.97%) Microsoft Excel
2 14 (1.87%) MS Visio
3 8 (1.07%) Microsoft Office
4 5 (0.67%) Spreadsheet
5 4 (0.54%) InfoPath
5 4 (0.54%) SPSS
6 3 (0.40%) Microsoft PowerPoint
Business Applications
1 20 (2.68%) Dynamics CRM
2 9 (1.20%) Dynamics NAV
3 7 (0.94%) NetSuite
4 6 (0.80%) Misys Opics
4 6 (0.80%) Oracle Financials
4 6 (0.80%) Unit4 Business World
5 5 (0.67%) Dynamics AX
6 2 (0.27%) Cognos Business Intelligence
6 2 (0.27%) Oracle EBS
7 1 (0.13%) Cerner Millennium
7 1 (0.13%) SAP ERP
7 1 (0.13%) SnowdropKCS
7 1 (0.13%) Sparx Enterprise Architect
Cloud Services
1 399 (53.41%) Power Platform
2 268 (35.88%) Azure
3 98 (13.12%) Azure Data Factory
4 49 (6.56%) AWS
5 16 (2.14%) Azure Machine Learning
6 14 (1.87%) Data Lake Analytics
7 12 (1.61%) Azure Functions
7 12 (1.61%) Serverless
8 11 (1.47%) Dynamics 365
8 11 (1.47%) GCP
9 10 (1.34%) Office 365
10 8 (1.07%) GitHub
10 8 (1.07%) PowerApps
11 5 (0.67%) OpenShift
12 4 (0.54%) Azure Active Directory
13 3 (0.40%) Cloud Computing
14 2 (0.27%) AWS CloudFormation
14 2 (0.27%) Azure Stack
14 2 (0.27%) IaaS
15 1 (0.13%) WhatsApp
Communications & Networking
1 11 (1.47%) Internet
2 7 (0.94%) Firewall
3 3 (0.40%) SAN
4 2 (0.27%) FTP
Database & Business Intelligence
1 573 (76.71%) SQL Server Integration Services
2 542 (72.56%) SQL Server Reporting Services
3 527 (70.55%) SQL Server
4 396 (53.01%) Power BI
5 369 (49.40%) Data Warehouse
6 126 (16.87%) Microsoft Analysis Services
7 88 (11.78%) Data Lake
8 75 (10.04%) Azure SQL Data Warehouse
9 74 (9.91%) Azure SQL Database
10 65 (8.70%) SQL Server 2012
11 60 (8.03%) OLAP
11 60 (8.03%) QlikView
12 58 (7.76%) SQL Server 2014
13 48 (6.43%) Big Data
14 44 (5.89%) SQL Server 2016
15 41 (5.49%) SQL Server 2017
16 38 (5.09%) PowerPivot
17 35 (4.69%) Relational Database
18 26 (3.48%) Hadoop
19 25 (3.35%) MySQL
Development Applications
1 45 (6.02%) Visual Studio
2 35 (4.69%) Visual Studio Team System
3 28 (3.75%) Team Foundation Server
3 28 (3.75%) TeamCity
4 25 (3.35%) Git (software)
5 19 (2.54%) JIRA
6 17 (2.28%) Octopus Deploy
7 12 (1.61%) Jenkins
8 10 (1.34%) Cucumber
9 9 (1.20%) ERwin
9 9 (1.20%) SQL Server Management Studio (SSMS)
10 8 (1.07%) Maven
11 7 (0.94%) Atlassian Bamboo
11 7 (0.94%) Eclipse
12 6 (0.80%) Concordion
12 6 (0.80%) EasyMock
12 6 (0.80%) Gradle
12 6 (0.80%) Mockito
12 6 (0.80%) Selenium
12 6 (0.80%) tSQLt
General
1 179 (23.96%) Finance
2 47 (6.29%) Retail
3 34 (4.55%) Banking
4 30 (4.02%) Public Sector
5 29 (3.88%) Legal
6 21 (2.81%) Front Office
7 15 (2.01%) Back Office
8 14 (1.87%) Investment Banking
9 11 (1.47%) Manufacturing
10 10 (1.34%) Telecoms
11 9 (1.20%) Marketing
12 5 (0.67%) Automotive
12 5 (0.67%) Local Government
13 4 (0.54%) Games
14 3 (0.40%) Billing
14 3 (0.40%) Financial Institution
14 3 (0.40%) Law
15 2 (0.27%) Publishing
16 1 (0.13%) Advertising
16 1 (0.13%) General Ledger
Job Titles
1 409 (54.75%) Developer
2 269 (36.01%) Business Intelligence Developer
3 131 (17.54%) SQL Developer
4 69 (9.24%) Analyst
5 68 (9.10%) SSIS Developer
6 66 (8.84%) SQL BI Developer
7 59 (7.90%) Architect
8 57 (7.63%) Power BI Developer
9 53 (7.10%) SSRS Developer
10 52 (6.96%) SSAS Developer
11 41 (5.49%) Consultant
12 39 (5.22%) Business Intelligence Analyst
13 37 (4.95%) DBA
14 36 (4.82%) Data Architect
15 33 (4.42%) Azure Developer
16 32 (4.28%) Azure Engineer
17 31 (4.15%) Data Engineer
17 31 (4.15%) SQL DBA
18 29 (3.88%) Senior Developer
19 28 (3.75%) Data Warehouse Developer
Libraries, Frameworks & Software Standards
1 111 (14.86%) MDX
2 95 (12.72%) .NET
3 28 (3.75%) XML
4 22 (2.95%) Web Services
5 21 (2.81%) JSON
6 20 (2.68%) AngularJS
7 19 (2.54%) ASP.NET
7 19 (2.54%) HTML
8 17 (2.28%) React
9 16 (2.14%) CSS
10 7 (0.94%) Gherkin
11 6 (0.80%) J2EE
11 6 (0.80%) Middleware
11 6 (0.80%) MSMQ
12 5 (0.67%) REST
12 5 (0.67%) SOAP
13 4 (0.54%) Kafka
13 4 (0.54%) WCF
13 4 (0.54%) XBRL
13 4 (0.54%) X-Windows
Miscellaneous
1 65 (8.70%) Analytical Skills
2 25 (3.35%) Hedge funds
3 22 (2.95%) NHS
4 21 (2.81%) Greenfield Project
5 17 (2.28%) Management Information System
6 15 (2.01%) Reinsurance
7 13 (1.74%) Clustering
8 12 (1.61%) Enterprise Software
9 10 (1.34%) Linux Command Line
10 9 (1.20%) Data Centre
11 7 (0.94%) Credit Risk
12 6 (0.80%) Self-Motivation
13 5 (0.67%) Derivative
13 5 (0.67%) Replication
14 4 (0.54%) Equities
14 4 (0.54%) Fixed Income
14 4 (0.54%) Market Risk
15 3 (0.40%) Cloud Native
15 3 (0.40%) Credit Derivative
15 3 (0.40%) Grid Computing
Operating Systems
1 28 (3.75%) Windows
2 19 (2.54%) Windows Server
3 13 (1.74%) Linux
4 12 (1.61%) Windows 7
5 10 (1.34%) Windows 10
6 9 (1.20%) Unix
7 8 (1.07%) Windows Server 2008
8 4 (0.54%) Windows 8
9 3 (0.40%) Windows Server 2003
9 3 (0.40%) Windows Server 2012
10 2 (0.27%) Solaris
11 1 (0.13%) CentOS
11 1 (0.13%) Red Hat Enterprise Linux
Processes & Methodologies
1 587 (78.58%) Business Intelligence
2 272 (36.41%) ETL
3 162 (21.69%) Agile Software Development
4 128 (17.14%) Data Modelling
5 118 (15.80%) Analytics
6 100 (13.39%) Migration
7 90 (12.05%) Visualisation
8 71 (9.50%) Kimball Methodology
9 69 (9.24%) Data Migration
10 66 (8.84%) DevOps
11 54 (7.23%) Data Analysis
12 53 (7.10%) Data Visualisation
13 48 (6.43%) Data Integration
13 48 (6.43%) Dimensional Modelling
14 46 (6.16%) TDD
15 41 (5.49%) Problem-Solving
16 38 (5.09%) Scrum
17 37 (4.95%) Test Automation
18 36 (4.82%) Data Management
18 36 (4.82%) Performance Tuning
Programming Languages
1 555 (74.30%) SQL
2 223 (29.85%) T-SQL
3 134 (17.94%) Data Analysis Expressions (DAX)
4 121 (16.20%) C#
5 76 (10.17%) PowerShell
6 71 (9.50%) Python
7 30 (4.02%) R
8 23 (3.08%) Scala
8 23 (3.08%) VBA
9 15 (2.01%) Java
10 13 (1.74%) JavaScript
11 12 (1.61%) PL/SQL
12 11 (1.47%) U-SQL
13 10 (1.34%) VB
13 10 (1.34%) VB.NET
14 6 (0.80%) C
15 5 (0.67%) VBScript
16 3 (0.40%) C++
16 3 (0.40%) Shell Script
17 2 (0.27%) Bash Shell
Qualifications
1 29 (3.88%) Degree
2 18 (2.41%) Security Cleared
3 17 (2.28%) SC Cleared
4 15 (2.01%) Microsoft Certification
5 10 (1.34%) Computer Science Degree
6 7 (0.94%) DBS Check
7 4 (0.54%) MCPD
8 3 (0.40%) CFA
8 3 (0.40%) MCSE
9 2 (0.27%) Master's Degree
10 1 (0.13%) BPSS Clearance
10 1 (0.13%) ITIL Certification
10 1 (0.13%) MCDBA
10 1 (0.13%) MCP
10 1 (0.13%) TOGAF Certification
Quality Assurance & Compliance
1 26 (3.48%) Data Quality
2 15 (2.01%) QA
3 14 (1.87%) SLA
4 5 (0.67%) GAAP
5 4 (0.54%) ISO/IEC 27001
5 4 (0.54%) Sarbanes-Oxley
6 3 (0.40%) PMO
7 1 (0.13%) ITGC
System Software
1 10 (1.34%) Docker
2 9 (1.20%) VMware Infrastructure
3 8 (1.07%) Active Directory
4 7 (0.94%) Hyper-V
5 4 (0.54%) HDFS
6 3 (0.40%) LXC
7 1 (0.13%) Virtual Machines
Systems Management
1 10 (1.34%) Ansible
2 9 (1.20%) Terraform
3 8 (1.07%) Kubernetes
3 8 (1.07%) Opscode Chef
3 8 (1.07%) Puppet
4 7 (0.94%) Control-M
5 5 (0.67%) Microsoft Clustering
6 4 (0.54%) Failover Clustering
7 3 (0.40%) Grafana
7 3 (0.40%) Kibana
7 3 (0.40%) Tivoli
7 3 (0.40%) Tivoli Storage Manager
8 2 (0.27%) HP ALM
8 2 (0.27%) Oracle RMAN
8 2 (0.27%) SCOM
9 1 (0.13%) Automic
9 1 (0.13%) Microsoft Data Protection Manager
9 1 (0.13%) SCOrch
9 1 (0.13%) SQL Sentry
Vendors
1 345 (46.18%) Microsoft
2 132 (17.67%) Tableau
3 67 (8.97%) Databricks
4 56 (7.50%) Oracle
5 35 (4.69%) Cognos
6 23 (3.08%) MicroStrategy
7 14 (1.87%) SAP
7 14 (1.87%) Teradata
8 12 (1.61%) Salesforce.com
9 10 (1.34%) Google
9 10 (1.34%) IBM
10 9 (1.20%) VMware
11 8 (1.07%) Infor
11 8 (1.07%) Trayport
12 6 (0.80%) CODA
12 6 (0.80%) JD Edwards
12 6 (0.80%) Misys
12 6 (0.80%) Sun
13 5 (0.67%) Hyperion
13 5 (0.67%) Telerik