Job Title/Job Code: Programmer 4/PR4
Contract Length: Possibility of extension subject to Budgetary & Administrative approval.
Interview Process: 1st Round Phone Interview 2nd Round Face to Face or Skype
Resumes will be pushed 3-11-16 @ 3:00PM
This is a Cognos Developer. This is primarily a coding position. Please DO NOT re-submit candidates that were previously submitted to this posting
Project: BWC is implementing a new claims, policy and billing system. This new implementation is
Shifting our data warehouse and reporting infrastructure from DB2/Hyperion to
Oracle/Cognos.
BWC is seeking a candidate with STRONG exp/skills with Cognos Report Studio on DW or BI projects) BWC is implementing a new claims, policy and billing system. This new implementation is shifting our data warehouse and reporting infrastructure from DB2/Hyperion to Oracle/Cognos. The nature of our data is also changing, as data elements are changing purpose and semantics as part of the transition. BWC's new system will have a transaction data store (TDS), operational data store (ODS) and a newly designed Oracle enterprise data warehouse.
The Cognos developer will be primarily involved in developing reports using Cognos Report Studio, and performing Unit testing. They will collaborate with framework modelers, data analysts, business analysts, testing specialists, and business customers to create business reports that are accurate, reliable, attractive, timely, and relevant.
Day-in-the-Life: During a given day, this position will be expected to
• Design and develop complex Report Studio objects (e.g. Active Reports, complex conditional formatting, and complex hierarchical development within list frames) based upon report specifications -Unit test developed reports and verify results against specifications
• Serve as a reporting expert as needed during user and systems testing
• Identify and document any inconsistencies between data model and report specifications
• Identify and document any software issues encountered
• Document functional specifications, technical specifications and unit testing requirements as assigned
• Use Cognos and Oracle software and tools to perform required tasks
• Perform knowledge transfer to BWC staff SKILLS (mandatory and desirable) with years of experience if applicable
Mandatory Skills
• 8 Years of experience with SQL programming against an Oracle RDBMS on data warehouse or business intelligence projects.
• 7 Years of experience with business intelligence tools including IBM Cognos
• 5 Years of experience with the development and support using dimensional star schema based data structures including fact tables (commonly referred to as Kimball)
• 4 Years of experience designing and developing Cognos (version 8.2 and above) reports using Report Studio, Analysis Studio and Active reports
