Period
to 18 November 2017

The following table provides summary statistics for contract job vacancies advertised in Cheshire 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 18 November 2017 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)
North West > Cheshire
6 months to
18 Nov 2017
Same period 2016 Same period 2015
Rank 79 62 82
Rank change year-on-year -17 +20 +1
Contract jobs citing SQL Server Analysis Services 12 39 33
As % of all contract IT jobs advertised in Cheshire 0.90% 2.64% 1.57%
As % of the Database & Business Intelligence category 4.24% 10.66% 7.99%
Number of daily rates quoted 6 21 19
Cheshire median daily rate £375 £413 £375
Median daily rate % change year-on-year -9.09% +10.00% +20.00%
10th Percentile £326 £273 £275
90th Percentile £450 £613 £430
North West median daily rate £375 £360 £352
% change year-on-year +4.17% +2.27% +8.31%
Number of hourly rates quoted 3 0 3
Cheshire median hourly rate £27.00 - £33.00
North West median hourly rate £27.00 - £33.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 advertised in Cheshire with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
Cheshire
Contract vacancies with a requirement for database or business intelligence skills 283 366 413
As % of all contract IT jobs advertised in Cheshire 21.23% 24.76% 19.66%
Number of daily rates quoted 213 271 282
Cheshire median daily rate £450 £375 £400
Median daily rate % change year-on-year +20.00% -6.25% +6.67%
10th Percentile £280 £263 £300
90th Percentile £625 £575 £538
North West median daily rate £400 £375 £400
% change year-on-year +6.67% -6.25% +23.08%
Number of hourly rates quoted 6 4 4
Cheshire median hourly rate £25.50 £14.86 £33.00
Median hourly rate % change year-on-year +71.60% -54.97% +109.52%
10th Percentile £9.00 £12.90 £20.83
90th Percentile £27.00 £20.34 £34.85
North West median hourly rate £42.75 £35.75 £40.00
% change year-on-year +19.58% -10.63% +63.27%

SQL Server Analysis Services
Job Vacancy Trend in Cheshire

Job postings citing SQL Server Analysis Services as a percentage of all IT jobs advertised in Cheshire.

Job vacancy trend for SQL Server Analysis Services in Cheshire

SQL Server Analysis Services
Contractor Daily Rate Trend in Cheshire

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing SQL Server Analysis Services in Cheshire.

Contractor daily rate trend for SQL Server Analysis Services in Cheshire

SQL Server Analysis Services
Contractor Daily Rate Histogram in Cheshire

The daily rate distribution of IT jobs citing SQL Server Analysis Services in Cheshire over the 6 months to 18 November 2017.

Contractor daily rate histogram for SQL Server Analysis Services in Cheshire

SQL Server Analysis Services
Contractor Hourly Rate Trend in Cheshire

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing SQL Server Analysis Services in Cheshire.

Contractor hourly rate trend for SQL Server Analysis Services in Cheshire

SQL Server Analysis Services
Contract Job Locations in Cheshire

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 Cheshire region over the 6 months to 18 November 2017. 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
Warrington +8 3 £369 +9.26% 2
Chester -2 1 £375 -13.04%
SQL Server Analysis Services
North West

For the 6 months to 18 November 2017, IT contractor jobs citing SQL Server Analysis Services also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all contract ads across the Cheshire region with a requirement for SQL Server Analysis Services.

1 12 (100.00%) SQL Server Integration Services
2 11 (91.67%) SQL Server
3 8 (66.67%) SQL Server Reporting Services
4 7 (58.33%) Business Intelligence
4 7 (58.33%) SQL
5 6 (50.00%) T-SQL
5 6 (50.00%) Data Warehouse
5 6 (50.00%) Microsoft
6 5 (41.67%) Migration
6 5 (41.67%) SQL Server 2012
7 4 (33.33%) SQL Server 2014
7 4 (33.33%) Data Migration
7 4 (33.33%) SQL Server 2008
7 4 (33.33%) High Availability
8 3 (25.00%) ETL
8 3 (25.00%) SharePoint
8 3 (25.00%) Web Services
8 3 (25.00%) .NET
8 3 (25.00%) C#
8 3 (25.00%) ASP.NET
8 3 (25.00%) Management Information System
8 3 (25.00%) Business Continuity
8 3 (25.00%) Asset Management
8 3 (25.00%) SQL Server 2005
8 3 (25.00%) .NET Framework
8 3 (25.00%) Microsoft Azure
8 3 (25.00%) PowerShell
8 3 (25.00%) Performance Management
8 3 (25.00%) Team Foundation Server
8 3 (25.00%) Data Structures

