Senior cognos developer vs bi developer

The differences between senior cognos developers and bi developers can be seen in a few details. Each job has different responsibilities and duties. It typically takes 2-4 years to become both a senior cognos developer and a bi developer. Additionally, a senior cognos developer has an average salary of $101,368, which is higher than the $92,647 average annual salary of a bi developer.

The top three skills for a senior cognos developer include board reports, data warehouse and sql server. The most important skills for a bi developer are power bi, dashboards, and ETL.

Senior cognos developer vs bi developer overview

	Senior Cognos Developer	BI Developer
Yearly salary	$101,368	$92,647
Hourly rate	$48.73	$44.54
Growth rate	21%	21%
Number of jobs	80,156	80,610
Job satisfaction	-	-
Most common degree	Bachelor's Degree, 73%	Bachelor's Degree, 66%
Average age	39	39
Years of experience	4	4

Senior cognos developer vs bi developer salary

Senior cognos developers and bi developers have different pay scales, as shown below.

	Senior Cognos Developer	BI Developer
Average salary	$101,368	$92,647
Salary range	Between $79,000 And $129,000	Between $71,000 And $119,000
Highest paying City	Pleasanton, CA	San Francisco, CA
Highest paying state	Washington	Washington
Best paying company	GM Financial	Dropbox
Best paying industry	Finance	Health Care

Differences between senior cognos developer and bi developer education

There are a few differences between a senior cognos developer and a bi developer in terms of educational background:

	Senior Cognos Developer	BI Developer
Most common degree	Bachelor's Degree, 73%	Bachelor's Degree, 66%
Most common major	Computer Science	Computer Science
Most common college	-	Massachusetts Institute of Technology

Senior cognos developer vs bi developer demographics

Here are the differences between senior cognos developers' and bi developers' demographics:

	Senior Cognos Developer	BI Developer
Average age	39	39
Gender ratio	Male, 70.2% Female, 29.8%	Male, 72.1% Female, 27.9%
Race ratio	Black or African American, 4.7% Unknown, 4.9% Hispanic or Latino, 8.5% Asian, 30.3% White, 51.5% American Indian and Alaska Native, 0.2%	Black or African American, 4.2% Unknown, 4.7% Hispanic or Latino, 7.9% Asian, 34.7% White, 48.2% American Indian and Alaska Native, 0.2%
LGBT Percentage	8%	8%

Differences between senior cognos developer and bi developer duties and responsibilities

Senior cognos developer example responsibilities.

Introduce and develop OLAP dimensional analysis and eventually lead the transition of reporting from relational to dimensional.
Create and design DTS packages (SSIS) used for implementing the schema for the required data mart.
Work along with the ETL team to understand the flow of data from OLTP system to the OLAP system.
Tweak the Java scripts in reports to support for Cognos10.1.
Involve in creating Informatica transformations, scheduling jobs and data loading.
Create an ODS for reporting from base tables in DB2 database.

Bi developer example responsibilities.

Modify several DB2 queries to accomplish the task.
Utilize TFS for code check-in and check-out and manage different versions of complicate codes.
Manage BO reporting servers for software patches, security upgrades and other maintenance activities.
Work with DBA to create jobs, store procedures and triggers in SSMS to automate database updating work.
Manage and execute various BO reporting projects within organization.
Create sub, drill-down, drill through, parameterize, summary, and matrix reports in SSRS.

Senior cognos developer vs bi developer skills

Common senior cognos developer skills

Board Reports, 8%
Data Warehouse, 6%
SQL Server, 5%
Drill-Through, 5%
Cognos BI, 4%
Master-Detail, 3%

Common bi developer skills

Power Bi, 20%
Dashboards, 10%
ETL, 5%
Visualization, 5%
SSRS, 5%
Data Warehouse, 4%