Senior Data Analyst – 12 months

Export Development Canada | Exportation et développement Canada

. Act as a liaison between business and technical communities to develop data solutions supporting business needs.

Posted 10/3/2026contractOttawa • CanadaSenior💰 CA$96,557 - CA$128,743 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in data analysis, data modeling, and ETL development, with a strong ability to translate business requirements into technical specifications. Proficient in collaborating with cross-functional teams in Agile environments to deliver data solutions that meet business needs.

Highest-signal resume keywords

Data AnalysisETL DevelopmentSQL ProgrammingData ModelingAgile Methodologies

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data ModelingSQL ProgrammingETL DevelopmentData QualityDimensional Data ModelingRelational Data ModelingData TransformationData LineageData CataloguingData Cleansing

Soft Skills

Analytical SkillsCommunication SkillsProblem-Solving SkillsInterpersonal SkillsTime Management

Tools & Technologies

Microsoft FabricAzure Data PlatformDatabricksErwinSpark SQL

Industry Keywords

Data LifecycleMaster Data ManagementMetadata ManagementAgile EnvironmentBilingualism

Tech Stack

Tools & technologies

AzureETLPythonSparkSQL

About the role

Key responsibilities & impact

Act as a liaison between business and technical communities to develop data solutions supporting business needs.
Elicit, analyze, communicate, validate and translate data requirements into communications, Agile work items and documentation.
Apply advanced data modelling and analysis techniques to build and maintain transformation rules and source-to-target mappings.
Examine business rules and data transformation requirements and document new data needs.
Contribute to designing new data integration streams and updating existing data pipelines.
Understand client requirements and translate them into technical terms and user stories.
Collaborate with Agile teams, Business Analysts, Data Architects and Data Engineers on solution approaches.
Review and recommend conceptual, logical and physical data models.
Research and document data platforms and outputs, including mappings, transformation rules, data cataloguing and data lineage.
Analyze system data elements and structures, trace data lineage and support efficient data flow.
Analyze, cleanse and enrich data to ensure accuracy and consistency.
Collect, organize, analyze and share complex information; explain technical solutions to non-technical audiences.
Lead data-requirements sessions and present complex issues to build consensus.
Produce documentation supporting sign-off and technical project members.
Participate in sprint reviews, retrospectives, backlog refinement and other sprint activities.

Requirements

What you’ll need

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, 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 based on physical data models.
Strong analytical skills and ability to collect, organize, analyze and disseminate significant amounts of information accurately.
Excellent oral and written communication skills for business and technical audiences.
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 French and English is an advantage.
Ability to work legally in Canada at the time of application, with preference for Canadian Citizens or Permanent Residents.
Must meet requisite government security screening requirements.

Benefits

Comp & perks

Competitive compensation and benefits package
Work-life balance
Hybrid work options
3 to 4 weeks paid vacation
Corporate closure period
Summer early Fridays
No meeting Fridays
Continuous learning opportunities
Training programs
Workshops
Language training
Inclusive workplace and employment equity
Wellness initiatives
Mental health support
Fitness programs
Volunteer opportunities
Social responsibility programs
Performance-based incentive