Period
to 21 January 2018

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

Microsoft SQL Server Integration Services (SSIS)
Hampshire > Portsmouth
6 months to
21 Jan 2018
Same period 2017 Same period 2016
Rank 63 57 61
Rank change year-on-year -6 +4 +30
Permanent jobs citing SQL Server Integration Services 22 21 30
As % of all permanent IT jobs advertised in Portsmouth 3.48% 3.37% 3.84%
As % of the Database & Business Intelligence category 10.00% 8.24% 9.87%
Number of salaries quoted 19 20 30
Portsmouth median annual salary £42,500 £40,000 £32,500
Median salary % change year-on-year +6.25% +23.08% +12.07%
10th Percentile £32,150 £31,250 £26,500
90th Percentile £50,250 £47,500 £47,500
Hampshire median annual salary £40,000 £42,500 £40,000
% change year-on-year -5.88% +6.25% -11.11%

SQL Server Integration 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 Portsmouth with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
Portsmouth
Permanent vacancies with a requirement for database or business intelligence skills 220 255 304
As % of all permanent IT jobs advertised in Portsmouth 34.76% 40.93% 38.87%
Number of salaries quoted 177 241 283
Portsmouth median annual salary £42,500 £40,000 £42,500
Median salary % change year-on-year +6.25% -5.88% -
10th Percentile £24,000 £27,500 £28,250
90th Percentile £57,500 £56,250 £58,750
Hampshire median annual salary £40,000 £40,000 £41,500
% change year-on-year - -3.61% +6.41%

SQL Server Integration Services
Job Vacancy Trend in Portsmouth

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

Job vacancy trend for SQL Server Integration Services in Portsmouth

SQL Server Integration Services
Salary Trend in Portsmouth

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

Salary trend for SQL Server Integration Services in Portsmouth

SQL Server Integration Services
Salary Histogram in Portsmouth

The salary distribution of IT jobs citing SQL Server Integration Services in Portsmouth over the 6 months to 21 January 2018.

Salary histogram for SQL Server Integration Services in Portsmouth

For the 6 months to 21 January 2018, IT jobs citing SQL Server Integration 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 Portsmouth region with a requirement for SQL Server Integration Services.

1 22 (100.00%) SQL Server Reporting Services
2 20 (90.91%) SQL
3 18 (81.82%) SQL Server
4 15 (68.18%) SQL Server Analysis Services
5 14 (63.64%) Business Intelligence
5 14 (63.64%) Microsoft
6 12 (54.55%) SQL Server 2016
7 9 (40.91%) Data Warehouse
8 7 (31.82%) Crystal Reports
8 7 (31.82%) Power BI
9 6 (27.27%) SQL Server 2012
9 6 (27.27%) VB.NET
9 6 (27.27%) .NET
9 6 (27.27%) C#
9 6 (27.27%) Advertising
10 5 (22.73%) Security Cleared
11 4 (18.18%) Microsoft Azure
11 4 (18.18%) SC Cleared
11 4 (18.18%) ETL
11 4 (18.18%) Microsoft Excel
11 4 (18.18%) T-SQL
12 3 (13.64%) Data Modelling
12 3 (13.64%) Microsoft Certification
12 3 (13.64%) Performance Tuning
12 3 (13.64%) Dashboard Development
12 3 (13.64%) SQL Server 2008
12 3 (13.64%) Learning Management System
13 2 (9.09%) Moodle
13 2 (9.09%) Blackboard
13 2 (9.09%) PerformancePoint

