Job Summary:
We are seeking an experienced Cognos Developer to lead the consolidation and optimization of our Cognos reporting environment. This role involves analyzing, redesigning, and consolidating over 900+ reports to improve performance, eliminate redundancies, and build a scalable reporting infrastructure supporting various business functions including Underwriting, Claims, Finance, and Risk.
Key Responsibilities:
Analyze existing Cognos reports (developed using Framework Manager packages and direct SQL) to identify duplication and inefficiencies.
Categorize reports (Simple, Medium, Complex) based on logic, queries, and structure.
Consolidate reports with overlapping logic or outputs into optimized versions.
Work with business stakeholders to prioritize consolidation efforts based on usage, complexity, and business impact.
Redesign reports for efficiency, scalability, and maintainability.
Perform unit testing, QA, and regression testing on newly developed reports.
Support user acceptance testing (UAT) and coordinate sign-offs.
Collaborate with the Analytics and Reporting (AW) team to implement signed-off reports into the production environment.
Document report analysis, design changes, validation results, and any identified issues or risks.
Ensure consistency and accuracy of data across all consolidated reports.
Required Skills & Experience:
5+ years of experience in Cognos development (Cognos 10 or 11 preferred).
Strong experience with Cognos Framework Manager and Report Studio.
Proficiency in writing and optimizing complex SQL queries.
Proven experience in analyzing and consolidating large sets of reports.
Understanding of data warehousing concepts and reporting best practices.
Experience in testing lifecycle – unit, QA, regression, and UAT support.
Strong documentation skills and attention to detail.
Ability to work independently and as part of a cross-functional team.
Excellent communication and stakeholder management skills.
Nice to Have:
Experience in performance tuning of Cognos reports.
Exposure to data governance and metadata management.
Familiarity with agile or iterative development methodologies.
Deliverables:
Consolidation and optimization of 900+ existing Cognos reports.
Detailed analysis and documentation for each consolidated report.
Fully tested and validated reports ready for production deployment.
Final documentation summarizing changes, validations, and recommendations.
Requirements
Education & Qualifications:
Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or a related field.
Relevant certifications in Cognos BI or similar technologies (preferred but not mandatory).
Technical Skills:
Cognos BI Tools:
Strong hands-on experience with Cognos Report Studio, Query Studio, and Workspace Advanced.
Proficiency in Cognos Framework Manager (FM) – building and modifying models/packages.
SQL & Database:
Advanced skills in SQL development and optimization.
Ability to understand and work with complex queries and stored procedures.
Experience working with relational databases (e.g., Oracle, SQL Server, DB2, or similar).
Report Optimization & Consolidation:
Demonstrated experience in analyzing and consolidating reports in large reporting environments (900+ reports or similar scale).
Ability to identify and eliminate redundancy in reporting logic and design.
Data & Reporting Concepts:
Solid understanding of data modeling, ETL workflows, and data warehousing concepts.
Familiarity with report categorization based on complexity (simple, medium, complex).
Testing & Validation:
Experience in unit testing, QA, regression testing, and user acceptance testing (UAT) support.
Strong data validation and troubleshooting skills.
Soft Skills:
Strong analytical and problem-solving skills.
Excellent documentation skills – able to clearly articulate report changes, logic, and findings.
Effective communication and stakeholder management abilities.
Ability to work independently and manage tasks with minimal supervision.
Team-oriented, collaborative, and proactive approach.
Preferred Experience:
Experience working in insurance, finance, or regulated industries is a plus.
Familiarity with report usage analysis and business impact assessments.
Exposure to agile methodologies or similar iterative development environments.