Marketing Operations Manager
Workleap
SQL
Marketing Data Analytics Specialist
Prosci
full-time
Posted on:
Origin: • 🇨🇦 Canada
Visit company websiteSalary
💰 CA$74,000 - CA$92,000 per year
Job Level
Mid-LevelSenior
Tech Stack
MagentoSQL
About the role
- Deliver monthly and quarterly Power BI dashboards for Leadership, Board, and Regional team ensuring reporting consistency across global regions, currencies, and phased technology rollouts
- Analyze and report on campaign, channel, and funnel performance and identify gaps or inconsistencies in attribution data
- Partner with campaign managers and Marketing Ops to define tracking requirements for campaigns, events, and new assets ensuring proper tagging and parameters are in place
- Monitor data integrity between HubSpot and Salesforce and flag sync or attribution issues
- Build, maintain, and iterate Power BI dashboards and write SQL queries to join data sources
- Manage interim connectors (Funnel.io, HubSpot API) and support the transition to Mulesoft in partnership with ICT
- Ensure smooth data pipelines across marketing, CRM, and eCommerce systems (HubSpot, Salesforce, Magento, GA4)
- Maintain and validate event/conversion tracking in GA4 and HubSpot using Google Tag Manager and campaign UTM frameworks
- Use SEMrush, Google Ads, and LinkedIn Ads to measure SEO rankings, campaign performance, social engagement, and channel ROI
- Train regional marketers on dashboard use and interpretation and collaborate with Growth Marketing, Sales Ops, and ICT to align analytics insights with business needs
- Translate data into compelling narratives for executives and practitioners
Requirements
- Bachelor’s degree in Marketing, Business, Data Science, or related field (or equivalent experience)
- 3–5+ years of direct marketing analytics / BI experience
- Proven track record building executive-level reporting in Power BI
- Strong SQL skills and BI development experience
- Experience reconciling multi-system data (HubSpot, Salesforce, GA4)
- Power BI – dashboard building, DAX, and data models
- SQL – querying/joining data from multiple systems
- Salesforce reporting & campaign hierarchy
- HubSpot reporting & dashboards – segmentation, campaigns, attribution views
- APIs and data connectors – Funnel.io, HubSpot API, Mulesoft
- Google Tag Manager – event and conversion tracking
- Campaign tracking best practices – UTMs, tagging frameworks, QA
- Microsoft Excel / 365 – analysis, pivot tables, formulas, data validation
- Microsoft PowerPoint / 365 – executive-level presentations and visual narratives
- Channel & performance marketing reporting – SEMrush, Google Ads, LinkedIn Ads
- Experience supporting regional teams across multiple markets and currencies
