Period
to 18 November 2017

The following table provides summary statistics for permanent job vacancies advertised in Cirencester with a requirement for SQL skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited SQL over the 6 months to 18 November 2017 with a comparison to the same period in the previous 2 years.

SQL (Structured Query Language)
Gloucestershire > Cirencester
6 months to
18 Nov 2017
Same period 2016 Same period 2015
Rank 3 3 1
Rank change year-on-year 0 -2 +5
Permanent jobs citing SQL 70 33 47
As % of all permanent IT jobs advertised in Cirencester 33.82% 27.97% 37.60%
As % of the Programming Languages category 66.04% 39.76% 55.95%
Number of salaries quoted 46 40 51
Cirencester median annual salary £35,250 £45,000 £40,000
Median salary % change year-on-year -21.67% +12.50% +11.89%
10th Percentile £25,500 £25,350 £23,500
90th Percentile £52,500 £56,250 £50,000
Gloucestershire median annual salary £40,000 £42,500 £40,000
% change year-on-year -5.88% +6.25% +3.90%

SQL is in the Programming Languages category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Cirencester with a requirement for coding skills.

All Programming Languages
Cirencester
Permanent vacancies with a requirement for coding skills 106 83 84
As % of all permanent IT jobs advertised in Cirencester 51.21% 70.34% 67.20%
Number of salaries quoted 77 71 76
Cirencester median annual salary £40,000 £42,500 £40,000
Median salary % change year-on-year -5.88% +6.25% +14.29%
10th Percentile £25,500 £27,500 £23,500
90th Percentile £53,950 £62,500 £49,000
Gloucestershire median annual salary £45,000 £42,500 £40,500
% change year-on-year +5.88% +4.94% +8.00%

SQL
Job Vacancy Trend in Cirencester

Job postings citing SQL as a percentage of all IT jobs advertised in Cirencester.

Job vacancy trend for SQL in Cirencester

SQL
Salary Trend in Cirencester

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing SQL in Cirencester.

Salary trend for SQL in Cirencester

SQL
Salary Histogram in Cirencester

The salary distribution of IT jobs citing SQL in Cirencester over the 6 months to 18 November 2017.

Salary histogram for SQL in Cirencester

For the 6 months to 18 November 2017, IT jobs citing SQL 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 Cirencester region with a requirement for SQL.

1 34 (48.57%) Finance
2 31 (44.29%) SQL Server
3 30 (42.86%) Degree
4 27 (38.57%) Analytical Skills
5 23 (32.86%) Agile Software Development
6 20 (28.57%) Data Analysis
6 20 (28.57%) Business Intelligence
7 19 (27.14%) Test Automation
8 18 (25.71%) SOAP
9 17 (24.29%) .NET
9 17 (24.29%) SoapUI
10 16 (22.86%) Waterfall
10 16 (22.86%) Windows
10 16 (22.86%) Microsoft Excel
10 16 (22.86%) Data Warehouse
11 15 (21.43%) Data Modelling
11 15 (21.43%) BusinessObjects
12 14 (20.00%) ERwin
12 14 (20.00%) Mathematics
13 13 (18.57%) Java
13 13 (18.57%) JavaScript
14 12 (17.14%) HTML
14 12 (17.14%) Apache
14 12 (17.14%) Python
14 12 (17.14%) CSS
14 12 (17.14%) Selenium
14 12 (17.14%) jQuery
14 12 (17.14%) Migration
15 11 (15.71%) Jython
15 11 (15.71%) Maven

