Period
to 24 May 2018

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 24 May 2018 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
24 May 2018
Same period 2017 Same period 2016
Rank 327 278 253
Rank change year-on-year -49 -25 -59
Contract jobs citing SQL Server Analysis Services 746 828 1,101
As % of all contract IT jobs advertised in the UK 0.74% 0.92% 1.04%
As % of the Database & Business Intelligence category 3.30% 4.06% 4.73%
Number of daily rates quoted 598 572 819
UK median daily rate £435 £400 £400
Median daily rate % change year-on-year +8.75% - +6.67%
10th Percentile £313 £298 £281
90th Percentile £571 £550 £538
UK excluding London median daily rate £388 £365 £375
% change year-on-year +6.16% -2.67% +10.29%
Number of hourly rates quoted 5 10 3
UK median hourly rate £22.50 £40.00 £38.75
Median hourly rate % change year-on-year -43.75% +3.23% +63.16%
UK excluding London median hourly rate £31.25 £40.00 £38.75
% change year-on-year -21.88% +3.23% +55.00%

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,607 20,370 23,255
As % of all contract IT jobs advertised in the UK 22.43% 22.55% 22.02%
Number of daily rates quoted 15,754 13,609 15,715
UK median daily rate £473 £437 £425
Median daily rate % change year-on-year +8.12% +2.82% +6.25%
10th Percentile £313 £295 £276
90th Percentile £625 £613 £600
UK excluding London median daily rate £415 £390 £375
% change year-on-year +6.34% +4.00% +2.74%
Number of hourly rates quoted 230 251 378
UK median hourly rate £33.00 £30.00 £27.75
Median hourly rate % change year-on-year +10.00% +8.11% -3.28%
10th Percentile £13.98 £9.25 £12.14
90th Percentile £53.53 £50.00 £52.58
UK excluding London median hourly rate £33.50 £29.50 £27.00
% change year-on-year +13.56% +9.26% +1.89%

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 24 May 2018.

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 24 May 2018.

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 24 May 2018. 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 -50 703 £438 +9.38% 255
London -19 430 £468 +3.89% 111
UK excluding London -68 316 £388 +6.16% 163
Midlands -7 91 £360 +6.67% 34
South East -23 68 £434 +11.15% 28
North of England -95 55 £375 +7.14% 53
West Midlands -21 51 £388 +10.71% 13
East Midlands +9 39 £343 +7.03% 18
East of England -5 36 £425 +6.25% 14
Scotland -24 29 £375 -11.76% 15
North West -69 25 £400 +11.11% 26
Yorkshire -47 24 £375 +7.14% 21
South West -17 23 £400 +8.11% 15
Isle of Man - 8 £400 -
North East +10 6 £359 -10.31% 6
Wales -6 6 £325 -7.14% 3

