Sr Data Analyst (12 months) - 030 EN

Export Development Canada | Exportation et développement Canada; Montreal (administrative region); Hybrid; CAD 95,000 - 129,000; Part time

Benefits offered by this job

Hybrid work options

Comprehensive benefits

Language training

Professional development

Inclusive culture

Wellness programs

Community engagement

Job summary

Export Development Canada (EDC) seeks a Senior Data Analyst to join the Data Transformation Initiatives team. You will liaison between business and technical teams to translate requirements into data solutions and agile work items.

You will design transformations, maintain mappings, and work with clients to define data needs. Strong IT knowledge and communication are essential for collaboration across disciplines.

Qualifications

• Seven years of dedicated Data Analyst experience.
• Experience with Microsoft Fabric.
• Broad experience across the data lifecycle, including dimensional and relational data modelling, data quality, SQL programming, ETL development, metadata management and master data management.
• Experience reverse-engineering source-to-target mappings to generate data insights.
• Ability to produce ETL specifications from physical data models.
• Strong analytical skills with the ability to organize, analyze and disseminate large amounts of information.

Responsibilities

• Understand client requirements and translate them into technical terms and user stories.
• Collaborate with Agile teams, Data Architects and Data Engineers to develop solution approaches.
• Review and align data models with architectural principles for optimal design.
• Document data platforms, including source-to-target mappings and data lineage.
• Analyze data elements and support efficient data flow for users and stakeholders.
• Apply end-to-end data process knowledge to cleanse and enrich data.
• Lead data-requirements sessions and build consensus.
• Produce clear documentation to support sign-off by technical teams.
• Participate in sprint reviews and backlog refinement.

Skills

Data analysis

Stakeholder collaboration

Agile methods

SQL

ETL development

Data modelling

Education

Bachelor's degree in a related field

Tools

Microsoft Fabric

Azure Data Platform

Job description

Application deadline:

Oct. 16, 2026 at 12:00PM ET

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:

Data Analyst 18

Employment Type:

Contract / Temporary assignment - 12 months

Compensation Details:

• Data Analyst 18: Salaries typically range from $94,664 to $128,743 annually, based on qualifications and experiences, plus a performance-based incentive

Location:

• Hybrid (), currently requiring three days per week in the office, subject to change
• This role can be performed from EDC's headquarters in Ottawa or from one of our Community Hubs located in Ottawa, Toronto, Mississauga, Montreal, Brossard or Laval.

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 Data Transformation Initiatives (DTI) team leads the Enterprise Data Ops and Technology's (EDOT) major data modernization programs, helping EDC build modern, scalable, and sustainable enterprise data capabilities. Working closely with business partners and teams across EDOT, DTI delivers strategic initiatives that improve how data is governed, integrated, managed, and consumed across the organization.

DTI's portfolio includes initiatives that modernize EDC's data ecosystem, retire legacy technologies, improve data quality and accessibility, and establish enterprise data management capabilities.

About the Role:

As a member of the DTI team, the Senior Data Analyst acts as a liaison between business and technical communities to develop data solutions that support business needs. You will elicit, analyze, communicate, validate and translate data requirements into clear communications, Agile work items—including epics, features, stories and tasks—and other documentation.

You will apply advanced data modelling and analysis techniques to build and maintain transformation rules and source-to-target mappings. Working closely with clients, you will examine business rules and data transformation requirements, document new data needs, and contribute to the design of new data integration streams or updates to existing data pipelines.

As an active member of an Agile team, you will participate throughout the product lifecycle and collaborate with squad members, technology stakeholders and internal customers. Success in this role requires strong digital and IT knowledge, the ability to learn new solutions quickly, adaptability, excellent communication and analytical skills, and strong relationship-management capabilities.

What you will be doing:

• Understand client requirements and translate them into technical terms and user stories
• Collaborate with Agile teams, Business Analysts, Data Architects and Data Engineers to develop solution approaches
• Review and recommend conceptual, logical and physical data models for alignment with architectural principles and optimal solution design
• Research and document data platforms and outputs, including source-to-target mappings, data transformation rules, data cataloguing and data lineage
• Analyze system data elements and existing structures, trace data lineage from source to target, and support efficient data flow among users and stakeholders
• Apply end-to-end data process knowledge to analyze, cleanse and enrich data, ensuring accuracy and consistency
• Collect, organize, analyze and share complex information with precision, and explain technical solutions to non-technical audiences
• Lead data-requirements sessions and present complex issues using persuasion, influence, negotiation and conflict-resolution skills to build consensus
• Produce clear, usable documentation that supports sign-off and can be used by technical project members
• Participate in sprint reviews, retrospectives, backlog refinement and other sprint-based activities

What we are looking for:

• An undergraduate degree in Management Information Systems, Computer Science, Engineering, Commerce, Business or a related field
• At least seven years of dedicated Data Analyst experience
• Experience with Microsoft Fabric
• Broad experience across the data lifecycle, with hands-on expertise in dimensional and relational data modelling, data quality, SQL programming, ETL development, metadata management and master data management
• Experience reverse-engineering source-to-target mappings to generate data insights
• Ability to produce ETL specifications based on physical data models
• Strong analytical skills and the ability to collect, organize, analyze and disseminate significant amounts of information with accuracy and attention to detail
• Excellent oral and written communication skills, including the ability to communicate effectively with business and technical audiences and listen actively

What will make you stand out:

• Experience with Azure Data Platform technologies and Databricks
• Experience with data modelling technologies such as Erwin
• Knowledge of Spark SQL
• Programming experience with SQL, R or Python
• Strong communication, critical-thinking, time-management, priority-planning and interpersonal skills
• Strong relationship-management skills, including facilitating group sessions and demonstrating leadership within a project team
• Strong problem-solving skills
• Experience working in an Agile environment and adapting to changing business priorities
• Bilingualism in both official languages - French and English

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

Privacy Notice

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.