Senior Cognos Programmer Analyst to design, develop and publish BI reports using Cognos Analytics Reporting

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