SQL
Co-occurring IT Skills in Cirencester 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 12 (17.14%) Apache
2 11 (15.71%) IIS
2 11 (15.71%) Tomcat
3 2 (2.86%) SAS
4 1 (1.43%) Alfresco
4 1 (1.43%) CMS
Applications
1 16 (22.86%) Microsoft Excel
2 7 (10.00%) Microsoft Office
3 2 (2.86%) Microsoft PowerPoint
3 2 (2.86%) Spreadsheet
3 2 (2.86%) SPSS
Business Applications
1 4 (5.71%) Dynamics CRM
2 2 (2.86%) FastStats
2 2 (2.86%) FastStats PeopleStage
3 1 (1.43%) Sage 1000
Cloud Services
1 6 (8.57%) Microsoft Azure
2 5 (7.14%) IaaS
3 2 (2.86%) Office 365
3 2 (2.86%) Pure360
3 2 (2.86%) SaaS
3 2 (2.86%) Silverpop
4 1 (1.43%) Amazon AWS
Communications & Networking
1 11 (15.71%) HTTP
2 2 (2.86%) Internet
3 1 (1.43%) Firewall
3 1 (1.43%) Intranet
3 1 (1.43%) LDAP
Database & Business Intelligence
1 31 (44.29%) SQL Server
2 16 (22.86%) Data Warehouse
3 15 (21.43%) BusinessObjects
4 10 (14.29%) SQL Server Integration Services
5 8 (11.43%) Qlik Sense
6 6 (8.57%) Power BI
7 5 (7.14%) SQL Server 2008
7 5 (7.14%) SQL Server 2012
7 5 (7.14%) SQL Server 2014
7 5 (7.14%) SQL Server 2016
8 4 (5.71%) MySQL
9 2 (2.86%) Oracle Reports
9 2 (2.86%) QlikView
Development Applications
1 17 (24.29%) SoapUI
2 14 (20.00%) ERwin
3 12 (17.14%) Selenium
4 11 (15.71%) Ant
4 11 (15.71%) Cucumber
4 11 (15.71%) Eclipse
4 11 (15.71%) HP UFT
4 11 (15.71%) Jenkins
4 11 (15.71%) JIRA
4 11 (15.71%) JUnit
4 11 (15.71%) Maven
4 11 (15.71%) Visual Studio
5 1 (1.43%) Concordion
General
1 34 (48.57%) Finance
2 9 (12.86%) Marketing
3 3 (4.29%) Advertising
4 1 (1.43%) Banking
4 1 (1.43%) Financial Institution
4 1 (1.43%) Manufacturing
Job Titles
1 46 (65.71%) Analyst
2 26 (37.14%) Data Analyst
3 11 (15.71%) Business Intelligence Analyst
3 11 (15.71%) Test Automation Manager
3 11 (15.71%) Test Manager
4 10 (14.29%) SQL Analyst
4 10 (14.29%) Test Analyst
5 7 (10.00%) Developer
5 7 (10.00%) SQL Data Analyst
6 6 (8.57%) Business Analyst
6 6 (8.57%) Business Intelligence Data Analyst
7 5 (7.14%) DBA
7 5 (7.14%) SQL DBA
8 4 (5.71%) Administrator
8 4 (5.71%) Analyst Developer
8 4 (5.71%) Business Data Analyst
8 4 (5.71%) Business Developer
8 4 (5.71%) Senior Analyst
8 4 (5.71%) Senior Data Analyst
9 3 (4.29%) Senior Financial Analyst
Libraries, Frameworks & Software Standards
1 18 (25.71%) SOAP
2 17 (24.29%) .NET
3 12 (17.14%) CSS
3 12 (17.14%) HTML
3 12 (17.14%) jQuery
4 11 (15.71%) Gherkin
4 11 (15.71%) J2EE
4 11 (15.71%) REST
4 11 (15.71%) XML
5 1 (1.43%) Hibernate
5 1 (1.43%) SailPoint
5 1 (1.43%) SPML
5 1 (1.43%) Spring
Miscellaneous
1 27 (38.57%) Analytical Skills
2 9 (12.86%) Computer Science
3 2 (2.86%) Management Information System
4 1 (1.43%) Clustering
Operating Systems
1 16 (22.86%) Windows
2 11 (15.71%) Linux
2 11 (15.71%) Unix
2 11 (15.71%) Windows Server
Processes & Methodologies
1 23 (32.86%) Agile Software Development
2 20 (28.57%) Business Intelligence
2 20 (28.57%) Data Analysis
3 19 (27.14%) Test Automation
4 16 (22.86%) Waterfall
5 15 (21.43%) Data Modelling
6 14 (20.00%) Mathematics
7 12 (17.14%) Migration
8 11 (15.71%) Software Testing
9 10 (14.29%) BDD
9 10 (14.29%) Data Management
9 10 (14.29%) TDD
10 8 (11.43%) Acceptance Criteria
10 8 (11.43%) ETL
11 7 (10.00%) Analytics
11 7 (10.00%) Business Analysis
11 7 (10.00%) Data Mapping
11 7 (10.00%) Functional Testing
11 7 (10.00%) Non-Functional Testing
11 7 (10.00%) User Acceptance Testing
Programming Languages
1 13 (18.57%) Java
1 13 (18.57%) JavaScript
2 12 (17.14%) Python
3 11 (15.71%) C#
3 11 (15.71%) C++
3 11 (15.71%) Groovy
3 11 (15.71%) Jython
3 11 (15.71%) Ruby
3 11 (15.71%) VBScript
4 5 (7.14%) T-SQL
4 5 (7.14%) VB
5 1 (1.43%) BeanShell
5 1 (1.43%) Perl
5 1 (1.43%) PowerShell
Qualifications
1 30 (42.86%) Degree
2 9 (12.86%) Numerate Degree
3 7 (10.00%) ISTQB
3 7 (10.00%) ISTQB Foundation Certification
4 3 (4.29%) ISEB
System Software
1 6 (8.57%) Active Directory
Systems Management
1 11 (15.71%) CA Service Virtualization
Vendors
1 11 (15.71%) CA
1 11 (15.71%) HP
2 6 (8.57%) Tableau
3 5 (7.14%) Oracle
4 2 (2.86%) Apteco
5 1 (1.43%) Microsoft
5 1 (1.43%) Sage
5 1 (1.43%) ServiceNow