Senior Business Intelligence Analyst

Work Location: Montréal, Quebec, Canada Hours: 37.5 Line of Business: Analytics, Insights, & Artificial Intelligence Pay Details: $76,800 - $115,200 CAD TD is committed to providing fair and equitable compensation opportunities to all colleagues. Growth opportunities and skill development are defining features of the colleague experience at TD. Our compensation policies and practices have been designed to allow colleagues to progress through the salary range over time as they progress in their role. The base pay actually offered may vary based upon the candidate's skills and experience, job-related knowledge, geographic location, and other specific business and organizational needs. As a candidate, you are encouraged to ask compensation related questions and have an open dialogue with your recruiter who can provide you more specific details for this role. Job Description: The successful candidate will be responsible for end-to-end Targeted campaigns supporting the growing needs of a portfolio within the broader Marketing, Digital, Social and Content group. Marketing, Digital, Social and Content supports the central marketing function within TD Bank Group and TDI with high quality, innovative, and insightful information to help build value for our customers and shareholders. Marketing, Digital, Social and Content is a North America centre of excellence located in Toronto, with satellite offices in Ottawa (MBNA brand) and New Jersey (TD Bank America's Most Convenient Bank). It supports most consumer facing TD Bank Group and TDI lines of business. Your goal as a part of the Marketing Delivery team is to design, execute and measure performance of campaigns to drive acquisition, retention, engagement across the portfolio. If you are driven by helping stakeholders understand data, love when the latest direct-to-consumer marketing campaign results are available, and continually strive to challenge the "process status quo" to make work flows run as efficiently as possible – this is the role for you. Success in this role will be achieved by: Translating key business objectives into insight rich experiments that drive marketing ROI Ensuring execution (i.e., list creation) is done efficiently and with excellence Providing high value post-campaign reporting that derives insights Your success will be predicated on your ability to forge strong partnerships, communicate effectively, deliver on-time, and continuously strive for increased efficiency. Responsibilities: • Design/execute/measure high impact direct to consumer marketing experiments • Proactively provide analytical guidance to key stakeholders, based on deep understanding of the businesses, to understand and enhance marketing ROI • Work in DataBricks, use SQL as one of the main programing languages. • Work closely with Integrated Marketing to design, streamline and optimize Salesforce Marketing Cloud (SFMC) journeys, including building and filtering audiences in Salesforce CDC. • Build and deploy marketing campaigns in Salesforce Marketing Cloud utilizing Email Studio, Automation Studio, and Journey Builder, thus including development of journeys, template setup, list management, form creations, A/B testing and automated triggers. • Design and execute cross-channel SFMC campaigns / journeys based on Marketer requirements. • Lead the configuration of audience entry source, exit criteria, re-entry criteria based on campaign goals, structures Journey decision splits • Oversee journey planning and execution including technical reviews and quality control. • Build and maintain modular campaign template(s) that are responsive and incorporate brand standards and best practices. • Perform QA testing to ensure segmented audiences and content are accurate and rendering properly on different devices. • Manage and segment audience data using the various Marketing Cloud tools (audience builder, data extensions, API, filters, queries, etc.). • Troubleshoot campaign development issues including template rendering, accurate links, accessibility, subscriber lookup, etc.). • Leverages SFMC tools and scripting languages to update content and enable dynamic content/personalization. • Build highly dynamic campaigns using HTML and AMPscript. • Provide guidance and train specialists on basic SFMC capabilities and deployment best practices. • Bring expertise in personalization and marketing automation around dynamic email content and segmentation rules to customize marketing campaigns • Participate in campaign optimization sessions and support analysis of campaign performance • Collaborate effectively with cross-functional teams achieve campaign objectives in the stated timelines • Utilize strong project management skills to drive initiatives from conception to completion within established timelines • Continuously improve campaign design and delivery by leveraging any and all analytical tools/techniques at your disposal • Execute with excellence • Manage your project pipeline to ensure agreed upon timelines can be met • Maintain a culture of risk management and control, supported by effective processes and sound infrastructure Skill Sets: • Minimum 3+ years of SQL. Be capable of understanding and programing complex SQL code. • Minimum 2+ years of Salesforce and Marketing Cloud automation experience. • Solid CRM experience and understanding of marketing campaign concepts and best practices • Solid experience owning multi-audience campaigns, and extensive usage of Salesforce Marketing Cloud (SFMC) required, inclusive of Journey Builder, Email Studio, Automation Studio, and Data Extensions, • Proficient in AMPscript, HTML/CSS, and dynamic content scripting for email customization. • Experience creating dynamic and personalized marketing campaigns using AMPscript and SQL expertise, building automations for marketing, analysis, and system maintenance using SQL knowledge, maintaining and optimizing SFMC for peak performance and data integrity. • Strong