Period
to 17 January 2020

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 17 January 2020 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
17 Jan 2020
Same period 2019 Same period 2018
Rank 291 324 325
Rank change year-on-year +33 +1 -64
Contract jobs citing SQL Server Analysis Services 630 807 804
As % of all contract IT jobs advertised in the UK 0.87% 0.81% 0.80%
As % of the Database & Business Intelligence category 4.11% 3.61% 3.64%
Number of daily rates quoted 472 617 628
UK median daily rate £450 £450 £425
Median daily rate % change year-on-year - +5.88% +6.25%
10th Percentile £316 £313 £300
90th Percentile £638 £588 £538
UK excluding London median daily rate £425 £410 £375
% change year-on-year +3.66% +9.33% -
Number of hourly rates quoted 2 7 10
UK median hourly rate £28.67 £42.00 £25.50
Median hourly rate % change year-on-year -31.75% +64.71% -38.55%
10th Percentile £22.05 £33.93 £20.31
90th Percentile £38.35 £60.50 £43.13
UK excluding London median hourly rate - £43.50 £27.00
% change year-on-year - +61.11% -34.94%

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 15,316 22,344 22,059
As % of all contract IT jobs advertised in the UK 21.03% 22.47% 21.99%
Number of daily rates quoted 10,204 15,405 15,353
UK median daily rate £475 £475 £450
Median daily rate % change year-on-year - +5.56% +5.88%
10th Percentile £319 £319 £310
90th Percentile £663 £638 £625
UK excluding London median daily rate £438 £425 £400
% change year-on-year +2.94% +6.25% +3.23%
Number of hourly rates quoted 244 247 254
UK median hourly rate £32.00 £32.50 £30.95
Median hourly rate % change year-on-year -1.54% +5.01% +9.83%
10th Percentile £13.06 £13.51 £14.68
90th Percentile £54.63 £57.40 £55.42
UK excluding London median hourly rate £26.50 £33.00 £35.00
% change year-on-year -19.70% -5.71% +27.85%

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 17 January 2020.

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 17 January 2020.

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 17 January 2020. 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 +34 600 £450 - 234
UK excluding London +61 321 £425 +3.66% 164
London +23 304 £500 +5.26% 78
South East +107 103 £425 +3.03% 28
North of England +12 76 £388 -3.13% 60
Midlands +39 54 £400 -5.88% 34
South West -2 38 £440 +3.53% 16
West Midlands +52 37 £388 -6.06% 19
North West +16 35 £400 +5.26% 37
Yorkshire +29 32 £360 -10.00% 18
East of England +13 24 £400 -7.25% 18
East Midlands +8 17 £400 -5.88% 15
Scotland +8 16 £425 +13.33% 5
Wales +29 9 £425 - 2
North East +25 9 £438 +0.29% 5
Northern Ireland +8 1 £325 - 1

