Marketing, Data Analyst

We are currently hiring a Marketing Data Analyst to join our Digital Engagement team based at our Head Office in Burnaby.

In this role, you will help build a data-driven, customer-obsessed culture by turning complex data into meaningful insights, improving campaign targeting and measurement, and supporting the tools and data that power BCAA’s marketing programs. You will work closely with Marketing, Information Services, Product Management and Customer Experience to develop dashboards, segmentation, automated customer journeys and predictive models that improve marketing performance and customer experiences.

Who you are:

• You are a curious, critical thinker who enjoys exploring complex data and turning it into clear, actionable insights.

• You are detail-oriented and quality-conscious, with a strong focus on accuracy, documentation and repeatable work.

• You are a proactive problem-solver who can manage multiple priorities and move work forward independently.

• You communicate technical information clearly and can translate between business stakeholders and technical teams.

• You are collaborative and build strong relationships across functions.

• You are passionate about using analytics, testing and technology to improve marketing performance and customer experiences.

What you’ll do:

• Perform descriptive analysis by extracting, exploring and analyzing data from multiple sources, then develop summaries, visualizations and reports that provide useful business insights.

• Create and maintain dashboards, define metrics with business partners, visualize key performance indicators and support data quality for effective decision-making.

• Help develop BCAA’s marketing analytics strategy and support projects where marketing data and analytics enable or directly drive business outcomes.

• Build campaign audiences and segmentation, develop SQL campaign queries, create campaign flow charts and support deployment lists.

• Design and automate customer communication journeys using Salesforce Marketing Cloud Journey Builder and Automation Studio.

• Develop and apply testing approaches for target groups, offers and creative, then translate results into recommendations that support a test-and-learn culture.

• Build, implement and maintain predictive models to identify customer targets, next-best-product opportunities, multi-product purchasers and lifetime value.

• Partner with cross-functional teams to improve data quality, enable commercial marketing and sales programs, and enhance customer experiences.

• Work with Information Services and Data Engineering to improve the flow, accessibility and use of marketing data across Amazon Redshift, Salesforce Marketing Cloud and Financial Services Cloud.

• Support website analytics and tracking strategy, and help implement Salesforce Marketing Cloud data enablement.

• Streamline and automate analytics processes, writing high-quality code that is clear, documented and repeatable.

• Follow privacy and customer contact standards for data use and file transfers, and document data sources, analyses and algorithms.

What you bring:

• A post-secondary degree in data science, marketing analytics, commerce, statistics or a related field, or an equivalent combination of education and experience.

• Approximately five years of relevant experience, including experience in marketing automation, business intelligence, customer insights or applied customer experience analytics.

• Hands-on experience querying complex relational databases using SQL.

• Experience creating dashboards and visualizations in Power BI or Tableau, and working with data in a Microsoft Fabric or comparable analytics environment.

• Experience with Salesforce Marketing Cloud or another campaign management platform, including audience segmentation and customer journey orchestration.

• Experience with Google Analytics and/or working knowledge of GA4.

• Proficiency with statistical tools or languages such as R or Python, including experience with techniques such as regression, decision trees, segmentation, clustering or classification.

• Experience managing large, complex or multi-source data sets with strong attention to quality and accuracy.

• Knowledge of database modelling, data structures, data wrangling and data pipeline concepts such as APIs, ETL, FTP and workflow orchestration.

• Strong project management, analytical, communication and interpersonal skills.

• Experience with Amazon Redshift, Salesforce CRM, Financial Services Cloud, digital media metrics or audience management tools is an asset.

• Experience in financial services is an asset.