"Cognos Analyst/Developer – Cognos & Power BI The Cognos Analyst/Developer will perform detailed analysis of the existing Cognos reporting setting and Power BI reports to identify duplicate, obsolete, and underutilized reporting assets. The resource will assess report dependencies, business logic, data sources, data lineage, and KPI calculations to support reporting rationalization, consolidation, migration, and decommissioning planning. The role will leverage technical expertise in IBM Cognos Analytics and Microsoft Power BI to evaluate reporting capabilities, identify opportunities for standardization, and document migration and retirement considerations.

Key Responsibilities

Analyze Cognos reports, packages, models, and reporting structures, along with Power BI reports, dashboards, semantic models, and datasets.

Document report dependencies, source systems, data lineage, and upstream and downstream relationships across Cognos and Power BI.

Assess report complexity, business relevance, usage patterns, and user adoption to identify rationalization opportunities.

Identify duplicate reports, overlapping dashboards, and redundant reporting capabilities across both platforms.





Analyze KPI calculations, business rules, filters, and aggregation logic to ensure consistency across Cognos and Power BI.

Assess Power BI data models, relationships, DAX measures, Power Query transformations, and data refresh dependencies.

Support report consolidation, standardization, and migration from Cognos to Power BI, where applicable.

Evaluate opportunities to reuse Power BI semantic models, datasets, and existing dashboards to reduce duplication and improve reporting efficiency.

Develop technical recommendations for report archival, migration, and decommissioning readiness.

Conduct impact assessments for report retirement, including dependencies on business processes, data sources, and downstream reporting.

Document migration considerations, gaps in functionality, KPI mapping, and validation requirements for reports transitioning between platforms.

Collaborate with business stakeholders, data teams, and reporting owners to validate report usage, business requirements, and retirement decisions."

📌 Lead Software Engineer (Hyderabad)
🏢 Virtusa
📍 Hyderabad