Our valued Public sector client is in need of a Senior Cognos Programmer Analyst to design, develop and publish BI reports using Cognos Analytics Reporting (v11) or Cognos Report Studio including complex drill-through, cascading prompts, summary reports, and burst reports.

Some of the tasks that may be required are, but not limited to, the following:

• Develop and document a Test Plan to verify the validity and functionality of all the solutions, for each environment, as required;
• Publish Business Intelligence (BI) reports using Cognos Workspace, Workspace Advanced, Report Studio, and Cognos, using the IBM Cognos software development kit (SDK) and the BI Bus API (application programming interface);
• Provide assistance and support to AAFC staff on the use of all Cognos BI suite products (as indicated above);
• Provide ad-hoc subject-matter-expertise on reporting options and the use of Cognos BI suite products, as required;
• Coach AAFC staff on BI report design techniques; and
• Provide mentoring or knowledge transfer to staff on all BI development activities

We are looking for someone with the following, but not limited to, skill set and experience:

• 10 years experience as a Programmer Analyst
• 5 years experience developing BI reports, using Report Studio (Cognos v10) or Analytics Reporting (Cognos V11) as the web-based report authoring tool
• Experience gathering user requirements, designing, developing, testing, deploying, and documenting reports using Cognos Analytics
• Experience utilizing at least four (4) of the following Cognos components in the conduct of the work:
  • Framework Manager;
  • Report Studio;
  • Query Studio;
  • Analysis Studio;
  • Cognos Connection;
  • Event Studio; and
  • Metric Studio
• Experience performing at least three (3) of the following activities in the conduct of the work:
  • Designing and creating dimensional data models for data warehouses;
  • Using enterprise ETL tools (e.g. Informatica PowerCenter, IBM InfoSphere);
  • Designing and creating dimensional data models with Cognos Transformer;
  • Working with Oracle version 12 c or higher (e.g. SQL / PL/SQL / views / materialized views); and
  • Using PL/SQL Development tools (e.g. TOAD (Quest), SQL Developer (Oracle), SQL Navigator (Quest);
• Experience developing BI reports using Cognos Analytics version 11.1 or higher
• Demonstration of one (1) valid IBM Cognos certification, OR one (1) IBM Cognos proficiency badge, OR two (2) IBM Cognos essential knowledge badges, as listed below
  • Cognos certifications:
    • IBM Certified Administrator - IBM Cognos Analytics Administrator V11 [or higher version, as becomes available],
    • IBM Certified Developer - Cognos Analytics V11.1.x [or higher version, as becomes available],
    • IBM Certified Designer - IBM Cognos Analytics Author V11 [or higher version, as applicable],
    • IBM Certified Developer - IBM Cognos Analytics Author V11 [or higher version, as becomes available]
  • Cognos proficiency badges:
    • IBM Cognos Analytics on Cloud V11.0.x proficiency badge
  • Cognos essential knowledge badges:
    • BM Cognos Analytics V11.0.x Reporting essentials knowledge badge
    • IBM Cognos Analytics V11.0.x Modeling essentials knowledge badge
    • IBM Cognos Analytics V11.0.x Administration Essentials Knowledge Badge
    • IBM Cognos Analytics V11.0.x Consumer Essentials Knowledge Badge
    • IBM Cognos Analytics V11.1.x Reporting essentials knowledge badge
    • IBM Cognos Analytics V11.1.x Modeling essentials knowledge badge
    • IBM Cognos Analytics V11.1.x Administration essentials knowledge badge
    • Other IBM certified training in the following subject areas for Cognos Analytics (V11 or higher, as becomes available):
      • Cognos Analytics Administration,
      • Cognos Analytics Reporting,
      • Cognos Analytics Framework Manager, and
      • Cognos Analytics Dashboards

Apply