Sr Reporting Analyst (15 month contract) - 280 EN

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.

Comprehensive Benefits: EDC offers a competitive compensation & benefits package, work-life balance, & the opportunity to help make Canada and the world better through trade.

Work-Life Balance: EDC offers a competitive compensation package & work-life balance. We have hybrid work options, 3 to 4 weeks paid vacation, a corporate closure period, summer early Friday’s & no meeting Fridays.

Professional Development: Take advantage of our continuous learning opportunities, including training programs, workshops and language training.

Inclusive Culture: Be part of a diverse and inclusive workplace that champions employment equity & values diversity of ideas, strengths, & backgrounds to succeed.

Wellness Programs: Access to wellness initiatives, mental health support, and fitness programs to keep you healthy and happy.

Community Engagement: Participate in volunteer opportunities and give back to the community through our various social responsibility programs.

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. Digital & Technology Solutions has set out to achieve the following objectives for EDC:

Define, execute, and sustain the integrated technology target state, target data model and technology operations required to enable EDC’s 2030 business transformation.

Establish and manage the rolling 3 Year Digital Roadmap that sequences the technology outcomes required to achieve the technology target state and facilitate its execution across all domains in the organization.

Keep pace with industry trends and emerging technologies, ensuring EDC has access to the digital technology tools it needs to stay relevant in the market and grow Canadian global trade.

Lead and ensure integrated digital, data, infrastructure, and cybersecurity implementations to create excellent customer, user, and employee 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.

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.

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.

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.

You can quickly understand complex legacy reports and translate them into modern, user-friendly analytics products.

You balance business context with technical detail, ensuring that migrated reports are not simply replicated but improved where appropriate.

You 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.

EDC is committed to Fair Employment Practices and preference will be given to a candidate who is able to work legally in Canada at the time of application (Canadian Citizens or Permanent Residents). Candidates must meet the requisite government security screening requirements. Internal applicants must also meet EDC's eligibility criteria for applying to internal opportunities. For more information, please refer to Section 2.1 in the Talent Acquisition Standard, available on LINK under the Resources tab in the Policies & Procedures section. The position is open to those who meet all of the essential requirements stated above and whose applications are received by the closing date. The position is open to those who meet all of the essential requirements stated above and whose applications are received by the closing date.

Export Development Canada (EDC) is dedicated 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.

Your application must clearly demonstrate how you meet all the requirements. We thank all applicants' interest in a career at EDC; however, only those selected for an interview will be contacted. Please note that qualified candidates may be considered for similar roles at this level within EDC.

EDC recognizes that disclosing the need for accommodations can be a personal matter. Please know that as an organization, we are committed to maintaining confidentiality and ensuring that any accommodations provided are tailored to support your needs. Our aim is to ensure you have a comfortable and positive experience throughout the recruitment process, so please do not hesitate to contact us directly for any accommodation requests at accessibility@edc.ca . We are here to support you every step of the way.

By applying for this job you acknowledge that you have read and understood EDC’s Privacy Notice for Job Applicants , which outlines how we collect, use, retain, and safeguard personal information during the recruitment process, as well as your rights of access and correction