Develop and maintain reporting applications using Cognos Business Intelligence components, including Report Studio, Framework Manager, Query Studio, and Cognos Connection. Design and implement complex reports in Cognos 10 and 11 BI Suite with advanced features like drill-through, master-detail relationships, conditional formatting, report bursting, and macros. Enhance existing Framework packages by integrating new namespaces, query subjects, query items, and data tables based on evolving business requirements. Perform metadata modeling tasks such as creating projects, managing metadata, preparing business views, and publishing packages to the Cognos portal. Administer Cognos environments, including creating data source connections, deploying reports from development to production environments, and managing user permissions for packages and folders. Conduct OLTP/OLAP system analysis and maintain database schemas, such as Star and Snowflake schemas, to ensure efficient data management. Optimize report performance, write and debug complex SQL queries, and troubleshoot issues to maintain seamless reporting operations. Leverage domain expertise in banking and finance to align reporting solutions with industry-specific needs. Qualifications: Proficiency in IBM Cognos BI Suite (versions 10 and 11), including Report Studio, Framework Manager, Query Studio, and Event Studio. Strong experience in metadata modeling and Cognos administration. Hands-on expertise in OLTP/OLAP systems and database schema design (Star and Snowflake schemas). Proficiency in SQL with experience in writing and troubleshooting complex queries. Knowledge of banking and finance processes and reporting needs is a significant advantage. A minimum of 5+ years of relevant experience in Cognos BI development and administration. Excellent problem-solving abilities, attention to detail, strong communication skills, and the ability to work collaboratively with cross-functional teams. Location: On site Jeddah location (Middle East)
