Cognos Contracts

The table below provides summary statistics for contract job vacancies with a requirement for knowledge and experience of Cognos products and/or services. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited Cognos over the 3 months to 29 June 2017 with a comparison to the same period in the previous 2 years.

Note that daily and hourly rates are treated separately in these statistics. When calculating contractor rate percentiles, daily rates are never derived from quoted hourly rates or vice versa.

The figures below represent the IT contractor job market in general and are not representative of contractor rates within IBM Cognos.

Cognos UK
Location	3 months to 29 Jun 2017	Same period 2016	Same period 2015
Rank	471	456	348
Rank change year-on-year	-15	-108
Contract jobs citing Cognos	143	195	334
As % of all contract IT jobs advertised in the UK	0.30%	0.36%	0.60%
As % of the Vendors category	0.69%	0.81%	1.34%
Number of daily rates quoted	85	126	213
UK median daily rate	£438	£425	£450
Median daily rate % change year-on-year	+2.94%	-5.55%
10th Percentile	£325	£300	£281
90th Percentile	£575	£556	£550
UK excluding London median daily rate	£425	£425	£400
% change year-on-year	-	+6.25%
Number of hourly rates quoted	1	6	5
UK median hourly rate	£16.06	£20.00	£22.50
Median hourly rate % change year-on-year	-19.70%	-11.11%
10th Percentile	£15.53	£12.25	£20.33
90th Percentile	£16.59	£20.88	£32.00
UK excluding London median hourly rate	£16.06	£20.50	£27.25
% change year-on-year	-21.65%	-24.77%

Cognos is in the vendor products and services category. The following table is for comparison with the above and provides summary statistics for all vendor product and service related skills in contract job vacancies.

Contract Vendor Product & Service Skills UK
Contract job vacancies with a requirement for skills associated with vendor products and/or services	20651	24117	24949
As % of all contract IT job vacancies advertised in the UK	43.84%	44.90%	44.51%
Number of daily rates quoted	20874	27087	25776
UK median daily rate	£425	£400	£390
Median daily rate % change year-on-year	+6.25%	+2.56%
10th Percentile	£240	£238	£213
90th Percentile	£600	£585	£575
UK excluding London median daily rate	£400	£375	£360
% change year-on-year	+6.66%	+4.16%
Number of hourly rates quoted	1319	1641	1981
UK median hourly rate	£19.00	£20.50	£18.75
Median hourly rate % change year-on-year	-7.31%	+9.33%
10th Percentile	£10.75	£10.75	£10.75
90th Percentile	£50.00	£43.00	£43.75
UK excluding London median hourly rate	£17.50	£21.00	£18.00
% change year-on-year	-16.66%	+16.66%

Cognos
Job Vacancy Trend

Job postings citing Cognos as a percentage of all IT jobs advertised.

Cognos
Contractor Daily Rate Trend

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing Cognos.

Contractor daily rate trend for Cognos in the UK

Cognos
Contractor Daily Rate Histogram

The daily rate distribution of IT jobs citing Cognos over the 3 months to 29 June 2017.

Contractor daily rate histogram for Cognos in the UK

Cognos
Contractor Hourly Rate Trend

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing Cognos.

Contractor hourly rate trend for Cognos in the UK

Cognos
Top 10 Contract Locations

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing Cognos within the UK over the 3 months to 29 June 2017. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location	Rank Change on Same Period Last Year	Matching Contract IT Job Ads	Median Daily Rate Last 3 Months	Median Daily Rate % Change on Same Period Last Year	Live Job Vacancies
England	-14	132	£425	-	48
UK excluding London	+21	78	£425	-	33
London	-12	53	£450	+5.88%	18
South East	-1	22	£425	-	6
North of England	+55	20	£388	-19.68%	10
Midlands	+10	15	£378	-12.20%	11
Scotland	+35	10	£520	+73.33%	2
South West	+6	8	£500	+44.92%	1
East of England	-18	6	£475	+5.55%	2
Channel Islands	-	1	£500	-	1

Cognos
Top 30 Co-occurring IT Skills

For the 6 months to 29 June 2017, IT contractor jobs citing Cognos also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all contract ads with a requirement for Cognos.

1	160 (52.81%)	Business Intelligence
2	137 (45.21%)	Finance
3	108 (35.64%)	SQL
4	85 (28.05%)	Data Warehouse
5	65 (21.45%)	Oracle
5	65 (21.45%)	Analytics
6	62 (20.46%)	Tableau
7	61 (20.13%)	IBM
8	58 (19.14%)	SQL Server
9	53 (17.49%)	BusinessObjects
9	53 (17.49%)	Data Modelling
10	52 (17.16%)	ETL
11	48 (15.84%)	Microsoft Excel
12	47 (15.51%)	SQL Server Integration Services
12	47 (15.51%)	Analytical Skills

