Middle (2-5 ani), Senior (5-10 ani)
Adresa/ adresele jobului
Analyze business requirements, raw data to produce a structured relational and/or dimensional data model that resonates with the user requirement and document the technical/functional requirement into standardized templates that facilitate easy and defect free development
Develop Framework Manager Models, BI Reports and Dashboards in IBM Cognos
Strong Knowledge of the Cognos reporting tool suite (Report Studio, Analysis Studio, Event studio, Cognos cubes, Cognos SDK)
Strong understanding of database and SQL. Experience with improving query performance and analyzing Cognos Query and Native Query. Create SQL queries against Oracle/SQL Server for data profiling, troubleshooting and tactical ad hoc reporting
Strong data modeling experience with multi-dimensional cubes, balanced/ragged hierarchies, logical/physical entity, 3nf, marts/star/snowflake
6-8+ years’ experience in Business Intelligence/Data Warehousing
Cognos SDK experience a plus
Understand business concepts behind reporting specifications
Produce technical design documentation including logical data models and detailed reporting specification consistent with reporting requirement.
Liaison with internal team of business analysts, project managers, architects, developers and infrastructure teams to ensure all functional and non‐functional requirements are met.
Conduct troubleshooting, root cause analysis, and problem resolution for report functions/specification