Lead Analyst, Analytics (Solutions & Onboarding)

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

Job summary

Une entreprise de services publicitaires recherche un Lead Analyst en Analytics pour se joindre à leur équipe. Le rôle implique de fournir un soutien analytique, de collaborer avec les clients sur les exigences techniques, et de diriger une petite équipe tout en travaillant sur des intégrations API et l'analyse de données. Il offre une rémunération compétitive et des avantages supplémentaires pour les employés permanents.

Benefits

Assurance médicale

Congés payés

Régime de retraite (RRSP)

Qualifications

• 3+ ans d'expérience avec Python et SQL.
• Connaissance des outils d'analyse BI (Tableau, Google Analytics, Adobe).
• Expérience avec des plateformes cloud telles que Google, Snowflake, Azure.

Responsibilities

• Fournir un support analytique pour les données de performance des médias.
• Collaborer avec les clients pour la conception technique des solutions.
• Créer des intégrations API pour l'ingestion de données en temps réel.

Skills

Python

SQL

Data Visualization

Data Modeling

Tools

Tableau

Azure Data Factory

Databricks

Job description

Lead Analyst, Analytics (Solutions & Onboarding)

Join or sign in to find your next job

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

Lead Analyst, Analytics (Solutions & Onboarding)

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

Get AI-powered advice on this job and more exclusive features.

Job Description:

This role is remote-friendly.

The Lead Analyst, Analytics (Solutions & Onboarding) responsibilities:

• Provide analytics and technical support for solutions dealing with media performance data both on reporting and analytics side
• Work with technical lead to design and implement scalable ETL architectures and data pipelines
• Collaborate directly with clients on technical requirements and solution design
• Perform data modeling and schema design for efficient data processing
• Create robust API integrations for real-time data ingestion from various sources
• Review code and engineering solutions for performance, scalability, and compliance with standards
• Create comprehensive technical documentation for data pipelines and integrations
• Design and implement API-based integration solutions
• Use advanced SQL (view tables, CTEs, multi-table joins) to automate data manipulation
• Create ETL processes in high-level scripting languages (e.g. Python) to pull and refresh data from media APIs
• Use Tableau to visualize client data, highlighting key metrics and insights
• Develop relationships with client partners, and communicate/interpret results in meetings with clients
• Lead a small team of junior associates, overseeing their day-to-day work, providing direction, and administering feedback
• You will report to VP, Data and Analytics
  
  
  

Qualifications:

• 3+ years experience with Python and SQL programming,
• 3+ years experience with on or multiple cloud platforms (Google , Snowflake and Azure)
• 1+ year experience in Azure Data Factory and Databricks is preferred
• Knowledge of BI or digital analytics tools (Tableau, Micro strategy, Adobe analytics, Google analytics, DMP insight tools)
• Experience with media platforms (Google Ads, Facebook, Campaign Manager, etc.) and site analytics platforms ( Google Analytics, Adobe, etc)
• Ability to analyze/synthesize data to provide insights with recommendations/action
• Understanding of digital data including the systems and processes used to generate and manipulate it by media type web, ad, email, mobile, etc.
  
  
  

Additional information: The salary range for this position is $67,500-$82,500. Actual salary within the salary range will be based on a variety of factors including relevant experience, knowledge, and skills. A range of medical, dental, RRSP, paid time off, and/or other benefits also are available to all permanent employees.

We know through experience that different ideas, perspectives and backgrounds foster a stronger and more creative work environment that delivers better business results. We strive to create workplaces that reflect the clients we serve and where everyone feels empowered to bring their full, authentic selves to work.

We are committed to working with our candidates from all ability levels throughout the recruitment process to ensure that they have what they need to be at their best. If you need accommodation during the application or interview process, please contact [e-mail] or to begin a conversation about your individual accessibility needs throughout the hiring process.

Location:

Toronto

Brand:

Merkle

Time Type:

Full time

Contract Type:

Permanent

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Business Development and Sales

• Industries

  Advertising Services

Referrals increase your chances of interviewing at dentsu by 2x

Freelance Data Analyst (Python) - AI Trainer

Health Data Analytics Graduate Teaching Assistant

MS Dynamics 365 CRM Sr. Business Analyst

Burnaby, British Columbia, Canada 1 week ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.