Senior Power BI & Reporting Analyst

Socket.dev; Toronto; Hybrid; CAD 97,000 - 129,000; Part time

Job summary

Export Development Canada seeks a Sr Reporting Analyst to migrate Cognos reports to Power BI, design dashboards, and build semantic models. You will partner with business users, data teams, and platform engineers to ensure governance, performance, and usable analytics.

The role emphasizes data validation, documentation, and user support within a hybrid Canada-wide environment. You will drive migration planning, provide technical guidance, and support production deployment while aligning with

Qualifications

• Minimum of 7 years of experience in BI, reporting, analytics for enterprise platforms.
• Experience migrating reports from Cognos to Power BI or similar tools.
• Strong SQL skills and data modeling capabilities.

Responsibilities

• Assess, rationalize, redesign, and rebuild Cognos reports on Power BI.
• Collaborate with stakeholders to define reporting requirements and validate mappings.
• Develop Power BI reports, dashboards, and semantic models.
• Document data lineage, field mappings, and business rules.
• Support testing, reconciliation, and sign-off with business users.

Skills

SQL

Data visualization

Stakeholder management

Requirements gathering

Analytical thinking

Education

Undergraduate degree in Business/CS/MIS/Data Analytics/Finance

Tools

Power BI

Microsoft Fabric

Cognos

Azure DevOps

Job description

Export Development Canada seeks a Sr Reporting Analyst to migrate Cognos reports to Power BI, design dashboards, and build semantic models. You will partner with business users, data teams, and platform engineers to ensure governance, performance, and usable analytics.

The role emphasizes data validation, documentation, and user support within a hybrid Canada-wide environment. You will drive migration planning, provide technical guidance, and support production deployment while aligning with