Post job

Cognos consultant vs functional consultant

The differences between cognos consultants and functional consultants can be seen in a few details. Each job has different responsibilities and duties. It typically takes 4-6 years to become both a cognos consultant and a functional consultant. Additionally, a cognos consultant has an average salary of $91,980, which is higher than the $85,317 average annual salary of a functional consultant.

The top three skills for a cognos consultant include dashboards, data warehouse and sql server. The most important skills for a functional consultant are business process, prototyping, and ERP.

Cognos consultant vs functional consultant overview

Cognos ConsultantFunctional Consultant
Yearly salary$91,980$85,317
Hourly rate$44.22$41.02
Growth rate9%9%
Number of jobs33,27751,066
Job satisfaction--
Most common degreeBachelor's Degree, 67%Bachelor's Degree, 66%
Average age4343
Years of experience66

Cognos consultant vs functional consultant salary

Cognos consultants and functional consultants have different pay scales, as shown below.

Cognos ConsultantFunctional Consultant
Average salary$91,980$85,317
Salary rangeBetween $73,000 And $115,000Between $65,000 And $110,000
Highest paying CityPortland, ORSan Francisco, CA
Highest paying stateCaliforniaCalifornia
Best paying companyThe News-ReviewWorkday
Best paying industryFinanceManufacturing

Differences between cognos consultant and functional consultant education

There are a few differences between a cognos consultant and a functional consultant in terms of educational background:

Cognos ConsultantFunctional Consultant
Most common degreeBachelor's Degree, 67%Bachelor's Degree, 66%
Most common majorComputer ScienceComputer Science
Most common collegeMassachusetts Institute of Technology-

Cognos consultant vs functional consultant demographics

Here are the differences between cognos consultants' and functional consultants' demographics:

Cognos ConsultantFunctional Consultant
Average age4343
Gender ratioMale, 72.9% Female, 27.1%Male, 71.9% Female, 28.1%
Race ratioBlack or African American, 8.4% Unknown, 4.9% Hispanic or Latino, 9.6% Asian, 25.3% White, 51.6% American Indian and Alaska Native, 0.2%Black or African American, 8.5% Unknown, 4.9% Hispanic or Latino, 9.6% Asian, 25.2% White, 51.7% American Indian and Alaska Native, 0.2%
LGBT Percentage8%8%

Differences between cognos consultant and functional consultant duties and responsibilities

Cognos consultant example responsibilities.

  • Manage SSIS jobs for weekly and monthly refresh.
  • Implement QlikView desktop and publisher, manage user authentication, establish publisher tasks, streamline loading procedures and review log.
  • Implement different techniques in DMR cubes development to improve performance on OLAP databases.
  • Develop, test and maintain ETL procedures employing both ETL tools and custom PL/SQL.
  • Develop packages and collections using PL/SQL.
  • Experience in writing shell scripts in Unix.
  • Show more

Functional consultant example responsibilities.

  • Lead project to enhance batch and on-line system, using DB2, VSAM and DYL280.
  • Used TcpTrace to track and analyze the status of leads in SalesForce.
  • Analyze impacts and work with SME's, business partners to gather detail requirements and manage risks/ issues.
  • Design and maintain numerous data warehousing tools to automate the ETL process, data retrieval, integration and reporting functions.
  • Lead architecture, develop of predictive models & application develop of radiology-oncology executive dashboard and alerting services base on statistical calculations.
  • Act as back up for FI analyst, assisting and providing support for issues relate to GL, AP and AR.
  • Show more

Cognos consultant vs functional consultant skills

Common cognos consultant skills
  • Dashboards, 11%
  • Data Warehouse, 9%
  • SQL Server, 6%
  • Drill-Through, 6%
  • Cognos BI, 5%
  • Windows XP, 5%
Common functional consultant skills
  • Business Process, 9%
  • Prototyping, 8%
  • ERP, 8%
  • CRM, 4%
  • Test Cases, 4%
  • Payroll, 3%

Browse computer and mathematical jobs