Period
to 17 July 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 17 July 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
17 Jul 2019
Same period 2018 Same period 2017
Rank 325 339 285
Rank change year-on-year +14 -54 -22
Contract jobs citing SQL Server Analysis Services 729 761 842
As % of all contract IT jobs advertised in the UK 0.79% 0.73% 0.89%
As % of the Database & Business Intelligence category 3.54% 3.24% 3.95%
Number of daily rates quoted 525 600 580
UK median daily rate £448 £433 £416
Median daily rate % change year-on-year +3.47% +3.90% +4.06%
10th Percentile £313 £313 £292
90th Percentile £625 £588 £575
UK excluding London median daily rate £400 £399 £375
% change year-on-year +0.31% +6.33% -
Number of hourly rates quoted 6 4 8
UK median hourly rate £24.37 £22.25 £23.25
Median hourly rate % change year-on-year +9.53% -4.30% -40.00%
10th Percentile £20.31 £21.00 £20.75
90th Percentile £30.23 £31.63 £87.78
UK excluding London median hourly rate £22.36 £22.50 £30.00
% change year-on-year -0.62% -25.00% -22.58%

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 20,567 23,514 21,319
As % of all contract IT jobs advertised in the UK 22.15% 22.69% 22.44%
Number of daily rates quoted 14,088 16,385 14,160
UK median daily rate £475 £463 £450
Median daily rate % change year-on-year +2.70% +2.78% +5.88%
10th Percentile £325 £313 £300
90th Percentile £650 £635 £614
UK excluding London median daily rate £430 £413 £400
% change year-on-year +4.24% +3.13% +6.67%
Number of hourly rates quoted 264 238 269
UK median hourly rate £35.00 £32.50 £31.00
Median hourly rate % change year-on-year +7.69% +4.84% +9.73%
10th Percentile £14.29 £14.00 £11.04
90th Percentile £60.00 £55.00 £52.50
UK excluding London median hourly rate £35.00 £33.50 £31.50
% change year-on-year +4.48% +6.35% +10.53%

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 July 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 17 July 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 17 July 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 +25 694 £450 - 296
London +6 379 £475 - 101
UK excluding London +26 339 £400 +0.31% 203
North of England +67 112 £375 - 69
South East +26 69 £413 -2.94% 49
Midlands +9 64 £350 -6.04% 44
North West +52 58 £375 -2.60% 44
Yorkshire +35 44 £388 +6.16% 21
West Midlands +24 42 £400 -3.03% 27
South West -2 41 £419 +2.13% 12
East of England -25 24 £448 +11.88% 21
East Midlands +14 22 £228 -33.58% 17
Scotland +8 12 £400 +9.59% 6
North East +23 10 £300 -14.29% 4
Wales +10 9 £375 +9.09% 2
Northern Ireland +16 8 £325 -

