Period
to 13 November 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 13 November 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
13 Nov 2018
Same period 2017 Same period 2016
Rank 332 319 266
Rank change year-on-year -13 -53 -88
Contract jobs citing SQL Server Analysis Services 812 814 1,045
As % of all contract IT jobs advertised in the UK 0.78% 0.80% 1.00%
As % of the Database & Business Intelligence category 3.48% 3.60% 4.41%
Number of daily rates quoted 619 615 749
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 £600 £570 £538
UK excluding London median daily rate £400 £375 £375
% change year-on-year +6.67% - +7.14%
Number of hourly rates quoted 3 13 9
UK median hourly rate £45.00 £21.50 £44.00
Median hourly rate % change year-on-year +109.30% -51.14% +33.33%
10th Percentile £27.76 £20.75 £16.25
90th Percentile £47.50 £44.40 £48.72
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,331 22,587 23,722
As % of all contract IT jobs advertised in the UK 22.49% 22.11% 22.62%
Number of daily rates quoted 16,253 15,399 15,738
UK median daily rate £475 £450 £425
Median daily rate % change year-on-year +5.56% +5.88% +6.25%
10th Percentile £313 £310 £281
90th Percentile £638 £625 £595
UK excluding London median daily rate £425 £400 £375
% change year-on-year +6.25% +6.67% -
Number of hourly rates quoted 243 281 374
UK median hourly rate £32.50 £30.75 £28.34
Median hourly rate % change year-on-year +5.69% +8.50% +0.10%
10th Percentile £12.85 £14.00 £10.08
90th Percentile £57.07 £55.00 £52.23
UK excluding London median hourly rate £34.25 £35.00 £28.18
% change year-on-year -2.14% +24.20% -4.47%

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 13 November 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 13 November 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 13 November 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 +12 777 £450 +5.88% 309
London +40 467 £475 +5.56% 113
UK excluding London -44 340 £400 +6.67% 215
North of England -38 86 £394 +8.62% 71
East of England +26 68 £425 +26.87% 30
South East -43 59 £413 +10.00% 31
Midlands -14 56 £425 +6.25% 47
Yorkshire -7 44 £400 +10.34% 41
South West -38 42 £410 +7.54% 18
North West -26 35 £386 +3.00% 28
West Midlands -30 34 £419 +4.69% 24
Scotland -26 24 £365 -8.75% 16
East Midlands +17 22 £425 +9.68% 23
North East +5 7 £275 -8.33% 2
Wales -17 5 £415 +10.67% 2
Northern Ireland +30 2 - - 1

