Back to jobs

Analyst, Marketing Client Data and Analytics

Pay
Pay not listed
Work setting
Not stated
Employment
Full-time — employment source
Employment type in the employer’s posting: Full time
From the employer’s posting

What you’ll work on

Full posting
  • Build and validate campaign audience lists from client and prospect data

  • Run recurring reports, scheduled data refreshes and campaign launch reports

  • Load, code and reconcile monthly campaign budget and spend data

  • Automate recurring data steps with approved AI tools and scripts

  • Document recurring procedures, queries and scripts so others can run them

From the employer’s posting
Build and validate campaign audience lists
Run recurring reports and data refreshes
Prepare and validate monthly campaign cost data
Work with the Data and AI team to automate recurring steps using approved AI tools and scripts.
Document queries and scripts so another team member can execute and maintain the work.

What you’ll bring

All qualifications

Core 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.
  • Communication: Ability to communicate clearly in writing with colleagues and partner teams.

Preferred experience

  • Experience with one or more of the following is considered an asset:
  • Knowledge of BDC's data environment
Qualification wording
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.
Communication: Ability to communicate clearly in writing with colleagues and partner teams.
Experience with one or more of the following is considered an asset:
Knowledge of BDC's data environment
Education & alternatives
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.
Apply at Bdc

Posting record

Report an error

Actively hiringFirst seen by us 5 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 16, 20265 days ago
Recorded sightings
2
Last seen by us
Nov 17, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 5

Similar jobs usually come down between day 5 and day 43.

From 16,020 similar postings that came down. Coming down is not always a hire.

Bdc is hiring

3 open jobs

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
  • Databricks
  • Power BI
Where the posting names them
- Databricks - Python - Microsoft Copilot
- 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.
- Budget or spend data - Databricks - Python
- 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.

Your next step

Complete your application on bdc.wd10.myworkdayjobs.com. The employer’s form will show what is required.

Applying through Workday

  • You create an account with each employer before you can upload anything. Every Workday employer has its own account, so one sign-up doesn’t carry over.
  • “Autofill with Resume” comes right after sign-in, before the My Information and My Experience steps. Check every field it fills in those steps, since that’s what recruiters see.
  • Your application status lives in that employer’s Candidate Home, under the same sign-in.

Already applied? Track this application

Job description

View original posting ↗

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.

Demand for Analyst roles

New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 993, the most 1,510, and the latest week had 1,367.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Montreal

- 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...
Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.