Data Analyst - Python, SQL, Marketing Analytics

FP Inc.; Toronto; On-site; CAD 69,000 - 85,000; Full time

Job summary

FP Inc. is seeking a seasoned Data Analyst in Toronto, Ontario for a 7-month contract. The role focuses on designing and integrating customer segmentation, campaign analytics, and personalized 1:1 journeys across channels.

You will synthesize data, identify trends, and deliver insights to drive engagement and business results. Strong SQL, Python, and Power BI reporting are required.

Qualifications

• 8+ years of experience as a Data Analyst, working with datasets, both structured and unstructured data.
• 8+ years’ advanced SQL skills (coding capability)
• 3+ years’ experience with Python
• 1+ year reporting experience with PowerBI

Responsibilities

• Design and integrate customer segmentation, channel analytics, campaign optimizations and recommendation/decision engines.
• Synthesize data across multiple platforms to deliver insights and business recommendations.
• Explore and incorporate new data sources to enhance customer experience.
• Collaborate with partners to review findings and insights regarding campaign performance.
• Validate and measure effectiveness of customer/channel/campaign strategies and implement improvements.
• Communicate results of highly technical projects to stakeholders with high-impact analytical solutions.

Skills

Advanced SQL

Python

Power BI

Data analysis

Education

Bachelor’s degree in related field

Tools

Power BI

Adobe Analytics

Job description

Duration: 7Months

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.
• Explore and incorporate new data sources to enhance customer experience
• Work closely with partners to review findings and insights regarding campaign performance
• 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

Candidate Requirements/Must Have Skills:

• 8+ years of experience as a Data Analyst, working with datasets, both structured and unstructured data
• 8+ years’ advanced SQL skills (coding capability)
• 3+ years’ experience with Python
• 1+ year reporting experience with PowerBI

Nice-To-Have Skills:

• Experience in Adobe Analytics be an asset
• Experience in marketing analytics is highly preferred
• Previous experience with Banks/ FI is nice to have

Soft Skills Required:

• Strong communication skills and ability to present information clearly are essential
• Self driven and able to manage time and expectations with stakeholders

Education:

Bachelor’s degree in related field

FP Inc. is committed to creating an inclusive environment where all team members and clients feel like they belong. In accordance with the requirements set out in the Employment Standards Act, FP Inc. hereby declares that AI is utilized in the screening process for this position. The hourly compensation range for this role is $50/hr -$62/hr. We seek applicants with a wide range of abilities, and we provide an accessible candidate experience. We advocate for you and welcome anyone regardless of race, colour, religion, national origin, sex, physical or mental disability, or age.