Period
to 25 September 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 25 September 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
25 Sep 2018
Same period 2017 Same period 2016
Rank 344 312 276
Rank change year-on-year -32 -36 -105
Contract jobs citing SQL Server Analysis Services 773 804 982
As % of all contract IT jobs advertised in the UK 0.75% 0.82% 0.93%
As % of the Database & Business Intelligence category 3.30% 3.65% 4.16%
Number of daily rates quoted 595 575 720
UK median daily rate £450 £425 £400
Median daily rate % change year-on-year +5.88% +6.25% -
10th Percentile £319 £313 £275
90th Percentile £617 £575 £538
UK excluding London median daily rate £400 £375 £375
% change year-on-year +6.67% - +7.91%
Number of hourly rates quoted 5 11 11
UK median hourly rate £24.08 £24.00 £44.00
Median hourly rate % change year-on-year +0.33% -45.45% +33.33%
10th Percentile £21.00 £20.75 £16.25
90th Percentile £42.50 £48.75 £51.00
UK excluding London median hourly rate £45.00 £27.00 £44.00
% change year-on-year +66.67% -38.64% +33.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 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 23,390 22,001 23,608
As % of all contract IT jobs advertised in the UK 22.75% 22.39% 22.28%
Number of daily rates quoted 16,400 14,681 15,801
UK median daily rate £475 £450 £425
Median daily rate % change year-on-year +5.56% +5.88% +6.25%
10th Percentile £313 £305 £281
90th Percentile £638 £625 £599
UK excluding London median daily rate £425 £400 £375
% change year-on-year +6.25% +6.67% -
Number of hourly rates quoted 235 276 384
UK median hourly rate £27.73 £29.56 £30.10
Median hourly rate % change year-on-year -6.19% -1.80% +2.04%
10th Percentile £13.35 £12.50 £11.25
90th Percentile £56.00 £53.75 £48.64
UK excluding London median hourly rate £26.90 £31.00 £29.76
% change year-on-year -13.23% +4.16% -0.79%

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 25 September 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 25 September 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 25 September 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 -24 748 £450 +5.88% 318
London +19 446 £480 +4.63% 124
UK excluding London -74 324 £400 +6.67% 204
North of England -49 83 £386 +6.55% 62
South East -42 71 £413 +3.13% 53
East of England +21 67 £400 -11.11% 15
Midlands -33 47 £410 +17.14% 51
Yorkshire -30 42 £413 +17.86% 22
South West -22 34 £400 +6.67% 13
North West -58 33 £385 +6.21% 31
West Midlands -34 28 £406 +16.07% 26
Scotland -38 19 £350 -17.65% 9
East Midlands -1 18 £418 +11.33% 25
North East - 8 £313 - 9
Wales -21 2 £388 +10.71%
Northern Ireland +30 1 - - 1

