Data Analyst

Mekanism; Toronto; Hybrid; CAD 50,000 - 60,000; Full time

Job summary

A modern agency in Toronto seeks a Data Analyst to drive data insights and measurement solutions. The ideal candidate has a strong background in SQL and data analytics, with proficiency in visualization tools. This role supports the Data Infrastructure and Analytics team, ensuring data integrity and delivering actionable media strategies. Salary ranges from $50,000 to $60,000 annually based on experience, with benefits and a flexible work policy.

Benefits

Hybrid work models

Generous vacation (3 weeks + holidays)

Wellness spending account

Social events and team gatherings

Qualifications

• 2+ years of experience in data analytics, preferably in a media agency.
• Proficient in SQL database design, Google Sheets/Excel is a must.
• Experience with Google Cloud Platform (BigQuery, Cloud Storage) desirable.

Responsibilities

• Partner with stakeholders to translate business goals into robust KPI frameworks.
• Extract, filter, and aggregate datasets using SQL for reporting insights.
• Build and maintain client dashboards with visualization tools.

Skills

Data Analytics

SQL

Excel

Data Visualization

Communication

Education

Bachelor's degree in a relevant field

Tools

Google Cloud Platform

Looker Studio

Tableau

Power BI

Google Analytics 4

Job description

Who We Are

Mekanism is a full-service modern agency making unexpected ideas unstoppable through the power of Soul & Science. We partner with brands to unleash breakthrough creativity and drive impact across the entire customer journey, delivering brand building at full volume.

With eight offices spanning markets throughout the US and Canada, we serve as collaborative business partners to some of the world’s best North American brands, including Alaska Airlines, Jose Cuervo, Quaker, Ben & Jerry's, and Amtrak in the US, and CAMH, Koodo Mobile and Public Mobile in Canada.

Named a Top 10 Most Effective Independent Agency in the US by the Effie Index, Mekanism has been profiled by The New York Times, Fast Company, and ABC’s Nightline. Our campaign methodologies are studied by Harvard Business School. For more information, visit Mekanism.com.

Transparency matters to us. For this role, you can expect a salary between $50,000-$60,000 annually, depending on experience. This is an existing vacancy.

We are seeking a brilliant individual who loves data and analytics, is a master of spreadsheets, knows how to use SQL and understands tracking and measurement for media data architecture. This person will play an essential role in supporting the Data Infrastructure and Analytics team bridging the gap between complex big data environments and actionable media strategy, supporting our clients through advanced reporting, custom database solutions, and the implementation of cutting‑edge AI agentic projects.

Responsibilities

• Measurement Strategy: Partner with stakeholders to translate business goals into robust KPI frameworks and measurement plans for multi‑channel media campaigns.
• Data Engineering & Extraction: Extract, filter, and aggregate complex datasets using SQL. You will assess system capabilities and workflows to determine the feasibility of automated reporting solutions.
• Visualization & Insights: Build and maintain high‑impact client dashboards using internal and external tools like Looker Studio, Tableau, or Power BI. You’ll turn raw data into visual stories with custom graphs.
• Digital Architecture & Tracking: Ensure data integrity by managing pixel implementation, tag management (GTM, Adobe Launch), and URL parameter tracking (UTMs).
• AI & Innovation: Support the development of AI agentic workflows and database solutions that drive efficiency for both internal teams and external clients.
• Quality Assurance: Conduct rigorous data audits and quality control to ensure 100% accuracy in client deliverables.
• Other duties may be assigned to meet the needs of the client, the team, and the company.

Qualifications

• Minimum 2+ years of experience in data analytics. Experience within a media agency or digital marketing environment is strongly preferred.
• Proven experience in SQL database design, coding, and maintenance. Mastery of Google Sheets/Excel (advanced formulas and pivot tables) is a must.
• Cloud Fluency. Experience with Google Cloud Platform (BigQuery, Cloud Storage, Firebase) is highly desirable.
• Proficiency with web analytics tools (Google Analytics 4, Adobe Analytics) and Tag Management systems.
• Visualization Expertise. Strong portfolio in data visualization (Looker Studio, Tableau, or Power BI).
• A proactive mindset with the ability to present complex technical ideas to non‑technical stakeholders.

Preferred Assets

• Familiarity with AI implementation, including chatbots and agentic workflows.
• Experience in front‑end or back‑end web development with working knowledge of JavaScript, HTML and CSS.
• Working knowledge of Python and advanced statistical modeling skills
• Understanding of GCP Vertex AI, Cloud Functions and Firebase.

What’s in it for you:

We Value The ‘whole You’

• An innovative and entrepreneurial work environment that promotes ingenuity and individuality - with the best of colleagues, and the best of clients
• Hybrid work models and flexible hours, plus a work from anywhere policy for short‑term stays in other regions
• Generous Vacation starting at 3 weeks + 1 extra week over the holidays
• Agency summer days (exact policy differs per campus and agency)
• Modern, open co‑working spaces with coffee & snack bars, located in great city neighborhoods, close to shops and restaurants and easy access to public transport
• Dogs allowed, dedicated Play Room to support families and Private wellness room (in select offices)
• Team social events - holiday parties, seasonal gatherings, weekly happy hours, inspiring speakers and more!

We are obsessed with learning and being better humans

• In‑house learning & development sessions and annual career and growth conversations’
• Access to internal network of opportunities across all agencies
• Focus on developing BIMPOC Talent via our BIMPOC Mentorship Program
• Internal EDI group(s), programs & initiatives across Plus Company and opportunities to be involved in employee resource group(s)

We invest in your health and wellness:

• Flexible benefits to support your individual lifestyle and life stage – with access to a personal wellness spending account you can use for a wide range of wellness expenses, including gym membership fees, pet care, education expenses, and much more!
• Comprehensive mental health support including access to a virtual mental health therapy clinic providing you with personalized therapist guided iCBT programs and live therapy, access to health clinicians 24/7, and a holistic array of other health and wellness resources to support you and your family.
• Dedicated play rooms for days you need to bring the kids and health and wellness rooms when you need a place to get grounded.
• A responsible sick & personal absence days policy designed so you don't have to worry the moment a personal obligation or emergency arises.
• Maternity leave top up program.

Expiry Date Notice: This job description expires on February 26, 2026

Check out our EDI report here to learn more about our work and commitment towards equity.

Employee & Job Applicants Privacy Notice

https://docs.google.com/document/d/e/2PACX-1vQIU40pchmRo2-xnl_UuSHgDa8xkw4fbkr6IZX20PCEdn2E9e3_eBD2chvxT0OWDHlPQicIkWP1kZ58/pub

Creating meaningful work means embracing different perspectives. We are an equal opportunity employer and do not discriminate based on age, colour, ability, national origin, race, religion, sex, or sexual orientation. Not only are these provisions protected by provincial and federal law, embracing difference is what makes Mekanism what it is—and we wouldn’t have it any other way. We pride ourselves on our inclusive and accessible workplace. If you need any accommodations during the interview process to make it work for you, let us know.

By joining Mekanism, you become part of Plus Company, a unique partnership of forward‑thinking creative agencies. As a network, we unabashedly believe anything is possible. Why? Because possibility is what powers the big dreams and limitless drive of an entrepreneur. And entrepreneurial agencies are what we’re made of. A whole network of them.