Period
to 5 June 2020

The following table provides summary statistics for permanent job vacancies advertised in the North West 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 5 June 2020 with a comparison to the same period in the previous 2 years.

Microsoft SQL Server Analysis Services (SSAS)
England > North West
6 months to
5 Jun 2020
Same period 2019 Same period 2018
Rank 170 184 181
Rank change year-on-year +14 -3 -52
Permanent jobs citing SQL Server Analysis Services 81 159 194
As % of all permanent jobs advertised in the North West 1.33% 1.56% 1.60%
As % of the Database & Business Intelligence category 4.59% 5.56% 4.66%
Number of salaries quoted 73 126 191
Median annual salary £48,000 £42,500 £44,000
Median salary % change year-on-year +12.94% -3.41% +10.00%
10th Percentile £36,250 £31,875 £31,250
90th Percentile £76,250 £52,500 £57,500
England median annual salary £55,000 £52,500 £50,000
% change year-on-year +4.76% +5.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 permanent job vacancies advertised in the North West with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
North West
Permanent vacancies with a requirement for database or business intelligence skills 1,766 2,862 4,162
As % of all permanent IT jobs advertised in the North West 29.10% 28.14% 34.32%
Number of salaries quoted 1,455 2,203 3,530
Median annual salary £47,500 £45,000 £42,500
Median salary % change year-on-year +5.56% +5.88% +6.25%
10th Percentile £32,500 £28,750 £27,500
90th Percentile £68,750 £67,500 £65,000
England median annual salary £55,000 £52,500 £50,000
% change year-on-year +4.76% +5.00% +5.26%

SQL Server Analysis Services
Job Vacancy Trend in the North West

Job postings citing SQL Server Analysis Services as a proportion of all IT jobs advertised in the North West.

Job vacancy trend for SQL Server Analysis Services in the North West

SQL Server Analysis Services
Salary Trend in the North West

3-month moving average salary quoted in jobs citing SQL Server Analysis Services in the North West.

Salary trend for SQL Server Analysis Services in the North West

SQL Server Analysis Services
Salary Histogram in the North West

Salary distribution for jobs citing SQL Server Analysis Services in the North West over the 6 months to 5 June 2020.

Salary histogram for SQL Server Analysis Services in the North West

SQL Server Analysis Services
Job Locations in the North West

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 North West region over the 6 months to 5 June 2020. 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
Manchester +34 47 £48,000 +14.29% 4
Cheshire +42 30 £47,500 +5.56% 1
Lancashire +28 3 £50,000 +11.11% 1
Merseyside +1 1 £37,000 -12.94%
SQL Server Analysis Services
England

For the 6 months to 5 June 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 North West region with a requirement for SQL Server Analysis Services.

1 81 (100.00%) SQL Server Integration Services
2 79 (97.53%) Business Intelligence
3 70 (86.42%) SQL Server
3 70 (86.42%) SQL Server Reporting Services
4 62 (76.54%) SQL
5 57 (70.37%) Data Warehouse
6 47 (58.02%) Power BI
6 47 (58.02%) Power Platform
7 38 (46.91%) T-SQL
8 34 (41.98%) ETL
9 33 (40.74%) Microsoft
10 30 (37.04%) Agile Software Development
11 26 (32.10%) Azure
12 24 (29.63%) Visualisation
13 23 (28.40%) Tableau
13 23 (28.40%) Analytics
14 19 (23.46%) Finance
15 16 (19.75%) MDX
16 15 (18.52%) Stakeholder Management
17 14 (17.28%) Data Visualisation
18 13 (16.05%) Kimball Methodology
18 13 (16.05%) QlikView
18 13 (16.05%) Microsoft Excel
18 13 (16.05%) Analytical Skills
19 12 (14.81%) OLAP
19 12 (14.81%) Data Analysis
19 12 (14.81%) Data Analytics
20 11 (13.58%) Microsoft Analysis Services
20 11 (13.58%) Data Management
20 11 (13.58%) Decision-Making

