Senior Data Analyst building financial models and Looker dashboards for Jane’s healthcare practice management platform. Supporting Finance and Payments with trusted revenue, billing, and transaction insights.
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.
Senior Data Analyst building AI - enabled Tableau analytics for Sun Life, a global financial services company. Developing trusted metrics, data models, dashboards, and sales insights.
Marketing data advisor analyzing and valorizing member/client data for Desjardins, North America's largest cooperative financial group. Developing dashboards, self - service reports and recommendations for marketing decisions.
LP
Payments Data Analyst (Modernization)
LinkedIn Recruiter Post
Payments Data Analyst needed for modernization project in Toronto. Requires Python, SQL, and wholesale payments expertise.
Intermediate Data Analyst transforming complex data into actionable insights for PLATO, Canada’s Indigenous - owned technology services company. Developing models, dashboards, and data management solutions with MS Dynamics and Azure.
Senior Data Analyst improving player engagement, monetization, and live operations for Big Viking Games’ YoWorld and FishWorld. Building SQL - driven dashboards and insights for product and business decisions.
Senior data analyst generating client acquisition insights for Sun Life, a global financial security and health company. Building KPIs, dashboards, forecasts, and automated analytics to improve lead conversion and client growth.
Data Analyst converting business data into actionable insights for StarTech.com, a global tech connectivity solutions provider. Building models, dashboards, and reports across product, inventory, revenue, customer, and marketing analytics.
LP
Data Solution Architect
LinkedIn Recruiter Post
Hiring a Data Solution Architect for a remote 6 - month contract. Expert in GCP, Kubernetes, distributed systems, and ML platforms.
Senior Oracle Data Analyst reconciling millions of records for an oil and gas modernization initiative. Investigating legacy - to - new - system discrepancies and guiding remediation.