Customer Data Analyst modernizing EDC’s customer data ecosystem at Canada’s export-finance Crown corporation. Building Microsoft Fabric pipelines, Power BI assets, and marketing analytics solutions.
Responsibilities
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
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
Analyste des données clients chez EDC, société d’État aidant les entreprises canadiennes à réussir à l’étranger. Modernisation des pipelines, tableaux de bord et solutions analytiques marketing.
Senior Data Analyst building trusted financial metrics, dbt models, and Looker dashboards for Jane’s clinic - management SaaS platform. Partnering with Finance and Payments to guide critical decisions.
Digital media specialist improving campaign tracking, reporting and analytics at a Toronto marketing technology lab. Automating insights with AI while maintaining data quality and measurement accuracy.
Data Analytics Intern analyzing new features and updates for Montreal - based mobile gaming studio Ludia. Building data modules, dashboards, and insights to optimize game operations.
Senior Data Analyst transforming Sun Life insurance and financial - services data into actionable marketing insights. Building SQL, Python, AWS, Adobe Analytics, reporting, and dashboard solutions.
Student Data Analyst supporting Sun Life’s financial security mission through stakeholder insights and Tableau KPI reporting. Building data analysis skills during a four - month hybrid campus placement.
Analyste de données principal modernisant les plateformes et pipelines de données d’EDC, société financière publique canadienne. Traduction des besoins opérationnels en modèles, règles de transformation et récits utilisateurs.
Senior Data Analyst modernizing enterprise data capabilities at Export Development Canada. Translating business requirements into data models, mappings, pipelines and Agile delivery artifacts.
Web Analyst owning GA4, GTM, pixel, and conversion tracking for an education and nonprofit marketing agency. Ensuring accurate, privacy - compliant data across client campaigns and CRM systems.