Cognos Developer

Envision Technology Solutions; United States; On-site; USD 90,000 - 120,000; Full time

Job summary

Envision Technology Solutions is seeking a Cognos Report Developer to design, develop, and maintain BI reports, dashboards, and scorecards using IBM Cognos Analytics. You will collaborate with stakeholders to translate data needs into actionable technical solutions ensuring accuracy and performance.

You will build complex reports, optimize SQL, and support testing, scheduling, and Cognos security administration while maintaining data integrity and seamless integration.

Qualifications

• Bachelor’s degree in computer science, Information Systems, or a related technical field.
• Hands-on experience with IBM Cognos Analytics, Framework Manager, Report Studio.
• Strong proficiency in SQL writing, query optimization, and relational databases.
• Solid understanding of ETL processes, data warehousing concepts, and dimensional modeling.
• Exceptional analytical, problem-solving, and communication skills to collaborate with non-technical business users.

Responsibilities

• Design and build complex reports (Drill-down, Crosstab, Master-Detail, Conditional Formatting) using Cognos Report Studio and Cognos Analytics.
• Create visually intuitive dashboards and KPIs driving data-driven decisions.
• Develop and maintain Framework Manager models, data modules, and metadata structures.
• Gather reporting requirements from analysts and stakeholders and translate into technical specs.
• Optimize report performance, tune SQL queries, and resolve production defects or data discrepancies.
• Perform unit testing, debugging, and support User Acceptance Testing (UAT).
• Assist with report scheduling, user permissions, and Cognos security administration.

Skills

Cognos Analytics

Framework Manager

Report Studio

SQL

Data warehousing

Dimensional modeling

Analytical thinking

Communication

Problem-solving

Education

Bachelor’s degree in computer science or related technical field

Tools

IBM Cognos Analytics

Framework Manager

Report Studio

Job description

A Cognos Report Developer designs, develops, and maintains business intelligence reports, interactive dashboards, and scorecards using IBM Cognos Analytics. They collaborate with business stakeholders to translate data requirements into actionable technical solutions, ensuring report accuracy, optimized performance, and seamless data integration.

Key Responsibilities

• Report Development: Design and build complex reports (e.g., Drill-down, Crosstab, Master-Detail, Conditional Formatting) utilizing Cognos Report Studio and Cognos Analytics.
• Dashboarding: Create visually intuitive dashboards and KPIs that drive data-driven decision-making.
• Data Modeling: Develop and maintain Framework Manager models, data modules, and metadata structures to support reporting.
• Requirement Analysis: Work closely with business analysts and stakeholders to gather reporting requirements and convert them into technical specifications.
• Optimization & Troubleshooting: Optimize report performance, fine-tune SQL queries, and resolve production defects or data discrepancies.
• Testing & UAT: Perform unit testing, debugging, and support User Acceptance Testing (UAT) to ensure data accuracy.
• Environment Maintenance: Assist with report scheduling, user permissions, and Cognos security administration.

Required Qualifications & Technical Skills

• Education: Bachelor’s degree in computer science, Information Systems, or a related technical field.
• Core Tooling: Hands-on experience with IBM Cognos Analytics , Framework Manager, Report Studio.
• Database Skills: Strong proficiency in SQL writing, query optimization, and relational databases.
• Data Warehousing: Solid understanding of ETL processes, data warehousing concepts, and dimensional modeling .
• Soft Skills: Exceptional analytical, problem-solving, and communication skills to effectively collaborate with non-technical business user