Senior Manager leading Medline Canada’s Microsoft Fabric data platform and BI strategy. Delivering governed data products and analytics for healthcare operations.
About the role
- Database Marketing Analyst at The Globe and Mail managing email contact lists and automating database marketing efforts using SQL. Collaborating across teams to enhance subscriber experience through data-driven campaigns.
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.
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.
Benefits
- Competitive compensation to ensure we hire, retain and reward team members
- Hybrid work environment that promotes work-life balance
- Generous vacation and flexible work arrangements
- Parental leave top-up
- Competitive health and dental benefits
- Defined Benefit pension plan
- Annual wellness subsidy
- On-site chiropractor and registered massage therapist
- Employee and family assistance program
- Free digital subscription to globeandmail.com and 40% off other Globe products
- Education assistance for external training courses
Job title
Job type
Experience level
Salary
Degree requirement
Tech skills
Location requirements
Report this job
Found something wrong with the page? Please let us know by submitting a report below.
Analyste des données clients chez EDC, société d’État aidant les entreprises canadiennes à réussir à l’étranger. Modernisation des pipelines, tableaux de bord et solutions analytiques marketing.
Customer Data Analyst modernizing EDC’s customer data ecosystem at Canada’s export - finance Crown corporation. Building Microsoft Fabric pipelines, Power BI assets, and marketing analytics solutions.
Senior Data Analyst building trusted financial metrics, dbt models, and Looker dashboards for Jane’s clinic - management SaaS platform. Partnering with Finance and Payments to guide critical decisions.
Digital media specialist improving campaign tracking, reporting and analytics at a Toronto marketing technology lab. Automating insights with AI while maintaining data quality and measurement accuracy.
Data Analytics Intern analyzing new features and updates for Montreal - based mobile gaming studio Ludia. Building data modules, dashboards, and insights to optimize game operations.
Senior Data Analyst transforming Sun Life insurance and financial - services data into actionable marketing insights. Building SQL, Python, AWS, Adobe Analytics, reporting, and dashboard solutions.
Student Data Analyst supporting Sun Life’s financial security mission through stakeholder insights and Tableau KPI reporting. Building data analysis skills during a four - month hybrid campus placement.
Analyste de données principal modernisant les plateformes et pipelines de données d’EDC, société financière publique canadienne. Traduction des besoins opérationnels en modèles, règles de transformation et récits utilisateurs.
Senior Data Analyst modernizing enterprise data capabilities at Export Development Canada. Translating business requirements into data models, mappings, pipelines and Agile delivery artifacts.