Cognos developerBookmark This
295 Durham Ave Suite A,
South Plainfield, NJ
DescriptionHands-on advanced experience with all of the Cognos BI studios, including Framework Manager, Report Studio Report Studio and/or Analysts Studio. Business Insight Advanced, and Administration. Ability to independently develop Framework Manager Models and advanced Report Studio and/or Analysts Studio reports is required.
Ability to collaborate on a team with infrastructure, data warehouse, and business analyst resources, and clearly communicate solutions to both technical and non-technical team members.
Ability to troubleshoot query issues during report development using a methodical approach, including comparing the tabular data from Cognos queries with SQL Server queries on the data warehouse database based on the report specification.
Strong understanding of BI and Data Warehouse database concepts, including star schema, with the ability to develop Report Studio queries which accurately use the relationships between fact tables in the data warehouse database.
Must be comfortable working in a fast-paced, results-driven team environment.
Business Analyst background preferred.
Ability to obtain and maintain a Secret security clearance
ResponsibilitiesManage and maintain the Cognos environment as the Cognos expert.
Create, enhance, and maintain Framework Manager models (relational and DMR) which connect to a star schema SQL Server 2008 data warehouse database, including packages designed for report development and for ad hoc Business Insight Advanced users, according to best practices.
Collaborate with business users and members of the BI team, including business analysts, data warehouse developers, and managers, to design and develop Cognos BI 10.2 reports using Report Studio and/or Analysts Studio.
Design and develop complicated reports including sub-reports, graphical reports, and well-formatted reports according user requirements.
Develop dashboards for C-level executives using Business Insight.
Exhibit a commitment to data quality by validating results compared with the data warehouse database at each step of the development process.
Administer the Cognos development and production environments, including managing Cognos securities using Active Directory, the Cognos Connection folder structure, deployment of content from development to production, and report scheduling and bursting.
Train and support Cognos end users (information consumers and power users) on basic navigation in Cognos Connection, Business Insight Advanced, and report/package usage based on business requirements.
RequirementsBachelor’s degree in Computer Science or a related discipline
experience in medium complex data warehouse environment, hands-on data warehousing project experience and experience in full life cycle Cognos Business Intelligence development, implementation, tuning, and support. This experience must include both Framework Manager modeling and advanced report development.