01 Feb
S.i. Systems
Quebec City
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 activitie s 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
Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.