Cognos Developer/Analyst

Responsibilities
The Cognos Developer/Analyst is responsible for working with the
global Business Intelligence (BI) team in order to provide
administrative, configuration, and design support for our Cognos
application that will be highly utilized for client and internal
projects. In this role, you will be responsible for creating,
maintaining, and updating the metadata layer of the application along
with developing insightful reports and dashboards. This position will
work with multiple departments and sites to ensure the system is built
to reflect the needs of all users.
The ideal candidate will apply high-quality expertise to the
implementation of our Business Intelligence application that supports
our global reporting business. The ideal candidate will:
Lead, design, and develop Cognos models, cubes, and reports
Perform detailed documentation of design, development, testing and
deployment activities
Design and deploy OLAP cubes, drill down reports and dashboards
Implement and maintain Cognos Framework Manager
Maintain and modify existing Business Intelligence cubes and reports.
Maintain the accuracy, integrity, and availability of our BI platform
The Cognos Developer/Analyst role is a combination of hands-on system
development along with report building, and it will require excellent
organization and communication skills. The responsibilities of this
role include managing multiple projects, providing database guidance,
and implementing system changes in order to grow and enhance the
global BI application. This individual will also:
Work directly with our IT developers to create the initial metadata
layer of the Cognos system
Work with the BI team to understand the current and future business needs
Continue to grow and enhance the metadata layer of the system so all
reporting on the BI team is automated through metadata changes,
filters, calculations, and complex case logic
Actively partner with IT staff to help manage the database and data
warehouse to ensure best practices are in place
Handle the application setup, database connection, and build the
framework manager content of the system
Assist in setting up the data security framework for internal and
external users
Consult with end-users to help define specifications for the
analysis projects and system enhancements
Assist in administering installation, configuration, and software
upgrades of Cognos applications
Requirements
Bachelor degree in technology preferred
2 - 5 years experience in database management (must be able to
interpret, understand, and develop SQL queries)
Cognos 8 Administrator, Framework Manager, Report Studio, and
Analysis Studio experience
Understanding of application and web servers
Familiarity with data warehouse functions and ETL concepts to
include experience with dimensional and relational data modeling
Experience with gathering business requirements, business design,
and assistance with technical design, development, and deployment of
dashboards
Experience with all phases of the software development life cycle
(requirements, design, development, testing, deployment, and support)
Ability to multi-task, understand and be responsive to customer
needs, and work under tight deadlines