Period
to 18 November 2017

The following table provides summary statistics for permanent job vacancies advertised in Watford 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 18 November 2017 with a comparison to the same period in the previous 2 years.

Microsoft SQL Server Analysis Services (SSAS)
Hertfordshire > Watford
6 months to
18 Nov 2017
Same period 2016 Same period 2015
Rank 76 74 83
Rank change year-on-year -2 +9 +22
Permanent jobs citing SQL Server Analysis Services 24 21 19
As % of all permanent IT jobs advertised in Watford 2.46% 2.02% 1.78%
As % of the Database & Business Intelligence category 8.42% 10.29% 5.40%
Number of salaries quoted 18 21 15
Watford median annual salary £55,000 £55,000 £49,000
Median salary % change year-on-year - +12.24% +3.16%
10th Percentile £48,000 £51,250 £29,500
90th Percentile £56,625 £55,000 £50,500
Hertfordshire median annual salary £47,500 £52,500 £45,000
% change year-on-year -9.52% +16.67% -

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 Watford with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
Watford
Permanent vacancies with a requirement for database or business intelligence skills 285 204 352
As % of all permanent IT jobs advertised in Watford 29.17% 19.60% 32.96%
Number of salaries quoted 248 189 277
Watford median annual salary £52,500 £50,000 £45,000
Median salary % change year-on-year +5.00% +11.11% +8.43%
10th Percentile £33,750 £32,500 £28,300
90th Percentile £68,750 £72,500 £61,100
Hertfordshire median annual salary £47,500 £50,000 £45,000
% change year-on-year -5.00% +11.11% -

SQL Server Analysis Services
Job Vacancy Trend in Watford

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

Job vacancy trend for SQL Server Analysis Services in Watford

SQL Server Analysis Services
Salary Trend in Watford

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

Salary trend for SQL Server Analysis Services in Watford

For the 6 months to 18 November 2017, IT 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 job ads across the Watford region with a requirement for SQL Server Analysis Services.

1 24 (100.00%) SQL
1 24 (100.00%) SQL Server
1 24 (100.00%) ETL
1 24 (100.00%) Business Intelligence
1 24 (100.00%) SQL Server Integration Services
2 22 (91.67%) .NET
2 22 (91.67%) SQL Server 2012
3 21 (87.50%) T-SQL
4 19 (79.17%) MDX
4 19 (79.17%) Data Warehouse
5 17 (70.83%) Data Modelling
5 17 (70.83%) Microsoft
5 17 (70.83%) Kimball Methodology
5 17 (70.83%) Power BI
6 16 (66.67%) ETL Development
6 16 (66.67%) SQL Server 2014
6 16 (66.67%) SQL Server 2016
6 16 (66.67%) Inmon Methodology
6 16 (66.67%) Performance Tuning
6 16 (66.67%) Cognos
6 16 (66.67%) IBM
6 16 (66.67%) MS Access
6 16 (66.67%) SOAP
6 16 (66.67%) Web Services
6 16 (66.67%) VBA
6 16 (66.67%) Unit Testing
6 16 (66.67%) PowerShell
6 16 (66.67%) Database Tuning
6 16 (66.67%) Team Foundation Server
6 16 (66.67%) REST

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

Applications
1 1 (4.17%) Microsoft Excel
Business Applications
1 3 (12.50%) Dynamics CRM
Communications & Networking
1 14 (58.33%) DNS
1 14 (58.33%) Firewall
Database & Business Intelligence
1 24 (100.00%) SQL Server
1 24 (100.00%) SQL Server Integration Services
2 22 (91.67%) SQL Server 2012
3 19 (79.17%) Data Warehouse
4 17 (70.83%) Power BI
5 16 (66.67%) MS Access
5 16 (66.67%) SQL Server 2014
5 16 (66.67%) SQL Server 2016
6 14 (58.33%) SAP Data Services
7 9 (37.50%) SAP BW
8 8 (33.33%) SQL Server Reporting Services
9 4 (16.67%) OLAP
9 4 (16.67%) RDBMS
9 4 (16.67%) Relational Database
10 1 (4.17%) Big Data
10 1 (4.17%) Data Lake
10 1 (4.17%) Microsoft Analysis Services
10 1 (4.17%) OLAP Cube
Development Applications
1 16 (66.67%) Team Foundation Server
2 1 (4.17%) Visual Studio
General
1 2 (8.33%) Finance
2 1 (4.17%) Legal
Job Titles
1 24 (100.00%) Developer
2 21 (87.50%) Business Intelligence Developer
3 7 (29.17%) SQL Developer
4 5 (20.83%) Microsoft BI Developer
5 4 (16.67%) Microsoft Developer
5 4 (16.67%) SQL BI Developer
6 3 (12.50%) DBA
6 3 (12.50%) SQL DBA
7 2 (8.33%) SQL Server BI Developer
7 2 (8.33%) SQL Server Developer
7 2 (8.33%) SSAS Developer
7 2 (8.33%) SSIS Developer
8 1 (4.17%) Analyst
8 1 (4.17%) Analyst Developer
8 1 (4.17%) Business Intelligence Analyst
8 1 (4.17%) Data Warehouse Developer
8 1 (4.17%) Developer Analyst
8 1 (4.17%) ETL Developer
8 1 (4.17%) SQL Server Data Warehouse Developer
Libraries, Frameworks & Software Standards
1 22 (91.67%) .NET
2 19 (79.17%) MDX
3 16 (66.67%) REST
3 16 (66.67%) SOAP
3 16 (66.67%) Web Services
Miscellaneous
1 4 (16.67%) Analytical Skills
2 1 (4.17%) Computer Science
2 1 (4.17%) Management Information System
Operating Systems
1 3 (12.50%) Windows
1 3 (12.50%) Windows Server
Processes & Methodologies
1 24 (100.00%) Business Intelligence
1 24 (100.00%) ETL
2 17 (70.83%) Data Modelling
2 17 (70.83%) Kimball Methodology
3 16 (66.67%) Database Tuning
3 16 (66.67%) ETL Development
3 16 (66.67%) Inmon Methodology
3 16 (66.67%) Performance Tuning
3 16 (66.67%) Unit Testing
4 5 (20.83%) CRM
5 4 (16.67%) Time Management
6 3 (12.50%) Collaborative Working
6 3 (12.50%) Data Migration
6 3 (12.50%) Data Protection
6 3 (12.50%) Migration
7 2 (8.33%) Analytics
8 1 (4.17%) Agile Software Development
8 1 (4.17%) Data Governance
8 1 (4.17%) KYC
8 1 (4.17%) SDLC
Programming Languages
1 24 (100.00%) SQL
2 21 (87.50%) T-SQL
3 16 (66.67%) PowerShell
3 16 (66.67%) VBA
4 4 (16.67%) C#
5 1 (4.17%) VB.NET
Qualifications
1 1 (4.17%) Degree
Vendors
1 17 (70.83%) Microsoft
2 16 (66.67%) Cognos
2 16 (66.67%) IBM
3 11 (45.83%) SAP
4 3 (12.50%) RedGate