COGNOS BI and Reporting Analyst - Corporate Finance

Merial is a world-leading, innovation-driven animal health company, providing a comprehensive range of products to enhance the health, well-being and performance of a wide range of animals. Merial employs approximately 5,000 people and operates in more than 150 countries worldwide. Its 2006 sales were in excess of $2.2 billion. Merial Limited is a joint venture between Merck & Co., Inc. and sanofi-aventis. For more information, please see www.merial.com.

Job Description:

This individual will be responsible for supporting the current Corporate Finance forecasting, planning, and statutory & Management reporting processes and will be heavily involved in the implementation of a new global planning environment.


Major Responsibilities:

1. Work closely with the key customers deriving and documenting requirements related to Corporate Finance forecasting, planning, and reporting.

2.  Manage the successful implementation of Corporate Finance Systems related to forecasting, planning, and reporting.
2. Provide guidance and input for BI and Corporate Planning related COGNOS Planning and COGNOS BI development.
3. Design, develop and document the Cognos related work in accordance with the standards and best practices.
4. Understand Cororate Finance’s OLAP and dimensional needs
5. Understand Corporate Finance’s Data Warehousing needs from source to target including data structures, ETL processes and reporting solutions.
6. Work closely with business and end-users to translate functional and business requirements into technical requirements.
7. Perform testing and quality assurance activities in accordance with standard best practices.
8. Assist in developing high-level and detailed requirements while presenting both technical and business facts with options to Enterprises.


EOE/AA/M/F/D/V

 

Qualifications:

·  Undergraduate degree in Computer Science or related field preferred with minimum of 6 years experience.  Accounting Background and degree highly desirable.

·  3+ years of Cognos BI development and migration experience

·  Hands-on Cognos Planning Development and Administration is a plus

·  ETL experience is a plus.

·  Must have an understanding of relational databases; SQL querying skills and the ability to read stored procedure logic is highly desired.

·  Excellent communication skills; Proven ability to effectively communicate ideas to business, functional, and technical audiences.

·  Strong documentation skills; Business Requirements to Functional Design; Test Scripts.

·  Project management skills

·  Strong Reasoning and problem solving skills.

·  Previous forecast and planning support with global reporting units is highly desired.

·  Previous experience with Hyperion a plus.

·  Self-motivator and focused on delivering technical solutions for business benefit.