Database Marketing Analyst – Data Science

Jobtailor; Toronto; On-site; CAD 90,000 - 120,000; Full time

Job summary

Jobtailor in Toronto, Canada seeks a data-driven Email Marketing Analytics professional to translate business requirements into targeted campaigns and automated journeys. You will manage segmentation, A/B testing, and content creation using SQL, HTML, and BI tools.

Ideal candidates will have strong SQL/database analytics skills, hands-on marketing automation experience, and excellent communication to align with stakeholders.

Qualifications

• Degree in Computer Science or a related analytical/database marketing field.
• 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 i.e. creating Email, Direct Mail, SMS contact lists.
• Working knowledge of HTML for email creation an asset.
• Strong technical skills in statistical analytics, data mining and reporting.
• Experience with big data platform (i.e., Snowflake, Metabase) an asset.
• Working knowledge in at least one modern programming language such as Java Script, Python, HiveQl, or R, an asset.
• Understand the principles of relational databases and importance of data hygiene.
• Tableau (or equivalent BI reporting tool) reporting experience would be beneficial.
• 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.

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.

Skills

Advanced SQL

Database analytics

Data mining

Statistical analytics

Education

Degree in Computer Science / related analytical/database marketing field

Tools

Java Script

HTML

Tableau

Snowflake

Metabase

Job description

• 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.

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.
• Working knowledge of HTML for email creation an asset.
• Strong technical skills in statistical analytics, data mining and reporting.
• 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.
• Understand the principles of relational databases and importance of data hygiene.
• Tableau (or equivalent BI reporting tool) reporting experience would be beneficial.
• 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.

Core Competencies

Demonstrates expertise in email marketing campaign management, including audience segmentation, A/B testing, and data-driven decision-making. Proficient in SQL and Java Script for data analysis and campaign execution, with a strong focus on marketing automation and customer engagement.

Highest-signal resume keywords

• Advanced SQL Skills
• Email Marketing Campaign Management
• Database Analytics
• Marketing Automation Experience
• Tableau Reporting Experience

ATS Optimization Keywords

Hard Skills

• SQL
• PL/SQL
• Java Script
• HTML
• Data Mining
• Statistical Analytics
• Database Marketing
• Email Campaign Segmentation
• A/B Testing
• Customer Journey Mapping

Soft Skills

• Excellent Communication Skills
• Strong Attention to Detail
• Organizational Skills
• Multi-tasking Skills
• Collaborative Team Player

Industry Keywords

• Email Marketing
• Customer Acquisition
• Customer Retention
• Data Hygiene
• Automated Campaigns

Tools & Technologies

• Oracle SQL
• Tableau
• Snowflake
• Metabase
• Email Marketing Platforms