Period
to 27 February 2020

The following table provides summary statistics for permanent job vacancies advertised in Guildford with a requirement for SQL Server Analysis Services skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited SQL Server Analysis Services over the 6 months to 27 February 2020 with a comparison to the same period in the previous 2 years.

Microsoft SQL Server Analysis Services (SSAS)
Surrey > Guildford
6 months to
27 Feb 2020
Same period 2019 Same period 2018
Rank 56 88 70
Rank change year-on-year +32 -18 -12
Permanent jobs citing SQL Server Analysis Services 26 9 29
As % of all permanent IT jobs advertised in Guildford 3.58% 1.00% 3.27%
As % of the Database & Business Intelligence category 13.54% 2.95% 10.03%
Number of salaries quoted 26 9 27
Guildford median annual salary £77,500 £60,000 £42,500
Median salary % change year-on-year +29.17% +41.18% -22.73%
10th Percentile £72,500 £55,000 £37,500
90th Percentile £80,000 £65,000 £55,000
Surrey median annual salary £75,000 £57,500 £50,000
% change year-on-year +30.43% +15.00% -9.09%

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 permanent job vacancies advertised in Guildford with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
Guildford
Permanent vacancies with a requirement for database or business intelligence skills 192 305 289
As % of all permanent IT jobs advertised in Guildford 26.41% 33.89% 32.62%
Number of salaries quoted 183 264 267
Guildford median annual salary £50,000 £50,000 £47,500
Median salary % change year-on-year - +5.26% -5.00%
10th Percentile £32,500 £31,000 £28,550
90th Percentile £80,000 £80,000 £66,750
Surrey median annual salary £55,000 £50,000 £47,500
% change year-on-year +10.00% +5.26% -5.00%

SQL Server Analysis Services
Job Vacancy Trend in Guildford

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

Job vacancy trend for SQL Server Analysis Services in Guildford

SQL Server Analysis Services
Salary Trend in Guildford

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing SQL Server Analysis Services in Guildford.

Salary trend for SQL Server Analysis Services in Guildford

SQL Server Analysis Services
Salary Histogram in Guildford

The salary distribution of IT jobs citing SQL Server Analysis Services in Guildford over the 6 months to 27 February 2020.

Salary histogram for SQL Server Analysis Services in Guildford

For the 6 months to 27 February 2020, IT 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 permanent job ads across the Guildford region with a requirement for SQL Server Analysis Services.

1 26 (100.00%) SQL
1 26 (100.00%) Data Warehouse
1 26 (100.00%) Business Intelligence
1 26 (100.00%) Microsoft
1 26 (100.00%) Agile Software Development
1 26 (100.00%) SQL Server Integration Services
1 26 (100.00%) Power BI
1 26 (100.00%) Power Platform
2 25 (96.15%) Technical Leadership
2 25 (96.15%) Data Integration
2 25 (96.15%) Enterprise Data Warehouse
2 25 (96.15%) SQL Server
2 25 (96.15%) Reinsurance
2 25 (96.15%) Management Information System
2 25 (96.15%) Finance
2 25 (96.15%) Tandem
2 25 (96.15%) Data Modelling
3 20 (76.92%) ETL
4 19 (73.08%) Data Mapping
4 19 (73.08%) ETL Development
4 19 (73.08%) Data Quality
4 19 (73.08%) DevOps
5 12 (46.15%) SQL Server Reporting Services
6 11 (42.31%) Data Analysis
6 11 (42.31%) Mentoring
6 11 (42.31%) Analytical Skills
6 11 (42.31%) Data Lake
7 1 (3.85%) Data Analysis Expressions (DAX)
7 1 (3.85%) T-SQL

SQL Server Analysis Services
Co-occurring IT Skills in Guildford 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:

Cloud Services
1 26 (100.00%) Power Platform
Database & Business Intelligence
1 26 (100.00%) Data Warehouse
1 26 (100.00%) Power BI
1 26 (100.00%) SQL Server Integration Services
2 25 (96.15%) Enterprise Data Warehouse
2 25 (96.15%) SQL Server
3 12 (46.15%) SQL Server Reporting Services
4 11 (42.31%) Data Lake
General
1 25 (96.15%) Finance
Job Titles
1 25 (96.15%) Technical Leader
2 8 (30.77%) Business Intelligence Lead
3 1 (3.85%) Business Developer
3 1 (3.85%) Business Intelligence Developer
3 1 (3.85%) Developer
Miscellaneous
1 25 (96.15%) Management Information System
1 25 (96.15%) Reinsurance
1 25 (96.15%) Tandem
2 11 (42.31%) Analytical Skills
Processes & Methodologies
1 26 (100.00%) Agile Software Development
1 26 (100.00%) Business Intelligence
2 25 (96.15%) Data Integration
2 25 (96.15%) Data Modelling
2 25 (96.15%) Technical Leadership
3 20 (76.92%) ETL
4 19 (73.08%) Data Mapping
4 19 (73.08%) DevOps
4 19 (73.08%) ETL Development
5 11 (42.31%) Data Analysis
5 11 (42.31%) Mentoring
Programming Languages
1 26 (100.00%) SQL
2 1 (3.85%) Data Analysis Expressions (DAX)
2 1 (3.85%) T-SQL
Quality Assurance & Compliance
1 19 (73.08%) Data Quality
Vendors
1 26 (100.00%) Microsoft