Period
to 21 August 2018

The following table provides summary statistics for permanent job vacancies advertised in Hertfordshire 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 21 August 2018 with a comparison to the same period in the previous 2 years.

Microsoft SQL Server Analysis Services (SSAS)
East of England > Hertfordshire
6 months to
21 Aug 2018
Same period 2017 Same period 2016
Rank 146 177 177
Rank change year-on-year +31 0 -4
Permanent jobs citing SQL Server Analysis Services 63 36 36
As % of all permanent IT jobs advertised in Hertfordshire 1.48% 0.87% 0.80%
As % of the Database & Business Intelligence category 5.48% 3.25% 3.13%
Number of salaries quoted 54 28 35
Hertfordshire median annual salary £52,500 £42,500 £52,500
Median salary % change year-on-year +23.53% -19.05% +16.67%
10th Percentile £40,000 £29,000 £31,500
90th Percentile £60,000 £50,000 £55,000
East of England median annual salary £47,500 £42,500 £44,500
% change year-on-year +11.76% -4.49% -6.32%

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

All Database and Business Intelligence Skills
Hertfordshire
Permanent vacancies with a requirement for database or business intelligence skills 1,150 1,109 1,151
As % of all permanent IT jobs advertised in Hertfordshire 27.00% 26.94% 25.58%
Number of salaries quoted 951 989 981
Hertfordshire median annual salary £50,000 £47,500 £45,000
Median salary % change year-on-year +5.26% +5.56% -
10th Percentile £32,500 £31,250 £28,000
90th Percentile £73,750 £70,000 £68,750
East of England median annual salary £47,500 £45,000 £42,500
% change year-on-year +5.56% +5.88% -

SQL Server Analysis Services
Job Vacancy Trend in Hertfordshire

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

Job vacancy trend for SQL Server Analysis Services in Hertfordshire

SQL Server Analysis Services
Salary Trend in Hertfordshire

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

Salary trend for SQL Server Analysis Services in Hertfordshire

SQL Server Analysis Services
Salary Histogram in Hertfordshire

The salary distribution of IT jobs citing SQL Server Analysis Services in Hertfordshire over the 6 months to 21 August 2018.

Salary histogram for SQL Server Analysis Services in Hertfordshire

SQL Server Analysis Services
Job Locations in Hertfordshire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing SQL Server Analysis Services within the Hertfordshire region over the 6 months to 21 August 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
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Welwyn Garden City - 23 £55,000 - 2
Watford +16 16 £57,500 +27.78%
Hemel Hempstead +20 10 £35,000 -17.65%
Hatfield -15 4 £50,000 +17.65% 1
Rickmansworth - 2 £55,000 -
Letchworth - 1 - -
SQL Server Analysis Services
East of England

For the 6 months to 21 August 2018, 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 Hertfordshire region with a requirement for SQL Server Analysis Services.

1 63 (100.00%) SQL Server Integration Services
2 62 (98.41%) SQL Server Reporting Services
3 61 (96.83%) Business Intelligence
4 59 (93.65%) SQL Server
5 58 (92.06%) T-SQL
5 58 (92.06%) Microsoft
6 57 (90.48%) SQL
7 53 (84.13%) Data Warehouse
8 48 (76.19%) ETL
8 48 (76.19%) Power BI
9 37 (58.73%) Visualisation
10 30 (47.62%) VBA
11 28 (44.44%) Analytical Skills
11 28 (44.44%) Microsoft Excel
12 20 (31.75%) Microsoft Azure
13 17 (26.98%) SQL Server 2012
13 17 (26.98%) Finance
14 16 (25.40%) Data Analysis Expressions (DAX)
14 16 (25.40%) Degree
14 16 (25.40%) MDX
15 15 (23.81%) Agile Software Development
15 15 (23.81%) Marketing
16 14 (22.22%) Tableau
17 13 (20.63%) MongoDB
17 13 (20.63%) Cognos
17 13 (20.63%) Greenfield Project
18 12 (19.05%) OLAP
18 12 (19.05%) Data Visualisation
18 12 (19.05%) Business Analysis
19 11 (17.46%) Cognos Business Intelligence