For the 6 months to 25 September 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 659 (85.25%) SQL Server Integration Services
2 597 (77.23%) SQL Server Reporting Services
3 593 (76.71%) Business Intelligence
4 587 (75.94%) SQL Server
5 570 (73.74%) SQL
6 405 (52.39%) Microsoft
7 388 (50.19%) Data Warehouse
8 308 (39.84%) T-SQL
9 301 (38.94%) Power BI
10 253 (32.73%) ETL
11 207 (26.78%) Finance
12 189 (24.45%) Agile Software Development
13 180 (23.29%) Microsoft Azure
14 157 (20.31%) Data Modelling
15 149 (19.28%) C#
16 145 (18.76%) Analytics
17 135 (17.46%) .NET
18 108 (13.97%) Microsoft Analysis Services
19 102 (13.20%) Visualisation
20 98 (12.68%) SQL Server 2012
21 96 (12.42%) SQL Server 2014
21 96 (12.42%) SQL Server 2016
22 91 (11.77%) Data Analysis Expressions (DAX)
23 90 (11.64%) SQL Server 2008
24 89 (11.51%) Analytical Skills
25 84 (10.87%) Kimball Methodology
26 82 (10.61%) MDX
27 79 (10.22%) Microsoft Excel
28 78 (10.09%) Data Lake
29 76 (9.83%) 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 38 (4.92%) SharePoint
2 11 (1.42%) Apache Spark
3 9 (1.16%) SAS
4 8 (1.03%) BizTalk Server
5 7 (0.91%) SharePoint 2013
6 6 (0.78%) SharePoint 2010
7 5 (0.65%) Confluence
7 5 (0.65%) IIS
8 2 (0.26%) CMS
9 1 (0.13%) Apache
9 1 (0.13%) Apache Airflow
9 1 (0.13%) Apache Pig
9 1 (0.13%) SharePoint Server
9 1 (0.13%) Skype for Business
Applications
1 79 (10.22%) Microsoft Excel
2 13 (1.68%) Microsoft Office
3 4 (0.52%) Spreadsheet
4 2 (0.26%) Microsoft PowerPoint
4 2 (0.26%) Microsoft Project
5 1 (0.13%) MS Visio
5 1 (0.13%) SPSS
Business Applications
1 19 (2.46%) Dynamics AX
2 12 (1.55%) NetSuite
3 6 (0.78%) Dynamics CRM
4 3 (0.39%) Oracle ERP
5 2 (0.26%) Markit EDM
5 2 (0.26%) ReMetrica
5 2 (0.26%) thinkFolio
5 2 (0.26%) Towers Watson Igloo
6 1 (0.13%) Cognos Business Intelligence
6 1 (0.13%) Dynamics NAV
6 1 (0.13%) Elite 3E
6 1 (0.13%) Endur
6 1 (0.13%) Infor CRM
6 1 (0.13%) Infor M3
6 1 (0.13%) Unit4 Business World
Cloud Services
1 180 (23.29%) Microsoft Azure
2 52 (6.73%) Azure Data Factory
3 35 (4.53%) PaaS
4 31 (4.01%) Dynamics 365
5 25 (3.23%) Amazon AWS
6 18 (2.33%) Office 365
7 17 (2.20%) IaaS
8 11 (1.42%) Data Lake Analytics
9 8 (1.03%) Cloud Computing
10 7 (0.91%) Cortana Intelligence Suite
11 4 (0.52%) Azure Machine Learning
11 4 (0.52%) Google Cloud Platform
12 3 (0.39%) SaaS
13 2 (0.26%) Google Analytics
14 1 (0.13%) Amazon S3
14 1 (0.13%) Trello
Communications & Networking
1 4 (0.52%) DMZ
1 4 (0.52%) SAN
2 2 (0.26%) Fibre Channel
2 2 (0.26%) HTTP
2 2 (0.26%) Intranet
2 2 (0.26%) iSCSI
2 2 (0.26%) Kerberos
2 2 (0.26%) SMS
2 2 (0.26%) SMTP
3 1 (0.13%) BIG-IP
3 1 (0.13%) Firewall
3 1 (0.13%) Internet
Database & Business Intelligence
1 659 (85.25%) SQL Server Integration Services
2 597 (77.23%) SQL Server Reporting Services
3 587 (75.94%) SQL Server
4 388 (50.19%) Data Warehouse
5 301 (38.94%) Power BI
6 108 (13.97%) Microsoft Analysis Services
7 98 (12.68%) SQL Server 2012
8 96 (12.42%) SQL Server 2014
8 96 (12.42%) SQL Server 2016
9 90 (11.64%) SQL Server 2008
10 78 (10.09%) Data Lake
11 66 (8.54%) OLAP
12 50 (6.47%) Azure SQL Database
13 45 (5.82%) Big Data
14 41 (5.30%) Relational Database
15 39 (5.05%) HDInsight
16 36 (4.66%) PowerPivot
17 27 (3.49%) Hadoop
17 27 (3.49%) SQL Server 2005
18 25 (3.23%) Azure SQL Data Warehouse
Development Applications
1 52 (6.73%) Team Foundation Server
2 48 (6.21%) Visual Studio
3 26 (3.36%) Git (software)
4 25 (3.23%) SQL Server Management Studio (SSMS)
5 12 (1.55%) Visual Studio Team System
6 8 (1.03%) JIRA
7 7 (0.91%) Subversion
8 5 (0.65%) Jenkins
8 5 (0.65%) MorphX
9 4 (0.52%) Selenium
10 3 (0.39%) MSBuild
10 3 (0.39%) NUnit
10 3 (0.39%) SpecFlow
10 3 (0.39%) TeamCity
11 2 (0.26%) FitNesse
12 1 (0.13%) Eclipse
12 1 (0.13%) Mercurial
12 1 (0.13%) MSTest
12 1 (0.13%) Rhino Mocks
12 1 (0.13%) VSS/SourceSafe
General
1 207 (26.78%) Finance
2 57 (7.37%) Banking
3 55 (7.12%) Retail
4 27 (3.49%) Front Office
5 25 (3.23%) Investment Banking
6 11 (1.42%) General Ledger
6 11 (1.42%) Marketing
7 10 (1.29%) Telecoms
8 9 (1.16%) Publishing
9 8 (1.03%) Manufacturing
10 7 (0.91%) Law
10 7 (0.91%) Legal
11 6 (0.78%) Back Office
11 6 (0.78%) Electronics
12 3 (0.39%) Automotive
12 3 (0.39%) Local Government
13 2 (0.26%) Games
13 2 (0.26%) Pharmaceutical
14 1 (0.13%) Advertising
14 1 (0.13%) Financial Institution
Job Titles
1 504 (65.20%) Developer
2 270 (34.93%) Business Intelligence Developer
3 186 (24.06%) SQL Developer
4 87 (11.25%) SSAS Developer
5 86 (11.13%) SSIS Developer
6 65 (8.41%) Power BI Developer
6 65 (8.41%) SSRS Developer
7 64 (8.28%) Analyst
8 61 (7.89%) SQL BI Developer
9 53 (6.86%) DBA
10 48 (6.21%) SQL DBA
11 46 (5.95%) C# Developer
12 44 (5.69%) Business Intelligence Analyst
13 42 (5.43%) Architect
14 41 (5.30%) Business Intelligence Lead
15 40 (5.17%) ETL Developer
15 40 (5.17%) SQL Server Developer
16 39 (5.05%) Senior Developer
17 37 (4.79%) .NET Developer
17 37 (4.79%) Data Warehouse Developer
Libraries, Frameworks & Software Standards
1 135 (17.46%) .NET
2 82 (10.61%) MDX
3 34 (4.40%) ASP.NET
4 33 (4.27%) XML
5 20 (2.59%) Web Services
6 17 (2.20%) HTML
7 16 (2.07%) .NET Framework
7 16 (2.07%) CSS
8 15 (1.94%) ASP.NET Web API
8 15 (1.94%) Entity Framework
9 14 (1.81%) WCF
10 10 (1.29%) JSON
10 10 (1.29%) WPF
11 9 (1.16%) jQuery
12 7 (0.91%) WF
13 6 (0.78%) Kafka
14 5 (0.65%) Ajax
14 5 (0.65%) AngularJS
14 5 (0.65%) REST
15 4 (0.52%) OAuth
Miscellaneous
1 89 (11.51%) Analytical Skills
2 26 (3.36%) Data Structures
3 25 (3.23%) Reinsurance
4 23 (2.98%) Greenfield Project
5 17 (2.20%) Private Cloud
6 14 (1.81%) Clustering
6 14 (1.81%) Credit Risk
7 12 (1.55%) Data Centre
7 12 (1.55%) Management Information System
7 12 (1.55%) Market Risk
8 10 (1.29%) Fixed Income
8 10 (1.29%) Grid Computing
8 10 (1.29%) Self-Motivation
9 9 (1.16%) Credit Derivative
9 9 (1.16%) Enterprise Software
9 9 (1.16%) Hedge funds
10 8 (1.03%) Computer Science
10 8 (1.03%) Derivative
11 7 (0.91%) User Experience
12 5 (0.65%) Replication
Operating Systems
1 29 (3.75%) Windows
2 14 (1.81%) Windows Server
3 5 (0.65%) Windows Server 2008
4 4 (0.52%) Linux
5 2 (0.26%) Windows 10
5 2 (0.26%) Windows 7
6 1 (0.13%) Windows Server 2012
Processes & Methodologies
1 593 (76.71%) Business Intelligence
2 253 (32.73%) ETL
3 189 (24.45%) Agile Software Development
4 157 (20.31%) Data Modelling
5 145 (18.76%) Analytics
6 102 (13.20%) Visualisation
7 84 (10.87%) Kimball Methodology
8 76 (9.83%) Migration
9 56 (7.24%) Performance Tuning
9 56 (7.24%) Problem-Solving
9 56 (7.24%) Scrum
10 54 (6.99%) Data Visualisation
11 53 (6.86%) Data Analysis
12 49 (6.34%) Dimensional Modelling
13 43 (5.56%) Data Migration
14 39 (5.05%) ETL Development
15 38 (4.92%) Data Analytics
16 32 (4.14%) ERP
17 31 (4.01%) Dashboard Development
18 29 (3.75%) Stakeholder Management
Programming Languages
1 570 (73.74%) SQL
2 308 (39.84%) T-SQL
3 149 (19.28%) C#
4 91 (11.77%) Data Analysis Expressions (DAX)
5 51 (6.60%) PowerShell
6 29 (3.75%) Python
7 25 (3.23%) VB
8 21 (2.72%) PL/SQL
9 20 (2.59%) JavaScript
9 20 (2.59%) VBA
10 18 (2.33%) R
11 11 (1.42%) VB.NET
12 8 (1.03%) VBScript
13 7 (0.91%) Java
13 7 (0.91%) X++
14 6 (0.78%) U-SQL
15 5 (0.65%) Shell Script
16 3 (0.39%) Go
16 3 (0.39%) MUMPS
16 3 (0.39%) TypeScript
Qualifications
1 26 (3.36%) Security Cleared
2 24 (3.10%) Degree
3 20 (2.59%) SC Cleared
4 10 (1.29%) Microsoft Certification
5 5 (0.65%) Computer Science Degree
6 4 (0.52%) MCSE
6 4 (0.52%) MCTS
6 4 (0.52%) Numerate Degree
7 3 (0.39%) TOGAF Certification
8 2 (0.26%) CCNA
8 2 (0.26%) Cisco Certification
8 2 (0.26%) DV Cleared
8 2 (0.26%) MCP
8 2 (0.26%) MCSD
8 2 (0.26%) PMI Certification
8 2 (0.26%) PMP
9 1 (0.13%) BC Cleared
9 1 (0.13%) ISEB
9 1 (0.13%) ITIL Certification
9 1 (0.13%) MCSA
Quality Assurance & Compliance
1 40 (5.17%) QA
2 37 (4.79%) Data Quality
3 15 (1.94%) GDPR
4 4 (0.52%) ISO/IEC 27001
5 2 (0.26%) Basel III
5 2 (0.26%) WCAG
6 1 (0.13%) HL7
System Software
1 11 (1.42%) Active Directory
2 6 (0.78%) Hyper-V
3 5 (0.65%) Virtual Machines
4 3 (0.39%) XenApp
5 1 (0.13%) Apache Flume
5 1 (0.13%) HDFS
5 1 (0.13%) VMware Infrastructure
Systems Management
1 6 (0.78%) SCOM
1 6 (0.78%) SCOrch
2 5 (0.65%) Failover Clustering
2 5 (0.65%) Microsoft Clustering
3 4 (0.52%) CA Single Sign-On
3 4 (0.52%) SCVMM
3 4 (0.52%) Single Sign-On
4 3 (0.39%) Ansible
4 3 (0.39%) NetBackup
4 3 (0.39%) SCCM
4 3 (0.39%) Symantec Enterprise Vault
5 2 (0.26%) Opscode Chef
5 2 (0.26%) Puppet
5 2 (0.26%) Systems Management Server (SMS)
5 2 (0.26%) Terraform
5 2 (0.26%) WhatsUp Gold
6 1 (0.13%) Control-M
6 1 (0.13%) Foglight
6 1 (0.13%) Microsoft Data Protection Manager
6 1 (0.13%) Oracle RMAN
Vendors
1 405 (52.39%) Microsoft
2 76 (9.83%) Tableau
3 54 (6.99%) Oracle
4 28 (3.62%) SAP
5 12 (1.55%) RedGate
6 10 (1.29%) Cognos
7 9 (1.16%) JD Edwards
8 7 (0.91%) Citrix
9 6 (0.78%) Google
9 6 (0.78%) IBM
10 4 (0.52%) Alteryx
10 4 (0.52%) CA
10 4 (0.52%) Informatica
11 3 (0.39%) 3PAR
11 3 (0.39%) Birst
11 3 (0.39%) Databricks
11 3 (0.39%) Sybase
11 3 (0.39%) Symantec
12 2 (0.26%) Charles River
12 2 (0.26%) Salesforce.com