Partner Intelligence Lead II - Ads

Instacart; Manitoba; Remote; CAD 137,000 - 152,000; Full time

Job summary

A leading e-commerce platform is seeking an Analytics Engineer to enhance Ads performance in a remote role. The candidate will define metrics, design data models, and drive strategic recommendations to optimize ad effectiveness. This position requires 4–7 years of experience in analytics, strong SQL and Python skills, and expertise in managing data pipelines. Competitive compensation ranges from $137,000 to $152,000 CAD based on the candidate's location and qualifications.

Benefits

Market-competitive compensation

Benefits offerings

New hire equity grants

Qualifications

• 4–7 years in analytics engineering, data science, or applied AI.
• 2+ years of domain expertise in ads or e-commerce.
• Advanced proficiency in Python and SQL.
• Experience using dbt and Snowflake or BigQuery.
• Expertise in orchestrating data pipelines using dbt and Airflow.
• Fluency in Ads analytics concepts.

Responsibilities

• Define Ads ontologies and metrics for campaigns.
• Build dbt models and curated marts in Snowflake.
• Design evaluation suites covering precision and recall.
• Run A/B or uplift experiments to guide iteration.
• Translate Ads problems into agent behaviors.

Skills

Analytics engineering

Data science

SQL

Python

Data visualization

Stakeholder communication

Data pipeline orchestration

Machine learning concepts

Tools

dbt

Snowflake

Airflow

Tableau

Looker

Job description

Overview

About the Role

Own the intelligence behind our Ads agents. You will design the Ads semantic/context layer and build vertical AI agents that analyze campaigns, diagnose performance, and recommend actions that improve ROAS, pacing, and partner outcomes. You will partner with Ads GTM, Product, Data Science, and Engineering to ship production agents with measurable lift.

About the Team

The Commercial Scaled Intelligence (CSI) team is an AI-first team dedicated to delivering actionable commercial insights and scalable automation to drive revenue growth and operational efficiency across the company. The team focuses on intelligence generation, predictive analytics, and workflow automation to enable data-driven decision-making and optimize commercial performance.

About the Job

• Define Ads ontologies and metrics for campaigns, budgets, bids, creatives, audiences, and placements.
• Build dbt models and curated marts in Snowflake with clear data contracts, tests, and SLOs.
• Ingest and enrich unstructured Ads content and publish retrieval-ready datasets using our managed search/vector services.
• Design and evaluate retrieval workflows (RAG) with existing services for hybrid search and re-ranking; set quality/latency targets and iterate via experiments.
• Design agent reasoning and policies on ads, including tool definitions and human-in-the-loop approvals.
• Establish evaluation suites covering precision/recall, calibration, hallucination rate, latency, and cost.
• Run A/B or uplift experiments to quantify impact and guide iteration.
• Translate Ads problems into agent behaviors and own KPIs such as ROAS lift, pacing accuracy, RCA precision/recall, forecast MAPE, and time-to-insight.

About You

Minimum Qualifications

• 4–7 years in analytics engineering, data science, or applied AI with strong SQL and Python.
• 2+ years of domain expertise in ads, retail, or e-commerce data.
• Advanced Proficiency in Python and SQL, with experience using dbt and Snowflake or BigQuery, including skills in data modeling, testing, and managing data contracts.
• Deep Expertise in orchestrating data pipelines using dbt and Airflow
• Experience with at least one data visualization tool (Tableau, Mode, Power BI, Looker, or similar)
• Ability to design offline/online evaluations and run A/B or uplift tests
• Fluency in Ads analytics concepts such as ROAS, CPA, CTR, CVR, LTV, pacing, auction dynamics, and incrementality.
• Strong stakeholder communication with a track record of shipping production data or AI systems that drove business impact.
• Understanding of ML models to drive recommendations on bid, keywords, and budgets
• Experience with evaluation and guardrail frameworks and human-in-the-loop QA.

Preferred Qualifications

• Strong understanding of AI and machine learning concepts, with experience creating AI-driven products.
• Deep expertise in advertising products, including leading and driving automation projects.
• Proven ability to improve operational efficiency through automation initiatives in fast-paced environments.
• Applied experience in modeling techniques for Ads, including forecasting, anomaly detection, uplift modeling, and causal inference.
• Hands-on experience with workflow automation and low-code development platforms (Zapier, n8n, Gumloop, Superblocks)
• Familiarity with retail media or ad platforms, including Amazon, Google, Meta, Shopify, or DoorDash.

#LI-REMOTE

Instacart provides highly market-competitive compensation and benefits in each location where our employees work. This role is remote and the base pay range for a successful candidate is dependent on their permanent work location. Please review our Flex First remote work policy here. Currently, we are only hiring in the following provinces: Ontario, Alberta, British Columbia, and Nova Scotia.

Offers may vary based on many factors, such as candidate experience and skills required for the role. Additionally, this role is eligible for a new hire equity grant as well as annual refresh grants. Please read more about our benefits offerings here.

For Canadian based candidates, the base pay ranges for a successful candidate are listed below.

CAN

$137,000—$152,000 CAD