Campaign Data Analyst – SAS, Power BI

JOB DESCRIPTION

Location: Hybrid (Downtown, Toronto)

Duration: 12 months

Our client, a leading financial institution in Downtown Toronto, is looking for a Campaign Data Analyst – SAS, Power BI to provide actionable insights and recommendations on marketing initiatives to business line and marketing partners. The successful candidate will have the opportunity to work with one of the Top 5 Banks in Canada.

Typical Day in role:

  • Analyze and synthesize large datasets to identify trends and opportunities, applying a customer-first approach to drive engagement.
  • Define and size target audience opportunities in collaboration with business and marketing teams.
  • Deliver Pre-Sizing, Segmentation, and Response Forecasting to inform campaign design and improve efficiency.
  • Optimize customer and channel allocation based on behavior, preferences, and historical performance.
  • Collaborate with stakeholders to define KPIs and benchmarks, and create reporting to track campaign performance.
  • Conduct Pre- and Post-Campaign Deep Dives, analyzing beyond offer acceptance to assess utilization, stickiness, cost of acquisition, and revenue impact.
  • Present insights and recommendations to stakeholders, maintaining strong communication and alignment.
  • Work in agile squads alongside marketing, execution, and business lines to identify new opportunities for improved customer experiences.
  • Explore and profile data sources, analyze backend data critically, and derive meaningful insights.
  • Perform SQL coding and data manipulation as needed.
  • Support automation and dashboard development using Power BI and Excel.
  • Participate in modernization initiatives, including migration to GCP and Python-based analytics.

Must-Have Skills:

  • 8+ years of experience in Data Analysis
  • 8+ years’ experience working with large data sets and relational databases with advanced SQL skills
  • 5+ years’ experience with both these analytical tools: SAS, Power BI

Nice-To-Have Skills:

  • Familiarity with banking products
  • Experience with Python
  • Experience with Google Cloud Platform
  • Experience with targeted leads/campaign execution and segmentation

Soft Skills Required:

  • Strong Communication and collaboration skills
  • Self-motivated, strong quantitative skills, attention to detail, a high aptitude for problem solving and a natural interest in understanding customer behavior
  • Analytical mindset

Education:

  • Analytical background with a quantitative focus, such as statistics, applied mathematics, economics, computer science

Finance professional is committed to creating an inclusive environment where all team members and clients feel like they belong. We seek applicants with a wide range of abilities and we provide an accessible candidate experience. We advocate for you and welcome anyone regardless of race, color, religion, national origin, sex, physical or mental disability, or age.