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.