Period
to 16 November 2019

The following table provides summary statistics for contract job vacancies advertised in London 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 16 November 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)
England > London
6 months to
16 Nov 2019
Same period 2018 Same period 2017
Rank 246 261 292
Rank change year-on-year +15 +31 -16
Contract jobs citing SQL Server Analysis Services 369 461 422
As % of all contract IT jobs advertised in London 1.03% 1.00% 0.90%
As % of the Database & Business Intelligence category 4.32% 4.08% 3.80%
Number of daily rates quoted 284 374 334
London median daily rate £500 £475 £450
Median daily rate % change year-on-year +5.26% +5.56% -
10th Percentile £384 £343 £354
90th Percentile £759 £625 £588
England median daily rate £450 £450 £425
% change year-on-year - +5.88% +6.25%
Number of hourly rates quoted 4 1 7
London median hourly rate £24.37 £24.08 £21.50
Median hourly rate % change year-on-year +1.20% +12.00% -
10th Percentile £22.04 £24.08 £20.75
90th Percentile £25.22 £24.08 £86.05
England median hourly rate £24.66 £45.00 £21.50
% change year-on-year -45.20% +109.30% -51.14%

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 advertised in London with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
London
Contract vacancies with a requirement for database or business intelligence skills 8,533 11,290 11,113
As % of all contract IT jobs advertised in London 23.85% 24.39% 23.70%
Number of daily rates quoted 6,155 8,420 8,240
London median daily rate £525 £525 £500
Median daily rate % change year-on-year - +5.00% +5.26%
10th Percentile £363 £363 £352
90th Percentile £700 £675 £656
England median daily rate £475 £475 £450
% change year-on-year - +5.56% +5.88%
Number of hourly rates quoted 58 50 59
London median hourly rate £35.00 £27.62 £26.61
Median hourly rate % change year-on-year +26.74% +3.80% -20.58%
10th Percentile £15.57 £16.15 £18.20
90th Percentile £62.10 £48.73 £58.75
England median hourly rate £32.50 £33.50 £32.00
% change year-on-year -2.99% +4.69% +14.29%

SQL Server Analysis Services
Job Vacancy Trend in London

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

Job vacancy trend for SQL Server Analysis Services in London

SQL Server Analysis Services
Contractor Daily Rate Trend in London

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

Contractor daily rate trend for SQL Server Analysis Services in London

SQL Server Analysis Services
Contractor Daily Rate Histogram in London

The daily rate distribution of IT jobs citing SQL Server Analysis Services in London over the 6 months to 16 November 2019.

Contractor daily rate histogram for SQL Server Analysis Services in London

SQL Server Analysis Services
Contractor Hourly Rate Trend in London

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

Contractor hourly rate trend for SQL Server Analysis Services in London

SQL Server Analysis Services
Contract Job Locations in London

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 London region over the 6 months to 16 November 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
Central London +34 115 £500 +11.11% 35
West London +13 6 £413 -8.33% 6
South London +12 2 £400 -20.00%
East London +23 1 - - 2
North London +5 1 - - 1
SQL Server Analysis Services
England

For the 6 months to 16 November 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 across the London region with a requirement for SQL Server Analysis Services.

1 294 (79.67%) Business Intelligence
2 274 (74.25%) SQL
3 269 (72.90%) SQL Server Integration Services
4 265 (71.82%) SQL Server
5 255 (69.11%) SQL Server Reporting Services
6 213 (57.72%) Power Platform
7 212 (57.45%) Power BI
8 177 (47.97%) Data Warehouse
9 162 (43.90%) Microsoft
10 126 (34.15%) Finance
11 123 (33.33%) ETL
12 112 (30.35%) Azure
13 94 (25.47%) T-SQL
14 91 (24.66%) Tableau
15 90 (24.39%) Agile Software Development
16 89 (24.12%) C#
17 71 (19.24%) .NET
17 71 (19.24%) Microsoft Analysis Services
18 64 (17.34%) Data Analysis Expressions (DAX)
19 62 (16.80%) PowerShell
20 61 (16.53%) MDX
21 59 (15.99%) Visualisation
22 57 (15.45%) Microsoft Excel
23 56 (15.18%) Analytics
24 54 (14.63%) QlikView
25 49 (13.28%) OLAP
26 48 (13.01%) Data Modelling
27 42 (11.38%) DevOps
28 41 (11.11%) TDD
29 39 (10.57%) Data Visualisation

