Cognos Report Developer(Available as both a Permanent role and W2 Contract)

Ampstek; Alpharetta (GA); On-site; USD 90,000 - 130,000; Full time

Job summary

Ampstek in Alpharetta, GA is seeking a Cognos Report Developer to design, develop, and maintain BI reports, dashboards, and scorecards using IBM Cognos Analytics.

You will partner with business stakeholders to translate data needs into technical specifications, optimize performance, and ensure data accuracy through testing and UAT.

Qualifications

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

Responsibilities

• Design and build complex Cognos reports (drill-down, crosstab, master-detail).
• Create dashboards and KPIs to drive data-driven decisions.
• Develop and maintain Framework Manager models and data modules.
• Gather reporting requirements from stakeholders and translate into specs.
• Optimize report performance and tune SQL queries.
• Perform unit testing and support UAT for data accuracy.
• Assist with report scheduling, permissions, and Cognos security.

Skills

Analytical thinking

Problem-solving

Communication

Education

Bachelor’s degree in computer science, Information Systems, or a related technical field

Tools

IBM Cognos Analytics

Framework Manager

Report Studio

SQL

Job description

Job Type: W2 Contract/Fulltime(Both available)

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