Period
to 24 September 2021

The following table provides summary statistics for contract job vacancies advertised in the City of 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 24 September 2021 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)
Central London > City of London
6 months to
24 Sep 2021
Same period 2020 Same period 2019
Rank 152 91 137
Rank change year-on-year -61 +46 +13
Contract jobs citing SQL Server Analysis Services 26 28 100
As % of all contract jobs advertised in the City of London 0.71% 1.57% 1.60%
As % of the Database & Business Intelligence category 3.24% 5.83% 6.18%
Number of daily rates quoted 24 26 80
10th Percentile £466 £413 £325
25th Percentile £486 £461 £422
Median daily rate (50th Percentile) £540 £475 £500
Median % change year-on-year +13.68% -5.00% +5.26%
75th Percentile £625 £600 £552
90th Percentile £710 £674 £641
Central London median daily rate £540 £475 £480
% change year-on-year +13.68% -1.04% +1.05%
Number of hourly rates quoted 0 0 1
Median hourly rate - - £22.33
Central London median hourly rate - - £22.33

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 the City of London with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
City of London
Contract vacancies with a requirement for database or business intelligence skills 803 480 1,618
As % of all contract IT jobs advertised in the City of London 21.92% 26.94% 25.87%
Number of daily rates quoted 589 362 1,294
10th Percentile £377 £394 £388
25th Percentile £475 £431 £461
Median daily rate (50th Percentile) £550 £525 £525
Median % change year-on-year +4.76% - -
75th Percentile £650 £610 £619
90th Percentile £738 £688 £688
Central London median daily rate £550 £525 £525
% change year-on-year +4.76% - -
Number of hourly rates quoted 8 6 8
10th Percentile " £18.50 £17.89
25th Percentile £8.00 £20.50 £21.23
Median hourly rate £15.25 £29.75 £28.75
Median % change year-on-year -48.74% +3.48% +27.78%
75th Percentile £33.69 £39.00 £47.42
90th Percentile £43.33 £43.50 £51.04
Central London median hourly rate £17.00 £29.75 £28.75
% change year-on-year -42.86% +3.48% +27.78%

SQL Server Analysis Services
Job Vacancy Trend in the City of London

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

Job vacancy trend for SQL Server Analysis Services in the City of London

SQL Server Analysis Services
Contractor Daily Rate Trend in the City of London

3-month moving average daily rate quoted in jobs citing SQL Server Analysis Services in the City of London.

Daily rate trend for SQL Server Analysis Services in the City of London

SQL Server Analysis Services
Daily Rate Histogram in the City of London

Daily rate distribution for jobs citing SQL Server Analysis Services in the City of London over the 6 months to 24 September 2021.

Daily rate histogram for SQL Server Analysis Services in the City of London

SQL Server Analysis Services
Contractor Hourly Rate Trend in the City of London

3-month moving average hourly rates quoted in jobs citing SQL Server Analysis Services in the City of London.

Hourly rate trend for SQL Server Analysis Services in the City of London

For the 6 months to 24 September 2021, 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 City of London region with a requirement for SQL Server Analysis Services.

1 22 (84.62%) SQL
2 19 (73.08%) Business Intelligence
2 19 (73.08%) SQL Server Integration Services
3 18 (69.23%) SQL Server
3 18 (69.23%) Finance
4 17 (65.38%) Data Warehouse
5 15 (57.69%) T-SQL
5 15 (57.69%) Azure
5 15 (57.69%) Power BI
5 15 (57.69%) Power Platform
6 13 (50.00%) Data Modelling
6 13 (50.00%) ETL
6 13 (50.00%) Microsoft
7 12 (46.15%) SQL Server Reporting Services
8 9 (34.62%) Analytics
9 8 (30.77%) Microsoft Analysis Services
9 8 (30.77%) Agile Software Development
9 8 (30.77%) Social Skills
9 8 (30.77%) Azure Data Factory
10 7 (26.92%) Databricks
10 7 (26.92%) Data Lake
10 7 (26.92%) Data Analysis Expressions (DAX)
10 7 (26.92%) Python
10 7 (26.92%) Kimball Methodology
11 6 (23.08%) Team Foundation Server
11 6 (23.08%) C#
11 6 (23.08%) Scrum
11 6 (23.08%) DevOps
12 5 (19.23%) Azure SQL Data Warehouse
12 5 (19.23%) Azure Synapse Analytics

