Process Mgmt/Support

Indiana  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Keywords

Description

Project Description:
The required skills for this position are as follows:
  • 5-7 years' experience with the Cognos 8.4 and later/Framework Manager as both metadata Modeler and Report Developer
  • 5+ years writing SQL queries to validate reports and research data in the tables
  • Working with business users to design and develop correct and well-performing Cognos reports and cubes using Report Studio with data drill-down and slice & dice options
  • Experience developing and scheduling complex reports using Event Studio and applying filters, prompts and calculations
  • Ability to consume Relational and Multidimensional models and translate this into the development of the metadata layer in Framework Manager in conjunction with the logical and physical data models
  • Extensive understanding of Multidimensional Analysis
  • Understand Data Warehousing best practices and associated methodologies
  • Working knowledge of the different types of data stores that make up a complete Data Warehousing environment (staging, ODS, etc.)
  • Excellent interpersonal, verbal, and written communication skills
  • Ability to troubleshoot query issues during report development using a methodical approach, including comparing the tabular data from Cognos queries with SQL queries on the database based on the reports specification.
  • Translate business requirements into a data model and be able to convert results into a Framework Manager Model to deliver reporting
  • Create enterprise-wide Relational and Multidimensional data models
  • Develop and execute unit test plans to successfully deliver a project
  • Develop and maintain supporting documentation
  • Scripting of SQL for investigating, researching and verifying results of queries and reports
  • Support users in problem resolution including troubleshooting of operational, data and performance issues
  • Provide analytical and decision support for the implantation and on-going enhancement of existing reports and cubes
  • Solid knowledge of Microsoft Excel (including advance use of Pivot Tables, Look-ups, If Statements, Macros etc.) and SQL programming language a plus

    Job Description:
    This candidate will work with the Lead Cognos Business Analyst to help develop reports; Cognos Alerts, etc. based on the business requirements/needs. The candidate will also develop user guides and train the Technical Business Analyst team to allow them the ability to support Cognos reporting and alert development in the future.

    SKILLS
    5-7 years' experience with Cognos 8.4 & later, 5+ years writing SQL queries to validate reports, Working w/business users to design Cognos Reports, Experience developing & scheduling complex reports, Ability to consume Multidimensional models, Understand Data Warehousing, Ability to troubleshoot query issues, Translate business requirements into a data model, Develop and maintain supporting documentation, Scripting of SQL for investigating & verifying

    Synectics is an Equal Opportunity Employer.
  • Start date
    n.a
    From
    Synectics
    Published at
    13.12.2012
    Project ID:
    461055
    Contract type
    Freelance
    To apply to this project you must log in.
    Register