Customer Data Analyst

Export Development Canada | Exportation et développement Canada

. Develop, maintain and enhance data pipelines, data flows, datasets, semantic models and analytical assets supporting 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 developing and optimizing data pipelines, datasets, and analytical models, with a strong focus on Power BI and SQL for data analysis and reporting. Proven ability to troubleshoot data issues and communicate technical findings effectively to diverse stakeholders.

Highest-signal resume keywords

SQL Query WritingPower BI Dashboard DevelopmentData Pipeline DevelopmentPython ProgrammingData Quality Monitoring

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 AnalysisData TransformationData IntegrationData ValidationData MiningETL ProcessesAnalytical ApplicationsMLOps PracticesRoot-Cause AnalysisData Governance

Soft Skills

Analytical SkillsProblem-SolvingCollaborationCommunicationAttention to Detail

Tools & Technologies

Microsoft FabricDenodoPower BIData LakesData Warehouses

Industry Keywords

Customer AnalyticsMarketing AnalyticsBusiness IntelligenceData EcosystemData Quality Checks

Tech Stack

Tools & technologies

PythonSQL

About the role

Key responsibilities & impact

Develop, maintain and enhance data pipelines, data flows, datasets, semantic models and analytical assets supporting customer analytics and Marketing
Migrate and repoint data flows and reporting assets from legacy sources, including Denodo and spreadsheet-based processes, to the Enterprise Data Platform and Microsoft Fabric
Analyze data artefacts, business rules, calculations and dependencies to rebuild or adapt them when sources, fields or logic change
Develop and optimize curated datasets and semantic models for Power BI dashboards, analytical applications and advanced analytics
Build, maintain and improve Power BI dashboards and reports for timely, reliable and actionable customer insights
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 solve operational and analytical challenges
Contribute to deployment and operationalization of analytical applications and models using development and MLOps practices
Troubleshoot data, refresh, integration and reporting issues; conduct root-cause analysis and implement corrective actions
Perform exploratory data analysis and data mining to identify customer behaviours, engagement patterns, preferences, segments and opportunities
Prepare customer and prospect data for campaign planning, targeting, personalization, measurement and reporting
Apply data-quality checks, validation rules, documentation standards and governance requirements
Support data acquisition, vendor-data processing, data-quality monitoring and production reporting
Document data sources, transformations, business rules, calculations, dependencies, controls and operating procedures
Collaborate with Marketing, analytics, data platform, governance, technology and other stakeholder teams
Communicate findings, technical issues, recommendations and delivery progress to technical and non-technical audiences
Share knowledge, contribute to team standards and strengthen backup coverage for critical processes and assets
Identify opportunities to improve automation, reliability, scalability and efficiency across the customer data and analytics environment

Requirements

What you’ll need

Undergraduate 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 developing, transforming, integrating or analyzing data in a business or production environment
Practical experience writing SQL queries for data extraction, transformation, validation and analysis
Practical programming experience with Python, R or a comparable language
Experience developing reports, dashboards, datasets or data models using Power BI or a comparable business intelligence platform
Experience with data pipelines, extract-transform-load processes, data flows, data warehouses, data lakes or lakehouse environments
Ability to understand existing data assets and business logic and adapt them to new sources, platforms or requirements
Experience investigating and resolving data-quality, integration, refresh or reporting issues
Strong analytical and problem-solving skills, with close attention to accuracy, controls and detail
Ability to translate business requirements into clear technical tasks and fit-for-purpose data solutions
Ability to explain technical concepts and analytical findings in clear business language
Ability to manage priorities, work independently and contribute effectively within cross-functional teams
Collaborative, accountable and customer-focused approach
Willingness to learn unfamiliar systems and understand a complex data ecosystem
Ability to work legally in Canada at the time of application; Canadian Citizens or Permanent Residents preferred
Must meet requisite government security screening requirements

Benefits

Comp & perks

Performance-based incentive
Comprehensive 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
Relocation assistance for eligible candidates