SQL Server Analysis Services
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 3 (11.54%) Apache Spark
2 2 (7.69%) SharePoint
3 1 (3.85%) CMS
3 1 (3.85%) Confluence
3 1 (3.85%) IIS
3 1 (3.85%) SharePoint Server
Applications
1 2 (7.69%) Microsoft Office
2 1 (3.85%) Microsoft Excel
2 1 (3.85%) Microsoft PowerPoint
Cloud Services
1 15 (57.69%) Azure
1 15 (57.69%) Power Platform
2 8 (30.77%) Azure Data Factory
3 5 (19.23%) Azure Synapse Analytics
4 3 (11.54%) Azure Cosmos DB
4 3 (11.54%) GitHub
5 2 (7.69%) Azure Data Lake Analytics
6 1 (3.85%) Amazon S3
6 1 (3.85%) AWS
6 1 (3.85%) Azure Functions
6 1 (3.85%) Azure Storage
6 1 (3.85%) NuGet
6 1 (3.85%) OpenShift
6 1 (3.85%) Power Automate
6 1 (3.85%) PowerApps
6 1 (3.85%) Serverless
Communications & Networking
1 1 (3.85%) Internet
1 1 (3.85%) Intranet
1 1 (3.85%) Kerberos
Database & Business Intelligence
1 19 (73.08%) SQL Server Integration Services
2 18 (69.23%) SQL Server
3 17 (65.38%) Data Warehouse
4 15 (57.69%) Power BI
5 12 (46.15%) SQL Server Reporting Services
6 8 (30.77%) Microsoft Analysis Services
7 7 (26.92%) Data Lake
8 5 (19.23%) Azure SQL Data Warehouse
8 5 (19.23%) Azure SQL Database
8 5 (19.23%) QlikView
9 4 (15.38%) BusinessObjects
10 3 (11.54%) Metadata
10 3 (11.54%) NoSQL
10 3 (11.54%) SSDT
10 3 (11.54%) Tableau
11 2 (7.69%) Delta Lake
12 1 (3.85%) Dremio
12 1 (3.85%) Enterprise Data Warehouse
12 1 (3.85%) OLAP Cube
12 1 (3.85%) Power Query
Development Applications
1 6 (23.08%) Team Foundation Server
2 5 (19.23%) Visual Studio
3 1 (3.85%) Atlassian Bamboo
3 1 (3.85%) Bitbucket
3 1 (3.85%) FishEye
3 1 (3.85%) Git (software)
3 1 (3.85%) JIRA
3 1 (3.85%) SonarQube
3 1 (3.85%) Sonatype Nexus
3 1 (3.85%) Toad
General
1 18 (69.23%) Finance
2 8 (30.77%) Social Skills
3 4 (15.38%) Analytical Skills
3 4 (15.38%) Banking
4 2 (7.69%) Front Office
4 2 (7.69%) Investment Banking
5 1 (3.85%) Documentation Skills
5 1 (3.85%) Financial Institution
5 1 (3.85%) Legal
5 1 (3.85%) Marketing
5 1 (3.85%) Presentation Skills
Job Titles
1 10 (38.46%) Developer
2 6 (23.08%) Data Engineer
3 4 (15.38%) Analyst
3 4 (15.38%) Architect
4 3 (11.54%) Azure Engineer
4 3 (11.54%) Business Intelligence Developer
4 3 (11.54%) C# Developer
4 3 (11.54%) Data Warehouse Analyst
4 3 (11.54%) Data Warehouse Developer
5 2 (7.69%) Analyst Developer
5 2 (7.69%) Front Office Developer
5 2 (7.69%) Lead Architect
5 2 (7.69%) SQL Developer
5 2 (7.69%) SQL Server Architect
6 1 (3.85%) Business Intelligence Analyst
6 1 (3.85%) Data Analyst
6 1 (3.85%) Junior Business Analyst
6 1 (3.85%) Operations Analyst
6 1 (3.85%) Senior Analyst
6 1 (3.85%) Senior Developer
Libraries, Frameworks & Software Standards
1 5 (19.23%) MDX
2 3 (11.54%) .NET
3 2 (7.69%) ASP.NET
3 2 (7.69%) PySpark
4 1 (3.85%) .NET Framework
4 1 (3.85%) Spring
4 1 (3.85%) XML
Miscellaneous
1 4 (15.38%) Management Information System
2 2 (7.69%) Credit Derivative
2 2 (7.69%) Grid Computing
2 2 (7.69%) Reinsurance
3 1 (3.85%) NHS
3 1 (3.85%) Self-Motivation
3 1 (3.85%) Wiki
Operating Systems
1 2 (7.69%) Unix
2 1 (3.85%) Linux
Processes & Methodologies
1 19 (73.08%) Business Intelligence
2 13 (50.00%) Data Modelling
2 13 (50.00%) ETL
3 9 (34.62%) Analytics
4 8 (30.77%) Agile Software Development
5 7 (26.92%) Kimball Methodology
6 6 (23.08%) DevOps
6 6 (23.08%) Scrum
7 4 (15.38%) Data Engineering
8 3 (11.54%) Change Management
8 3 (11.54%) Continuous Delivery
8 3 (11.54%) Data Ingestion
8 3 (11.54%) Data Management
8 3 (11.54%) Data Pipeline
8 3 (11.54%) Data Science
8 3 (11.54%) Data Strategy
8 3 (11.54%) ETL Development
8 3 (11.54%) Problem-Solving
8 3 (11.54%) Risk Management
8 3 (11.54%) Stakeholder Management
Programming Languages
1 22 (84.62%) SQL
2 15 (57.69%) T-SQL
3 7 (26.92%) Data Analysis Expressions (DAX)
3 7 (26.92%) Python
4 6 (23.08%) C#
5 3 (11.54%) R
5 3 (11.54%) Scala
6 2 (7.69%) PowerShell
7 1 (3.85%) Groovy
7 1 (3.85%) Java
7 1 (3.85%) PL/SQL
Qualifications
1 1 (3.85%) ACCA
1 1 (3.85%) CIMA
Quality Assurance & Compliance
1 3 (11.54%) Solvency II
2 2 (7.69%) IFRS
2 2 (7.69%) Sarbanes-Oxley
3 1 (3.85%) Accessibility
3 1 (3.85%) Data Quality
3 1 (3.85%) GDPR
3 1 (3.85%) QA
System Software
1 1 (3.85%) Active Directory
1 1 (3.85%) Docker
Systems Management
1 1 (3.85%) Ansible
1 1 (3.85%) Kubernetes
Vendors
1 13 (50.00%) Microsoft
2 7 (26.92%) Databricks
3 3 (11.54%) StreamSets
4 2 (7.69%) Oracle
5 1 (3.85%) Atlassian
5 1 (3.85%) Sybase