Period
to 10 July 2020

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

Microsoft SQL Server Analysis Services (SSAS)
England > North of England
6 months to
10 Jul 2020
Same period 2019 Same period 2018
Rank 217 213 177
Rank change year-on-year -4 -36 -55
Permanent jobs citing SQL Server Analysis Services 120 324 451
As % of all permanent jobs advertised in the North of England 1.15% 1.65% 1.86%
As % of the Database & Business Intelligence category 4.10% 6.30% 6.04%
Number of salaries quoted 109 289 435
Median annual salary £45,000 £45,000 £45,000
10th Percentile £34,450 £32,000 £31,250
90th Percentile £63,000 £56,050 £60,000
England median annual salary £55,000 £52,500 £50,000
% change year-on-year +4.76% +5.00% +3.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 the North of England with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
North of England
Permanent vacancies with a requirement for database or business intelligence skills 2,930 5,146 7,464
As % of all permanent IT jobs advertised in the North of England 27.99% 26.16% 30.81%
Number of salaries quoted 2,466 4,190 6,379
Median annual salary £46,000 £43,500 £42,500
Median salary % change year-on-year +5.75% +2.35% +6.25%
10th Percentile £31,250 £28,750 £27,500
90th Percentile £67,500 £65,000 £62,500
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 of England

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

Job vacancy trend for SQL Server Analysis Services in the North of England

SQL Server Analysis Services
Salary Trend in the North of England

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

Salary trend for SQL Server Analysis Services in the North of England

SQL Server Analysis Services
Salary Histogram in the North of England

Salary distribution for jobs citing SQL Server Analysis Services in the North of England over the 6 months to 10 July 2020.

Salary histogram for SQL Server Analysis Services in the North of England

SQL Server Analysis Services
Job Locations in the North of England

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 of England region over the 6 months to 10 July 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
North West +40 72 £49,000 +15.29% 5
Yorkshire -5 29 £42,500 -5.56% 3
North East +25 19 £40,000 +1.27%
SQL Server Analysis Services
England

For the 6 months to 10 July 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 of England region with a requirement for SQL Server Analysis Services.

1 116 (96.67%) SQL Server Integration Services
2 100 (83.33%) Business Intelligence
3 97 (80.83%) SQL Server
4 95 (79.17%) SQL Server Reporting Services
5 77 (64.17%) SQL
6 64 (53.33%) Data Warehouse
7 62 (51.67%) Microsoft
8 55 (45.83%) Power BI
8 55 (45.83%) Power Platform
9 46 (38.33%) ETL
10 45 (37.50%) T-SQL
11 34 (28.33%) Azure
12 29 (24.17%) Visualisation
13 26 (21.67%) Agile Software Development
14 25 (20.83%) Tableau
15 21 (17.50%) Analytics
16 20 (16.67%) Analytical Skills
17 18 (15.00%) Data Analysis
17 18 (15.00%) Finance
17 18 (15.00%) Microsoft Excel
17 18 (15.00%) Data Modelling
18 16 (13.33%) Data Visualisation
18 16 (13.33%) Data Quality
19 15 (12.50%) QlikView
19 15 (12.50%) Stakeholder Management
20 14 (11.67%) Microsoft Analysis Services
20 14 (11.67%) MDX
20 14 (11.67%) Microsoft Office
20 14 (11.67%) Decision-Making
21 13 (10.83%) Problem-Solving

