Sr Reporting Analyst (15 month contract) - 280 EN

Position Overview

Compensation

• The stated salary range is $96,557 to $128,743 annually, based on qualifications and experience.

Work Model

• The role follows a hybrid work model with employees currently required to work from the office two days per week.
• Effective September 2026, the office requirement is expected to increase to three days per week through a phased approach, subject to change.
• The role can be performed from EDC locations in Ottawa, Montreal, Toronto, Mississauga, Brossard, Laval, Calgary, Edmonton, Vancouver, or Halifax.

Reporting Migration

• Analyze Cognos reports, packages, queries, prompts, calculations, filters, security requirements, and usage patterns to determine migration scope.
• Confirm reporting requirements with business stakeholders and recommend consolidation, redesign, or retirement opportunities.
• Document report logic, data sources, mappings, layouts, dependencies, and business rules.
• Design and develop Power BI reports, dashboards, paginated reports, and semantic models.

Data, Testing, and Delivery

• Transform and validate data using SQL, Power Query, DAX, and approved enterprise data sources.
• Support user acceptance testing, reconcile Cognos and Power BI results, investigate variances, and document testing outcomes.
• Collaborate with data, architecture, governance, and platform teams on security, performance, maintainability, and target architecture.
• Support deployment, post-implementation validation, and transition into ongoing support.

Documentation and Planning

• Prepare report inventory updates, technical documentation, user guidance, and knowledge transfer materials.
• Contribute to migration planning, backlog refinement, prioritization, status reporting, and issue and risk tracking.

Required Qualifications

• An undergraduate degree in a related discipline or an equivalent combination of education and experience is required.
• At least seven years of experience in business intelligence, reporting, analytics, or large-scale enterprise reporting development is required.
• Experience with Microsoft Fabric, Power BI development, and IBM Cognos report migration is required.
• Strong SQL skills and experience with enterprise data platforms are required.
• Experience gathering requirements, documenting business logic, validating results, and supporting report testing is required.

Preferred Qualifications

• Experience in financial services, insurance, banking, Crown corporations, or regulated reporting environments is preferred.
• Experience with data governance, metadata, lineage, report inventory management, and controlled report retirement is preferred.
• Familiarity with Agile delivery, Azure DevOps, backlog management, and iterative report development is preferred.
• Bilingualism in English and French is preferred.