Lead Analyst, Analytics

dentsu; Canada; Remote; USD 67,000 - 82,000; Full time

Job summary

An innovative agency is looking for a skilled analytics professional to join their remote-friendly team. In this role, you'll leverage your expertise in Python and SQL to automate data manipulation and create ETL processes, while using Tableau for data visualization. You'll collaborate with clients, providing insights and recommendations based on your analyses. This position offers a competitive salary and a range of benefits, including medical and dental coverage, making it an exciting opportunity to advance your career in a supportive and inclusive environment.

Benefits

Medical insurance

Dental insurance

RRSP

Paid time off

Qualifications

• 5+ years experience with Python and SQL programming.
• Hands-on experience with BI tools like Tableau and Google Analytics.

Responsibilities

• Provide analytics and technical support for media performance reporting.
• Lead a small team of junior associates and oversee their work.

Skills

Python

SQL

multi-variate statistics

logistic regression

multiple regression

Excel

PowerPoint

Tools

Tableau

Google Cloud Platform

Adobe Analytics

Google Analytics

Job description

Merkle is a leading technology-enabled, data-driven customer experience management (CXM) company. For over 30 years, Fortune 1,000 companies and leading nonprofit organizations have partnered with us to build and maximize the value of their customer portfolios. We are champions for meaningful progress and we strive to be a force for good—for our people, for our clients, for the industry and for our society. We keep our people at the center, creating space for growth, understanding and learning so they can thrive. We embed diversity, in our mindset, in our solutions and in our teams to empower an inclusive, equitable and culturally fluent environment. Building this culture within our teams makes us better collaborators with each other and with our clients, driving better outcomes for all. Merkle is an agency of dentsu.

Job Description

This role is remote-friendly.

• You will provide analytics and technical support for solutions dealing with media performance reporting and analysis.
• You will use advanced SQL (view tables, CTEs, multi-table joins) to automate data manipulation.
• You will create ETL processes in high-level scripting languages (Python) to accurately pull & refresh data from media APIs.
• You will use Tableau to visualize client data, highlighting key metrics and insights.
• You will perform ad-hoc analyses in Excel, including multiple regression and linear optimization.
• You will develop relationships with client stakeholders, and communicate / interpret results in meetings with clients.
• You will lead a small team of junior associates, overseeing their day-to-day work, providing direction, and administering feedback as necessary.
• You will report to Senior Director.

Qualifications

• 5+ years experience with Python, SQL programming, multi-variate statistics, logistic regression, multiple regression, Google Cloud Platform, Excel, PowerPoint, etc.
• 3+ years hands-on experience with BI or digital analytics tools (Tableau, Adobe analytics, Google analytics, DMP insight tools).
• Good understanding of 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,000-$82,000. Actual salary within the salary range will be based on a variety of factors including relevant experience. A range of medical, dental, RRSP, paid time off, and other benefits also are available to all permanent employees.

We know through experience that different perspectives and backgrounds foster a stronger and more creative work environment that delivers better results. We aim 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 us to begin a conversation about your individual accessibility needs throughout the hiring process.