Marketing Operations Analyst - SQL and Offer Creation

Aquent; Toronto; Hybrid; CAD 60,000 - 80,000; Full time

Job summary

A marketing talent agency is seeking a Marketing Operations Analyst to join their Toronto team. This role requires strong SQL skills and experience in campaign operations. You will create promotional offers and analyze data to improve marketing efforts. If you have a knack for detail and a data-driven mindset, this opportunity could be perfect for you. This position offers a hybrid work model with competitive benefits.

Benefits

Subsidized health, vision, and dental plans

Paid sick leave

Retirement plans with a match

Free online training through Aquent Gymnasium

Qualifications

• Experience with CRM, loyalty marketing, or marketing operations.
• Ability to analyze data and provide actionable insights.
• Experience with email marketing platforms or CRM systems is a plus.

Responsibilities

• Create and manage promotional offers weekly.
• Use SQL to analyze customer and product data.
• Collaborate with teams to align offers.

Skills

Strong SQL querying skills

Analytical mindset

Strong communication skills

Detail-oriented

Organized

Tools

Acoustic

Hubspot

Salesforce Marketing Cloud

Mailchimp

Job description

Marketing Operations Analyst - SQL and Offer Creation

**We are seeking authorized candidates who are local to or commutable to Toronto, Ontario, for hybrid office requirements.**

We’re looking for a data-driven Marketing Operations Analyst to join oure-commerce client’s team and help deliver engaging customer offers. If you have strong SQL skills and hands-on experience with marketing campaigns, loyalty programs, or promotional offers, this consultant role will let you put both your technical and marketing expertise into action.

What You’ll Do

• Create and manage promotional offers on a weekly basis, ensuring accuracy and timely execution.
• Use SQL to pull and analyze customer and product data to inform offer targeting and performance tracking.
• Test offers in both staging (SIT) and live (PROD) environments to guarantee flawless customer experiences.
• Troubleshoot and resolve issues quickly to keep campaigns running smoothly.
• Collaborate with marketing and merchandising teams to align offers with overall campaigns and promotions.
• Analyze results to identify trends and provide insights that improve future offers.
• Support ad hoc requests that help optimize offer creation and execution processes.

What We’re Looking For

• Strong SQL querying skills and comfort working with large datasets.
• Background in CRM, loyalty marketing, or marketing operations (offer creation or campaign execution experience is a big plus).
• Analytical mindset — ability to spot trends, troubleshoot issues, and turn data into actionable insights.
• Strong communication skills for working with cross-functional teams (marketing, merchandising, IT).
• Detail-oriented, organized, and adaptable — you’ll be testing, validating, and adjusting campaigns on tight timelines.

Nice to Have

• Experience with email marketing platforms or CRM systems (Acoustic, Hubspot, Salesforce Marketing Cloud, Mailchimp, etc.).
• Exposure to e-commerce or retail marketing environments.
• Familiarity with campaign QA, SIT/PROD testing, or technical troubleshooting in a marketing context.

Why This Role is Exciting

• Work at the intersection of marketing and data — not just creating offers, but ensuring they are accurate, effective, and impactful.
• Be part of a high-visibility team where your work directly influences customer engagement and sales.
• Gain experience with enterprise-level systems and offer creation processes.
• Join a collaborative environment with strong mentorship fromhigh-performing peers.

Who Should Apply:

• Marketing coordinators or analysts with SQL and campaign operations experience.
• CRM or loyalty specialists who want to expand their technical/analytical skillset.
• Data-savvy marketers who enjoy hands-on execution, testing, and problem-solving.
  

Who Should Not Apply:

• Purely creative/brand marketers without SQL or data experience.
• Candidates looking for a strategy-only role without operational, detail-oriented execution.

#LI-BC1

About Aquent Talent:
Aquent Talent connects the best talent in marketing, creative, and design with the world’s biggest brands. Our eligible talent get access to amazing benefits like subsidized health, vision, and dental plans, paid sick leave, and retirement plans with a match. We also offer free online training through Aquent Gymnasium.

Aquent is an equal-opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, and other legally protected characteristics. We’re about creating an inclusive environment—one where different backgrounds, experiences, and perspectives are valued, and everyone can contribute, grow their careers, and thrive.