Data Analyst, Business Intelligence

About the Role

StackAdapt is a programmatic advertising platform that helps marketers build high-impact campaigns across the customer journey using AI-driven optimization. The Business Intelligence team within Advertising Technologies is hiring a Data Analyst II to provide advanced analysis and reporting that supports decisions across product, revenue, and operations.

In this position, you will work with large and complex datasets, create dependable reporting pipelines, and surface new metrics and KPIs that improve visibility into business performance. The role is remote-friendly and open to candidates located in Canada.

Key Responsibilities

• Develop and support dashboards, reports, and datasets that enable decision-making for product, revenue, and operations stakeholders.
• Use advanced SQL to pull, transform, and validate information from multiple systems while maintaining reporting accuracy.
• Spot opportunities for additional KPIs and performance measures that help teams better understand trends and results.
• Coordinate reporting projects by defining requirements, tracking milestones, and delivering updates on schedule.
• Work closely with Product, Revenue, and Operations teams to clarify data needs, fix data quality issues, and support planning with evidence.
• Own recurring BI reporting work, contribute to at least one new KPI framework, and support the team’s use of AI-assisted workflows with tools such as Claude and Gemini.
• Use AI and LLM tools such as Claude, ChatGPT, and Gemini to speed up analysis, reduce repetitive work, and help draft documentation.

What We're Looking For

• At least 2 years of experience in data analytics delivering practical insights from complex datasets.
• Strong command of SQL, including advanced querying, issue troubleshooting, and work with warehouses such as Redshift, Snowflake, or BigQuery.
• Hands-on experience creating and maintaining dashboards and reports in BI tools such as Looker, Tableau, Sigma, or similar platforms.
• Solid project management ability with experience gathering requirements, setting milestones, managing risks, and independently delivering reporting work.
• Clear communication skills and the ability to explain analytical findings to both technical and non-technical audiences.
• Comfort using AI tools in daily workflows, including writing prompts, checking AI-generated output, and incorporating results into analysis and documentation.

Compensation and Benefits

The Ontario salary band for this role is CAD 76,000 to CAD 90,000. The stated range reflects base pay only and is based on market data and the approved budget for the role. Final compensation may vary by location and will also depend on experience, technical ability, knowledge, education, certifications, and other business factors. In addition to base salary, candidates may also be eligible for annual bonuses, commissions, equity awards, and a benefits package.

• Competitive salary
• Retirement savings support, including 401K/Pension options globally
• Paid time off, including birthdays off
• Mental health care support
• Health benefits starting from day one
• Home office reimbursement
• Optional global WeWork membership, plus hubs in London and Toronto
• Structured onboarding and training
• Support for professional development such as conferences, courses, and books
• Access to programmatic advertising courses and certifications
• Parental leave program
• Friendly, inclusive, and supportive team culture
• Social and team events

Additional Information

Benefits and perks can differ based on the country of employment and the type of engagement. Where StackAdapt does not have a legal entity, employment and benefits are managed according to local regulations and partner policies.

StackAdapt emphasizes diversity and inclusion and welcomes applicants of all backgrounds, identities, abilities, and beliefs. Candidates who need accommodations during the interview process are encouraged to share those needs with the talent team.

The company also notes that AI is used to help review resumes and assess fit against the posting criteria, but final hiring and interview decisions are not made by AI.

About the company: StackAdapt is recognized for its inclusive workplace, strong campaign performance, customer service, and innovation, with awards including G2 Top Software for 2026, 2026 Best Workplaces for Young Talent and in Canada by Great Place to Work, and #1 DSP on G2 with leadership in cross-channel advertising categories.