For the 6 months to 13 November 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 658 (81.03%) SQL Server Integration Services
2 615 (75.74%) SQL Server Reporting Services
3 605 (74.51%) SQL
4 603 (74.26%) Business Intelligence
5 589 (72.54%) SQL Server
6 408 (50.25%) Data Warehouse
7 383 (47.17%) Microsoft
8 332 (40.89%) T-SQL
9 323 (39.78%) Power BI
10 300 (36.95%) ETL
11 239 (29.43%) Finance
12 215 (26.48%) Microsoft Azure
13 190 (23.40%) Agile Software Development
14 161 (19.83%) Data Modelling
15 133 (16.38%) Analytics
16 127 (15.64%) C#
17 125 (15.39%) Microsoft Analysis Services
18 118 (14.53%) .NET
19 108 (13.30%) SQL Server 2016
20 102 (12.56%) Data Analysis Expressions (DAX)
21 95 (11.70%) Analytical Skills
22 93 (11.45%) Microsoft Excel
22 93 (11.45%) Migration
23 92 (11.33%) Visualisation
24 91 (11.21%) SQL Server 2012
25 90 (11.08%) Kimball Methodology
25 90 (11.08%) Data Lake
26 89 (10.96%) SQL Server 2014
27 85 (10.47%) SQL Server 2008
28 78 (9.61%) Tableau

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 36 (4.43%) SharePoint
2 12 (1.48%) Apache Spark
3 11 (1.35%) IIS
4 9 (1.11%) SharePoint 2013
5 7 (0.86%) SAS
5 7 (0.86%) SharePoint 2010
6 4 (0.49%) Apache Pig
7 3 (0.37%) BizTalk Server
7 3 (0.37%) Confluence
7 3 (0.37%) SharePoint Server
8 2 (0.25%) CMS
8 2 (0.25%) Skype for Business
9 1 (0.12%) Apache
9 1 (0.12%) Apache Airflow
9 1 (0.12%) WebSphere
Applications
1 93 (11.45%) Microsoft Excel
2 17 (2.09%) Microsoft Office
3 5 (0.62%) Microsoft PowerPoint
3 5 (0.62%) MS Visio
4 4 (0.49%) Spreadsheet
5 1 (0.12%) SPSS
Business Applications
1 14 (1.72%) Dynamics AX
2 10 (1.23%) NetSuite
3 7 (0.86%) Dynamics CRM
4 3 (0.37%) Dynamics NAV
5 2 (0.25%) Infor M3
5 2 (0.25%) Markit EDM
5 2 (0.25%) ReMetrica
5 2 (0.25%) thinkFolio
5 2 (0.25%) Towers Watson Igloo
6 1 (0.12%) Actimize
6 1 (0.12%) Infor CRM
6 1 (0.12%) Oracle Procure-to-Pay
6 1 (0.12%) Unit4 Business World
Cloud Services
1 215 (26.48%) Microsoft Azure
2 73 (8.99%) Azure Data Factory
3 33 (4.06%) PaaS
4 32 (3.94%) Dynamics 365
5 21 (2.59%) Office 365
6 20 (2.46%) IaaS
7 14 (1.72%) Data Lake Analytics
8 13 (1.60%) Amazon AWS
9 7 (0.86%) Cloud Computing
9 7 (0.86%) GitHub
9 7 (0.86%) Google Cloud Platform
10 5 (0.62%) Cortana Intelligence Suite
11 4 (0.49%) Azure Machine Learning
11 4 (0.49%) SaaS
12 2 (0.25%) Google Analytics
13 1 (0.12%) Amazon S3
13 1 (0.12%) Azure Active Directory
13 1 (0.12%) Trello
Communications & Networking
1 5 (0.62%) DMZ
2 4 (0.49%) Fibre Channel
2 4 (0.49%) iSCSI
2 4 (0.49%) SAN
3 3 (0.37%) HTTP
3 3 (0.37%) SMTP
4 2 (0.25%) Firewall
4 2 (0.25%) Intranet
4 2 (0.25%) SMS
5 1 (0.12%) BIG-IP
5 1 (0.12%) Cisco ASA
5 1 (0.12%) Cisco Firepower
5 1 (0.12%) Cisco Nexus
5 1 (0.12%) DNS
5 1 (0.12%) Internet
Database & Business Intelligence
1 658 (81.03%) SQL Server Integration Services
2 615 (75.74%) SQL Server Reporting Services
3 589 (72.54%) SQL Server
4 408 (50.25%) Data Warehouse
5 323 (39.78%) Power BI
6 125 (15.39%) Microsoft Analysis Services
7 108 (13.30%) SQL Server 2016
8 91 (11.21%) SQL Server 2012
9 90 (11.08%) Data Lake
10 89 (10.96%) SQL Server 2014
11 85 (10.47%) SQL Server 2008
12 62 (7.64%) OLAP
13 57 (7.02%) Azure SQL Database
14 54 (6.65%) Big Data
15 52 (6.40%) Relational Database
16 37 (4.56%) HDInsight
16 37 (4.56%) PowerPivot
17 28 (3.45%) Azure SQL Data Warehouse
18 26 (3.20%) QlikView
19 25 (3.08%) Hadoop
Development Applications
1 61 (7.51%) Team Foundation Server
2 42 (5.17%) Visual Studio
3 24 (2.96%) Git (software)
4 18 (2.22%) SQL Server Management Studio (SSMS)
5 14 (1.72%) Visual Studio Team System
6 12 (1.48%) Subversion
7 5 (0.62%) JIRA
7 5 (0.62%) MorphX
8 4 (0.49%) git-flow
9 3 (0.37%) Jenkins
9 3 (0.37%) MSBuild
9 3 (0.37%) NUnit
9 3 (0.37%) Selenium
9 3 (0.37%) SpecFlow
9 3 (0.37%) TeamCity
9 3 (0.37%) Visual Studio Coded UI
10 2 (0.25%) ER Studio
10 2 (0.25%) ERwin
10 2 (0.25%) FitNesse
10 2 (0.25%) Plastic SCM
General
1 239 (29.43%) Finance
2 52 (6.40%) Banking
2 52 (6.40%) Retail
3 29 (3.57%) Front Office
4 21 (2.59%) Investment Banking
5 14 (1.72%) General Ledger
6 13 (1.60%) Publishing
7 10 (1.23%) Marketing
7 10 (1.23%) Telecoms
8 9 (1.11%) Manufacturing
9 7 (0.86%) Legal
10 6 (0.74%) Back Office
11 5 (0.62%) Electronics
12 3 (0.37%) Law
12 3 (0.37%) Local Government
13 2 (0.25%) Financial Institution
13 2 (0.25%) Games
13 2 (0.25%) Pharmaceutical
14 1 (0.12%) Billing
14 1 (0.12%) Corporate Banking
Job Titles
1 554 (68.23%) Developer
2 313 (38.55%) Business Intelligence Developer
3 196 (24.14%) SQL Developer
4 93 (11.45%) SSIS Developer
5 85 (10.47%) SSAS Developer
6 72 (8.87%) Analyst
7 68 (8.37%) SQL BI Developer
8 67 (8.25%) Power BI Developer
9 63 (7.76%) SSRS Developer
10 46 (5.67%) DBA
11 44 (5.42%) SQL DBA
12 41 (5.05%) Business Intelligence Analyst
13 40 (4.93%) SQL Server Developer
14 39 (4.80%) Senior Developer
15 38 (4.68%) Data Warehouse Developer
15 38 (4.68%) T-SQL Developer
16 37 (4.56%) Architect
16 37 (4.56%) Business Developer
16 37 (4.56%) ETL Developer
17 32 (3.94%) .NET Developer
Libraries, Frameworks & Software Standards
1 118 (14.53%) .NET
2 73 (8.99%) MDX
3 26 (3.20%) ASP.NET
3 26 (3.20%) XML
4 18 (2.22%) Web Services
5 12 (1.48%) HTML
6 11 (1.35%) CSS
6 11 (1.35%) Entity Framework
6 11 (1.35%) JSON
6 11 (1.35%) WCF
7 10 (1.23%) .NET Framework
8 9 (1.11%) Kafka
9 8 (0.99%) ASP.NET Web API
10 7 (0.86%) jQuery
10 7 (0.86%) WPF
11 5 (0.62%) AngularJS
11 5 (0.62%) ASP.NET MVC
11 5 (0.62%) OAuth
11 5 (0.62%) SAML
11 5 (0.62%) WF
Miscellaneous
1 95 (11.70%) Analytical Skills
2 28 (3.45%) Data Structures
3 23 (2.83%) Greenfield Project
4 16 (1.97%) Self-Motivation
5 14 (1.72%) Clustering
5 14 (1.72%) Data Centre
5 14 (1.72%) Reinsurance
6 13 (1.60%) Credit Risk
7 12 (1.48%) Management Information System
8 10 (1.23%) Hedge funds
8 10 (1.23%) Market Risk
9 9 (1.11%) Credit Derivative
9 9 (1.11%) Fixed Income
10 8 (0.99%) Derivative
10 8 (0.99%) Grid Computing
11 7 (0.86%) Computer Science
11 7 (0.86%) Enterprise Software
12 6 (0.74%) Fintech
12 6 (0.74%) Smart City
12 6 (0.74%) User Experience
Operating Systems
1 33 (4.06%) Windows
2 18 (2.22%) Windows Server
3 6 (0.74%) Linux
4 5 (0.62%) Windows Server 2008
5 2 (0.25%) Windows 10
5 2 (0.25%) Windows 7
6 1 (0.12%) VMS
6 1 (0.12%) Windows Server 2012
Processes & Methodologies
1 603 (74.26%) Business Intelligence
2 300 (36.95%) ETL
3 190 (23.40%) Agile Software Development
4 161 (19.83%) Data Modelling
5 133 (16.38%) Analytics
6 93 (11.45%) Migration
7 92 (11.33%) Visualisation
8 90 (11.08%) Kimball Methodology
9 64 (7.88%) Problem-Solving
10 59 (7.27%) Data Migration
11 57 (7.02%) Dimensional Modelling
12 54 (6.65%) Scrum
13 52 (6.40%) Data Analysis
13 52 (6.40%) Performance Tuning
14 42 (5.17%) Data Visualisation
15 41 (5.05%) Data Management
16 40 (4.93%) Dashboard Development
16 40 (4.93%) Data Analytics
17 35 (4.31%) ETL Development
18 34 (4.19%) Stakeholder Management
Programming Languages
1 605 (74.51%) SQL
2 332 (40.89%) T-SQL
3 127 (15.64%) C#
4 102 (12.56%) Data Analysis Expressions (DAX)
5 62 (7.64%) PowerShell
6 31 (3.82%) VB
7 25 (3.08%) Python
8 23 (2.83%) PL/SQL
9 19 (2.34%) JavaScript
10 17 (2.09%) VBA
11 15 (1.85%) R
12 8 (0.99%) VB.NET
13 7 (0.86%) U-SQL
13 7 (0.86%) VBScript
14 6 (0.74%) Java
15 5 (0.62%) X++
16 4 (0.49%) PHP
17 3 (0.37%) Shell Script
17 3 (0.37%) TypeScript
18 2 (0.25%) Go
Qualifications
1 24 (2.96%) Degree
2 16 (1.97%) Microsoft Certification
3 8 (0.99%) MCSE
4 7 (0.86%) Security Cleared
5 5 (0.62%) Computer Science Degree
5 5 (0.62%) MCTS
6 4 (0.49%) TOGAF Certification
7 3 (0.37%) CCNA
7 3 (0.37%) Cisco Certification
7 3 (0.37%) MCSD
7 3 (0.37%) Numerate Degree
7 3 (0.37%) PMI Certification
7 3 (0.37%) PMP
7 3 (0.37%) SC Cleared
8 2 (0.25%) BPSS Clearance
8 2 (0.25%) DV Cleared
8 2 (0.25%) ITIL Certification
8 2 (0.25%) MCP
8 2 (0.25%) MCSA
9 1 (0.12%) DBS Check
Quality Assurance & Compliance
1 50 (6.16%) QA
2 36 (4.43%) Data Quality
3 9 (1.11%) GDPR
4 3 (0.37%) ISO/IEC 27001
5 2 (0.25%) Basel III
6 1 (0.12%) HL7
System Software
1 11 (1.35%) Active Directory
2 6 (0.74%) Virtual Machines
3 5 (0.62%) Hyper-V
3 5 (0.62%) XenApp
4 1 (0.12%) Apache Flume
4 1 (0.12%) HDFS
4 1 (0.12%) VMware Infrastructure
Systems Management
1 5 (0.62%) CA Single Sign-On
1 5 (0.62%) Microsoft Clustering
1 5 (0.62%) SCOM
1 5 (0.62%) SCOrch
1 5 (0.62%) Single Sign-On
1 5 (0.62%) Symantec Enterprise Vault
2 3 (0.37%) Ansible
3 2 (0.25%) Microsoft Data Protection Manager
3 2 (0.25%) WhatsUp Gold
4 1 (0.12%) Control-M
4 1 (0.12%) Failover Clustering
4 1 (0.12%) Foglight
4 1 (0.12%) SQL Sentry
4 1 (0.12%) Systems Management Server (SMS)
Vendors
1 383 (47.17%) Microsoft
2 78 (9.61%) Tableau
3 51 (6.28%) Oracle
4 30 (3.69%) SAP
5 10 (1.23%) Citrix
5 10 (1.23%) IBM
5 10 (1.23%) RedGate
6 9 (1.11%) Google
7 7 (0.86%) JD Edwards
8 6 (0.74%) Cognos
9 5 (0.62%) CA
9 5 (0.62%) Symantec
10 4 (0.49%) Databricks
10 4 (0.49%) Informatica
10 4 (0.49%) Sybase
11 3 (0.37%) Alteryx
11 3 (0.37%) Teradata
12 2 (0.25%) Charles River
12 2 (0.25%) FactSet
12 2 (0.25%) Xamarin