13	45 (14.85%)	Microsoft
14	42 (13.86%)	Cognos TM1
15	39 (12.87%)	SQL Server Reporting Services
15	39 (12.87%)	Cognos Business Intelligence
16	33 (10.89%)	QlikView
17	30 (9.90%)	Data Analysis
18	29 (9.57%)	Banking
18	29 (9.57%)	Informatica
19	28 (9.24%)	Microsoft Office
19	28 (9.24%)	Power BI
20	26 (8.58%)	Business Analysis
21	25 (8.25%)	SAP
21	25 (8.25%)	Stakeholder Management
22	24 (7.92%)	Migration
22	24 (7.92%)	Project Management

Cognos
Co-occurring IT Skills 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
Applications
Business Applications
Cloud Services
Communications & Networking
Database & Business Intelligence
Development Applications
General
Job Titles
Libraries, Frameworks & Software Standards
Miscellaneous
Operating Systems
Processes & Methodologies
Programming Languages
Qualifications
Quality Assurance & Compliance
System Software
Systems Management
Vendors

Application Platforms
1	20 (6.60%)	SAS
2	16 (5.28%)	SharePoint
3	10 (3.30%)	Apache Pig
4	9 (2.97%)	Apache Spark
5	7 (2.31%)	BizTalk Server
6	6 (1.98%)	Apache
6	6 (1.98%)	MQSeries
6	6 (1.98%)	OpenStack
7	5 (1.65%)	iPlanet
7	5 (1.65%)	JBoss
7	5 (1.65%)	Oracle Application Server
7	5 (1.65%)	Tomcat
7	5 (1.65%)	WebLogic
7	5 (1.65%)	WebLogic Portal
8	4 (1.32%)	Adobe Experience Manager
8	4 (1.32%)	SharePoint 2010
9	3 (0.99%)	FileNet
9	3 (0.99%)	Oracle Coherence
10	2 (0.66%)	IIS
10	2 (0.66%)	SharePoint 2013

Applications
1	48 (15.84%)	Microsoft Excel
2	28 (9.24%)	Microsoft Office
3	10 (3.30%)	SPSS
4	8 (2.64%)	Microsoft Project
5	6 (1.98%)	MS Visio
6	4 (1.32%)	Microsoft PowerPoint
7	2 (0.66%)	Spreadsheet
7	2 (0.66%)	Weka

Business Applications
1	42 (13.86%)	Cognos TM1
2	39 (12.87%)	Cognos Business Intelligence
3	17 (5.61%)	Cognos Controller
4	9 (2.97%)	Maximo
5	8 (2.64%)	Cognos Planning
6	6 (1.98%)	Dynamics CRM
6	6 (1.98%)	Oracle EBS
6	6 (1.98%)	Oracle Procure-to-Pay
7	5 (1.65%)	Adobe Campaign
7	5 (1.65%)	WebTrends
8	4 (1.32%)	Unit4 Business World
9	3 (0.99%)	JDE EnterpriseOne
9	3 (0.99%)	Oracle Assets
9	3 (0.99%)	Oracle Cash Management
9	3 (0.99%)	Oracle ERP
9	3 (0.99%)	Oracle Financials
9	3 (0.99%)	Oracle iProcurement
9	3 (0.99%)	Oracle Receivables
9	3 (0.99%)	Primavera
9	3 (0.99%)	SAP Payroll

Cloud Services
1	13 (4.29%)	Adobe Analytics
2	5 (1.65%)	SaaS
3	4 (1.32%)	Google Analytics
4	3 (0.99%)	SuccessFactors
5	2 (0.66%)	Amazon AWS
5	2 (0.66%)	Microsoft Azure
6	1 (0.33%)	Amazon EC2
6	1 (0.33%)	Amazon EMR
6	1 (0.33%)	Cloud Computing
6	1 (0.33%)	Dynamics 365
6	1 (0.33%)	Google Tag Manager
6	1 (0.33%)	Office 365

Communications & Networking
1	6 (1.98%)	LDAP
1	6 (1.98%)	NAS
1	6 (1.98%)	SAN
2	5 (1.65%)	Firewall
2	5 (1.65%)	TCP/IP
3	3 (0.99%)	DNS
3	3 (0.99%)	FCoE
3	3 (0.99%)	Internet
3	3 (0.99%)	iSCSI
3	3 (0.99%)	VLAN
3	3 (0.99%)	WAN
4	2 (0.66%)	HTTP
4	2 (0.66%)	Network Security
5	1 (0.33%)	Intranet

