Period
to 17 July 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 17 July 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
17 Jul 2018
Same period 2017 Same period 2016
Rank 334 282 262
Rank change year-on-year -52 -20 -75
Contract jobs citing SQL Server Analysis Services 761 842 1,105
As % of all contract IT jobs advertised in the UK 0.73% 0.89% 1.00%
As % of the Database & Business Intelligence category 3.24% 3.95% 4.55%
Number of daily rates quoted 600 580 813
UK median daily rate £433 £416 £400
Median daily rate % change year-on-year +3.90% +4.06% +6.67%
10th Percentile £313 £292 £292
90th Percentile £588 £575 £525
UK excluding London median daily rate £399 £375 £375
% change year-on-year +6.33% - +11.11%
Number of hourly rates quoted 4 8 4
UK median hourly rate £22.25 £23.25 £38.75
Median hourly rate % change year-on-year -4.30% -40.00% +41.94%
10th Percentile £21.00 £20.75 £23.00
90th Percentile £31.63 £87.78 £47.33
UK excluding London median hourly rate £22.50 £30.00 £38.75
% change year-on-year -25.00% -22.58% +20.72%

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,514 21,317 24,299
As % of all contract IT jobs advertised in the UK 22.69% 22.44% 22.06%
Number of daily rates quoted 16,385 14,158 16,293
UK median daily rate £463 £450 £425
Median daily rate % change year-on-year +2.78% +5.88% +6.25%
10th Percentile £313 £300 £280
90th Percentile £635 £614 £600
UK excluding London median daily rate £413 £400 £375
% change year-on-year +3.13% +6.67% +3.45%
Number of hourly rates quoted 238 269 378
UK median hourly rate £32.50 £31.00 £28.25
Median hourly rate % change year-on-year +4.84% +9.73% +13.00%
10th Percentile £14.00 £11.04 £11.58
90th Percentile £55.00 £52.50 £51.00
UK excluding London median hourly rate £33.50 £31.50 £28.50
% change year-on-year +6.35% +10.53% +14.00%

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 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 17 July 2018.

Contractor hourly rate histogram for SQL Server Analysis Services in the UK

SQL Server Analysis Services
Top 17 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 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 -53 719 £450 +7.14% 273
London -21 426 £475 +2.98% 120
UK excluding London -74 333 £399 +6.33% 166
South East -31 76 £425 +6.25% 28
Midlands -24 70 £373 +6.43% 36
North of England -80 70 £375 +4.17% 58
East of England +22 56 £400 -8.57% 19
West Midlands -35 38 £413 +17.86% 15
Yorkshire -34 32 £365 +4.29% 31
Scotland -38 32 £365 -18.89% 10
East Midlands +1 31 £343 +3.40% 21
North West -70 29 £385 +6.21% 24
South West -14 21 £410 +9.33% 12
North East - 9 £350 - 3
Wales -11 6 £344 -5.17% 2
Northern Ireland +14 1 - - 1
Isle of Man - 1 £400 -

