Sr Reporting Analyst (15 month contract) - 280 EN

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

Join the EDC Team!

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.

Position: Sr Reporting Analyst

Employment Type: Contract

Compensation Details:

• Data Analyst 18: Salaries typically range from $96,557 to $128,743 annually, based on qualifications and experiences.

Location:

• Export Development Canada operates under a hybrid work model, with employees currently required to work from the office two days per week. Effective September 2026, this requirement will increase to three days per week and will be implemented gradually through a phased approach based on employee location. (subject to change).
• This role can be performed from EDC's headquarters in Ottawa or from one of our community hubs located in Montreal, Toronto, Mississauga, Brossard, Laval, Calgary, Edmonton, Vancouver, or Halifax.

Internal Employees, please consult the ServiceNow article entitled Internal movements - what you need to know.

About EDC:

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.

Why Join EDC?

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

Team Overview:

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.

What you will be doing:

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.

What we are looking for:

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

What will make you stand out:

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

Eligibility:

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.

EDC's Commitment to Employment Equity

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 [e-mail]. 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