- Analyze existing Cognos reports, packages, queries, prompts, calculations, filters, security requirements, and usage patterns to determine migration scope and complexity
- Work with business stakeholders to confirm reporting requirements and identify redundant or low-value reports
- Recommend opportunities for report consolidation, redesign, or retirement
- Document report logic, data sources, field mappings, layouts, dependencies, and business rules
- Design and develop Power BI reports, dashboards, paginated reports, and semantic models
- Transform and validate data using SQL, Power Query, DAX, and approved enterprise data sources
- Support user acceptance testing and reconcile results between Cognos and Power BI
- Investigate variances and document testing outcomes
- Collaborate with data engineering, architecture, governance, and platform teams
- Ensure reports are secure, performant, maintainable, and aligned with target data architecture
- Prepare report inventory updates, technical documentation, user guidance, and knowledge-

📌 Senior Reporting Analyst – 15 Month Contract (Ottawa)
🏢 Jobtailor
📍 Ottawa