SQL Server Analysis Services
Co-occurring IT Skills in Cheshire 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 3 (25.00%) SharePoint
2 2 (16.67%) IIS
2 2 (16.67%) SharePoint 2010
2 2 (16.67%) SharePoint 2013
3 1 (8.33%) Exchange Server 2007
3 1 (8.33%) Exchange Server 2013
3 1 (8.33%) MS Exchange
Business Applications
1 1 (8.33%) Salesforce.com CRM
Cloud Services
1 3 (25.00%) Microsoft Azure
2 2 (16.67%) Azure Active Directory
2 2 (16.67%) Office 365
2 2 (16.67%) OneDrive
2 2 (16.67%) Yammer
3 1 (8.33%) Dynamics 365
Communications & Networking
1 2 (16.67%) DNS
1 2 (16.67%) TCP/IP
Database & Business Intelligence
1 12 (100.00%) SQL Server Integration Services
2 11 (91.67%) SQL Server
3 8 (66.67%) SQL Server Reporting Services
4 6 (50.00%) Data Warehouse
5 5 (41.67%) SQL Server 2012
6 4 (33.33%) SQL Server 2008
6 4 (33.33%) SQL Server 2014
7 3 (25.00%) SQL Server 2005
8 2 (16.67%) Power BI
9 1 (8.33%) Business Intelligence Development Studio
9 1 (8.33%) OLAP
9 1 (8.33%) OLTP
9 1 (8.33%) Qlik Sense
9 1 (8.33%) QlikView
9 1 (8.33%) SQL Server 2016
9 1 (8.33%) SSDT
Development Applications
1 3 (25.00%) Team Foundation Server
2 1 (8.33%) Octopus Deploy
2 1 (8.33%) TeamCity
General
1 1 (8.33%) Finance
1 1 (8.33%) Local Government
Job Titles
1 8 (66.67%) Developer
2 6 (50.00%) Business Intelligence Developer
3 4 (33.33%) DBA
4 2 (16.67%) Architect
4 2 (16.67%) Enterprise Architect
4 2 (16.67%) Microsoft BI Developer
4 2 (16.67%) Microsoft Developer
4 2 (16.67%) SharePoint Architect
5 1 (8.33%) .NET Developer
5 1 (8.33%) Administrator
5 1 (8.33%) Analyst
5 1 (8.33%) C# .NET Developer
5 1 (8.33%) C# ASP.NET Developer
5 1 (8.33%) C# Developer
5 1 (8.33%) Data Warehouse Analyst
5 1 (8.33%) Data Warehouse Test Analyst
5 1 (8.33%) ETL Developer
5 1 (8.33%) SQL Data Analyst
5 1 (8.33%) Test Analyst
5 1 (8.33%) Test Data Analyst
Libraries, Frameworks & Software Standards
1 3 (25.00%) .NET
1 3 (25.00%) .NET Framework
1 3 (25.00%) ASP.NET
1 3 (25.00%) Web Services
2 2 (16.67%) Ajax
2 2 (16.67%) CSS
2 2 (16.67%) CSS3
2 2 (16.67%) HTML
2 2 (16.67%) HTML5
2 2 (16.67%) JSON
2 2 (16.67%) Twitter Bootstrap
2 2 (16.67%) WAP
2 2 (16.67%) XML
3 1 (8.33%) ASP.NET MVC
3 1 (8.33%) ASP.NET MVC 5
3 1 (8.33%) ASP.NET Web API
3 1 (8.33%) Entity Framework
3 1 (8.33%) jQuery
3 1 (8.33%) MDX
3 1 (8.33%) WCF
Miscellaneous
1 3 (25.00%) Data Structures
1 3 (25.00%) Management Information System
2 2 (16.67%) Data Centre
2 2 (16.67%) Replication
Operating Systems
1 1 (8.33%) Windows
1 1 (8.33%) Windows 10
1 1 (8.33%) Windows 7
1 1 (8.33%) Windows Server
1 1 (8.33%) Windows Server 2012
Processes & Methodologies
1 7 (58.33%) Business Intelligence
2 5 (41.67%) Migration
3 4 (33.33%) Data Migration
3 4 (33.33%) High Availability
4 3 (25.00%) Asset Management
4 3 (25.00%) Business Continuity
4 3 (25.00%) ETL
4 3 (25.00%) Performance Management
4 3 (25.00%) SDLC
5 2 (16.67%) ITIL
5 2 (16.67%) Load Balancing
5 2 (16.67%) TOGAF
6 1 (8.33%) Continuous Integration
6 1 (8.33%) Integration Testing
6 1 (8.33%) Performance Testing
6 1 (8.33%) Software Testing
6 1 (8.33%) Stress Testing
6 1 (8.33%) System Testing
6 1 (8.33%) Unit Testing
6 1 (8.33%) Validation
Programming Languages
1 7 (58.33%) SQL
2 6 (50.00%) T-SQL
3 3 (25.00%) C#
3 3 (25.00%) PowerShell
4 2 (16.67%) JavaScript
5 1 (8.33%) Data Analysis Expressions (DAX)
Qualifications
1 1 (8.33%) ISEB
1 1 (8.33%) ISTQB
Quality Assurance & Compliance
1 2 (16.67%) COBIT
2 1 (8.33%) Cyber Essentials
2 1 (8.33%) Cyber Essentials PLUS
System Software
1 2 (16.67%) Active Directory
1 2 (16.67%) UAG
Systems Management
1 1 (8.33%) HP Quality Center
1 1 (8.33%) Symantec Enterprise Vault
Vendors
1 6 (50.00%) Microsoft
2 1 (8.33%) Citrix
2 1 (8.33%) RedGate
2 1 (8.33%) Salesforce.com
2 1 (8.33%) Symantec
2 1 (8.33%) Tableau