Export Development Canada | Exportation et développement Canada
Export Development Canada | Exportation et développement Canada
1,001 – 5,000 Employees
FinanceGovernmentInsurance
Export Development Canada (EDC) is Canada’s federal export credit agency and a Crown corporation supporting Canadian companies as they enter and expand in international markets. Its finance and insurance teams provide trade credit insurance, guarantees, working-capital support, export and buyer financing, structured and project finance, and equity investment. EDC also combines market intelligence, advisory services, digital tools, and specialized initiatives such as the Trade Impact Program and Business Connections. The organization serves exporters across industries including agri-food, cleantech, defence, and energy, with a focus on managing international risk, diversifying markets, enabling sustainable trade, and helping businesses compete globally.

Senior Data Analyst (12-Month Contract) – Ottawa Hybrid

Senior Data Analyst supporting enterprise data modernization at Export Development Canada. The role covers requirements analysis, data modelling, mappings, pipelines and Agile delivery.

Description

  • Bridge business and technical teams to develop data solutions aligned with organizational needs.
  • Gather, assess, communicate, validate and convert data requirements into communications, Agile work items and project documentation.
  • Use advanced data modelling and analysis methods to create and maintain transformation rules and source-to-target mappings.
  • Evaluate business rules and transformation needs, documenting emerging data requirements.
  • Help design new data integration streams and enhance existing data pipelines.
  • Interpret client needs and convert them into technical specifications and user stories.
  • Work with Agile teams, Business Analysts, Data Architects and Data Engineers to shape solution approaches.
  • Assess and recommend conceptual, logical and physical data models.
  • Investigate and document data platforms and outputs, including mappings, transformation rules, cataloguing and lineage.
  • Examine system data elements and structures, trace lineage and help maintain efficient data flows.
  • Analyze, cleanse and enrich data to support accuracy and consistency.
  • Organize, interpret and communicate complex information, explaining technical solutions to non-technical stakeholders.
  • Facilitate data-requirements sessions and present complex issues to help teams reach consensus.
  • Create documentation required for sign-off and technical project contributors.
  • Take part in sprint reviews, retrospectives, backlog refinement and other sprint activities.

Requirements

  • Undergraduate degree in Management Information Systems, Computer Science, Engineering, Commerce, Business or a related discipline.
  • At least seven years of dedicated Data Analyst experience.
  • Experience working with Microsoft Fabric.
  • Broad data-lifecycle experience spanning dimensional and relational modelling, data quality, SQL programming, ETL development, metadata management and master data management.
  • Experience reverse-engineering source-to-target mappings to derive data insights.
  • Ability to create ETL specifications from physical data models.
  • Strong analytical ability, with a track record of accurately collecting, organizing, analyzing and disseminating substantial amounts of information.
  • Excellent written and verbal communication skills for both business and technical audiences.
  • Experience with Azure Data Platform technologies and Databricks.
  • Experience using data modelling tools such as Erwin.
  • Knowledge of Spark SQL.
  • Programming experience in SQL, R or Python.
  • Strong communication, critical-thinking, time-management, prioritization and interpersonal abilities.
  • Strong relationship-management skills, including group facilitation and leadership within project teams.
  • Strong problem-solving ability.
  • Experience in Agile environments and flexibility when business priorities change.
  • French-English bilingualism is an advantage.
  • Must be legally authorized to work in Canada when applying; Canadian Citizens or Permanent Residents are preferred.
  • Must satisfy the required government security screening conditions.

Benefits

  • Competitive compensation and benefits package
  • Work-life balance
  • Hybrid work options
  • Three to four weeks of paid vacation
  • Corporate closure period
  • Early Fridays during the summer
  • Fridays without meetings
  • Ongoing learning opportunities
  • Training programs
  • Workshops
  • Language training
  • Inclusive workplace with employment equity
  • Wellness initiatives
  • Mental health support
  • Fitness programs
  • Volunteer opportunities
  • Social responsibility programs
  • Performance-based incentive

Related Jobs

NVIDIA

NVIDIA Senior Manager, Rack-Scale Systems Software Engineering

NVIDIA

Lead NVIDIA’s engineering team building rack-scale infrastructure software for AI computing systems. Drive control planes, lifecycle orchestration, reliability, and delivery across teams.

Open