Sr Data Analyst (12 months) - 030 EN

Role overview

Responsibilities

• Translate client data requirements into technical terms, documentation, and Agile work items.
• Collaborate with Agile teams, Business Analysts, Data Architects, and Data Engineers on solution approaches.
• Review conceptual, logical, and physical data models for architectural alignment.
• Document data platforms, source-to-target mappings, transformation rules, data cataloguing, and lineage.
• Analyze data structures and flows; cleanse and enrich data to improve accuracy and consistency.
• Lead requirements sessions, communicate technical information to varied audiences, and produce documentation for sign-off.
• Participate in sprint reviews, retrospectives, backlog refinement, and other Agile activities.

Required qualifications

• Undergraduate degree in Management Information Systems, Computer Science, Engineering, Commerce, Business, or a related field.
• At least seven years of dedicated Data Analyst experience and experience with Microsoft Fabric.
• Hands-on experience in dimensional and relational modeling, data quality, SQL, ETL development, metadata management, and master data management.
• Experience reverse-engineering source-to-target mappings and producing ETL specifications based on physical data models.
• Strong analytical accuracy and excellent oral and written communication for business and technical audiences.

Preferred qualifications

• Azure Data Platform technologies, Databricks, and data modeling tools such as Erwin.
• Spark SQL and programming experience with SQL, R, or Python.
• Agile experience, adaptability, and strong communication, critical-thinking, planning, interpersonal, problem-solving, and relationship-management skills.
• French and English bilingualism.

Compensation

• The stated annual salary range is $94,664–$128,743, with a performance-based incentive.

Employment term

• Contract / temporary assignment for 12 months.

Workplace

• Hybrid arrangement currently requires two office days per week, subject to change.
• Work may be based at EDC headquarters in Ottawa or a Community Hub in Ottawa, Toronto, Mississauga, Montreal, Brossard, or Laval.