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 (#LI-Hybrid), currently requiring two 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 accessibility@edc.ca. 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.
