Analyst, Constituent & Marketing Analytics

The opportunity

Please note this is a 13-month contract and hybrid working role. Candidates can work from anywhere in Canada. However, this role requires the ability to come to the Toronto office up to 6 times per year and to work Eastern Time (ET) hours.

The Analyst, Constituent & Marketing Analytics is responsible for delivery of analytics and data-driven insight in support of the Foundations fundraising programs, products and campaigns, as to best drive net revenue growth, supporter loyalty and supporter engagement.

This includes support in data operations, analysis, segmentation, targeting, as well as process documentation and data management. This role primarily supports, but is not exclusive to, the Lottery program.

Working collaboratively with departmental and organizational peers, the role will provide analytics support in a fast-paced, fluid environment to ensure data-driven decision-making advances progress toward our mission.

• Analyze customer behaviour and work with marketing leads to develop and implement supporter segmentation and communication strategies and tactics
• Evaluate tactics and develop data insights to identify opportunities to improve supporter communication, upgrade, cross-sell, retention and lifetime value
• Intake analytics and reporting requests, including documenting requirements, metrics and dimension definitions, mock ups and robust documentation while tracking in task management platform
• Ensure the accurate completion of daily, weekly and campaign performance reports, as well as automated reports and dashboards using Big Query, Power Bl, Salesforce Marketing Cloud, Google Analytics, Social and Paid Digital channels amongst other data sources.
• In-campaign, track Media, Digital and Offline channel results; provide status updates during weekly meetings and recommend changes mid campaign to drive results

• Collaborate in the planning, execution and evaluation of the Foundations multi-channel Direct Marketing campaigns
• Manage the marketing campaign calendar to ensure critical dates related to data operations are met
• Extract data required for campaign analysis and communications using existing data protocols and request forms
• Document new data protocols to ensure knowledge sharing and transfer
• Work with key stakeholders and media vendors to support media campaign planning
• Ensure data operations meet plan and data sent to and received from external partners is accurate and timely
• Identify when changes or improvements to datasets are required, and collaborate to develop requirements and UAT
• Work with vendors to ensure work is being completed as agreed
• Work across the organization to keep informed of other Foundation programs and activities to identify opportunities for learning, insight and collaboration
• Support priority initiatives and projects

• Provide data and insights to support the development of program leads annual and short-term plans, forecasts and budgets
• Build strong lateral relationships with IT team and vendors to achieve maximum integrations and synergies

• Minimum 2 years of analytics or data management experience in a customer-centered organization
• Experience reporting on mass media campaigns including all types of digital and traditional media channels
• Experience delivering data analysis and insight through storytelling and visualization
• Experience in data-visualization and data modeling using tools like Power BI or Tableau
• Experience working with CRM systems, and Cloud Analytics environments like Big Query, Snowflake or Redshift
• Experience working with Google Analytics and digital marketing performance management

• University degree in analytics, data science, statistics, finance or equivalent

• Solid experience and understanding of data to inform integrated digital/offline campaign operations, tactics evaluation and results monitoring
• Exceptional data analysis skills using Excel, SQL, DAX
• Data-visualization using tools like Power Bl
• Experience integrating Al tools…