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
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.
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.