SQL Server Analysis Services
Co-occurring IT Skills in 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 24 (6.50%) SharePoint
2 7 (1.90%) Apache Spark
3 6 (1.63%) CMS
3 6 (1.63%) IIS
3 6 (1.63%) SAS
3 6 (1.63%) WebLogic
3 6 (1.63%) WebLogic Integration
4 4 (1.08%) BizTalk Server
5 3 (0.81%) Confluence
6 2 (0.54%) Skype for Business
7 1 (0.27%) Apache
7 1 (0.27%) Apache Airflow
7 1 (0.27%) Oracle SOA Suite
7 1 (0.27%) Oracle Workflow
7 1 (0.27%) SharePoint 2010
7 1 (0.27%) SharePoint 2013
Applications
1 57 (15.45%) Microsoft Excel
2 6 (1.63%) Microsoft Office
3 5 (1.36%) MS Visio
4 3 (0.81%) Microsoft PowerPoint
5 1 (0.27%) InfoPath
5 1 (0.27%) Spreadsheet
Business Applications
1 16 (4.34%) Dynamics CRM
2 6 (1.63%) Misys Opics
2 6 (1.63%) Oracle Financials
2 6 (1.63%) Unit4 Business World
3 2 (0.54%) Dynamics NAV
3 2 (0.54%) NetSuite
4 1 (0.27%) Cognos Business Intelligence
4 1 (0.27%) Dynamics AX
4 1 (0.27%) SnowdropKCS
Cloud Services
1 213 (57.72%) Power Platform
2 112 (30.35%) Azure
3 35 (9.49%) Azure Data Factory
4 23 (6.23%) AWS
5 6 (1.63%) Azure Functions
5 6 (1.63%) GCP
5 6 (1.63%) Serverless
6 5 (1.36%) Data Lake Analytics
6 5 (1.36%) Office 365
6 5 (1.36%) OpenShift
7 4 (1.08%) Dynamics 365
8 3 (0.81%) Cloud Computing
9 2 (0.54%) Azure Machine Learning
9 2 (0.54%) Azure Stack
9 2 (0.54%) GitHub
9 2 (0.54%) IaaS
9 2 (0.54%) PowerApps
10 1 (0.27%) NuGet
10 1 (0.27%) PaaS
10 1 (0.27%) SaaS
Communications & Networking
1 4 (1.08%) Firewall
1 4 (1.08%) Internet
2 1 (0.27%) SAN
Database & Business Intelligence
1 269 (72.90%) SQL Server Integration Services
2 265 (71.82%) SQL Server
3 255 (69.11%) SQL Server Reporting Services
4 212 (57.45%) Power BI
5 177 (47.97%) Data Warehouse
6 71 (19.24%) Microsoft Analysis Services
7 54 (14.63%) QlikView
8 49 (13.28%) OLAP
9 36 (9.76%) Azure SQL Database
10 31 (8.40%) Data Lake
10 31 (8.40%) SQL Server 2012
11 28 (7.59%) Azure SQL Data Warehouse
11 28 (7.59%) SQL Server 2017
12 23 (6.23%) Big Data
12 23 (6.23%) PowerPivot
12 23 (6.23%) SQL Server 2014
13 18 (4.88%) SQL Server 2016
14 12 (3.25%) BusinessObjects
15 11 (2.98%) Relational Database
16 9 (2.44%) Semantic Layer
Development Applications
1 34 (9.21%) Git (software)
2 29 (7.86%) TeamCity
3 27 (7.32%) Octopus Deploy
4 18 (4.88%) Visual Studio
5 14 (3.79%) Visual Studio Team System
6 10 (2.71%) Team Foundation Server
7 7 (1.90%) Jenkins
7 7 (1.90%) JIRA
8 6 (1.63%) Eclipse
8 6 (1.63%) Selenium
9 4 (1.08%) WebDriver
10 3 (0.81%) Subversion
11 2 (0.54%) GitLab
11 2 (0.54%) Maven
11 2 (0.54%) webpack
12 1 (0.27%) ERwin
12 1 (0.27%) MSI
12 1 (0.27%) NUnit
12 1 (0.27%) SQL Server Management Studio (SSMS)
12 1 (0.27%) Visual Studio Coded UI
General
1 126 (34.15%) Finance
2 29 (7.86%) Banking
2 29 (7.86%) Retail
3 20 (5.42%) Front Office
4 12 (3.25%) Public Sector
5 11 (2.98%) Investment Banking
5 11 (2.98%) Legal
6 8 (2.17%) Back Office
7 7 (1.90%) Manufacturing
8 5 (1.36%) Marketing
9 3 (0.81%) Games
9 3 (0.81%) Telecoms
10 2 (0.54%) Billing
11 1 (0.27%) Automotive
11 1 (0.27%) Law
11 1 (0.27%) Retail Banking
Job Titles
1 225 (60.98%) Developer
2 139 (37.67%) Business Intelligence Developer
3 69 (18.70%) SQL Developer
4 40 (10.84%) SSIS Developer
5 36 (9.76%) SSAS Developer
6 34 (9.21%) Analyst
7 30 (8.13%) SSRS Developer
8 28 (7.59%) SQL BI Developer
9 24 (6.50%) C# Developer
9 24 (6.50%) Power BI Developer
10 19 (5.15%) Business Intelligence Analyst
10 19 (5.15%) Consultant
11 18 (4.88%) Architect
12 17 (4.61%) Azure Engineer
12 17 (4.61%) SQL Server Developer
13 15 (4.07%) Business Developer
14 13 (3.52%) Senior Developer
15 12 (3.25%) Business Intelligence Consultant
15 12 (3.25%) Data Engineer
16 11 (2.98%) Business Intelligence Lead
Libraries, Frameworks & Software Standards
1 71 (19.24%) .NET
2 61 (16.53%) MDX
3 28 (7.59%) AngularJS
4 27 (7.32%) HTML
4 27 (7.32%) React
5 25 (6.78%) ASP.NET
6 24 (6.50%) CSS
7 10 (2.71%) JSON
7 10 (2.71%) XML
8 8 (2.17%) Web Services
9 6 (1.63%) J2EE
9 6 (1.63%) Middleware
9 6 (1.63%) MSMQ
10 5 (1.36%) Vue.js
11 4 (1.08%) Kafka
11 4 (1.08%) XBRL
12 3 (0.81%) D3.js
12 3 (0.81%) REST
12 3 (0.81%) SOAP
13 2 (0.54%) ASP.NET Web API
Miscellaneous
1 32 (8.67%) Analytical Skills
2 30 (8.13%) Hedge funds
3 11 (2.98%) Greenfield Project
4 7 (1.90%) Reinsurance
5 6 (1.63%) Management Information System
5 6 (1.63%) NHS
6 5 (1.36%) Derivative
6 5 (1.36%) Equities
6 5 (1.36%) Self-Motivation
7 4 (1.08%) Clustering
7 4 (1.08%) Fixed Income
8 3 (0.81%) Cloud Native
8 3 (0.81%) Credit Derivative
8 3 (0.81%) Credit Risk
8 3 (0.81%) Grid Computing
9 2 (0.54%) Analytical Mindset
9 2 (0.54%) Enterprise Software
9 2 (0.54%) Public Cloud
9 2 (0.54%) User Experience
10 1 (0.27%) Data Structures
Operating Systems
1 13 (3.52%) Windows
2 10 (2.71%) Windows Server
3 8 (2.17%) Windows 7
4 7 (1.90%) Linux
5 6 (1.63%) Windows 10
6 1 (0.27%) CentOS
6 1 (0.27%) Red Hat Enterprise Linux
6 1 (0.27%) Unix
Processes & Methodologies
1 294 (79.67%) Business Intelligence
2 123 (33.33%) ETL
3 90 (24.39%) Agile Software Development
4 59 (15.99%) Visualisation
5 56 (15.18%) Analytics
6 48 (13.01%) Data Modelling
7 42 (11.38%) DevOps
8 41 (11.11%) TDD
9 39 (10.57%) Data Analysis
9 39 (10.57%) Data Visualisation
10 38 (10.30%) Migration
11 32 (8.67%) Data Integration
12 31 (8.40%) Kimball Methodology
13 27 (7.32%) Dimensional Modelling
14 24 (6.50%) Problem-Solving
15 23 (6.23%) CRM
15 23 (6.23%) Test Automation
16 21 (5.69%) Data Migration
17 20 (5.42%) Web Development
18 16 (4.34%) Scrum
Programming Languages
1 274 (74.25%) SQL
2 94 (25.47%) T-SQL
3 89 (24.12%) C#
4 64 (17.34%) Data Analysis Expressions (DAX)
5 62 (16.80%) PowerShell
6 33 (8.94%) Python
7 14 (3.79%) VBA
8 12 (3.25%) Java
9 10 (2.71%) JavaScript
10 9 (2.44%) R
10 9 (2.44%) Scala
11 7 (1.90%) VB
11 7 (1.90%) VB.NET
12 5 (1.36%) PL/SQL
13 3 (0.81%) C
13 3 (0.81%) Shell Script
14 2 (0.54%) Bash Shell
14 2 (0.54%) U-SQL
15 1 (0.27%) TypeScript
15 1 (0.27%) XMLA
Qualifications
1 15 (4.07%) Degree
1 15 (4.07%) Security Cleared
2 14 (3.79%) SC Cleared
3 5 (1.36%) Computer Science Degree
4 3 (0.81%) CFA
4 3 (0.81%) Microsoft Certification
5 1 (0.27%) MCDBA
5 1 (0.27%) MCITP
5 1 (0.27%) MCP
5 1 (0.27%) MCPD
5 1 (0.27%) TOGAF Certification
Quality Assurance & Compliance
1 9 (2.44%) QA
2 8 (2.17%) SLA
3 7 (1.90%) Data Quality
4 5 (1.36%) GAAP
5 1 (0.27%) ISO/IEC 27001
System Software
1 4 (1.08%) Docker
2 3 (0.81%) Active Directory
2 3 (0.81%) HDFS
3 2 (0.54%) Hyper-V
3 2 (0.54%) VMware Infrastructure
4 1 (0.27%) Virtual Machines
Systems Management
1 10 (2.71%) Opscode Chef
1 10 (2.71%) Puppet
2 9 (2.44%) Control-M
3 4 (1.08%) Ansible
4 3 (0.81%) Grafana
4 3 (0.81%) Kibana
5 2 (0.54%) Kubernetes
5 2 (0.54%) Microsoft Clustering
5 2 (0.54%) Terraform
6 1 (0.27%) Automic
6 1 (0.27%) Failover Clustering
6 1 (0.27%) Microsoft Data Protection Manager
6 1 (0.27%) SCOM
6 1 (0.27%) SCOrch
Vendors
1 162 (43.90%) Microsoft
2 91 (24.66%) Tableau
3 29 (7.86%) Databricks
4 28 (7.59%) Cognos
4 28 (7.59%) Oracle
5 26 (7.05%) MicroStrategy
6 12 (3.25%) Salesforce.com
7 9 (2.44%) Teradata
8 8 (2.17%) Trayport
9 6 (1.63%) CODA
9 6 (1.63%) Google
9 6 (1.63%) Infor
9 6 (1.63%) Misys
9 6 (1.63%) Sun
10 4 (1.08%) DataFlux
10 4 (1.08%) Hyperion
11 3 (0.81%) SAP
12 2 (0.54%) Twitter
12 2 (0.54%) VMware
13 1 (0.27%) Alteryx