BD

ANALYST, MARKETING CLIENT DATA AND ANALYTICS

Hiring from
Canada
Work type
Hybrid
Posted

626,622 remote jobs, straight from company career pages

100% free · New jobs every minute

Show job description

We are banking at another level.

Choosing BDC as your employer means working in a healthy, inclusive, and skilled workplace that puts forward the best conditions to bring together unique teams where employees are empowered to act. It also means being at the centre of ambitious economic and financial projects to see further and to do things differently, to fuel the success of Canadian entrepreneurs.

Choosing BDC as your employer also means:

  • Flexible and competitive benefits, including an Employee Savings and Investment Plan where BDC matches part of your voluntary contributions, a Defined Benefit Pension Plan, a $750 wellness and health care spending account, to name a few

  • In addition to paid vacation each year, five personal days, sick days as necessary, and our offices are closed from December 25 to January 1

  • A hybrid work model that truly balances work and personal life

  • Opportunities for learning, training and development, and much more...

Explore the BDC Way in our Culture Book

POSITION OVERVIEW

As an Analyst, Marketing Client Data and Analytics, you will manage recurring data activities that support Marketing campaigns, including audience lists, scheduled reports and data refreshes, and monthly campaign cost data.

You will work from approved specifications and standards, collaborating with analysts and the Data and AI team to deliver accurate, documented, and repeatable outputs. You will also use AI tools and scripts to automate routine steps while validating output quality.

BDC is the only bank dedicated exclusively to Canadian entrepreneurs. Your work will help Marketing use client and prospect data reliably to support the growth of small and medium-sized businesses across Canada.


CHALLENGES TO BE MET

  • Build and validate campaign audience lists
    • Create campaign and program audience lists from BDC client and prospect data based on approved specifications.
    • Apply defined eligibility and consent rules.
    • Complete standard quality checks, document the results, and submit lists for review.
    • Deliver approved audience lists to the team responsible for the marketing platform and confirm that the correct approved version is used.
  • Run recurring reports and data refreshes
    • Produce campaign launch reports, scheduled data refreshes, and recurring reports according to established schedules.
    • Investigate alerts and reported issues, resolve issues covered by established procedures, and escalate other issues to the appropriate report owner.
    • Migrate recurring reports to validated data sources as they become available while maintaining reporting continuity.
  • Prepare and validate monthly campaign cost data
    • Load campaign budget and spend data as it becomes available.
    • Apply established campaign codes and reconcile totals against source data.
    • Identify and flag missing information or discrepancies to the analyst responsible for cost and return reporting.
  • Automate recurring data processes
    • Identify repetitive tasks that can be automated.
    • Work with the Data and AI team to automate recurring steps using approved AI tools and scripts.
    • Test automated outputs against manual results before replacing existing steps.
    • Track time savings and output quality after automation.
  • Document recurring processes, queries, and scripts
    • Create and maintain step-by-step procedures for recurring audience lists, data refreshes, and reports.
    • Document queries and scripts so another team member can execute and maintain the work.
  • Support Marketing Client Analytics priorities
    • Complete data and reporting activities needed to keep campaigns and analyses moving, including reconciling different versions of audience lists and producing reports requested by analysts.
    • Through this work, you will contribute directly to how Client Analytics supports Marketing and Canadian businesses. At BDC, we value inclusion, equity, and diversity, and you can be yourself at work.

WHAT WE ARE LOOKING FOR

  • Education: Bachelor's degree in statistics, economics, computer science, engineering, business, or a related field, or equivalent experience.
  • Experience: 3 to 5 years of experience in a corporate environment, including hands-on experience with data, reporting, or analytics.
  • SQL: Hands-on experience using SQL as part of regular work.
  • Reporting and business intelligence: Experience building or maintaining reports using Microsoft Power BI or a comparable reporting or business intelligence tool.
  • Data validation: Ability to compare reported figures against source data and identify and explain discrepancies.
  • Data preparation: Experience preparing audience lists, data lists, data extracts, or recurring reports based on written requirements for use by others.
  • Quality assurance: Experience validating or quality-checking data outputs before delivery.
  • Documentation: Experience documenting recurring processes, queries, scripts, or code so that another person can execute the work.
  • Automation and AI: Experience using AI tools or scripts to automate or accelerate work, including validating the resulting outputs.
  • Independent work: Experience managing priorities and completing assigned work without close supervision.
  • Communication: Ability to communicate clearly in writing with colleagues and partner teams.
  • Languages: Bilingual proficiency in French and English, spoken and written, including the ability to work with partner teams and write procedures in both official languages.

Preferred Qualifications

Experience with one or more of the following is considered an asset:

  • Campaign data
  • Customer Relationship Management (CRM) data
  • Marketing automation data
  • Budget or spend data
  • Databricks
  • Python
  • Microsoft Copilot
  • Microsoft Power Automate
  • Industry classification codes, including the North American Industry Classification System (NAICS)
  • Knowledge of BDC's data environment

Proudly one of Canada’s Top 100 Employers and one of Canada’s Best Diversity Employers, we are committed to fostering a diverse, equitable, inclusive and accessible environment where all employees can thrive and feel empowered to bring their whole selves to work. If you require an accommodation to complete your application, please do not hesitate to contact us at accessibility@bdc.ca.

While we appreciate all applications, we advise that only the candidates selected to participate in the recruitment process will be contacted.

About Us

BDC is a bank unlike any other. We are the only bank dedicated exclusively to the development of Canadian businesses. The only institution whose purpose is to promote the growth of the Canadian economy by focusing on the success of small and medium-sized businesses, with a human touch and a genuine presence. At BDC, we’re changing people’s and businesses’ lives for the better. That’s what makes us unique as a bank.

That’s why we are banking at another level.

Similar jobs

Apply for this job100% free