Junior Campaign Business Analyst

Junior Campaign Business Analyst

Role Mandate:

The analyst will have experience working with marketing databases and building and automating complex direct marketing campaigns that drive the business forward. Working with Leads Management, responsibilities include implementing campaign data requirements developed by internal business partners, developing technical specifications, producing and quality-testing campaign data files, identifying and remediating issues along the campaign workflow, and managing relationships with stakeholders.

Candidate Value Proposition:

This role allows the candidate to work in an established institution and with multiple groups within the bank, which will allow candidate to build effective skills and confidence. The individual is exposed to other lines of business, as there are lots of opportunities for learning, growth, and development. This is a fast-paced environment that requires the ability to manage several campaign projects simultaneously. It is essential to have strong communication and project management skills. The analyst will develop a deep understanding of the campaign management tool and the content of the data warehouse. The right candidate must enjoy and excel at problem-solving, troubleshooting, and root cause analysis.

Group Culture:

This individual will be working both individually and, in a collaborative, diverse team-oriented environment. There are one-on-one meetings monthly to provide HM with updates pertaining to any issues, questions, or potential delays. MS Teams is available throughout the day for team members to communicate. Teams are very supportive of one another.

Project Information:

• SAS / SQL
• SharePoint system in place and Kanban board to track campaigns and ensure all steps are followed and delivered on time
• Everyday Banking (EDB) products – chequings and savings, investment products, and digital campaigns
• Completing audits to ensure correct customers are targeted
• Assigned campaigns to analysts to work on (slow, medium, and high complexity)
• Creating channel files for vendor to send emails to customers for specific targeted markets
• Fill out implementation documentation
• Walk through with Leads Manager to describe campaigns and which markets to target

Role Responsibilities:

• Act as a project leader for small to medium sized projects
• Manage project timelines and key deliverable dates
• Prepare customer lists with campaign management toolset to meet the requirements of documented technical requirements
• Conduct campaign technical audits and review data output to ensure accuracy
• Contribute to campaign definition documentation and template library to support standardization of customer data extracts
• Identify issues and make recommendations for campaign improvement
• Engage in knowledge transfer with other Campaign Analysts to ensure projects are transferable
• Develop and execute direct to consumer campaigns
• Establish a two-way working relationship with internal partners and proactively communicate project status updates to Campaign Production Manager, Leads Manager, Measurement Analysts and Product & Marketing business partners
• Build potentially recurring campaigns with automation in mind and automate campaigns as required
• Review and analyze campaign business requirements and produce Technical Implementation Plans
• Support the lead generation cycle by monitoring file execution processes and ensure final output meets regulatory requirements, is complete and available for execution by internal systems and external vendors
• Trouble shoot critical issues, as required, to ensure the lead generation cycle remains on track and provide required support to Campaign Managers
• Make recommendations to streamline, enhance and improve overall operations
• Ensure campaign requirements have documented business partner approval prior to file development and execution

Must-Have Skills:

• Experience in data analytics, developing and executing direct marketing campaigns, analyzing marketing campaigns and initiatives
• High level of proficiency with SQL and SAS
• Ability to translate business strategies into technical requirements
• Solid and proven background in business process improvement
• Working knowledge of customer relationship management, campaign design and development
• Proficient in MS Office (Word, Excel)
• Minimum 3 years of campaign or database marketing experience

Nice-to-Have Skills:

• Previous baking / FI experience
• Unica Campaign or equivalent experience

Soft Skills:

• In-depth analytical and problem-solving skills
• Manage expectations and multiple complex projects simultaneously
• Ability to prioritize, handle multiple tasks, quickly shift between competing and sometimes conflicting priorities in a high pressure, fast-paced environment
• Possess excellent interpersonal skills, and have proven written and verbal communication skills
• Solid organizational and time management skills