About the TeamThe AI & Data Platform team builds the foundation that makes Vantage's retail media platform intelligent. We own the data platform that turns campaign activity across onsite, offsite, and in-store channels into the trusted reporting that retailers and brands rely on to understand what their advertising delivers. And we're building Vantage's AI platform: the intelligent systems, automation, and workflows that help advertisers scale their operations, and the foundation that lets every team at Vantage bring agents into the product safely.
About the RoleIn this role you'll focus on building and evolving the data platform behind Vantage's reporting and the AI platform that lets teams build agents on top of it, while acting as a subject matter expert and mentor for our engineering team. Expect heavy use of external APIs and data feeds to pull data from ad platforms and partner systems, as well as designing and delivering pipelines, data models, and agent-facing services that other teams at Vantage depend on. You'll work with large datasets, perform hands-on coding, and keep our pipelines and services reliable, and fast.
In this role you'll be called on to support multiple product teams to uphold sound architecture, high code quality, and on-time delivery across both halves of what we own. On the data side, you'll be a trusted go-to reviewer for SQL, dbt, and data model changes, and set clear standards for warehouse performance and data trust. On the AI side, you'll shape the intelligent systems and automated workflows advertisers rely on inside Vantage and how other teams build agents on our platform: which tools an agent can call, how it reaches data securely, and whether the answer it gives actually solves the customer's problem. We're a platform team, but we measure ourselves by what our customers can do with what we build. You'll talk to the people who use it, care about whether it delights them, and guide design and trade-off decisions that keep the platform scalable while solving real problems.
This posting is for an existing vacancy (backfill).
Minimum Requirements- 6+ years of professional experience with a strong record in software development, testing, software design, and architecture.
- Advanced SQL expertise: comfortable reading query plans, designing data models, tuning complex joins and aggregations, and refactoring queries for reliability and speed on large datasets.
- Hands-on experience with a cloud data warehouse and a transformation framework such as dbt, including dimensional modelling (star schema or medallion architectures).
- Experience building with LLMs in production: agent frameworks (e.g. LangGraph or LangChain), tool use, and protocols such as MCP, with an understanding of how to give agents secure, scoped access to data.
- Experience as a gatekeeper for data quality and query performance in code reviews and debugging sessions, with a demonstrated ability to both diagnose and prevent issues.
- Proven ability to troubleshoot and debug production pipelines and services using logs, metrics, and traces.
- Experience with cloud platforms, Docker, and CI/CD tooling such as CircleCI or GitHub Actions.
- Experience with B2B API and data integrations, and with relational databases such as MySQL or Postgres.
- Track record of effective mentoring and knowledge sharing.
- Nice to have: Experience with Snowflake and streaming data systems, or with managed LLM platforms, evals, and guardrails. A degree in Computer Science or a related field is a plus.
Role Responsibilities- Own data platform performance and quality. Review pull requests with an eye for query cost, data model design, test coverage, and freshness, and drive improvements across the warehouse.
- Own data ingestion and integrations. Build and maintain reliable connectors to ad platforms and partner systems, including authentication, rate limiting, and retries, and define how other Vantage teams land data on the platform.
- Design and ship transformation pipelines and data models in SQL, dbt, and Python that turn raw data into trusted, query-ready datasets with predictable latency and high reliability.
- Build and evolve the AI platform: agent-facing services and MCP tools that expose data to agents with per-user identity and access controls, and the shared patterns other teams use to build their own agents on Vantage.
- Diagnose production issues, lead debugging sessions, and improve observability using logs, metrics, and traces. Proactively identify performance, cost, and data-quality risks and coach the team on preventing regressions, backed by strong automated tests and clear documentation.
- Mentor engineers through pairing, design reviews, and actionable feedback, and stay close to the people who use what we build: advertisers scaling their operations on our automation, product teams querying the data, and engineers building agents on the platform. Bring their problems into architectural decisions so the platform scales and solves real customer needs.
Remote-First, Based in TorontoVantage is proudly headquartered in Toronto, but we're a remote-first team spread across North America (and beyond). Our flexible work philosophy means team members can thrive from wherever they do their best work-whether that's from a home office, a local café, or while adding stamps to their passport. With a remote-friendly setup, home office support, and annual company retreats, we stay connected, collaborative, and energized-no matter the time zone.