Period
to 20 January 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 20 January 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
20 Jan 2019
Same period 2018 Same period 2017
Rank 306 307 251
Rank change year-on-year +1 -56 -54
Contract jobs citing SQL Server Analysis Services 795 804 995
As % of all contract IT jobs advertised in the UK 0.81% 0.81% 1.03%
As % of the Database & Business Intelligence category 3.61% 3.68% 4.55%
Number of daily rates quoted 605 626 713
UK median daily rate £450 £425 £400
Median daily rate % change year-on-year +5.88% +6.25% -
10th Percentile £313 £300 £291
90th Percentile £588 £538 £538
UK excluding London median daily rate £413 £375 £375
% change year-on-year +10.00% - -
Number of hourly rates quoted 7 10 15
UK median hourly rate £42.00 £25.50 £41.50
Median hourly rate % change year-on-year +64.71% -38.55% -7.78%
10th Percentile £33.93 £20.31 £22.30
90th Percentile £60.50 £43.13 £48.00
UK excluding London median hourly rate £43.50 £27.00 £41.50
% change year-on-year +61.11% -34.94% -7.78%

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 22,024 21,859 21,848
As % of all contract IT jobs advertised in the UK 22.47% 21.98% 22.56%
Number of daily rates quoted 15,166 15,210 14,571
UK median daily rate £475 £450 £425
Median daily rate % change year-on-year +5.56% +5.88% +2.41%
10th Percentile £319 £310 £288
90th Percentile £644 £625 £600
UK excluding London median daily rate £425 £400 £388
% change year-on-year +6.25% +3.23% +3.33%
Number of hourly rates quoted 242 251 315
UK median hourly rate £32.50 £30.75 £28.18
Median hourly rate % change year-on-year +5.69% +9.12% -6.07%
10th Percentile £13.72 £14.54 £10.00
90th Percentile £57.19 £55.60 £48.60
UK excluding London median hourly rate £32.50 £35.00 £26.50
% change year-on-year -7.14% +32.08% -9.40%

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 20 January 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 20 January 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 20 January 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 +11 748 £450 +5.88% 321
London +9 429 £475 +5.56% 115
UK excluding London -25 358 £413 +10.00% 227
North of England -12 93 £400 +6.67% 83
Midlands -7 64 £425 +13.33% 39
South East +1 62 £413 +19.57% 46
South West -25 55 £425 +6.25% 14
Yorkshire -8 48 £400 +9.59% 41
East of England 0 46 £431 +28.73% 24
North West 0 41 £380 +1.33% 38
West Midlands -38 33 £400 - 23
East Midlands +21 32 £425 +21.43% 16
Scotland +1 30 £375 -1.64% 13
Wales -25 8 £425 +21.43% 5
North East -1 4 £436 +18.71% 4
Northern Ireland +21 2 - - 3

