Lead Analyst, Analytics (Solutions & Onboarding)
Job Summary
Job Description
The Lead Analyst, Analytics (Solutions & Onboarding) role involves providing analytics and technical support for media performance data, designing and implementing scalable ETL architectures, collaborating with clients on technical requirements, performing data modeling, creating API integrations, reviewing code, creating technical documentation, and using SQL and Python for data manipulation. The role also includes visualizing client data using Tableau, communicating results to clients, and leading a small team. This position reports to the VP, Data and Analytics.
Must have:
- 3+ years experience with Python and SQL programming.
- 3+ years experience with cloud platforms (Google, Snowflake and Azure).
- Knowledge of BI or digital analytics tools (Tableau etc.).
- Experience with media platforms and site analytics platforms.
Good to have:
- 1+ year experience in Azure Data Factory and Databricks is preferred
6 skills required
Job Details
Job Description:
This role is remote-friendly.
The Lead Analyst, Analytics (Solutions & Onboarding) responsibilities:
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 Canada.Recruitment@dentsu.com or to begin a conversation about your individual accessibility needs throughout the hiring process.
#LI-Remote
#LI-AB2
Location:
Toronto
Brand:
Merkle
Time Type:
Full time
Contract Type:
Permanent
- 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
- 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.
Similar Jobs
Looks like we're out of matches
Set up an alert and we'll send you similar jobs the moment they appear!
Similar Skill Jobs
Looks like we're out of matches
Set up an alert and we'll send you similar jobs the moment they appear!
Jobs in Toronto, Ontario, Canada
Looks like we're out of matches
Set up an alert and we'll send you similar jobs the moment they appear!
Similar Category Jobs
Looks like we're out of matches
Set up an alert and we'll send you similar jobs the moment they appear!
About The Company
For over 120 years, innovation has been a core tenet of our offering – exploring new ways to reach, engage and nurture relationships with audiences. Together we drive a multiplier effect for clients at a global scale, through the development of Integrated Growth Solutions that are underpinned by our promise to clients: innovating to impact. Read MoreBe a force for good. Sustainability is a vital part of our business and an important area of focus for our clients. We’re leading the way – helping to build a more sustainable planet. Dream loud. In this moment of transformation, we need our people to be fearless, embracing change and ambiguity, driven by the love for their work and excitement for the future. Team without limits. We create opportunities for connection and collaboration between our colleagues and clients, building a sense of belonging and having some fun along the way.
Get notified when new jobs are added by Dentsu Aegis
