Senior Data Analyst

Export Development Canada; Toronto; Hybrid; CAD 94,000 - 127,000; Full time

Job summary

Export Development Canada is seeking a Senior Data Analyst to join their team. The position involves translating client requirements into user stories, collaborating with Agile teams, and analyzing data elements for efficiency. Candidates should have extensive experience in data lifecycle management and possess strong analytical and communication skills. This role is perfect for individuals looking to empower Canadian businesses globally through data-driven insights.

Benefits

Flexible benefits

Defined Contribution Pension Plan

Competitive vacation program

Comprehensive wellness programs

Professional Development opportunities

Qualifications

• At least 7 years’ experience as a Data Analyst.
• Experience in dimensional and relational data modeling.
• Hands-on experience with data lifecycle management.

Responsibilities

• Translate client requirements into technical terms and user stories.
• Collaborate with Agile teams to develop solution approaches.
• Analyze data elements and ensure efficient data flow.

Skills

Analytical skills

Communication

SQL programming

Data modeling

Education

Undergraduate Degree in Management Information Systems, Computer Science, or Engineering

Tools

Azure Data Platform

Databricks

Erwin

Job description

Application deadline: June 27th, 2025

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. #LI-Hybrid

Position: Senior Data Analyst

Employment Type: Permanent

Compensation Details :

• Data Analyst 18 : Salaries typically range from $94,664 to $126,218 annually, based on qualifications and experiences, p lus a performance-based incentive .

Location:

• Export Development Canada operates in a hybrid work environment, currently requiring employees to work in the office 2 days per week. (subject to change)
• This role can be performed from EDC’s headquarters in Ottawa or from one of our Community Hubs located in Toronto, Mississauga, Montreal, Brossard or Laval.
• Relocation assistance is available for candidates who meet the eligibility criteria.

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?

• Collaborate with a diverse, experienced team – Work alongside talented professionals who bring a wealth of knowledge and expertise to drive success.
• Thrive in a supportive, teamwork-driven environment – Flourish in a workplace where collaboration and mutual support are paramount.
• Impact global communities through sustainable growth in emerging markets – Make a meaningful difference by fostering sustainable development in key regions around the world.
• Recognized as one of Canada’s Top 100 Employers, Best Diversity Employers, and a Top 100 Family-Friendly Employers – Join a company that is celebrated for its commitment to excellence, diversity, and work-life balance.
• Enjoy a comprehensive Total Rewards package:
  • Flexible benefits – Our program lets you choose coverage that suits your unique needs, including Medical, Dental, Life, and more. Plus, we offer additional Flex credits to tailor your plan even further.
  • Defined Contribution Pension Plan – Secure your future with our generous matching program that helps you save for retirement.
  • Competitive vacation program – Enjoy a work-life balance with our competitive vacation program, starting with 4 weeks of vacation and 2 floater days each year for permanent employees.
  • Comprehensive wellness programs – Stay healthy and happy with access to wellness initiatives, mental health support, and fitness programs.
  • Professional Development – Advance your career with our support for growth and development through conferences, language training, and educational opportunities.

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.
• As a member of the Data Analysis Chapter, the Senior Data Analyst works as a liaison between the business and technical communities in the development of data solutions that support the business needs. The Senior Data Analyst, while applying digital principles, elicits, analyzes, communicates, validates, and translates data business needs into communications, agile stories (EPIC, Features, Stories and Tasks) and other documentation. This role also requires an enhanced understanding and experience with Data modeling and analysis techniques to build and maintain transformation rules and source to target mappings.
• The Senior Data Analyst should be able to understand client ask, work with clients to deep dive into the business rules and data transformation rules requirements, as well as analyze and document new data requirements and to be able to help the design of the new data integration stream or update the existing data pipeline.
• The Senior Data Analyst is an active participant in an Agile team and all phases of the product lifecycle and will work with the squad, various technology stakeholders, and internal customers to identify and maximize opportunities to leverage information and technology capabilities to enable business use cases. The Senior Data Analyst assesses processes and information streams and is proficient in the utilization of the appropriate tools, models, and techniques as part of delivering capabilities.
• This position requires digital competencies, an ability to learn new solutions rapidly, the agility to respond to constant change, strong IT knowledge, as well as excellent communications and analytical skills. It also necessitates strong collaborative and relationship management skills given the high level of interaction.

What you will be doing:

• Understand client requirementsand translating 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 to determine compatibility and fit with architectural principles and optimal solution design.
• Research and document data platformsand outputs, including source-to-target mapping, business rules for data transformation, data cataloging, and data lineage.
• Analyze system data elementsand existing data structures, understanding data lineage from source to target, and ensuring efficient data flow between users and stakeholders.
• Utilize end-to-end data process knowledgeto analyze, cleanse, and enrich data elements, ensuring accuracy and consistency.
• Collect, organize, analyze, and disseminate informationwith attention to detail and accuracy, and deconstructing complex technical solutions for non-technical audiences.
• Present complex issues to stakeholdersusing persuasion, influence, negotiation, and conflict resolution skills, and leading sessions to review data requirements and achieve consensus.
• Deliver clear and usable documentationthat supports the sign-off process and is serviceable for technical project members
• Participate in sprint-based activities such as Sprint Reviews, Retrospectives, and backlog refinements.

What we are looking for:

• Completed an Undergraduate Degree in Management Information Systems, Computer Science or Engineering, Commerce, Business, or related field.
• Minimum of 7 years’ experience as a dedicated Data Analyst.
• Well-rounded experience in the whole data lifecycle management and hands-on experience in the following data management domains: dimensional and relational data modeling, data quality, SQL programming, ETL development, metadata management and master data management.
• Experience with reverse engineering the source to target mapping to gain data insights.
• Ability to produce ETL specification based on the physical data model.
• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
• Excellent oral and written communication skills. Ability to communicate with both business and technical audiences. Strong listening skills.

What will make you stand out:

• Experience with Azure Data Platform technologies.
• Experience with Databricks.
• Experience with data modeling technologies such as Erwin.
• Knowledge of Spark SQL.
• Programming experience: SQL, R, Python.
• Excellent verbal and written communication, critical thinking, time management, priority planning and interpersonal skills.
• Strong relationship management skills, including facilitating group sessions and displaying leadership within a project team.
• Strong problem-solving skills.
• Experienced in an agile environment and can pivot to support changing business priorities.
• Bilingual 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.The position is open to those who meet all of the essential requirements stated above and whose applications are received by the closing date.

This position is open to individuals who meet all the essential criteria outlined above and submit their applications by the closing date. Ready to make a difference? This is your chance to join a dynamic, growing team and leave your mark on our organization, development finance, and the world.

Apply today!

Want to learn more about EDC? Check our website here https://www.edc.ca

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.

Should you require any accommodation during the recruitment and selection process, please let our Recruitment team know

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.