Marketing Operations Analyst - SQL and Offer Creation

Overview

**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 our e-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 from high-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.