Intermediate Business Systems Analyst to decouple systems, enable transition of marketing campaign data, and create new campaign query packages

Our client is Canada's largest retailer. They are looking for an Intermediate Business Systems Analyst for a large initiative to decouple marketing campaign data for a a major line of business, enable transition of marketing campaign data, and create new campaign query packages.

Location: 1 day/week onsite (flex)

Duration: Until December 2026, possibility of extension

Responsibilities:

• Translate business intake requests directly into data solutions. Rewrite, optimize, and refactor existing SQL scripts.
• Optimize data models and features to support campaign targeting and audience segmentation.
• Support decoupling efforts by restructuring campaign data packages and ownership.
• Work closely with Marketing stakeholders to clarify targeting requirements and deliver usable outputs.
• Independently manage workload in a fast-paced build environment and drive work forward with minimal oversight.

Must Have Skills:

• Intermediate - Strong SQL skills required (ability to rewrite, optimize, and refactor existing code)
• Experience gathering business requirements and translating them into technical specifications for delivery teams.
• Strong communication skills - will interact directly with Marketing stakeholders.

Nice to Haves:

• Experience working with marketing campaign data.
• BigQuery experience (not mandatory).