SQL Server Analysis Services
Co-occurring IT Skills in the North of England 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 (2.50%) SharePoint
2 2 (1.67%) Apache Spark
2 2 (1.67%) SAS
2 2 (1.67%) WebLogic
Applications
1 18 (15.00%) Microsoft Excel
2 14 (11.67%) Microsoft Office
3 3 (2.50%) Microsoft PowerPoint
4 2 (1.67%) MS Visio
Business Applications
1 1 (0.83%) Dynamics NAV
Cloud Services
1 55 (45.83%) Power Platform
2 34 (28.33%) Azure
3 9 (7.50%) Azure Data Factory
3 9 (7.50%) Dynamics 365
4 3 (2.50%) AWS
4 3 (2.50%) PowerApps
5 2 (1.67%) IaaS
5 2 (1.67%) Logic Apps
5 2 (1.67%) PaaS
5 2 (1.67%) SaaS
6 1 (0.83%) Amazon Kinesis
6 1 (0.83%) GCP
6 1 (0.83%) Google Analytics
Database & Business Intelligence
1 116 (96.67%) SQL Server Integration Services
2 97 (80.83%) SQL Server
3 95 (79.17%) SQL Server Reporting Services
4 64 (53.33%) Data Warehouse
5 55 (45.83%) Power BI
6 15 (12.50%) QlikView
7 14 (11.67%) Microsoft Analysis Services
8 12 (10.00%) OLAP
9 9 (7.50%) PowerPivot
9 9 (7.50%) SQL Server 2016
10 8 (6.67%) Biml
10 8 (6.67%) Data Lake
10 8 (6.67%) Oracle Database
10 8 (6.67%) SQL Server 2012
11 7 (5.83%) BusinessObjects
11 7 (5.83%) Relational Database
11 7 (5.83%) ZAP BI
12 6 (5.00%) Big Data
12 6 (5.00%) Enterprise Data Warehouse
13 4 (3.33%) SQL Server 2008
Development Applications
1 7 (5.83%) Octopus Deploy
1 7 (5.83%) TeamCity
2 3 (2.50%) Visual Studio Team System
3 2 (1.67%) SQL Server Management Studio (SSMS)
4 1 (0.83%) Git (software)
4 1 (0.83%) JIRA
4 1 (0.83%) MSTest
4 1 (0.83%) NUnit
4 1 (0.83%) Toad
4 1 (0.83%) Visual Studio
General
1 18 (15.00%) Finance
2 3 (2.50%) Retail
3 2 (1.67%) Local Government
3 2 (1.67%) Public Sector
4 1 (0.83%) Advertising
4 1 (0.83%) Housing Association
4 1 (0.83%) Marketing
4 1 (0.83%) Police
Job Titles
1 71 (59.17%) Developer
2 54 (45.00%) Business Intelligence Developer
3 20 (16.67%) Business Intelligence Lead
4 17 (14.17%) DBA
5 15 (12.50%) SQL DBA
5 15 (12.50%) SQL Developer
6 8 (6.67%) Business Intelligence Specialist
6 8 (6.67%) Lead Developer
7 7 (5.83%) Analyst
7 7 (5.83%) Business Developer
7 7 (5.83%) Data Warehouse Developer
7 7 (5.83%) Senior Business Intelligence Developer
7 7 (5.83%) Senior Developer
7 7 (5.83%) SQL Server DBA
8 6 (5.00%) Business Intelligence Analyst
9 5 (4.17%) Business Intelligence Manager
9 5 (4.17%) Business Manager
9 5 (4.17%) Data Manager
9 5 (4.17%) SQL BI Developer
10 4 (3.33%) Consultant
Libraries, Frameworks & Software Standards
1 14 (11.67%) MDX
2 7 (5.83%) Middleware
3 4 (3.33%) .NET
4 3 (2.50%) Kafka
5 2 (1.67%) Oracle Fusion
6 1 (0.83%) REST
6 1 (0.83%) SOAP
6 1 (0.83%) Web Services
Miscellaneous
1 20 (16.67%) Analytical Skills
2 10 (8.33%) Data Structures
3 8 (6.67%) Clustering
4 3 (2.50%) Management Information System
5 2 (1.67%) Tandem
6 1 (0.83%) Client/Server
6 1 (0.83%) Credit Risk
6 1 (0.83%) NHS
6 1 (0.83%) Replication
6 1 (0.83%) User Experience
Operating Systems
1 2 (1.67%) Linux
1 2 (1.67%) Solaris
1 2 (1.67%) Windows
2 1 (0.83%) Windows Server
2 1 (0.83%) Windows Server 2012
Processes & Methodologies
1 100 (83.33%) Business Intelligence
2 46 (38.33%) ETL
3 29 (24.17%) Visualisation
4 26 (21.67%) Agile Software Development
5 21 (17.50%) Analytics
6 18 (15.00%) Data Analysis
6 18 (15.00%) Data Modelling
7 16 (13.33%) Data Visualisation
8 15 (12.50%) Stakeholder Management
9 14 (11.67%) Decision-Making
10 13 (10.83%) Kimball Methodology
10 13 (10.83%) Problem-Solving
11 11 (9.17%) Data Analytics
11 11 (9.17%) DevOps
12 10 (8.33%) Data Management
12 10 (8.33%) Performance Tuning
13 9 (7.50%) Inmon Methodology
14 8 (6.67%) ERP
14 8 (6.67%) High Availability
14 8 (6.67%) Migration
Programming Languages
1 77 (64.17%) SQL
2 45 (37.50%) T-SQL
3 10 (8.33%) Data Analysis Expressions (DAX)
4 6 (5.00%) VBA
5 4 (3.33%) C#
6 3 (2.50%) Python
7 1 (0.83%) C
7 1 (0.83%) PL/SQL
Qualifications
1 5 (4.17%) Degree
2 4 (3.33%) Microsoft Certification
3 1 (0.83%) Computer Science Degree
3 1 (0.83%) MCSA
3 1 (0.83%) PRINCE2 Certification
Quality Assurance & Compliance
1 16 (13.33%) Data Quality
2 3 (2.50%) GDPR
Systems Management
1 1 (0.83%) Microsoft Clustering
Vendors
1 62 (51.67%) Microsoft
2 25 (20.83%) Tableau
3 13 (10.83%) Oracle
4 7 (5.83%) Sage
5 3 (2.50%) Databricks
6 2 (1.67%) Cognos
6 2 (1.67%) IBM
7 1 (0.83%) Alteryx
7 1 (0.83%) Google
7 1 (0.83%) RedGate
7 1 (0.83%) SAP
7 1 (0.83%) TARGIT
7 1 (0.83%) Teradata
7 1 (0.83%) VMware