Skip to Main Content
Michigan State University masthead graphic
University Advancement

Senior Cognos Reports Developer

Post Date: 05-17-2017
Job No.: 438391
Department: University Advancement
Type: Administrative Professional
Salary Range: Negotiable

Print Page Back to List

Description

As a key member of the Business Intelligence and Information Systems team, the Senior Cognos Report Developer will work with the other team members of the University Advancement BI groups to meet the reporting requirements of University Advancement. This will include understanding the data architecture of the data warehouse, the business rules for reporting, and understanding the reporting frameworks those are created by the BI Architect. Primary responsibilities include working with Business and IT stakeholders to understand business goals and requirements to deploy reports quickly and analytics that enable better decision making. The Senior Cognos Report Developer will provide development, testing, and support throughout the report development lifecycle.

Qualifications

  • Bachelor degree in computer science, information systems, business or related information technology field with coursework in an information technology specialization related to programming reports.
  • Three years of related and progressively more responsible or expansive work experience in developing/designing Business Intelligence.
  • Cognos report development experience using Report Studio.
  • Extensive Cognos Framework Manager modeling experience, including DMR.
  • Experience working with Cognos in a multi-tenant environment.
  • Database/EDW design experience.
  • SQL/MDX skills.
  • Knowledge of Cognos modeling and report development best practices.
  • Report and model trouble-shooting skills.
  • Ability to convey BOTH technical & business acumen in terms of requirements, approaches, responses, and outcomes. Ability to present to internal/external groups as required.
  • Cognos Transformer experience (designing/developing PowerCubes) .
  • Understanding of effective dimensional modeling techniques as they relate to the performance of Cognos.
  • Familiarity with other Cognos UIs, especially Metrics Studio, Event Studio, Query Studio and Analysis Studio.
  • Strong understanding of Data Warehousing concepts as applicable to BI.
  • Ability to take initiative and multi-task in order to manage time-sensitive deliverables for internal and external customers.
  • Strong ability to utilize written and verbal communication skills.
  • Have strong customer service orientation and commitment to professionalism.
  • Ability to work independently as well as on a team.

DESIRED

  • More than 5 years of experience developing/designing Business Intelligence solutions (at least 3 of which on the IBM Cognos platform).
  • Familiarity with dimensional data models, Star schema, Snow-flakes etc.
  • Familiarity with Ellucian’s Advancement Performance.
  • Familiarity with UC4 process flow.
  • Familiarity with Tableau or other Business Intelligence tool.
  • Knowledge and work experience in a fund-raising setting.
  • IBM Certified Designer - Cognos 10 BI Multidimensional Reports

How to apply

If you have any questions regarding this position, please contact Pat Karam, Recruitment Manager at karampat@msu.edu.

All candidates must submit an application and resume through the Michigan State University Human Resources web-based system (MAP).  The URL for this website is www.careers.msu.edu.  Please indicate the position number 438391 when submitting your application.

MSU is an affirmative action, equal opportunity employer.

MSU is committed to achieving excellence through cultural diversity.  The university actively encourages applications and/or nominations of women, persons of color, veterans and persons with disabilities.