SQL Server Analysis Services
Co-occurring IT Skills in the North West 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 2 (2.47%) Apache Spark
2 1 (1.23%) SAS
2 1 (1.23%) SharePoint
Applications
1 13 (16.05%) Microsoft Excel
2 3 (3.70%) Microsoft Office
2 3 (3.70%) Microsoft PowerPoint
Business Applications
1 1 (1.23%) Dynamics NAV
Cloud Services
1 47 (58.02%) Power Platform
2 26 (32.10%) Azure
3 9 (11.11%) Dynamics 365
4 6 (7.41%) Azure Data Factory
5 3 (3.70%) PowerApps
6 1 (1.23%) AWS
6 1 (1.23%) Google Analytics
Database & Business Intelligence
1 81 (100.00%) SQL Server Integration Services
2 70 (86.42%) SQL Server
2 70 (86.42%) SQL Server Reporting Services
3 57 (70.37%) Data Warehouse
4 47 (58.02%) Power BI
5 13 (16.05%) QlikView
6 12 (14.81%) OLAP
7 11 (13.58%) Microsoft Analysis Services
8 10 (12.35%) PowerPivot
9 9 (11.11%) BusinessObjects
9 9 (11.11%) SQL Server 2016
10 8 (9.88%) Biml
11 6 (7.41%) Relational Database
11 6 (7.41%) SQL Server 2012
12 5 (6.17%) Big Data
13 4 (4.94%) Data Lake
13 4 (4.94%) Enterprise Data Warehouse
13 4 (4.94%) SQL Server 2008
14 3 (3.70%) Data Mining
14 3 (3.70%) Semantic Layer
Development Applications
1 7 (8.64%) Octopus Deploy
1 7 (8.64%) TeamCity
2 3 (3.70%) SQL Server Management Studio (SSMS)
3 1 (1.23%) Git (software)
3 1 (1.23%) JIRA
3 1 (1.23%) MSTest
3 1 (1.23%) NUnit
3 1 (1.23%) Visual Studio
General
1 19 (23.46%) Finance
2 1 (1.23%) Housing Association
2 1 (1.23%) Legal
2 1 (1.23%) Retail
Job Titles
1 51 (62.96%) Developer
2 42 (51.85%) Business Intelligence Developer
3 19 (23.46%) Business Intelligence Lead
4 9 (11.11%) Business Intelligence Specialist
4 9 (11.11%) Data Warehouse Developer
4 9 (11.11%) Senior Developer
4 9 (11.11%) SQL Developer
5 8 (9.88%) Senior Business Intelligence Developer
6 7 (8.64%) Business Intelligence Manager
6 7 (8.64%) Business Manager
6 7 (8.64%) Data Manager
6 7 (8.64%) Lead Developer
7 6 (7.41%) Business Developer
7 6 (7.41%) DBA
7 6 (7.41%) SQL DBA
8 5 (6.17%) SQL BI Developer
9 3 (3.70%) Administrator
9 3 (3.70%) Consultant
10 2 (2.47%) Business Intelligence Consultant
10 2 (2.47%) Solutions Architect
Libraries, Frameworks & Software Standards
1 16 (19.75%) MDX
2 2 (2.47%) Kafka
3 1 (1.23%) JSON
3 1 (1.23%) REST
3 1 (1.23%) XML
Miscellaneous
1 13 (16.05%) Analytical Skills
2 8 (9.88%) Data Structures
3 1 (1.23%) PKI
Operating Systems
1 1 (1.23%) Windows
1 1 (1.23%) Windows Server
1 1 (1.23%) Windows Server 2012
Processes & Methodologies
1 79 (97.53%) Business Intelligence
2 34 (41.98%) ETL
3 30 (37.04%) Agile Software Development
4 24 (29.63%) Visualisation
5 23 (28.40%) Analytics
6 15 (18.52%) Stakeholder Management
7 14 (17.28%) Data Visualisation
8 13 (16.05%) Kimball Methodology
9 12 (14.81%) Data Analysis
9 12 (14.81%) Data Analytics
10 11 (13.58%) Data Management
10 11 (13.58%) Decision-Making
11 9 (11.11%) Inmon Methodology
12 8 (9.88%) E-Commerce
12 8 (9.88%) Migration
12 8 (9.88%) Problem-Solving
13 7 (8.64%) Data Science
13 7 (8.64%) DevOps
13 7 (8.64%) Performance Tuning
13 7 (8.64%) Scrum
Programming Languages
1 62 (76.54%) SQL
2 38 (46.91%) T-SQL
3 9 (11.11%) Data Analysis Expressions (DAX)
4 4 (4.94%) VBA
5 2 (2.47%) Python
6 1 (1.23%) C#
Qualifications
1 1 (1.23%) Degree
1 1 (1.23%) PRINCE2 Certification
Quality Assurance & Compliance
1 8 (9.88%) Data Quality
2 5 (6.17%) GDPR
Vendors
1 33 (40.74%) Microsoft
2 23 (28.40%) Tableau
3 5 (6.17%) Cognos
3 5 (6.17%) IBM
4 3 (3.70%) Databricks
4 3 (3.70%) Oracle
5 2 (2.47%) Telerik
6 1 (1.23%) Alteryx
6 1 (1.23%) Google
6 1 (1.23%) Intapp
6 1 (1.23%) RedGate
6 1 (1.23%) SnapLogic
6 1 (1.23%) TARGIT