For the 6 months to 20 January 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 650 (81.76%) SQL Server Integration Services
2 616 (77.48%) SQL
3 600 (75.47%) SQL Server Reporting Services
4 575 (72.33%) Business Intelligence
5 557 (70.06%) SQL Server
6 385 (48.43%) Data Warehouse
7 352 (44.28%) Power BI
8 343 (43.14%) T-SQL
9 334 (42.01%) Microsoft
10 300 (37.74%) ETL
11 236 (29.69%) Microsoft Azure
12 194 (24.40%) Finance
13 171 (21.51%) Agile Software Development
14 169 (21.26%) Data Modelling
15 114 (14.34%) Analytics
16 107 (13.46%) Data Analysis Expressions (DAX)
17 105 (13.21%) Migration
18 102 (12.83%) Microsoft Analysis Services
19 99 (12.45%) C#
20 92 (11.57%) SQL Server 2016
21 91 (11.45%) Azure Data Factory
22 86 (10.82%) Visualisation
23 84 (10.57%) .NET
23 84 (10.57%) Analytical Skills
24 83 (10.44%) SQL Server 2012
24 83 (10.44%) MDX
25 82 (10.31%) Tableau
26 78 (9.81%) Data Lake
27 77 (9.69%) Kimball Methodology
27 77 (9.69%) PowerShell

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 (3.52%) SharePoint
2 10 (1.26%) Apache Spark
3 9 (1.13%) IIS
4 7 (0.88%) SharePoint 2013
5 5 (0.63%) SharePoint 2010
6 4 (0.50%) Confluence
7 3 (0.38%) Apache Pig
7 3 (0.38%) BizTalk Server
7 3 (0.38%) SAS
7 3 (0.38%) SharePoint Server
8 2 (0.25%) CMS
8 2 (0.25%) Skype for Business
9 1 (0.13%) Apache
9 1 (0.13%) WebSphere
Applications
1 77 (9.69%) Microsoft Excel
2 15 (1.89%) Microsoft Office
3 11 (1.38%) MS Visio
4 4 (0.50%) Spreadsheet
5 3 (0.38%) Microsoft PowerPoint
6 1 (0.13%) Microsoft Project
6 1 (0.13%) Photoshop
Business Applications
1 14 (1.76%) Dynamics AX
2 10 (1.26%) Dynamics CRM
3 8 (1.01%) NetSuite
4 6 (0.75%) Dynamics NAV
5 2 (0.25%) Markit EDM
5 2 (0.25%) thinkFolio
6 1 (0.13%) Actimize
6 1 (0.13%) Infor CRM
6 1 (0.13%) Infor M3
6 1 (0.13%) Oracle Procure-to-Pay
6 1 (0.13%) Unit4 Business World
Cloud Services
1 236 (29.69%) Microsoft Azure
2 91 (11.45%) Azure Data Factory
3 33 (4.15%) PaaS
4 24 (3.02%) IaaS
5 19 (2.39%) Dynamics 365
5 19 (2.39%) Office 365
6 14 (1.76%) Data Lake Analytics
6 14 (1.76%) GitHub
7 6 (0.75%) Amazon AWS
8 5 (0.63%) Google Cloud Platform
9 4 (0.50%) Azure Machine Learning
9 4 (0.50%) Cortana Intelligence Suite
10 3 (0.38%) Cloud Computing
11 2 (0.25%) SaaS
12 1 (0.13%) Azure Active Directory
12 1 (0.13%) Azure Functions
12 1 (0.13%) iPaaS
12 1 (0.13%) Serverless
12 1 (0.13%) Trello
Communications & Networking
1 6 (0.75%) SAN
2 5 (0.63%) DMZ
2 5 (0.63%) Fibre Channel
2 5 (0.63%) iSCSI
3 4 (0.50%) AMQP
4 3 (0.38%) HTTP
4 3 (0.38%) SMTP
5 2 (0.25%) DNS
5 2 (0.25%) Firewall
5 2 (0.25%) Intranet
6 1 (0.13%) BIG-IP
6 1 (0.13%) Cisco ASA
6 1 (0.13%) Cisco Firepower
6 1 (0.13%) Cisco Nexus
6 1 (0.13%) Internet
6 1 (0.13%) TCP/IP
Database & Business Intelligence
1 650 (81.76%) SQL Server Integration Services
2 600 (75.47%) SQL Server Reporting Services
3 557 (70.06%) SQL Server
4 385 (48.43%) Data Warehouse
5 352 (44.28%) Power BI
6 102 (12.83%) Microsoft Analysis Services
7 92 (11.57%) SQL Server 2016
8 83 (10.44%) SQL Server 2012
9 78 (9.81%) Data Lake
10 74 (9.31%) SQL Server 2014
11 69 (8.68%) Azure SQL Database
12 62 (7.80%) OLAP
12 62 (7.80%) SQL Server 2008
13 51 (6.42%) Big Data
13 51 (6.42%) Relational Database
14 44 (5.53%) Azure SQL Data Warehouse
15 31 (3.90%) QlikView
16 29 (3.65%) PowerPivot
17 21 (2.64%) RDBMS
18 20 (2.52%) OLAP Cube
Development Applications
1 55 (6.92%) Team Foundation Server
2 46 (5.79%) Visual Studio
3 22 (2.77%) SQL Server Management Studio (SSMS)
4 18 (2.26%) JIRA
5 16 (2.01%) Git (software)
6 13 (1.64%) Visual Studio Team System
7 9 (1.13%) ERwin
8 7 (0.88%) Bitbucket
8 7 (0.88%) Subversion
9 6 (0.75%) ER Studio
10 5 (0.63%) git-flow
11 3 (0.38%) MorphX
11 3 (0.38%) TeamCity
12 2 (0.25%) FitNesse
12 2 (0.25%) Octopus Deploy
12 2 (0.25%) Plastic SCM
13 1 (0.13%) gulp
13 1 (0.13%) Jenkins
13 1 (0.13%) Selenium
13 1 (0.13%) Visual Studio Coded UI
General
1 194 (24.40%) Finance
2 56 (7.04%) Retail
3 29 (3.65%) Banking
4 20 (2.52%) Front Office
5 15 (1.89%) Investment Banking
6 11 (1.38%) Manufacturing
7 10 (1.26%) Publishing
8 9 (1.13%) General Ledger
8 9 (1.13%) Marketing
8 9 (1.13%) Telecoms
9 8 (1.01%) Legal
10 6 (0.75%) Back Office
11 4 (0.50%) Electronics
12 3 (0.38%) Law
13 2 (0.25%) Advertising
13 2 (0.25%) Financial Institution
13 2 (0.25%) Pharmaceutical
14 1 (0.13%) Automotive
14 1 (0.13%) Billing
14 1 (0.13%) Games
Job Titles
1 519 (65.28%) Developer
2 283 (35.60%) Business Intelligence Developer
3 190 (23.90%) SQL Developer
4 79 (9.94%) SSIS Developer
5 72 (9.06%) SSAS Developer
6 66 (8.30%) SQL BI Developer
7 62 (7.80%) Analyst
8 59 (7.42%) SSRS Developer
9 55 (6.92%) Power BI Developer
10 54 (6.79%) DBA
11 50 (6.29%) SQL DBA
12 49 (6.16%) Architect
13 46 (5.79%) SQL Server Developer
14 38 (4.78%) Senior Developer
15 37 (4.65%) Azure Developer
16 36 (4.53%) Business Developer
17 35 (4.40%) Data Warehouse Developer
18 34 (4.28%) Data Engineer
19 33 (4.15%) T-SQL Developer
20 30 (3.77%) Data Architect
Libraries, Frameworks & Software Standards
1 84 (10.57%) .NET
2 83 (10.44%) MDX
3 16 (2.01%) ASP.NET
4 13 (1.64%) XML
5 11 (1.38%) HTML
6 10 (1.26%) JSON
7 9 (1.13%) .NET Framework
7 9 (1.13%) CSS
7 9 (1.13%) Web Services
8 8 (1.01%) ASP.NET Web API
9 6 (0.75%) Kafka
9 6 (0.75%) WCF
9 6 (0.75%) WPF
10 5 (0.63%) jQuery
10 5 (0.63%) OAuth
10 5 (0.63%) SAML
11 4 (0.50%) ASP.NET MVC
11 4 (0.50%) Entity Framework
11 4 (0.50%) Swagger
12 3 (0.38%) HTML5
Miscellaneous
1 84 (10.57%) Analytical Skills
2 22 (2.77%) Data Structures
2 22 (2.77%) Greenfield Project
3 21 (2.64%) Self-Motivation
4 15 (1.89%) Data Centre
5 14 (1.76%) Hedge funds
6 12 (1.51%) Clustering
7 9 (1.13%) Credit Risk
7 9 (1.13%) Management Information System
7 9 (1.13%) NHS
8 8 (1.01%) Enterprise Software
8 8 (1.01%) Fixed Income
8 8 (1.01%) Reinsurance
9 6 (0.75%) Fintech
9 6 (0.75%) Smart City
10 4 (0.50%) Credit Derivative
10 4 (0.50%) Derivative
10 4 (0.50%) Replication
10 4 (0.50%) User Experience
11 3 (0.38%) Market Risk
Operating Systems
1 31 (3.90%) Windows
2 19 (2.39%) Windows Server
3 7 (0.88%) Linux
4 5 (0.63%) Windows Server 2008
5 1 (0.13%) VMS
Processes & Methodologies
1 575 (72.33%) Business Intelligence
2 300 (37.74%) ETL
3 171 (21.51%) Agile Software Development
4 169 (21.26%) Data Modelling
5 114 (14.34%) Analytics
6 105 (13.21%) Migration
7 86 (10.82%) Visualisation
8 77 (9.69%) Kimball Methodology
9 73 (9.18%) Data Migration
10 69 (8.68%) Dimensional Modelling
11 55 (6.92%) Data Analysis
11 55 (6.92%) Problem-Solving
12 52 (6.54%) DevOps
13 51 (6.42%) Data Management
14 48 (6.04%) Performance Tuning
15 47 (5.91%) Data Analytics
16 45 (5.66%) Scrum
17 42 (5.28%) Data Visualisation
18 39 (4.91%) Logical Data Model
19 37 (4.65%) ETL Development
Programming Languages
1 616 (77.48%) SQL
2 343 (43.14%) T-SQL
3 107 (13.46%) Data Analysis Expressions (DAX)
4 99 (12.45%) C#
5 77 (9.69%) PowerShell
6 24 (3.02%) VB
7 16 (2.01%) Python
8 15 (1.89%) JavaScript
8 15 (1.89%) VBA
9 13 (1.64%) PL/SQL
10 12 (1.51%) R
11 10 (1.26%) U-SQL
12 7 (0.88%) Java
13 4 (0.50%) PHP
13 4 (0.50%) VB.NET
14 3 (0.38%) X++
15 2 (0.25%) Go
15 2 (0.25%) MUMPS
16 1 (0.13%) TypeScript
16 1 (0.13%) XMLA
Qualifications
1 23 (2.89%) Degree
2 20 (2.52%) Microsoft Certification
3 13 (1.64%) Security Cleared
4 8 (1.01%) MCSE
5 7 (0.88%) SC Cleared
6 5 (0.63%) ITIL Certification
6 5 (0.63%) MCTS
7 4 (0.50%) Computer Science Degree
8 3 (0.38%) CCNA
8 3 (0.38%) Cisco Certification
8 3 (0.38%) MCITP
8 3 (0.38%) MCSA
8 3 (0.38%) MCSD
8 3 (0.38%) PMI Certification
8 3 (0.38%) PMP
8 3 (0.38%) Postgraduate
8 3 (0.38%) TOGAF Certification
9 2 (0.25%) DV Cleared
9 2 (0.25%) MCDBA
9 2 (0.25%) Numerate Degree
Quality Assurance & Compliance
1 43 (5.41%) QA
2 24 (3.02%) Data Quality
3 8 (1.01%) GDPR
4 1 (0.13%) HL7
4 1 (0.13%) IFRS
4 1 (0.13%) ISO/IEC 27001
4 1 (0.13%) SLA
System Software
1 10 (1.26%) Active Directory
2 7 (0.88%) Virtual Machines
3 6 (0.75%) Hyper-V
3 6 (0.75%) XenApp
4 2 (0.25%) VMware Infrastructure
5 1 (0.13%) VMware Server
Systems Management
1 7 (0.88%) Microsoft Clustering
2 6 (0.75%) SCOM
2 6 (0.75%) SCOrch
2 6 (0.75%) Symantec Enterprise Vault
3 5 (0.63%) CA Single Sign-On
3 5 (0.63%) Single Sign-On
4 2 (0.25%) Failover Clustering
4 2 (0.25%) Microsoft Data Protection Manager
5 1 (0.13%) Ansible
5 1 (0.13%) Control-M
5 1 (0.13%) Foglight
5 1 (0.13%) Opscode Chef
5 1 (0.13%) Puppet
5 1 (0.13%) SQL Sentry
5 1 (0.13%) Terraform
Vendors
1 334 (42.01%) Microsoft
2 82 (10.31%) Tableau
3 32 (4.03%) Oracle
4 30 (3.77%) SAP
5 15 (1.89%) IBM
6 13 (1.64%) RedGate
7 11 (1.38%) Citrix
8 6 (0.75%) JD Edwards
8 6 (0.75%) Sybase
8 6 (0.75%) Symantec
9 5 (0.63%) CA
9 5 (0.63%) Cognos
9 5 (0.63%) Databricks
9 5 (0.63%) Google
10 3 (0.38%) Salesforce.com
10 3 (0.38%) Teradata
11 2 (0.25%) Bloomberg
11 2 (0.25%) Charles River
11 2 (0.25%) Informatica
11 2 (0.25%) VMware