Analyze and understand Meta Data of current systems to refine the logical data model and analyze data quality.
Design and develop Data Warehouse ETL Processes, Multi-Dimensional OLAP Cubes, and Performance dashboards
Administrate Cognos by creating a group for every department and giving roles to every group users.
Conceptualize, design and develop the Meta Data Model forever report for fast startup.
Designing and enhancing the reports interface.
Doing the best solution for loading data to escape the bad connection issues.
Creating an analysis document for every report to support – Requirements, Design and Help Manual.
Prepare relevant documentation, Testing, Deployment and Help Manual.
Production support including bug fixes and technical issue resolution.
Bachelor Degree of Computer Science, information systems or any relevant degree.
5 years experience (Should know - Cognos 10 (Framework Manager, c, Query Studio, Report Studio, Analysis Studio, and Event Studio))
Practical experience with SQL, DWH Concepts, Data Analysis
Experience in Dimensional/Data Modeling
Good knowledge with ETL/Reporting basics
Very Good knowledge with IBM Cognos
Prefer to have exposure to Governmental Sector and Financial Services/GL data
Prefer to have exposure to other Data Integration tools.
Prefer to have exposure to other databases such as DB2, SQL Server