Data Analyst with strong SQL, Big Query, Meta, Google Ads, and Digital Marketing experience to interpret, build insights based off existing customer data

Our client is Canada's largest retailer. They are looking for a Data Analyst with strong SQL, Big Query, Meta, Google Ads, and Digital Marketing experience to interpret, build insights based off existing customer data.

Duration: 1yr

Location: 3 days onsite Toronto

Project: Supporting market segment creation for our client’s ecommerce channels.

Responsibilities:

• Conduct in-depth analysis of CDP ID resolution and C360 results to identify trends, patterns, and insights in support of audience strategy.
• Collaborate with the Manager to present findings to business unit Spoke teams, providing actionable recommendations based on the analysis.
• Utilize query logics to translate audience requirements into audience prototypes.
• Collaborate with the Data Core team to provide clear and comprehensive requirements for the production of data products.
• Ensure that the data products enable Spoke teams to perform analytics on customer data effectively.
• Develop and build robust visualization and analytics products to help Spoke teams better understand their customer base.
• Utilize tools and technologies to create user-friendly and insightful visualizations and analytics products.
• Build audience segments in CDP and push them to the activation platform.
• Continuously monitor and aid Spoke teams to adopt the use of CDP for self-serve segmentation needs.
• Build audiences in the experimentation platform in support of onsite and in-app experimentation for all LOBs.

Must Haves:

• 5+ years Sr Data Analyst
• Expert SQL
• Expert Big Query (Analytical side - SQL Queries to pull data and interpret results to the business)
• Large data sets
• Digital Marketing experience
• Meta, Google Ads

Nice to Haves:

• Experience with third party paid media platforms in terms of audience creation