For the 6 months to 17 July 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 551 (75.58%) Business Intelligence
2 549 (75.31%) SQL Server Integration Services
3 540 (74.07%) SQL
4 536 (73.53%) SQL Server
5 524 (71.88%) SQL Server Reporting Services
6 403 (55.28%) Power Platform
7 401 (55.01%) Power BI
8 350 (48.01%) Data Warehouse
9 300 (41.15%) Microsoft
10 244 (33.47%) ETL
11 241 (33.06%) Microsoft Azure
12 224 (30.73%) T-SQL
13 171 (23.46%) Finance
14 141 (19.34%) Microsoft Analysis Services
15 140 (19.20%) Agile Software Development
16 129 (17.70%) Data Analysis Expressions (DAX)
17 107 (14.68%) Data Modelling
18 106 (14.54%) C#
19 103 (14.13%) Tableau
20 102 (13.99%) SQL Server 2012
21 96 (13.17%) MDX
22 87 (11.93%) .NET
23 86 (11.80%) Analytics
24 83 (11.39%) Migration
25 77 (10.56%) Azure Data Factory
26 74 (10.15%) SQL Server 2014
26 74 (10.15%) Visualisation
27 72 (9.88%) Kimball Methodology
27 72 (9.88%) Analytical Skills
28 70 (9.60%) OLAP

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 54 (7.41%) SharePoint
2 18 (2.47%) SharePoint 2010
3 17 (2.33%) IIS
4 10 (1.37%) SharePoint 2013
5 8 (1.10%) BizTalk Server
5 8 (1.10%) Oracle SOA Suite
6 6 (0.82%) Tomcat
7 5 (0.69%) Apache Spark
8 4 (0.55%) Apache
8 4 (0.55%) CMS
8 4 (0.55%) Confluence
8 4 (0.55%) SAS
8 4 (0.55%) WebLogic
9 3 (0.41%) WebLogic Integration
10 1 (0.14%) Apache Airflow
10 1 (0.14%) FormScape
10 1 (0.14%) Oracle Workflow
Applications
1 67 (9.19%) Microsoft Excel
2 19 (2.61%) Microsoft Office
3 10 (1.37%) MS Visio
4 5 (0.69%) Spreadsheet
5 4 (0.55%) InfoPath
5 4 (0.55%) Microsoft PowerPoint
6 2 (0.27%) SPSS
Business Applications
1 20 (2.74%) Dynamics CRM
2 7 (0.96%) Dynamics AX
3 5 (0.69%) NetSuite
4 4 (0.55%) Dynamics NAV
5 3 (0.41%) Oracle Financials
5 3 (0.41%) Unit4 Business World
6 1 (0.14%) CA PPM
6 1 (0.14%) Cerner Millennium
6 1 (0.14%) Cognos Business Intelligence
6 1 (0.14%) SAP S/4HANA
Cloud Services
1 403 (55.28%) Power Platform
2 241 (33.06%) Microsoft Azure
3 77 (10.56%) Azure Data Factory
4 50 (6.86%) Amazon AWS
5 14 (1.92%) Office 365
6 12 (1.65%) Dynamics 365
7 10 (1.37%) Google Cloud Platform
8 9 (1.23%) GitHub
9 7 (0.96%) Azure Functions
9 7 (0.96%) SaaS
9 7 (0.96%) Serverless
10 5 (0.69%) PaaS
11 4 (0.55%) PowerApps
12 3 (0.41%) Azure Machine Learning
12 3 (0.41%) Cloud Computing
12 3 (0.41%) Data Lake Analytics
12 3 (0.41%) OpenShift
13 1 (0.14%) Azure Stack
13 1 (0.14%) IaaS
13 1 (0.14%) WhatsApp
Communications & Networking
1 7 (0.96%) Firewall
1 7 (0.96%) Internet
1 7 (0.96%) Network Security
2 6 (0.82%) SAN
3 1 (0.14%) FTP
Database & Business Intelligence
1 549 (75.31%) SQL Server Integration Services
2 536 (73.53%) SQL Server
3 524 (71.88%) SQL Server Reporting Services
4 401 (55.01%) Power BI
5 350 (48.01%) Data Warehouse
6 141 (19.34%) Microsoft Analysis Services
7 102 (13.99%) SQL Server 2012
8 74 (10.15%) SQL Server 2014
9 70 (9.60%) OLAP
10 62 (8.50%) SQL Server 2016
11 55 (7.54%) Data Lake
12 53 (7.27%) Azure SQL Database
13 51 (7.00%) QlikView
14 50 (6.86%) SQL Server 2017
15 45 (6.17%) SQL Server 2008
16 43 (5.90%) Azure SQL Data Warehouse
17 42 (5.76%) Relational Database
18 34 (4.66%) Big Data
19 29 (3.98%) Star Schema
20 26 (3.57%) OLAP Cube
Development Applications
1 41 (5.62%) Visual Studio
2 27 (3.70%) Team Foundation Server
2 27 (3.70%) Visual Studio Team System
3 16 (2.19%) JIRA
3 16 (2.19%) SQL Server Management Studio (SSMS)
4 11 (1.51%) Git (software)
5 10 (1.37%) TeamCity
6 7 (0.96%) ERwin
7 6 (0.82%) Jenkins
8 5 (0.69%) Cucumber
8 5 (0.69%) Octopus Deploy
8 5 (0.69%) Selenium
9 4 (0.55%) Eclipse
9 4 (0.55%) SpecFlow
10 3 (0.41%) Bitbucket
10 3 (0.41%) git-flow
10 3 (0.41%) Subversion
11 2 (0.27%) Gradle
11 2 (0.27%) webpack
11 2 (0.27%) Zephyr
General
1 171 (23.46%) Finance
2 46 (6.31%) Retail
3 45 (6.17%) Banking
4 25 (3.43%) Front Office
5 22 (3.02%) Legal
6 18 (2.47%) Investment Banking
7 10 (1.37%) Telecoms
8 9 (1.23%) Back Office
9 7 (0.96%) Financial Institution
10 6 (0.82%) Marketing
11 3 (0.41%) Billing
11 3 (0.41%) Law
12 2 (0.27%) Advertising
12 2 (0.27%) French Language
12 2 (0.27%) Games
12 2 (0.27%) German Language
12 2 (0.27%) Local Government
12 2 (0.27%) Publishing
12 2 (0.27%) Retail Banking
13 1 (0.14%) Corporate Banking
Job Titles
1 418 (57.34%) Developer
2 253 (34.71%) Business Intelligence Developer
3 135 (18.52%) SQL Developer
4 71 (9.74%) Analyst
5 70 (9.60%) Power BI Developer
6 65 (8.92%) Architect
7 62 (8.50%) DBA
8 61 (8.37%) SQL BI Developer
9 54 (7.41%) SQL DBA
10 47 (6.45%) SSIS Developer
11 45 (6.17%) Data Warehouse Developer
12 42 (5.76%) SSAS Developer
12 42 (5.76%) SSRS Developer
13 41 (5.62%) Business Intelligence Analyst
14 40 (5.49%) Consultant
15 28 (3.84%) SQL Server DBA
16 27 (3.70%) Azure Engineer
16 27 (3.70%) Business Intelligence Architect
17 25 (3.43%) Business Intelligence Consultant
17 25 (3.43%) Data Architect
Libraries, Frameworks & Software Standards
1 96 (13.17%) MDX
2 87 (11.93%) .NET
3 31 (4.25%) XML
4 22 (3.02%) ASP.NET
5 17 (2.33%) .NET Framework
6 16 (2.19%) JSON
6 16 (2.19%) Web Services
7 14 (1.92%) HTML
8 10 (1.37%) WCF
9 7 (0.96%) AngularJS
9 7 (0.96%) REST
9 7 (0.96%) WPF
10 6 (0.82%) OAuth
10 6 (0.82%) OAuth2
10 6 (0.82%) SAML
11 5 (0.69%) CSS
11 5 (0.69%) HTML5
11 5 (0.69%) Middleware
12 4 (0.55%) Kafka
12 4 (0.55%) React
Miscellaneous
1 72 (9.88%) Analytical Skills
2 30 (4.12%) Greenfield Project
3 24 (3.29%) Self-Motivation
4 19 (2.61%) NHS
5 16 (2.19%) Replication
6 15 (2.06%) Hedge funds
6 15 (2.06%) Reinsurance
7 14 (1.92%) Management Information System
8 12 (1.65%) Enterprise Software
9 11 (1.51%) Clustering
10 10 (1.37%) Data Structures
11 8 (1.10%) Credit Risk
11 8 (1.10%) Data Centre
12 7 (0.96%) Hybrid Cloud
13 6 (0.82%) User Experience
14 5 (0.69%) Derivative
14 5 (0.69%) Market Risk
15 4 (0.55%) Fixed Income
16 3 (0.41%) Credit Derivative
16 3 (0.41%) Grid Computing
Operating Systems
1 32 (4.39%) Windows
2 14 (1.92%) Windows Server
3 9 (1.23%) Windows Server 2008
4 6 (0.82%) Windows Server 2012
5 4 (0.55%) Linux
6 3 (0.41%) Unix
7 2 (0.27%) Windows Server 2003
8 1 (0.14%) Solaris
Processes & Methodologies
1 551 (75.58%) Business Intelligence
2 244 (33.47%) ETL
3 140 (19.20%) Agile Software Development
4 107 (14.68%) Data Modelling
5 86 (11.80%) Analytics
6 83 (11.39%) Migration
7 74 (10.15%) Visualisation
8 72 (9.88%) Kimball Methodology
9 66 (9.05%) Performance Tuning
10 59 (8.09%) Data Analysis
11 56 (7.68%) Data Migration
11 56 (7.68%) Problem-Solving
12 55 (7.54%) Dimensional Modelling
13 49 (6.72%) DevOps
14 40 (5.49%) Data Visualisation
15 37 (5.08%) Dashboard Development
16 35 (4.80%) Business Analysis
17 33 (4.53%) Data Integration
18 32 (4.39%) Data Management
19 28 (3.84%) CRM
Programming Languages
1 540 (74.07%) SQL
2 224 (30.73%) T-SQL
3 129 (17.70%) Data Analysis Expressions (DAX)
4 106 (14.54%) C#
5 55 (7.54%) PowerShell
6 31 (4.25%) Python
6 31 (4.25%) VBA
7 19 (2.61%) PL/SQL
8 17 (2.33%) JavaScript
9 15 (2.06%) R
10 13 (1.78%) Java
11 12 (1.65%) Scala
12 10 (1.37%) Shell Script
12 10 (1.37%) VB
13 9 (1.23%) VB.NET
14 3 (0.41%) C
14 3 (0.41%) C++
14 3 (0.41%) PHP
14 3 (0.41%) TypeScript
14 3 (0.41%) X++
Qualifications
1 26 (3.57%) Security Cleared
2 23 (3.16%) Degree
3 22 (3.02%) SC Cleared
4 17 (2.33%) Microsoft Certification
5 11 (1.51%) Computer Science Degree
6 6 (0.82%) MCITP
7 5 (0.69%) CTC Cleared
8 4 (0.55%) MCPD
9 3 (0.41%) CFA
9 3 (0.41%) ITIL Certification
10 2 (0.27%) BPSS Clearance
10 2 (0.27%) Master's Degree
10 2 (0.27%) MCSE
11 1 (0.14%) ISEB
11 1 (0.14%) ISTQB
11 1 (0.14%) ITIL Foundation Certificate
11 1 (0.14%) MCDBA
11 1 (0.14%) MCP
11 1 (0.14%) PhD
11 1 (0.14%) TOGAF Certification
Quality Assurance & Compliance
1 26 (3.57%) Data Quality
2 18 (2.47%) QA
3 5 (0.69%) IFRS
3 5 (0.69%) SLA
4 4 (0.55%) GAAP
4 4 (0.55%) PMO
4 4 (0.55%) SEPA
5 3 (0.41%) GDPR
6 1 (0.14%) ISO/IEC 27001
6 1 (0.14%) Solvency II
System Software
1 7 (0.96%) VMware Infrastructure
2 5 (0.69%) Active Directory
2 5 (0.69%) Docker
3 1 (0.14%) HDFS
3 1 (0.14%) Hyper-V
Systems Management
1 6 (0.82%) Microsoft Clustering
1 6 (0.82%) Single Sign-On
2 3 (0.41%) Ansible
2 3 (0.41%) Control-M
2 3 (0.41%) Grafana
2 3 (0.41%) Kibana
2 3 (0.41%) Opscode Chef
2 3 (0.41%) Puppet
2 3 (0.41%) SCOM
3 2 (0.27%) Failover Clustering
3 2 (0.27%) HP ALM
3 2 (0.27%) Kubernetes
3 2 (0.27%) Terraform
4 1 (0.14%) SQL Sentry
4 1 (0.14%) Tivoli
4 1 (0.14%) Tivoli Storage Manager
4 1 (0.14%) WMI
Vendors
1 300 (41.15%) Microsoft
2 103 (14.13%) Tableau
3 46 (6.31%) Oracle
4 40 (5.49%) Databricks
5 17 (2.33%) Cognos
6 13 (1.78%) MicroStrategy
7 9 (1.23%) Greenplum
8 7 (0.96%) Google
8 7 (0.96%) SAP
8 7 (0.96%) VMware
9 6 (0.82%) Salesforce.com
9 6 (0.82%) Teradata
10 5 (0.69%) JD Edwards
10 5 (0.69%) Telerik
11 4 (0.55%) Alteryx
11 4 (0.55%) Cloudera
11 4 (0.55%) OutSystems
11 4 (0.55%) RedGate
12 3 (0.41%) Sparx
12 3 (0.41%) Talend