Lead Analyst, Analytics (Solutions & Onboarding)

dentsu; Toronto; Remote; CAD 67,000 - 83,000; Full time

Job summary

A prominent advertising services company is seeking a Lead Analyst to support analytics and onboarding processes. This remote-friendly position involves designing ETL architectures, client interaction, and team management. Candidates should possess significant experience in Python and SQL, along with strong knowledge of BI tools like Tableau. The role offers a competitive salary and comprehensive benefits, fostering an inclusive environment.

Benefits

Medical benefits

Dental benefits

Paid time off

RRSP benefits

Qualifications

• 3+ years experience with Python and SQL.
• Experience with Azure Data Factory and Databricks preferred.
• Knowledge of BI tools like Tableau and Adobe Analytics.

Responsibilities

• Provide analytics support for media performance.
• Design scalable ETL architectures and data pipelines.
• Lead and oversee a small team of junior associates.

Skills

Python

SQL

API integrations

Data modeling

Tableau

Tools

Azure Data Factory

Databricks

Google Cloud

Snowflake

Job description

Lead Analyst, Analytics (Solutions & Onboarding)

Join to apply for the Lead Analyst, Analytics (Solutions & Onboarding) role at dentsu.

This role is remote-friendly.

Responsibilities:

• Provide analytics and technical support for media performance data reporting and analytics.
• Design and implement scalable ETL architectures and data pipelines in collaboration with technical leads.
• Work directly with clients to understand technical requirements and design solutions.
• Perform data modeling and schema design for efficient processing.
• Create API integrations for real-time data ingestion from various sources.
• Review code for performance, scalability, and compliance.
• Document data pipelines and integrations thoroughly.
• Develop API-based integration solutions.
• Use advanced SQL techniques for data manipulation.
• Create ETL processes using scripting languages like Python.
• Visualize data using Tableau, highlighting key metrics and insights.
• Communicate findings and insights to clients effectively.
• Lead and oversee a small team of junior associates.

Qualifications:

• 3+ years experience with Python and SQL.
• 3+ years experience with cloud platforms (Google, Snowflake, Azure).
• 1+ year experience with Azure Data Factory and Databricks (preferred).
• Knowledge of BI and digital analytics tools (Tableau, MicroStrategy, Adobe Analytics, Google Analytics, DMP tools).
• Experience with media platforms (Google Ads, Facebook, Campaign Manager) and site analytics platforms.
• Ability to analyze data and provide insights with recommendations.
• Understanding of digital data systems and processes across various media types.

The salary range for this position is $67,500-$82,500, based on experience and skills. Benefits include medical, dental, RRSP, paid time off, among others.

We value diversity and are committed to creating an inclusive environment. Candidates needing accommodations during the hiring process should contact [e-mail].

Location: Toronto

Brand: Merkle

Time Type: Full-time

Contract Type: Permanent

Seniority level

• Mid-Senior level

Employment type

• Full-time

Job function

• Business Development and Sales

Industries

• Advertising Services