Database & Business Intelligence
1	85 (28.05%)	Data Warehouse
2	58 (19.14%)	SQL Server
3	53 (17.49%)	BusinessObjects
4	47 (15.51%)	SQL Server Integration Services
5	39 (12.87%)	SQL Server Reporting Services
6	33 (10.89%)	QlikView
7	28 (9.24%)	Power BI
8	23 (7.59%)	SQL Server Analysis Services
9	20 (6.60%)	Oracle Database
10	19 (6.27%)	Relational Database
11	15 (4.95%)	Cognos Framework Manager
12	14 (4.62%)	Big Data
12	14 (4.62%)	Hadoop
12	14 (4.62%)	Oracle Database 11g
12	14 (4.62%)	Oracle Reports
13	13 (4.29%)	Star Schema
14	12 (3.96%)	Cognos Report Studio
14	12 (3.96%)	RDBMS
14	12 (3.96%)	Spotfire
14	12 (3.96%)	SQL Server 2012

Development Applications
1	9 (2.97%)	Team Foundation Server
2	8 (2.64%)	Eclipse
3	5 (1.65%)	Talend Open Studio
4	3 (0.99%)	ERwin
4	3 (0.99%)	Git (software)
4	3 (0.99%)	JIRA
4	3 (0.99%)	Visual Studio
5	1 (0.33%)	Vagrant

General
1	137 (45.21%)	Finance
2	29 (9.57%)	Banking
3	13 (4.29%)	Retail
4	11 (3.63%)	Marketing
5	7 (2.31%)	Investment Banking
6	5 (1.65%)	Legal
7	4 (1.32%)	General Ledger
7	4 (1.32%)	Law
8	3 (0.99%)	Advertising
8	3 (0.99%)	Front Office
8	3 (0.99%)	Manufacturing
8	3 (0.99%)	Telecoms
9	2 (0.66%)	Financial Institution
9	2 (0.66%)	Games
10	1 (0.33%)	Aerospace
10	1 (0.33%)	Dutch Language
10	1 (0.33%)	Electronics
10	1 (0.33%)	Pharmaceutical
10	1 (0.33%)	Publishing

Job Titles
1	106 (34.98%)	Developer
2	57 (18.81%)	Analyst
3	50 (16.50%)	Cognos Developer
4	48 (15.84%)	Consultant
5	34 (11.22%)	Cognos Consultant
6	31 (10.23%)	Business Intelligence Developer
7	24 (7.92%)	Architect
8	15 (4.95%)	Business Analyst
8	15 (4.95%)	Cognos BI Developer
8	15 (4.95%)	Cognos Support
8	15 (4.95%)	SQL Developer
8	15 (4.95%)	Support Consultant
8	15 (4.95%)	Systems Support
9	14 (4.62%)	Data Analyst
9	14 (4.62%)	Report Developer
10	13 (4.29%)	Project Manager
10	13 (4.29%)	TM1 Developer
11	12 (3.96%)	Data Architect
11	12 (3.96%)	Report Specialist
12	11 (3.63%)	ETL Developer

Libraries, Frameworks & Software Standards
1	11 (3.63%)	.NET
2	9 (2.97%)	HTML
3	6 (1.98%)	J2EE
4	5 (1.65%)	XML
5	4 (1.32%)	CSS
5	4 (1.32%)	Web Services
6	3 (0.99%)	REST
6	3 (0.99%)	SOAP
6	3 (0.99%)	WSDL
6	3 (0.99%)	XML Messaging
6	3 (0.99%)	XSD
7	2 (0.66%)	.NET Framework
7	2 (0.66%)	D3.js
7	2 (0.66%)	JSON
7	2 (0.66%)	MDX
7	2 (0.66%)	Node.js
8	1 (0.33%)	HTML5
8	1 (0.33%)	jQuery
8	1 (0.33%)	Kafka
8	1 (0.33%)	Oracle Fusion

Miscellaneous
1	47 (15.51%)	Analytical Skills
2	9 (2.97%)	Data Structures
2	9 (2.97%)	Management Information System
3	7 (2.31%)	Clustering
4	6 (1.98%)	Grid Computing
4	6 (1.98%)	User Experience
5	4 (1.32%)	Data Centre
6	3 (0.99%)	Client/Server
6	3 (0.99%)	Computer Science
6	3 (0.99%)	Enterprise Software
6	3 (0.99%)	Replication
7	2 (0.66%)	Algorithms
7	2 (0.66%)	Fintech
7	2 (0.66%)	Greenfield Project
7	2 (0.66%)	Mainframe
7	2 (0.66%)	Reinsurance
7	2 (0.66%)	Virtual Team
8	1 (0.33%)	Digital TV
8	1 (0.33%)	Fixed Income
8	1 (0.33%)	Life Science