For the 6 months to 17 July 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 662 (86.99%) SQL Server Integration Services
2 597 (78.45%) SQL Server Reporting Services
3 582 (76.48%) Business Intelligence
4 570 (74.90%) SQL Server
5 568 (74.64%) SQL
6 400 (52.56%) Microsoft
7 389 (51.12%) Data Warehouse
8 308 (40.47%) Power BI
9 271 (35.61%) T-SQL
10 252 (33.11%) ETL
11 197 (25.89%) Agile Software Development
12 193 (25.36%) Finance
13 171 (22.47%) Microsoft Azure
14 154 (20.24%) Analytics
15 152 (19.97%) Data Modelling
16 144 (18.92%) C#
17 122 (16.03%) .NET
18 106 (13.93%) Microsoft Analysis Services
18 106 (13.93%) SQL Server 2016
19 94 (12.35%) Microsoft Excel
20 93 (12.22%) Visualisation
21 92 (12.09%) Data Analysis Expressions (DAX)
21 92 (12.09%) MDX
22 88 (11.56%) SQL Server 2008
23 84 (11.04%) Analytical Skills
24 81 (10.64%) SQL Server 2012
25 80 (10.51%) Kimball Methodology
25 80 (10.51%) SQL Server 2014
26 68 (8.94%) Migration
27 66 (8.67%) Data Lake

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 49 (6.44%) SharePoint
2 17 (2.23%) SAS
3 10 (1.31%) IIS
4 9 (1.18%) Apache Spark
5 6 (0.79%) BizTalk Server
6 4 (0.53%) Apache Pig
6 4 (0.53%) Confluence
6 4 (0.53%) SharePoint 2013
7 3 (0.39%) SharePoint 2010
8 2 (0.26%) Apache
8 2 (0.26%) CMS
8 2 (0.26%) Oracle SOA Suite
8 2 (0.26%) SharePoint Server
9 1 (0.13%) Apache Airflow
9 1 (0.13%) Exchange Server 2013
9 1 (0.13%) JBoss
9 1 (0.13%) Mongoose
9 1 (0.13%) MS Exchange
9 1 (0.13%) WordPress
Applications
1 94 (12.35%) Microsoft Excel
2 17 (2.23%) MS Visio
3 15 (1.97%) Microsoft Office
4 9 (1.18%) Microsoft Project
5 6 (0.79%) SPSS
6 4 (0.53%) Spreadsheet
7 3 (0.39%) Microsoft PowerPoint
Business Applications
1 15 (1.97%) Dynamics AX
2 10 (1.31%) Dynamics CRM
3 9 (1.18%) NetSuite
4 3 (0.39%) Oracle ERP
5 2 (0.26%) Demantra
5 2 (0.26%) Infor M3
5 2 (0.26%) Markit EDM
5 2 (0.26%) Oracle Financials
5 2 (0.26%) Oracle Retail
5 2 (0.26%) ReMetrica
5 2 (0.26%) Retail-J
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%) MetaTrader
6 1 (0.13%) SystmOne
Cloud Services
1 171 (22.47%) Microsoft Azure
2 51 (6.70%) Azure Data Factory
3 26 (3.42%) Amazon AWS
3 26 (3.42%) PaaS
4 25 (3.29%) Dynamics 365
5 11 (1.45%) Cortana Intelligence Suite
6 9 (1.18%) Data Lake Analytics
6 9 (1.18%) Office 365
7 8 (1.05%) Cloud Computing
8 6 (0.79%) SaaS
9 5 (0.66%) IaaS
10 2 (0.26%) Google Analytics
10 2 (0.26%) Google Cloud Platform
10 2 (0.26%) Salesforce Sales Cloud
11 1 (0.13%) Amazon S3
11 1 (0.13%) GitHub
11 1 (0.13%) iPaaS
Communications & Networking
1 5 (0.66%) SAN
2 3 (0.39%) SMS
2 3 (0.39%) WinSCP
3 2 (0.26%) Kerberos
4 1 (0.13%) FTP
4 1 (0.13%) Intranet
Database & Business Intelligence
1 662 (86.99%) SQL Server Integration Services
2 597 (78.45%) SQL Server Reporting Services
3 570 (74.90%) SQL Server
4 389 (51.12%) Data Warehouse
5 308 (40.47%) Power BI
6 106 (13.93%) Microsoft Analysis Services
6 106 (13.93%) SQL Server 2016
7 88 (11.56%) SQL Server 2008
8 81 (10.64%) SQL Server 2012
9 80 (10.51%) SQL Server 2014
10 66 (8.67%) Data Lake
11 62 (8.15%) OLAP
12 60 (7.88%) Azure SQL Database
13 47 (6.18%) Big Data
14 41 (5.39%) PowerPivot
15 37 (4.86%) HDInsight
16 34 (4.47%) Hadoop
17 33 (4.34%) Star Schema
18 30 (3.94%) SQL Server 2005
19 29 (3.81%) QlikView
Development Applications
1 57 (7.49%) Visual Studio
2 49 (6.44%) Team Foundation Server
3 30 (3.94%) SQL Server Management Studio (SSMS)
4 25 (3.29%) Git (software)
5 11 (1.45%) Jenkins
6 9 (1.18%) Visual Studio Team System
7 7 (0.92%) JIRA
7 7 (0.92%) SpecFlow
7 7 (0.92%) Subversion
8 5 (0.66%) Octopus Deploy
9 4 (0.53%) MSBuild
9 4 (0.53%) NUnit
9 4 (0.53%) StarTeam
9 4 (0.53%) TeamCity
9 4 (0.53%) Toad
10 3 (0.39%) MorphX
10 3 (0.39%) Selenium
10 3 (0.39%) tSQLt
11 2 (0.26%) Ant
11 2 (0.26%) Maven
General
1 193 (25.36%) Finance
2 54 (7.10%) Banking
3 49 (6.44%) Retail
4 22 (2.89%) Investment Banking
5 20 (2.63%) Legal
6 18 (2.37%) Front Office
7 15 (1.97%) Marketing
8 8 (1.05%) Law
9 7 (0.92%) General Ledger
10 6 (0.79%) Manufacturing
11 4 (0.53%) Automotive
11 4 (0.53%) Financial Institution
11 4 (0.53%) Publishing
12 3 (0.39%) Back Office
12 3 (0.39%) Local Government
12 3 (0.39%) Telecoms
13 2 (0.26%) Billing
13 2 (0.26%) Electronics
14 1 (0.13%) Advertising
14 1 (0.13%) Games
Job Titles
1 489 (64.26%) Developer
2 268 (35.22%) Business Intelligence Developer
3 170 (22.34%) SQL Developer
4 93 (12.22%) SSAS Developer
5 92 (12.09%) SSIS Developer
6 74 (9.72%) SSRS Developer
7 72 (9.46%) Analyst
8 62 (8.15%) SQL BI Developer
9 61 (8.02%) Power BI Developer
10 56 (7.36%) Consultant
11 46 (6.04%) DBA
12 45 (5.91%) ETL Developer
13 42 (5.52%) Architect
14 39 (5.12%) SQL Server Developer
15 38 (4.99%) Business Intelligence Consultant
16 37 (4.86%) Business Intelligence Analyst
16 37 (4.86%) SQL DBA
17 35 (4.60%) .NET Developer
17 35 (4.60%) Business Intelligence Lead
18 34 (4.47%) C# Developer
Libraries, Frameworks & Software Standards
1 122 (16.03%) .NET
2 92 (12.09%) MDX
3 34 (4.47%) XML
4 32 (4.20%) ASP.NET
5 26 (3.42%) Web Services
6 21 (2.76%) HTML
7 20 (2.63%) CSS
8 17 (2.23%) ASP.NET Web API
9 15 (1.97%) .NET Framework
9 15 (1.97%) Entity Framework
10 14 (1.84%) WCF
11 13 (1.71%) JSON
12 11 (1.45%) jQuery
13 9 (1.18%) Node.js
13 9 (1.18%) REST
14 7 (0.92%) WF
15 5 (0.66%) Ajax
15 5 (0.66%) AngularJS
15 5 (0.66%) SOAP
16 4 (0.53%) Angular 2
Miscellaneous
1 84 (11.04%) Analytical Skills
2 27 (3.55%) Greenfield Project
3 25 (3.29%) Self-Motivation
4 24 (3.15%) Reinsurance
5 19 (2.50%) Data Structures
6 17 (2.23%) Market Risk
6 17 (2.23%) Private Cloud
7 15 (1.97%) Clustering
8 11 (1.45%) Management Information System
9 10 (1.31%) Computer Science
9 10 (1.31%) Fintech
9 10 (1.31%) Fixed Income
10 9 (1.18%) Grid Computing
10 9 (1.18%) User Experience
11 8 (1.05%) NHS
11 8 (1.05%) Replication
12 6 (0.79%) Hedge funds
13 5 (0.66%) Credit Derivative
13 5 (0.66%) Credit Risk
13 5 (0.66%) FMCG
Operating Systems
1 43 (5.65%) Windows
2 13 (1.71%) Windows Server
3 11 (1.45%) Windows Server 2012
4 8 (1.05%) Windows Server 2008
5 3 (0.39%) Windows 10
5 3 (0.39%) Windows 7
5 3 (0.39%) Windows Server 2003
6 2 (0.26%) Unix
7 1 (0.13%) Linux
7 1 (0.13%) VMS
Processes & Methodologies
1 582 (76.48%) Business Intelligence
2 252 (33.11%) ETL
3 197 (25.89%) Agile Software Development
4 154 (20.24%) Analytics
5 152 (19.97%) Data Modelling
6 93 (12.22%) Visualisation
7 80 (10.51%) Kimball Methodology
8 68 (8.94%) Migration
9 62 (8.15%) Performance Tuning
10 61 (8.02%) Data Analysis
11 59 (7.75%) Scrum
12 51 (6.70%) Problem-Solving
13 49 (6.44%) Dimensional Modelling
14 48 (6.31%) Data Visualisation
15 40 (5.26%) Data Analytics
16 36 (4.73%) ETL Development
17 32 (4.20%) Business Analysis
18 29 (3.81%) Data Integration
18 29 (3.81%) High Availability
19 28 (3.68%) Data Migration
Programming Languages
1 568 (74.64%) SQL
2 271 (35.61%) T-SQL
3 144 (18.92%) C#
4 92 (12.09%) Data Analysis Expressions (DAX)
5 43 (5.65%) PowerShell
6 29 (3.81%) PL/SQL
7 28 (3.68%) VBA
8 26 (3.42%) Python
9 21 (2.76%) JavaScript
9 21 (2.76%) VB
10 19 (2.50%) R
11 17 (2.23%) VB.NET
12 15 (1.97%) Java
13 13 (1.71%) VBScript
14 8 (1.05%) XMLA
15 5 (0.66%) X++
16 4 (0.53%) C++
16 4 (0.53%) TypeScript
16 4 (0.53%) U-SQL
17 3 (0.39%) MUMPS
Qualifications
1 29 (3.81%) Security Cleared
2 23 (3.02%) Degree
2 23 (3.02%) SC Cleared
3 10 (1.31%) Microsoft Certification
4 5 (0.66%) MCTS
5 4 (0.53%) Computer Science Degree
5 4 (0.53%) MCSE
6 3 (0.39%) MCSA
7 2 (0.26%) BPSS Clearance
7 2 (0.26%) MCAD
7 2 (0.26%) MCITP
7 2 (0.26%) MCP
7 2 (0.26%) MCSD
7 2 (0.26%) Numerate Degree
8 1 (0.13%) BC Cleared
8 1 (0.13%) DV Cleared
8 1 (0.13%) ISEB
8 1 (0.13%) MCPD
8 1 (0.13%) TOGAF Certification
Quality Assurance & Compliance
1 34 (4.47%) Data Quality
2 28 (3.68%) QA
3 18 (2.37%) GDPR
4 3 (0.39%) ISO/IEC 27001
5 2 (0.26%) WCAG
6 1 (0.13%) Basel III
6 1 (0.13%) ISO 9001
6 1 (0.13%) PMO
System Software
1 10 (1.31%) Active Directory
2 7 (0.92%) Hyper-V
3 4 (0.53%) Apache Flume
3 4 (0.53%) Virtual Machines
4 2 (0.26%) VMware Infrastructure
5 1 (0.13%) HDFS
5 1 (0.13%) XenApp
Systems Management
1 10 (1.31%) Failover Clustering
2 7 (0.92%) Microsoft Clustering
3 6 (0.79%) SCVMM
4 5 (0.66%) Opscode Chef
5 3 (0.39%) NetBackup
5 3 (0.39%) Puppet
5 3 (0.39%) SCCM
5 3 (0.39%) SCOM
5 3 (0.39%) SCOrch
5 3 (0.39%) WhatsUp Gold
5 3 (0.39%) WMI
6 2 (0.26%) Ansible
6 2 (0.26%) Systems Management Server (SMS)
6 2 (0.26%) Terraform
7 1 (0.13%) Control-M
7 1 (0.13%) Foglight
7 1 (0.13%) Oracle RMAN
7 1 (0.13%) SQL Sentry
Vendors
1 400 (52.56%) Microsoft
2 65 (8.54%) Oracle
2 65 (8.54%) Tableau
3 25 (3.29%) SAP
4 19 (2.50%) RedGate
5 17 (2.23%) Cognos
6 11 (1.45%) Informatica
7 8 (1.05%) JD Edwards
8 7 (0.92%) Cloudera
9 6 (0.79%) Salesforce.com
10 5 (0.66%) Vertica
11 4 (0.53%) Google
11 4 (0.53%) Micro Focus
12 3 (0.39%) 3PAR
12 3 (0.39%) Birst
12 3 (0.39%) Bloomberg
12 3 (0.39%) FactSet
12 3 (0.39%) Talend
12 3 (0.39%) Teradata
12 3 (0.39%) VMware