SQL Server Integration Services
Co-occurring IT Skills in Portsmouth 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 (9.09%) Apache
1 2 (9.09%) CMS
1 2 (9.09%) Moodle
1 2 (9.09%) SharePoint
1 2 (9.09%) Tomcat
Applications
1 4 (18.18%) Microsoft Excel
2 2 (9.09%) MS Visio
Cloud Services
1 4 (18.18%) Microsoft Azure
2 1 (4.55%) Amazon AWS
2 1 (4.55%) SaaS
Database & Business Intelligence
1 22 (100.00%) SQL Server Reporting Services
2 18 (81.82%) SQL Server
3 15 (68.18%) SQL Server Analysis Services
4 12 (54.55%) SQL Server 2016
5 9 (40.91%) Data Warehouse
6 7 (31.82%) Crystal Reports
6 7 (31.82%) Power BI
7 6 (27.27%) SQL Server 2012
8 3 (13.64%) SQL Server 2008
9 2 (9.09%) BusinessObjects
9 2 (9.09%) Microsoft Power View
9 2 (9.09%) OLAP
9 2 (9.09%) PerformancePoint
9 2 (9.09%) QlikView
9 2 (9.09%) Relational Database
10 1 (4.55%) Amazon RDS
10 1 (4.55%) BusinessObjects Web Intelligence
10 1 (4.55%) Lumira
10 1 (4.55%) RDBMS
10 1 (4.55%) Star Schema
General
1 6 (27.27%) Advertising
2 1 (4.55%) Finance
2 1 (4.55%) Law
2 1 (4.55%) Retail
Job Titles
1 15 (68.18%) Developer
2 9 (40.91%) Business Intelligence Developer
3 6 (27.27%) Analyst
3 6 (27.27%) Business Developer
4 4 (18.18%) Data Warehouse Developer
4 4 (18.18%) SQL Analyst
4 4 (18.18%) SSRS Developer
5 3 (13.64%) Applications Support
5 3 (13.64%) Applications Support Analyst
5 3 (13.64%) Business Intelligence Analyst
5 3 (13.64%) Senior Data Warehouse Developer
5 3 (13.64%) Senior Developer
5 3 (13.64%) SQL Developer
5 3 (13.64%) Support Analyst
6 2 (9.09%) DBA
6 2 (9.09%) Report Analyst
6 2 (9.09%) SQL BI Developer
6 2 (9.09%) SQL DBA
6 2 (9.09%) SQL Support Analyst
6 2 (9.09%) Systems Support Analyst
Libraries, Frameworks & Software Standards
1 6 (27.27%) .NET
2 1 (4.55%) XML
Miscellaneous
1 3 (13.64%) Learning Management System
2 1 (4.55%) Greenfield Project
Processes & Methodologies
1 14 (63.64%) Business Intelligence
2 4 (18.18%) ETL
3 3 (13.64%) Dashboard Development
3 3 (13.64%) Data Modelling
3 3 (13.64%) Performance Tuning
4 2 (9.09%) Data Migration
4 2 (9.09%) Dimensional Modelling
4 2 (9.09%) Migration
4 2 (9.09%) Release Management
4 2 (9.09%) User Acceptance Testing
5 1 (4.55%) Agile Software Development
5 1 (4.55%) Analytics
5 1 (4.55%) Complex ETL
5 1 (4.55%) ETL Development
5 1 (4.55%) ITIL
5 1 (4.55%) Performance Management
5 1 (4.55%) Software Engineering
5 1 (4.55%) Visualisation
Programming Languages
1 20 (90.91%) SQL
2 6 (27.27%) C#
2 6 (27.27%) VB.NET
3 4 (18.18%) T-SQL
4 2 (9.09%) PL/SQL
5 1 (4.55%) JavaScript
5 1 (4.55%) PowerShell
5 1 (4.55%) VBScript
Qualifications
1 5 (22.73%) Security Cleared
2 4 (18.18%) SC Cleared
3 3 (13.64%) Microsoft Certification
4 2 (9.09%) Degree
4 2 (9.09%) MCSA
4 2 (9.09%) MCSE
5 1 (4.55%) MCITP
5 1 (4.55%) MCTS
Quality Assurance & Compliance
1 1 (4.55%) ISO/IEC 27001
1 1 (4.55%) QA
Vendors
1 14 (63.64%) Microsoft
2 2 (9.09%) Adobe
2 2 (9.09%) Blackboard
3 1 (4.55%) Cognos
3 1 (4.55%) SAP
3 1 (4.55%) Tableau
3 1 (4.55%) Talend