For the 6 months to 24 May 2018, 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 653 (87.53%) SQL Server Integration Services
2 601 (80.56%) SQL Server Reporting Services
3 577 (77.35%) SQL
4 557 (74.66%) Business Intelligence
5 556 (74.53%) SQL Server
6 371 (49.73%) Microsoft
7 353 (47.32%) Data Warehouse
8 283 (37.94%) Power BI
9 252 (33.78%) T-SQL
10 239 (32.04%) ETL
11 178 (23.86%) Agile Software Development
12 162 (21.72%) Finance
13 149 (19.97%) C#
14 148 (19.84%) Data Modelling
15 136 (18.23%) Microsoft Azure
16 132 (17.69%) Analytics
17 125 (16.76%) .NET
18 117 (15.68%) MDX
19 105 (14.08%) Microsoft Analysis Services
20 100 (13.40%) SQL Server 2016
21 95 (12.73%) Data Analysis Expressions (DAX)
22 90 (12.06%) SQL Server 2012
23 88 (11.80%) SQL Server 2008
24 82 (10.99%) Analytical Skills
25 80 (10.72%) Visualisation
26 78 (10.46%) Data Analysis
27 77 (10.32%) Kimball Methodology
28 71 (9.52%) SQL Server 2014
29 70 (9.38%) Microsoft Excel
30 68 (9.12%) Migration

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 53 (7.10%) SharePoint
2 16 (2.14%) SAS
3 11 (1.47%) IIS
4 9 (1.21%) SharePoint Server
5 7 (0.94%) Apache Spark
6 6 (0.80%) BizTalk Server
7 4 (0.54%) Confluence
7 4 (0.54%) SharePoint 2013
8 3 (0.40%) Apache
8 3 (0.40%) Apache Pig
8 3 (0.40%) SharePoint 2010
8 3 (0.40%) WordPress
9 2 (0.27%) Oracle SOA Suite
10 1 (0.13%) CMS
10 1 (0.13%) Exchange Server 2013
10 1 (0.13%) JBoss
10 1 (0.13%) Mongoose
10 1 (0.13%) MS Exchange
10 1 (0.13%) Tomcat
10 1 (0.13%) WebLogic
Applications
1 70 (9.38%) Microsoft Excel
2 32 (4.29%) MS Visio
3 12 (1.61%) Microsoft Office
4 10 (1.34%) Microsoft Project
5 6 (0.80%) SPSS
6 5 (0.67%) Spreadsheet
7 1 (0.13%) InfoPath
7 1 (0.13%) Microsoft PowerPoint
Business Applications
1 15 (2.01%) Dynamics AX
2 14 (1.88%) Dynamics CRM
3 9 (1.21%) NetSuite
4 3 (0.40%) Oracle ERP
5 2 (0.27%) Demantra
5 2 (0.27%) Dynamics NAV
5 2 (0.27%) Infor M3
5 2 (0.27%) Markit EDM
5 2 (0.27%) Oracle Financials
5 2 (0.27%) Oracle Retail
5 2 (0.27%) Retail-J
6 1 (0.13%) Cognos Business Intelligence
6 1 (0.13%) Elite 3E
6 1 (0.13%) Endur
6 1 (0.13%) MetaTrader
6 1 (0.13%) Summit
6 1 (0.13%) SystmOne
6 1 (0.13%) Unit4 Business World
Cloud Services
1 136 (18.23%) Microsoft Azure
2 40 (5.36%) Azure Data Factory
3 15 (2.01%) Amazon AWS
3 15 (2.01%) PaaS
4 14 (1.88%) Dynamics 365
5 10 (1.34%) Cortana Intelligence Suite
6 8 (1.07%) Data Lake Analytics
7 6 (0.80%) Office 365
8 5 (0.67%) Cloud Computing
9 3 (0.40%) IaaS
9 3 (0.40%) SaaS
10 2 (0.27%) GitHub
10 2 (0.27%) Google Cloud Platform
10 2 (0.27%) iPaaS
10 2 (0.27%) Salesforce Sales Cloud
11 1 (0.13%) Adobe Analytics
11 1 (0.13%) Azure Machine Learning
11 1 (0.13%) Google Analytics
Communications & Networking
1 7 (0.94%) SAN
2 5 (0.67%) WinSCP
3 2 (0.27%) Intranet
3 2 (0.27%) Kerberos
4 1 (0.13%) FTP
4 1 (0.13%) SMS
Database & Business Intelligence
1 653 (87.53%) SQL Server Integration Services
2 601 (80.56%) SQL Server Reporting Services
3 556 (74.53%) SQL Server
4 353 (47.32%) Data Warehouse
5 283 (37.94%) Power BI
6 105 (14.08%) Microsoft Analysis Services
7 100 (13.40%) SQL Server 2016
8 90 (12.06%) SQL Server 2012
9 88 (11.80%) SQL Server 2008
10 71 (9.52%) SQL Server 2014
11 60 (8.04%) OLAP
12 51 (6.84%) Data Lake
13 45 (6.03%) Azure SQL Database
14 35 (4.69%) QlikView
15 33 (4.42%) PowerPivot
16 32 (4.29%) Star Schema
17 30 (4.02%) BusinessObjects
18 29 (3.89%) Big Data
19 28 (3.75%) SQL Server 2005
20 26 (3.49%) Enterprise Data Warehouse
Development Applications
1 59 (7.91%) Visual Studio
2 56 (7.51%) Team Foundation Server
3 23 (3.08%) Git (software)
3 23 (3.08%) SQL Server Management Studio (SSMS)
4 13 (1.74%) Jenkins
5 8 (1.07%) Octopus Deploy
5 8 (1.07%) Visual Studio Team System
6 6 (0.80%) JIRA
7 5 (0.67%) SpecFlow
8 4 (0.54%) MorphX
8 4 (0.54%) StarTeam
8 4 (0.54%) Subversion
8 4 (0.54%) TeamCity
8 4 (0.54%) Toad
9 3 (0.40%) tSQLt
10 2 (0.27%) Ant
10 2 (0.27%) ClearCase
10 2 (0.27%) Maven
10 2 (0.27%) MSBuild
10 2 (0.27%) NUnit
General
1 162 (21.72%) Finance
2 40 (5.36%) Retail
3 38 (5.09%) Banking
4 20 (2.68%) Legal
5 19 (2.55%) Marketing
6 16 (2.14%) Law
7 14 (1.88%) Investment Banking
8 12 (1.61%) Front Office
9 5 (0.67%) Financial Institution
9 5 (0.67%) Manufacturing
10 4 (0.54%) Publishing
11 3 (0.40%) Advertising
11 3 (0.40%) Automotive
11 3 (0.40%) Back Office
11 3 (0.40%) General Ledger
12 2 (0.27%) Billing
12 2 (0.27%) Telecoms
13 1 (0.13%) Electronics
13 1 (0.13%) Games
13 1 (0.13%) Retail Banking
Job Titles
1 479 (64.21%) Developer
2 262 (35.12%) Business Intelligence Developer
3 151 (20.24%) SQL Developer
4 99 (13.27%) SSAS Developer
5 90 (12.06%) SSIS Developer
6 85 (11.39%) SSRS Developer
7 76 (10.19%) Analyst
8 61 (8.18%) SQL BI Developer
9 56 (7.51%) Consultant
10 55 (7.37%) Power BI Developer
11 52 (6.97%) DBA
12 47 (6.30%) Architect
13 43 (5.76%) SQL DBA
14 38 (5.09%) C# Developer
15 37 (4.96%) Business Intelligence Analyst
16 36 (4.83%) Business Developer
17 34 (4.56%) ETL Developer
18 33 (4.42%) Business Intelligence Consultant
19 32 (4.29%) Senior Developer
20 31 (4.16%) .NET Developer
Libraries, Frameworks & Software Standards
1 125 (16.76%) .NET
2 117 (15.68%) MDX
3 33 (4.42%) CSS
4 32 (4.29%) XML
5 29 (3.89%) ASP.NET
5 29 (3.89%) HTML
6 21 (2.82%) Node.js
6 21 (2.82%) Web Services
7 20 (2.68%) .NET Framework
8 19 (2.55%) jQuery
9 17 (2.28%) ASP.NET Web API
10 13 (1.74%) Entity Framework
10 13 (1.74%) JSON
11 10 (1.34%) SOAP
11 10 (1.34%) WCF
12 9 (1.21%) Ajax
12 9 (1.21%) REST
13 8 (1.07%) Classic ASP
14 5 (0.67%) AngularJS
15 4 (0.54%) ASP.NET MVC
Miscellaneous
1 82 (10.99%) Analytical Skills
2 36 (4.83%) Self-Motivation
3 26 (3.49%) Greenfield Project
4 22 (2.95%) Reinsurance
5 16 (2.14%) Data Structures
6 15 (2.01%) Private Cloud
7 14 (1.88%) NHS
8 13 (1.74%) Computer Science
9 12 (1.61%) Clustering
9 12 (1.61%) Market Risk
10 10 (1.34%) Fintech
10 10 (1.34%) User Experience
11 9 (1.21%) Replication
12 8 (1.07%) Fixed Income
12 8 (1.07%) Management Information System
13 7 (0.94%) Hedge funds
14 6 (0.80%) Grid Computing
14 6 (0.80%) Hybrid Cloud
15 5 (0.67%) FMCG
16 4 (0.54%) Credit Risk
Operating Systems
1 50 (6.70%) Windows
2 18 (2.41%) Windows Server 2012
3 14 (1.88%) Windows Server
4 9 (1.21%) Windows Server 2008
5 8 (1.07%) Unix
6 5 (0.67%) Linux
7 3 (0.40%) Windows Server 2003
8 2 (0.27%) HPUX
8 2 (0.27%) VMS
8 2 (0.27%) Windows 10
8 2 (0.27%) Windows 7
9 1 (0.13%) Solaris
Processes & Methodologies
1 557 (74.66%) Business Intelligence
2 239 (32.04%) ETL
3 178 (23.86%) Agile Software Development
4 148 (19.84%) Data Modelling
5 132 (17.69%) Analytics
6 80 (10.72%) Visualisation
7 78 (10.46%) Data Analysis
8 77 (10.32%) Kimball Methodology
9 68 (9.12%) Migration
10 57 (7.64%) Performance Tuning
11 56 (7.51%) Scrum
12 55 (7.37%) Dimensional Modelling
13 50 (6.70%) ETL Development
14 47 (6.30%) Data Visualisation
15 46 (6.17%) Problem-Solving
16 37 (4.96%) Business Analysis
17 33 (4.42%) Data Migration
18 32 (4.29%) Data Analytics
19 31 (4.16%) Continuous Integration
19 31 (4.16%) High Availability
Programming Languages
1 577 (77.35%) SQL
2 252 (33.78%) T-SQL
3 149 (19.97%) C#
4 95 (12.73%) Data Analysis Expressions (DAX)
5 43 (5.76%) PowerShell
6 32 (4.29%) JavaScript
7 28 (3.75%) Java
8 25 (3.35%) VBA
9 24 (3.22%) Python
9 24 (3.22%) VB.NET
10 21 (2.82%) VB
11 20 (2.68%) PL/SQL
12 15 (2.01%) R
13 11 (1.47%) VBScript
14 10 (1.34%) XMLA
15 9 (1.21%) MUMPS
16 7 (0.94%) X++
17 5 (0.67%) C++
18 4 (0.54%) Shell Script
18 4 (0.54%) U-SQL
Qualifications
1 31 (4.16%) Degree
2 29 (3.89%) Security Cleared
3 25 (3.35%) SC Cleared
4 13 (1.74%) Microsoft Certification
5 7 (0.94%) Computer Science Degree
6 6 (0.80%) Numerate Degree
7 5 (0.67%) MCSA
7 5 (0.67%) MCSE
7 5 (0.67%) MCTS
8 4 (0.54%) MCAD
8 4 (0.54%) MCSD
9 2 (0.27%) BPSS Clearance
9 2 (0.27%) MCITP
9 2 (0.27%) MCPD
10 1 (0.13%) DV Cleared
10 1 (0.13%) ISEB
Quality Assurance & Compliance
1 34 (4.56%) QA
2 23 (3.08%) Data Quality
3 16 (2.14%) GDPR
4 8 (1.07%) ISO/IEC 27001
5 2 (0.27%) PMO
5 2 (0.27%) WCAG
6 1 (0.13%) IFRS
6 1 (0.13%) IFRS 9
6 1 (0.13%) ISO 9001
6 1 (0.13%) SLA
System Software
1 9 (1.21%) Active Directory
2 7 (0.94%) Hyper-V
3 5 (0.67%) Virtual Machines
4 3 (0.40%) Apache Flume
5 2 (0.27%) VMware Infrastructure
6 1 (0.13%) XenApp
Systems Management
1 10 (1.34%) Failover Clustering
2 7 (0.94%) Microsoft Clustering
2 7 (0.94%) Opscode Chef
3 6 (0.80%) SCVMM
4 3 (0.40%) NetBackup
4 3 (0.40%) Puppet
4 3 (0.40%) SCCM
4 3 (0.40%) SCOM
4 3 (0.40%) SCOrch
4 3 (0.40%) WMI
5 2 (0.27%) Systems Management Server (SMS)
5 2 (0.27%) Terraform
5 2 (0.27%) WhatsUp Gold
6 1 (0.13%) Control-M
6 1 (0.13%) Foglight
6 1 (0.13%) Oracle RMAN
6 1 (0.13%) SQL Sentry
Vendors
1 371 (49.73%) Microsoft
2 56 (7.51%) Oracle
3 55 (7.37%) Tableau
4 23 (3.08%) SAP
5 20 (2.68%) Cognos
6 19 (2.55%) RedGate
7 11 (1.47%) IBM
7 11 (1.47%) Informatica
8 10 (1.34%) JD Edwards
9 6 (0.80%) Cloudera
10 5 (0.67%) Adobe
10 5 (0.67%) Capita
10 5 (0.67%) Salesforce.com
10 5 (0.67%) Vertica
11 4 (0.54%) Micro Focus
11 4 (0.54%) Netezza
11 4 (0.54%) VMware
12 3 (0.40%) Bloomberg
12 3 (0.40%) MicroStrategy
12 3 (0.40%) Teradata