Senior Data Analyst to provide analytical support using SQL, PowerBI and SAS/Python/Spark with one of our major banking clients- 35222

Senior Data Analyst to provide analytical support using SQL, PowerBI and SAS/Python/Spark with one of our major banking clients- 35222

Location Address: Hybrid - Toronto- 2 days/week max (Tuesday + another day, flexible)

Contract Duration: 11/04/2024 to 07/31/2025 - 9 months

Schedule Hours: 37.5 hrs/week

Story Behind the Need

• Business group: Canadian Analytics - provide analytics support to Canadian retail banking
• Project: Personalization Squad - to create personalized customer journey to better tailor to banking customers leveraging Adobe Analytics - in exploration stage

Typical Day in Role:

• Design and integrate customer segmentation, channel analytics, campaign optimizations and recommendation/decision engines to help elevate our customer’s experiences across various channels and move to a personalized 1:1 customer journey.
• Synthesize data across multiple platforms to identify trends and deliver key insights and business recommendations around a customer-first approach to driving engagement and results across our marketing channels and campaigns, to then bringing these recommendations to market through execution and measurement.
• Ability to validate and measure effectiveness of customer/channel/campaign strategies to continually make ongoing changes and improvements.
• Effectively communicate results of highly technical projects to stakeholders and deliver high quality, high impact analytical solutions to business problem

Must Have Skills:

• 10+ years of experience as a Data Analyst, working with datasets, both structured and unstructured data
• 8+ years’ advanced SQL skills (coding capability)
• 5+ years’ experience with all or one of the following: SAS, Spark, Python (please list which)
• 1+ year reporting experience with PowerBI

Nice-To-Have Skills:

• Google Cloud, Hadoop, Big Data, Data Lake experience
• Experience in Adobe Analytics be an asset

Education:

• Bachelor’s degree

Best VS. Average Candidate:

• Python prioritized from Must Have#3 but all are OK; Adobe analytics - using output and see how it fits in the platform so if they have used it in the past as end user will be helpful but not necessary to be an expert

Candidate Review & Selection

• 2 rounds - MS Teams video Interviews - standard
• 1st with HM - 30 minutes
• 2nd with Director - 30 minutes