SQL Server Analysis Services
Co-occurring IT Skills in Hertfordshire 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 1 (1.59%) IBM Notes
1 1 (1.59%) IIS
1 1 (1.59%) SharePoint
1 1 (1.59%) SharePoint 2010
Applications
1 28 (44.44%) Microsoft Excel
2 1 (1.59%) InfoPath
2 1 (1.59%) Microsoft Office
Business Applications
1 11 (17.46%) Cognos Business Intelligence
1 11 (17.46%) Cognos TM1
Cloud Services
1 20 (31.75%) Microsoft Azure
Communications & Networking
1 4 (6.35%) DNS
1 4 (6.35%) Firewall
Database & Business Intelligence
1 63 (100.00%) SQL Server Integration Services
2 62 (98.41%) SQL Server Reporting Services
3 59 (93.65%) SQL Server
4 53 (84.13%) Data Warehouse
5 48 (76.19%) Power BI
6 17 (26.98%) SQL Server 2012
7 13 (20.63%) MongoDB
8 12 (19.05%) OLAP
9 11 (17.46%) Data Mining
9 11 (17.46%) Microsoft Analysis Services
10 10 (15.87%) NoSQL
11 8 (12.70%) MS Access
11 8 (12.70%) Snowflake Schema
11 8 (12.70%) SQL Server 2016
11 8 (12.70%) Star Schema
12 7 (11.11%) SQL Server 2008
13 6 (9.52%) Big Data
14 5 (7.94%) SAP Data Services
15 4 (6.35%) Qlik Sense
15 4 (6.35%) QlikView
Development Applications
1 8 (12.70%) SQL Server Management Studio (SSMS)
1 8 (12.70%) Team Foundation Server
General
1 17 (26.98%) Finance
2 15 (23.81%) Marketing
3 8 (12.70%) Advertising
4 3 (4.76%) Retail
Job Titles
1 36 (57.14%) Developer
2 30 (47.62%) Business Intelligence Developer
3 16 (25.40%) Analyst
4 10 (15.87%) Business Intelligence Analyst
4 10 (15.87%) SQL Developer
5 8 (12.70%) Senior Business Intelligence Developer
5 8 (12.70%) Senior Developer
6 7 (11.11%) SSIS Developer
7 6 (9.52%) Data Analyst
7 6 (9.52%) Data Warehouse Developer
7 6 (9.52%) ETL Developer
7 6 (9.52%) SQL BI Developer
8 5 (7.94%) Business Intelligence Lead
9 4 (6.35%) Analyst Developer
9 4 (6.35%) Database Developer
9 4 (6.35%) Microsoft BI Developer
9 4 (6.35%) Microsoft Developer
9 4 (6.35%) Report Developer
9 4 (6.35%) SQL Database Developer
10 3 (4.76%) Team Leader
Libraries, Frameworks & Software Standards
1 16 (25.40%) MDX
2 10 (15.87%) Web Services
3 6 (9.52%) .NET
4 5 (7.94%) REST
4 5 (7.94%) SOAP
5 1 (1.59%) .NET Framework
5 1 (1.59%) SAP XI
5 1 (1.59%) XML
Miscellaneous
1 28 (44.44%) Analytical Skills
2 13 (20.63%) Greenfield Project
3 4 (6.35%) Computer Science
3 4 (6.35%) Management Information System
Operating Systems
1 3 (4.76%) Linux
2 1 (1.59%) Windows
Processes & Methodologies
1 61 (96.83%) Business Intelligence
2 48 (76.19%) ETL
3 37 (58.73%) Visualisation
4 15 (23.81%) Agile Software Development
5 12 (19.05%) Business Analysis
5 12 (19.05%) Data Visualisation
6 11 (17.46%) Business Development
6 11 (17.46%) Dashboard Development
6 11 (17.46%) Data Extraction
6 11 (17.46%) Dimensional Modelling
7 10 (15.87%) Critical Thinking
7 10 (15.87%) Data Architecture
8 9 (14.29%) Kimball Methodology
9 8 (12.70%) Data Modelling
9 8 (12.70%) Database Tuning
9 8 (12.70%) ETL Development
9 8 (12.70%) Performance Tuning
9 8 (12.70%) Unit Testing
10 7 (11.11%) Analytics
11 4 (6.35%) Continuous Improvement
Programming Languages
1 58 (92.06%) T-SQL
2 57 (90.48%) SQL
3 30 (47.62%) VBA
4 16 (25.40%) Data Analysis Expressions (DAX)
5 11 (17.46%) C#
6 10 (15.87%) Go
6 10 (15.87%) Python
7 9 (14.29%) PowerShell
8 1 (1.59%) Java
Qualifications
1 16 (25.40%) Degree
2 1 (1.59%) CBAP
2 1 (1.59%) ISEB
Vendors
1 58 (92.06%) Microsoft
2 14 (22.22%) Tableau
3 13 (20.63%) Cognos
4 6 (9.52%) SAP
5 2 (3.17%) Sybase
6 1 (1.59%) IBM
6 1 (1.59%) Lotus
6 1 (1.59%) MicroStrategy
6 1 (1.59%) Nintex