Client Data Analyst

Export Development Canada | Exportation et développement Canada

. Develop, maintain, and improve data pipelines, data flows, datasets, semantic models, and analytical assets for customer analytics and Marketing .

Posted 10/7/2026full-timeOttawa • CanadaMid-LevelSenior💰 CA$65,172 - CA$86,898 per yearWebsite

Core Competencies

Role fit

Core Competencies

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

Demonstrates expertise in data pipeline development, transformation, and integration using SQL, Python, and Power BI, while ensuring data quality and governance. Capable of translating complex business requirements into actionable data solutions and analytical insights.

Highest-signal resume keywords

SQL Query WritingPython ProgrammingPower BI Dashboard DesignData Pipeline DevelopmentData Quality Analysis

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 TransformationData IntegrationETL ProcessesData FlowsData WarehousingData LakesAnalytical ApplicationsMLOps PracticesData MiningStatistical Analysis

Soft Skills

Analytical SkillsProblem-SolvingCollaborationCommunicationAttention to Detail

Tools & Technologies

Microsoft FabricPower BIDenodoData Governance ToolsData Quality Monitoring Tools

Industry Keywords

Customer AnalyticsMarketing AnalyticsBusiness IntelligenceData GovernanceOperational Environment

Tech Stack

Tools & technologies

ETLFluxPythonSQLTypeScript

About the role

Key responsibilities & impact

Develop, maintain, and improve data pipelines, data flows, datasets, semantic models, and analytical assets for customer analytics and Marketing
Migrate and redirect production reporting data flows and assets from Denodo and spreadsheet-based processes to the Enterprise Data Platform and Microsoft Fabric
Analyze data artifacts, business rules, calculations, and dependencies to rebuild or adapt them when systems, fields, or logic change
Develop and optimize curated datasets and semantic models for Power BI, analytical applications, and advanced analytics
Create, maintain, and improve Power BI dashboards and reports
Use SQL, Python, R, or comparable languages to acquire, transform, integrate, analyze, and validate structured data
Develop scripts, notebooks, utilities, or lightweight applications to automate processes and address operational and analytical challenges
Contribute to the deployment and operationalization of analytical applications and models in accordance with development and MLOps practices
Troubleshoot data, refresh, integration, and reporting issues; perform root cause analyses and implement corrective actions
Conduct exploratory analyses and data mining on customer-related behaviors, engagement patterns, preferences, segments, and opportunities
Support the preparation of customer and prospect data for campaign planning, targeting, personalization, measurement, and reporting
Apply quality controls, validation rules, documentation standards, and governance requirements to customer and marketing data
Support data acquisition, vendor data processing, quality monitoring, and reporting
Document sources, transformations, business rules, calculations, dependencies, controls, and operating procedures
Collaborate with Marketing, analytics, data platform, governance, technology, and other stakeholders
Communicate analytical findings, technical issues, recommendations, and progress to technical and non-technical audiences
Share knowledge, contribute to team standards, and strengthen succession coverage for critical analytical processes and assets
Identify opportunities to improve automation, reliability, scalability, and efficiency across the data environment

Requirements

What you’ll need

Bachelor’s degree in computer science, data science, mathematics, statistics, engineering, business analytics, management information systems, marketing analytics, or a related field, or an equivalent combination of education and relevant experience
Relevant experience in data development, transformation, integration, or analysis in an operational or production environment
Hands-on experience writing SQL queries
Hands-on programming experience in Python, R, or a comparable language
Experience designing reports, dashboards, datasets, or data models using Power BI or a comparable business intelligence platform
Experience with data pipelines, ETL processes, data flows, data warehouses, data lakes, or lakehouse environments
Demonstrated ability to understand and adapt existing data assets and business logic
Experience analyzing and resolving issues related to data quality, integration, refreshes, or reporting
Strong analytical and problem-solving skills, with a focus on accuracy, controls, and attention to detail
Ability to translate business requirements into technical tasks and data solutions
Ability to explain technical concepts and analytical findings in clear business language
Ability to manage priorities, work independently, and contribute within cross-functional teams
Collaborative, accountable, and customer-focused approach
Willingness to learn unfamiliar systems and continually develop technical and business knowledge
Candidates must meet government security requirements
Preference will be given to candidates legally authorized to work in Canada at the time of application (Canadian citizens or permanent residents)

Benefits

Comp & perks

Performance-based compensation
Various hybrid work options
Three to four weeks of vacation
Company-wide shutdown period
Shorter summer Fridays
Meeting-free Fridays
Continuous learning opportunities
Training programs
Workshops
Language training
Diverse and inclusive workplace
Wellness initiatives
Mental health support
Fitness programs
Volunteer activities
Corporate social responsibility programs
Relocation assistance for eligible candidates