Impress employers and recruiters.
Choose from hundreds of resume examples.

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

Tailor your resume to this Sr Reporting Analyst (15 month contract) - 280 EN role.

Rezi rewrites your resume against Export Development Canada | Exportation et développement Canada's job description. Free.

Tailor your resume to this Sr Reporting Analyst (15 month contract) - 280 EN role.

Rezi rewrites your resume against Export Development Canada | Exportation et développement Canada's job description. Free.

Tailor my resume

Don't guess if your resume is good enough.

See how it scores against the Sr Reporting Analyst (15 month contract) - 280 EN posting at Export Development Canada | Exportation et développement Canada — free, in seconds.

Don't guess if your resume is good enough.

See how it scores against the Sr Reporting Analyst (15 month contract) - 280 EN posting at Export Development Canada | Exportation et développement Canada — free, in seconds.

Get my score

About the Role

The Reporting Analyst will play a key role in assessing, rationalizing, redesigning, and rebuilding existing Cognos reporting assets on the Power BI platform. The successful candidate will work closely with business users, data teams, technology partners, and report owners to understand current-state reporting needs, document data and business logic, validate source-to-target mappings, and build Power BI reports and semantic models that meet EDC standards for governance, performance, usability, and supportability.

Responsibilities

• 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, identify redundant or low-value reports, and recommend opportunities for consolidation, redesign, or retirement.
• Document current-state report logic, data sources, field mappings, report layouts, dependencies, and business rules.
• Design and develop Power BI reports, dashboards, paginated reports, and semantic models that align with EDC reporting standards and business needs.
• Transform and validate data using SQL, Power Query, DAX, and approved enterprise data sources, ensuring accuracy and traceability from legacy reports to new Power BI outputs.
• Support user acceptance testing, reconcile results between Cognos and Power BI, investigate variances, and document testing outcomes.
• Collaborate with data engineering, architecture, governance, and platform teams to ensure reports are secure, performant, maintainable, and aligned with EDC’s target data architecture.
• Prepare report inventory updates, technical documentation, user guidance, and knowledge transfer materials for support teams and business users.
• Contribute to migration planning, backlog refinement, prioritization, status reporting, and issue/risk tracking.
• Support production deployment, post-implementation validation, and transition of migrated reports into ongoing support.

Requirements

• Undergraduate degree in Business, Computer Science, Management Information Systems, Data Analytics, Finance, or a related discipline, or an equivalent combination of education and experience.
• Minimum of 7 years of experience in business intelligence, reporting, analytics, developing large scale reporting/analytics in enterprise analytics platforms such as Cognos, Tableau, Power BI or similar.
• Experience working with Microsoft Fabric
• Experience developing Power BI reports, dashboards, semantic models, or paginated reports.
• Experience analyzing, reverse engineering, or migrating reports from IBM Cognos Analytics to Power BI: Report Studio, Framework Manager, Cognos packages, prompts, and audit/usage analysis.
• Strong SQL skills and experience working with relational databases, data marts, data warehouses, or enterprise data platforms.
• Demonstrated ability to gather requirements, document business logic, validate results, and communicate findings to both technical and business audiences.
• Experience supporting report testing, reconciliation, defect resolution, and stakeholder sign-off.
• Ability to quickly understand complex legacy reports and translate them into modern, user-friendly analytics products.
• Ability to balance business context with technical detail, ensuring that migrated reports are not simply replicated but improved where appropriate.
• Ability to communicate clearly with report users, developers, architects, and platform teams, helping bridge business needs and technical implementation.
• Experience working in financial services, insurance, banking, Crown corporations, or regulated reporting environments.
• Experience with data governance, metadata documentation, lineage, report inventory management, and controlled report retirement.
• Familiarity with Agile delivery, Azure DevOps, backlog management, and iterative report development.
• Bilingualism in both official languages, English and French.
• Ability to work legally in Canada.
• Must meet requisite government security screening requirements.

Skills

• Cognos
• Power BI
• Microsoft Fabric
• SQL
• Power Query
• DAX
• Agile delivery
• Azure DevOps

Location

• Ottawa
• Montreal
• Toronto
• Mississauga
• Brossard
• Laval
• Calgary
• Edmonton
• Vancouver
• Halifax

Work Type

• Hybrid
• Contract

Experience Level

• Senior
• Minimum of 7 years of experience

Education Level

• Undergraduate degree in Business, Computer Science, Management Information Systems, Data Analytics, Finance, or a related discipline, or an equivalent combination of education and experience.

Salary/Compensations

• $96,557 to $128,743 annually

Benefits

• Competitive compensation & benefits package
• Work-life balance
• 3 to 4 weeks paid vacation
• Corporate closure period
• Summer early Friday’s
• No meeting Fridays
• Continuous learning opportunities, including training programs, workshops and language training
• Inclusive and diverse workplace
• Wellness initiatives, mental health support, and fitness programs
• Community engagement and volunteer opportunities

About the Company

• At EDC, we support Canadian businesses to succeed globally. We provide the financial tools and expertise they need to explore new markets, reduce risks, all towards the goal of making Canada and the world better through trade.
• At Export Development Canada (EDC), we empower Canadian businesses to succeed globally. As a financial Crown corporation, we offer innovative financial solutions and expert insights to help businesses explore new markets, mitigate risks, and achieve growth.
• The Digital & Technology Solutions (DTS) group under the leadership of the Chief Information Officer was established in 2023 with the mission of empowering our customers and colleagues to take on the world, by seamlessly delivering secure and reliable digital experiences.
• The Data Transformation Initiative team oversees transformation initiatives to enable business areas across EDC to make timely, informed decisions through trusted reporting, analytics, and data products. As EDC continues to modernize its reporting ecosystem, this role will support the migration and modernization of legacy Cognos reports to Microsoft Power BI/Fabric.

Equal Opportunity

• EDC is committed to fostering employment equity and building a diverse workforce. We are committed to creating a safe and inclusive environment that respects people from all cultures, backgrounds, and abilities. At EDC, we nurture a culture of inclusion and belonging where everyone has equal opportunity to grow, develop, succeed, and be their truest selves.
• We actively encourage applications from women, Indigenous peoples, visible minorities, persons with disabilities, and members of the 2SLGBTQI+ community.