Senior Cognos Administrator

Job Summary:   As the Senior Cognos Administrator in our Corporate Information Services Department, this role is responsible for: the Cognos applications environment, including software configuration and upgrades; day to day administration, maintenance, and technical support; data modeling, development and report migration for supporting our KLC internal / external customers.  The ideal candidate will combine strong Cognos development and administration background with strong technical leadership skills. The role will work closely with developers and BI production support staff to ensure that the system is configured optimally to support business needs. Job Responsibilities:  Responsibilities include planning, developing, maintaining, supporting, and optimizing the Cognos applications environment as well as training BI developers, analysts and modelers on best practice methodologies. The Senior Cognos Administrator will also serve as the BI technical lead in related projects governed by the PMO. Essential Functions:   Provide technical support for Cognos 8 applications including report analysis, development, maintenance, and report migration. Install, upgrade, configure and administer Cognos products, including ETL. Proactively monitor the all BI environments for capacity and performance related issues and take steps necessary to address them. Responsible for developing and maintaining Framework Manager models, applying proper security and publishing packages. Responsible for creating new Cognos groups and roles in Cognos Connection. Responsible for providing Cognos access by assigning roles and maintaining security for auditing purposes. Provide training, support, and best practices for Adhoc Query users and Report Authors Familiarity with OLAP Dimensional Modeling techniques and best practices. Design and build Oracle tables, views, and complex SQL statements Act as primary technical contact to Cognos for support and enhancement issues Mentor junior Cognos administration team members Provide occasional weekend on-call support for BI applications Demonstrate solid understanding of Oracle Applications Proactively identify, build, and maintain relationships with business process owners and colleagues Demonstrate solid ability to understand, analyze, and solve problems Recognize and promptly advise management of potential problems and or potential follow-on business opportunities Understand the mechanics of project administration, project timelines, budgets, issue tracking/resolution, and status reporting Produce quality deliverables on time and within budget Keep current with new products / technologies that provide for continuous improvement in KLC’s BI ArchitectureNon-essential Functions:  Focus on continuous improvement Supports and advances change within the division and the company.Adaptability Requirements:  High- Position requires a high degree of adaptability.  Incumbent will be faced with a variety of issues on a day to day basis and will be expected to respond to these issues appropriately.Working Conditions:  Location: OR-Portland Schedule:  Full-time.  Extended work hours when necessary to meet deadlines Travel: NoExperience and Education:  BS or BA in computer science, business, or equivalent preferred. Excellent knowledge of Cognos 8 BI Suite (Query Studio, Report Studio, PowerPlay Transformer, Metrics Studio, Event Studio, Framework Manager, administration). UNIX and/or Linux experience Windows Server experience ETL experience, such as Informatica PowerCenter and/or Cognos Data Manager desirable 3+ years of experience in Oracle development technologies such as PLSQL, SQL Plus, and 10g. 3+ years of experience in MS SQL Server technologies and stored procedures Strong general SQL knowledge for utilization in query optimization and tuning in a BI environment Oracle Internet Directory Source control and version control for change management Extensive application support experienceKnowledge, Skills, and Abilities:  Problem solving skills and demonstrate strong working knowledge of using Cognos Support site and Oracle Metalink Strong influencing skills and ability to interact with business functions  Excellent interpersonal and communication skills Excellent writing skills, with ability to express technical knowledge, procedures and processes in clear, orderly and easily understood presentation.  Results driven Demonstrated ability to prioritize and manage development team Superior PC skills Proficiency with Microsoft Office suite of products Experienced with MS Project or equivalent project management softwareWe offer a comprehensive benefits package, childcare discount and more! To apply for this position, please click the Apply Now button. To see a list of all of our current openings, please visit our website at http://knowledgelearning.careers.. Knowledge Learning Corporation is proud to be an Equal Opportunity Employer. *CB*