Description

Design, develop, and maintain IBM Cognos Analytics and Report Studio solutions, including pixel-perfect reports, dashboards, and parameterized visualizations. Build and optimize Framework Manager models, defining namespaces, query subjects, relationships, and complex calculations to support scalable data warehousing structures. Write and tune advanced SQL queries for Oracle, SQL Server, DB2, or Teradata to ensure efficient data retrieval and reporting performance. Implement row-level and object-level security, manage report bursting, and handle versioning and deployment across environments. Collaborate with stakeholders to translate business requirements into technical solutions, perform data validation, and support UAT and production troubleshooting.

Responsibilities

• Develop and maintain Cognos reports and dashboards with a focus on performance and usability.
• Design Framework Manager models, including hierarchies, determinants, and relational/dimensional structures.
• Write and optimize complex SQL queries for data retrieval and reporting efficiency.
• Implement security protocols and manage report distribution and scheduling.
• Troubleshoot performance issues and support data governance standards.

Required Skills

• 5+ years of hands-on experience with IBM Cognos Analytics and Report Studio.
• Strong expertise in Framework Manager for metadata modeling and calculations.
• Advanced SQL skills with experience in complex joins and performance tuning.
• Experience with relational databases: Oracle, SQL Server, DB2, or Teradata.
• Understanding of data warehousing concepts (star/snowflake schemas, facts, dimensions).
• Ability to translate business requirements into technical reporting solutions.

Preferred Skills

• Experience with Cognos Administration, security, and deployments.
• Familiarity with other BI tools such as Power BI or Tableau.

Key Skills

Education

Bachelor's degree