Operating Systems
1	15 (4.95%)	Solaris
2	13 (4.29%)	Windows
3	12 (3.96%)	Linux
4	6 (1.98%)	AIX
4	6 (1.98%)	HPUX
4	6 (1.98%)	SUSE
4	6 (1.98%)	Unix
5	3 (0.99%)	Windows Server 2008
6	2 (0.66%)	Windows 2000 Server
6	2 (0.66%)	Windows Server
6	2 (0.66%)	Windows Server 2003
7	1 (0.33%)	OpenVMS
7	1 (0.33%)	Windows Server 2012

Processes & Methodologies
1	160 (52.81%)	Business Intelligence
2	65 (21.45%)	Analytics
3	53 (17.49%)	Data Modelling
4	52 (17.16%)	ETL
5	30 (9.90%)	Data Analysis
6	26 (8.58%)	Business Analysis
7	25 (8.25%)	Stakeholder Management
8	24 (7.92%)	Migration
8	24 (7.92%)	Project Management
9	20 (6.60%)	Agile Software Development
9	20 (6.60%)	Visualisation
10	19 (6.27%)	Budgeting and Forecasting
10	19 (6.27%)	ERP
11	18 (5.94%)	Data Management
12	16 (5.28%)	Translating Business Requirements
13	15 (4.95%)	CRM
14	14 (4.62%)	Data Migration
15	13 (4.29%)	E-Commerce
16	12 (3.96%)	Data Integration
16	12 (3.96%)	User Acceptance Testing

Programming Languages
1	108 (35.64%)	SQL
2	17 (5.61%)	R
3	15 (4.95%)	PL/SQL
3	15 (4.95%)	Python
4	12 (3.96%)	Korn
5	11 (3.63%)	C#
6	10 (3.30%)	Java
6	10 (3.30%)	T-SQL
6	10 (3.30%)	VBA
7	6 (1.98%)	C
7	6 (1.98%)	Scala
8	5 (1.65%)	JavaScript
8	5 (1.65%)	Perl
9	4 (1.32%)	PowerShell
10	3 (0.99%)	ABAP
10	3 (0.99%)	Bash Shell
10	3 (0.99%)	C-shell
10	3 (0.99%)	Shell Script
11	2 (0.66%)	PHP
12	1 (0.33%)	C++

Qualifications
1	22 (7.26%)	Degree
2	16 (5.28%)	Security Cleared
3	12 (3.96%)	SC Cleared
4	7 (2.31%)	Computer Science Degree
5	5 (1.65%)	Numerate Degree
6	4 (1.32%)	ACCA
6	4 (1.32%)	CIMA
7	3 (0.99%)	BPSS Clearance
8	2 (0.66%)	CBAP
8	2 (0.66%)	IIBA
8	2 (0.66%)	ISEB
8	2 (0.66%)	PRINCE2 Certification
9	1 (0.33%)	PMI Certification
9	1 (0.33%)	PMP
9	1 (0.33%)	PRINCE2 Practitioner

Quality Assurance & Compliance
1	19 (6.27%)	Data Quality
2	9 (2.97%)	QA
3	8 (2.64%)	PMO
4	3 (0.99%)	Sarbanes-Oxley
5	2 (0.66%)	Basel II
5	2 (0.66%)	SLA
6	1 (0.33%)	Solvency II

System Software
1	8 (2.64%)	Apache Flume
2	6 (1.98%)	Hyper-V
2	6 (1.98%)	KVM
2	6 (1.98%)	Oracle RAC
2	6 (1.98%)	Veritas Volume Manager
2	6 (1.98%)	VMware Infrastructure
3	3 (0.99%)	Samba
4	2 (0.66%)	Active Directory
5	1 (0.33%)	HDFS

Systems Management
1	6 (1.98%)	OpenView
2	4 (1.32%)	Oozie
3	2 (0.66%)	Opscode Chef
4	1 (0.33%)	Ansible
4	1 (0.33%)	Hadoop YARN

Vendors
1	65 (21.45%)	Oracle
2	62 (20.46%)	Tableau
3	61 (20.13%)	IBM
4	45 (14.85%)	Microsoft
5	29 (9.57%)	Informatica
6	25 (8.25%)	SAP
7	19 (6.27%)	MicroStrategy
8	12 (3.96%)	Teradata
9	9 (2.97%)	Cisco
9	9 (2.97%)	HP
10	8 (2.64%)	Netezza
11	7 (2.31%)	Omniture
12	6 (1.98%)	Adobe
12	6 (1.98%)	Brio
12	6 (1.98%)	Opsware
12	6 (1.98%)	PlateSpin
12	6 (1.98%)	Red Hat
12	6 (1.98%)	Sun
12	6 (1.98%)	Veritas
12	6 (1.98%)	VMware