Database Marketing Analyst (Data Science) - Hybrid

The Globe and Mail•Toronto, ON

10d•Hybrid

About The Position

The Globe and Mail is seeking a Database Marketing Analyst to support its database marketing efforts in a competitive landscape, reporting to the Manager of Database Marketing. This role involves building email contact lists using SQL code, consolidating data from various sources to develop direct email marketing campaigns that align with a comprehensive subscriber contact strategy. The position requires the automation and scheduling of scripted data workflows, a strong understanding and strict adherence to data privacy laws, and acting as an advocate for subscriber data protection and enhanced subscriber engagement. This is an existing, full-time hybrid vacancy based in Toronto.

Requirements

Degree in Computer Science or a related analytical/database marketing field required.
5+ years of experience in software packages or programming languages used for analyzing and manipulating data and automating Oracle jobs (PL/SQL, SQL).
Advanced SQL skills are mandatory.
5+ years minimum experience performing database analytics supporting customer acquisition and retention.
Passionate about marketing automation with hands-on experience using email-marketing platforms and email automation software.
Practical experience in database marketing utilizing SQL ie: creating Email, Direct Mail, SMS contact lists.
Strong technical skills in statistical analytics, data mining and reporting.
Understand the principles of relational databases and importance of data hygiene.
Excellent communication skills (verbal and written).
Ability to prioritize and meet strict deadlines.
Strong attention to detail.
Well organized with strong multi-tasking skills.
Collaborative team player who is willing to share knowledge and learnings.
Autonomous self-starter, comfortable working in a team environment with minimal direction.

Nice To Haves

Working knowledge of HTML for email creation an asset.
Experience with big data platform (ie: Snowflake, Metabase) an asset.
Working knowledge in at least one modern programming language such as Java Script, Python, HiveQl, or R, an asset.
Tableau (or equivalent BI reporting tool) reporting experience would be beneficial.

Responsibilities

Gather, document and translate business requirements from various business units into executable direct email marketing campaigns.
Collaborate with internal stakeholders to confirm requirements and provide recommendations for campaign design and execution.
Manage all facets of the email marketing process – developing and managing the execution of email marketing campaigns, audience segmentation, A/B testing, preference management and copywriting.
Create customer journeys and develop implementation plans for new program initiatives with a focus on automated campaigns and a personalized customer content utilizing data from disparate CEM data sources.
Develop email marketing campaign segmentation strategies based on customer and prospect type/persona data, transactional history and on site behavioral data.
Create both ad hoc and recurring email campaigns utilizing Oracle SQL and JAVA Script.
Design and create optimized test and learn (target vs control, A/B) email campaigns that leverage previous campaign learnings.
Complete quality assurance audits to ensure email creative and campaign list SQL code accurately reflect business requirements and specifications - pinpoint actionable insights, efficiencies, and new opportunities.
Take insights and KPI data from our email deployments, identifying key takeaways and areas of opportunity for future email efforts utilizing SQL and Tableau.
Communicate insights to internal stakeholders in order to leverage the email-marketing channel.
Work with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures.
Ensure email marketing campaign data is accurate and email creative is error free.