Resume Score

Check how well your resume matches this job before you apply.

Sign in to check score

About the role

  • 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

Benefits

  • 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

Job title

Job type

Full Time

Experience level

Mid levelSenior

Salary

CA$65,172 - CA$86,898 per year

Degree requirement

Bachelor's Degree

Tech skills

PythonSQL

Location requirements

HybridOttawaCanada

Report this job

Found something wrong with the page? Please let us know by submitting a report below.