For the 6 months to 17 January 2020, 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 487 (77.30%) SQL Server Integration Services
2 475 (75.40%) SQL
2 475 (75.40%) Business Intelligence
3 448 (71.11%) SQL Server
4 419 (66.51%) SQL Server Reporting Services
5 314 (49.84%) Power Platform
6 313 (49.68%) Power BI
7 306 (48.57%) Data Warehouse
8 285 (45.24%) Microsoft
9 225 (35.71%) Azure
10 215 (34.13%) ETL
11 213 (33.81%) T-SQL
12 191 (30.32%) Finance
13 172 (27.30%) Agile Software Development
14 118 (18.73%) C#
15 109 (17.30%) .NET
16 107 (16.98%) Tableau
17 106 (16.83%) Analytics
18 103 (16.35%) Microsoft Analysis Services
19 94 (14.92%) MDX
20 93 (14.76%) Data Modelling
21 92 (14.60%) Visualisation
22 86 (13.65%) PowerShell
23 84 (13.33%) Azure Data Factory
24 80 (12.70%) Analytical Skills
25 77 (12.22%) Data Analysis Expressions (DAX)
26 72 (11.43%) Migration
27 70 (11.11%) Data Lake
27 70 (11.11%) Azure SQL Database
28 68 (10.79%) Python

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 28 (4.44%) SharePoint
2 8 (1.27%) SAS
3 7 (1.11%) BizTalk Server
4 6 (0.95%) IIS
5 5 (0.79%) Apache Spark
5 5 (0.79%) DataSynapse
5 5 (0.79%) SharePoint 2013
6 4 (0.63%) Apache
7 3 (0.48%) Apache Airflow
7 3 (0.48%) CMS
7 3 (0.48%) Skype for Business
7 3 (0.48%) WebLogic
7 3 (0.48%) WebLogic Integration
8 1 (0.16%) Confluence
8 1 (0.16%) Oracle SOA Suite
Applications
1 58 (9.21%) Microsoft Excel
2 7 (1.11%) MS Visio
3 6 (0.95%) SPSS
4 3 (0.48%) Microsoft Office
5 2 (0.32%) Microsoft PowerPoint
6 1 (0.16%) Spreadsheet
Business Applications
1 10 (1.59%) Dynamics CRM
2 7 (1.11%) NetSuite
3 6 (0.95%) Misys Opics
4 5 (0.79%) Dynamics NAV
5 4 (0.63%) Dynamics AX
6 3 (0.48%) Oracle Financials
6 3 (0.48%) Unit4 Business World
7 2 (0.32%) Oracle EBS
7 2 (0.32%) SAP ERP
8 1 (0.16%) Cognos Business Intelligence
8 1 (0.16%) SnowdropKCS
8 1 (0.16%) Sparx Enterprise Architect
8 1 (0.16%) thinkFolio
Cloud Services
1 314 (49.84%) Power Platform
2 225 (35.71%) Azure
3 84 (13.33%) Azure Data Factory
4 49 (7.78%) AWS
5 14 (2.22%) Azure Machine Learning
5 14 (2.22%) Data Lake Analytics
5 14 (2.22%) Dynamics 365
6 11 (1.75%) GitHub
7 9 (1.43%) GCP
8 7 (1.11%) Azure Functions
8 7 (1.11%) PowerApps
8 7 (1.11%) Serverless
9 6 (0.95%) PaaS
10 4 (0.63%) Azure Active Directory
10 4 (0.63%) Azure Stack
10 4 (0.63%) IaaS
10 4 (0.63%) Office 365
11 3 (0.48%) OpenShift
12 2 (0.32%) Amazon EMR
12 2 (0.32%) AWS CloudFormation
Communications & Networking
1 6 (0.95%) SAN
2 5 (0.79%) Internet
3 2 (0.32%) SMS
4 1 (0.16%) Firewall
4 1 (0.16%) FTP
Database & Business Intelligence
1 487 (77.30%) SQL Server Integration Services
2 448 (71.11%) SQL Server
3 419 (66.51%) SQL Server Reporting Services
4 313 (49.68%) Power BI
5 306 (48.57%) Data Warehouse
6 103 (16.35%) Microsoft Analysis Services
7 70 (11.11%) Azure SQL Database
7 70 (11.11%) Data Lake
8 68 (10.79%) Azure SQL Data Warehouse
9 56 (8.89%) OLAP
10 46 (7.30%) QlikView
10 46 (7.30%) SQL Server 2016
11 35 (5.56%) SQL Server 2012
11 35 (5.56%) SQL Server 2014
12 32 (5.08%) Big Data
13 29 (4.60%) MySQL
14 26 (4.13%) PowerPivot
14 26 (4.13%) Relational Database
15 24 (3.81%) MongoDB
16 23 (3.65%) SQL Server 2008
Development Applications
1 48 (7.62%) TeamCity
2 45 (7.14%) Git (software)
3 38 (6.03%) Octopus Deploy
4 26 (4.13%) Visual Studio
5 25 (3.97%) Team Foundation Server
6 16 (2.54%) Visual Studio Team System
7 15 (2.38%) MSBuild
8 13 (2.06%) SQL Server Management Studio (SSMS)
9 10 (1.59%) Subversion
10 9 (1.43%) Jenkins
11 7 (1.11%) JIRA
11 7 (1.11%) Maven
11 7 (1.11%) Selenium
11 7 (1.11%) tSQLt
12 5 (0.79%) Atlassian Bamboo
12 5 (0.79%) Cucumber
13 4 (0.63%) Concordion
13 4 (0.63%) EasyMock
13 4 (0.63%) Gradle
13 4 (0.63%) Mockito
General
1 191 (30.32%) Finance
2 30 (4.76%) Retail
3 24 (3.81%) Banking
3 24 (3.81%) Public Sector
4 22 (3.49%) Front Office
4 22 (3.49%) Legal
5 13 (2.06%) Manufacturing
6 10 (1.59%) Marketing
7 9 (1.43%) Back Office
8 6 (0.95%) Telecoms
9 4 (0.63%) Automotive
9 4 (0.63%) Local Government
10 3 (0.48%) Games
11 2 (0.32%) Electronics
12 1 (0.16%) Billing
12 1 (0.16%) Law
Job Titles
1 379 (60.16%) Developer
2 238 (37.78%) Business Intelligence Developer
3 133 (21.11%) SQL Developer
4 71 (11.27%) SQL BI Developer
5 52 (8.25%) Analyst
6 50 (7.94%) SSIS Developer
7 44 (6.98%) SSAS Developer
8 43 (6.83%) Power BI Developer
9 41 (6.51%) SSRS Developer
10 40 (6.35%) Data Engineer
11 35 (5.56%) DBA
11 35 (5.56%) Senior Developer
12 32 (5.08%) Architect
12 32 (5.08%) SQL DBA
13 31 (4.92%) Azure Developer
14 29 (4.60%) Consultant
14 29 (4.60%) SQL Server Developer
15 24 (3.81%) Data Architect
15 24 (3.81%) Senior Business Intelligence Developer
16 23 (3.65%) ETL Developer
Libraries, Frameworks & Software Standards
1 109 (17.30%) .NET
2 94 (14.92%) MDX
3 48 (7.62%) ASP.NET
4 46 (7.30%) AngularJS
5 45 (7.14%) React
6 35 (5.56%) HTML
7 33 (5.24%) CSS
7 33 (5.24%) Web Services
8 28 (4.44%) XML
9 18 (2.86%) .NET Core
10 15 (2.38%) JSON
11 8 (1.27%) SOAP
12 6 (0.95%) REST
13 5 (0.79%) .NET Framework
13 5 (0.79%) Ajax
13 5 (0.79%) Gherkin
13 5 (0.79%) Vue.js
14 4 (0.63%) jQuery
14 4 (0.63%) XHTML
14 4 (0.63%) X-Windows
Miscellaneous
1 80 (12.70%) Analytical Skills
2 28 (4.44%) Hedge funds
3 17 (2.70%) NHS
4 15 (2.38%) Management Information System
5 13 (2.06%) Greenfield Project
6 10 (1.59%) Clustering
7 9 (1.43%) Analytical Mindset
8 8 (1.27%) Linux Command Line
8 8 (1.27%) Replication
9 5 (0.79%) Grid Computing
9 5 (0.79%) Reinsurance
9 5 (0.79%) Self-Motivation
10 4 (0.63%) Data Centre
10 4 (0.63%) Data Structures
10 4 (0.63%) Enterprise Software
10 4 (0.63%) Equities
11 3 (0.48%) Fat Client
11 3 (0.48%) Reference Data
11 3 (0.48%) Thin Client
11 3 (0.48%) User Experience
Operating Systems
1 34 (5.40%) Windows
2 21 (3.33%) Windows Server
3 19 (3.02%) Linux
4 12 (1.90%) Unix
4 12 (1.90%) Windows 7
5 10 (1.59%) Windows 10
6 5 (0.79%) Windows Server 2008
7 4 (0.63%) Windows 8
8 2 (0.32%) CentOS
8 2 (0.32%) Red Hat Enterprise Linux
8 2 (0.32%) Solaris
8 2 (0.32%) Windows Server 2003
9 1 (0.16%) Windows Mobile
Processes & Methodologies
1 475 (75.40%) Business Intelligence
2 215 (34.13%) ETL
3 172 (27.30%) Agile Software Development
4 106 (16.83%) Analytics
5 93 (14.76%) Data Modelling
6 92 (14.60%) Visualisation
7 72 (11.43%) Migration
8 60 (9.52%) DevOps
9 56 (8.89%) TDD
10 53 (8.41%) Data Visualisation
11 51 (8.10%) Scrum
12 49 (7.78%) Data Analysis
13 48 (7.62%) Data Migration
13 48 (7.62%) Kimball Methodology
13 48 (7.62%) Machine Learning
14 44 (6.98%) Dimensional Modelling
15 35 (5.56%) Performance Tuning
16 33 (5.24%) Data Integration
17 31 (4.92%) Problem-Solving
18 30 (4.76%) Data Management
Programming Languages
1 475 (75.40%) SQL
2 213 (33.81%) T-SQL
3 118 (18.73%) C#
4 86 (13.65%) PowerShell
5 77 (12.22%) Data Analysis Expressions (DAX)
6 68 (10.79%) Python
7 34 (5.40%) JavaScript
8 24 (3.81%) R
9 16 (2.54%) F#
10 15 (2.38%) Scala
11 14 (2.22%) Java
12 13 (2.06%) VBA
13 12 (1.90%) PL/SQL
13 12 (1.90%) VB.NET
14 11 (1.75%) U-SQL
15 10 (1.59%) VB
16 8 (1.27%) Bash Shell
17 7 (1.11%) Shell Script
18 6 (0.95%) VBScript
19 3 (0.48%) C
Qualifications
1 22 (3.49%) Degree
2 20 (3.17%) Security Cleared
3 18 (2.86%) SC Cleared
4 12 (1.90%) Microsoft Certification
5 7 (1.11%) DBS Check
6 4 (0.63%) MCITP
7 3 (0.48%) Computer Science Degree
8 1 (0.16%) BPSS Clearance
8 1 (0.16%) CITP
8 1 (0.16%) ITIL Certification
8 1 (0.16%) Master's Degree
8 1 (0.16%) MCDBA
8 1 (0.16%) MCP
8 1 (0.16%) MCSE
8 1 (0.16%) TOGAF Certification
Quality Assurance & Compliance
1 20 (3.17%) SLA
2 19 (3.02%) Data Quality
3 11 (1.75%) QA
4 5 (0.79%) Sarbanes-Oxley
5 3 (0.48%) ISO/IEC 27001
6 2 (0.32%) GDPR
7 1 (0.16%) GAAP
7 1 (0.16%) ITGC
7 1 (0.16%) PCI DSS
7 1 (0.16%) PMO
System Software
1 10 (1.59%) Active Directory
2 8 (1.27%) Hyper-V
3 6 (0.95%) Docker
3 6 (0.95%) VMware Infrastructure
4 4 (0.63%) HDFS
4 4 (0.63%) Virtual Machines
5 3 (0.48%) LXC
Systems Management
1 14 (2.22%) Puppet
2 9 (1.43%) Opscode Chef
3 8 (1.27%) Ansible
3 8 (1.27%) Terraform
4 7 (1.11%) Control-M
4 7 (1.11%) Kubernetes
5 3 (0.48%) Failover Clustering
5 3 (0.48%) Microsoft Clustering
6 2 (0.32%) Microsoft Data Protection Manager
6 2 (0.32%) Oracle RMAN
6 2 (0.32%) SCOM
6 2 (0.32%) SCOrch
6 2 (0.32%) Tivoli
6 2 (0.32%) Tivoli Storage Manager
7 1 (0.16%) Ambari
7 1 (0.16%) Automic
7 1 (0.16%) Hadoop YARN
Vendors
1 285 (45.24%) Microsoft
2 107 (16.98%) Tableau
3 54 (8.57%) Oracle
4 46 (7.30%) Databricks
5 33 (5.24%) Cognos
6 26 (4.13%) MicroStrategy
7 13 (2.06%) SAP
8 12 (1.90%) Salesforce.com
8 12 (1.90%) Teradata
9 9 (1.43%) IBM
10 8 (1.27%) Google
10 8 (1.27%) Infor
10 8 (1.27%) Trayport
11 7 (1.11%) Hyperion
11 7 (1.11%) VMware
12 6 (0.95%) Alteryx
12 6 (0.95%) JD Edwards
12 6 (0.95%) Misys
12 6 (0.95%) Sun
12 6 (0.95%) TIBCO