AdTechTalent
Data Science6 days agoRemote

StackAdapt

Lead, Business Intelligence

SQLPythonPySparkETLdata pipelinesdashboardsbusiness intelligencedata visualizationThoughtSpotTableauQlikLookerAILLMprogrammatic advertisingRTBDSPSSPanalyticsdata science

Key details

Salary

CA$114K – CA$136K

Employment type

Full-time

Seniority

Lead

Years experience

3-5

Location

Canada

Full job description

StackAdapt is hiring a BI Lead for their Advertising Technologies Team. The role involves leading design and execution of automated and scalable reporting, insights, and analytics infrastructure. Responsibilities include building data pipelines, ETL workflows, dashboards, monitoring business metrics, performing deep-dive analysis, and collaborating cross-functionally. Requires 4+ years experience in BI/data/analytics, proficiency in SQL, Python or PySpark, experience with data visualization tools, strong communication skills, and familiarity with programmatic advertising platforms. The position is remote within Canada. Salary range for Ontario candidates is $114,400 to $136,000 CAD base. Benefits include competitive salary, retirement plans, paid time off, mental health programs, health benefits from day one, work from home reimbursements, WeWork membership options, training, personal development support, parental leave, and a supportive culture.

What you'll do

  • Design and implementation of automated, scalable reporting infrastructure and analytics solutions
  • Design and build data pipelines, ETL workflows and dashboards collaborating with other analysts
  • Continuously monitor, report and review business metrics and supply quality with internal stakeholders
  • Translate data into actionable prescriptive insights and recommendations
  • Initiate, execute and fully own projects from planning to execution collaborating with BI team members
  • Perform deep-dive analysis to understand trends, anomalies, and provide actionable recommendations
  • Independently build and manage relationships with internal stakeholders including Director/VP+ level
  • Partner closely with Inventory & Data Partnerships, Product Solutions, Platform Quality Teams, and work cross-functionally on data analysis
  • Leverage AI/LLM tools (Claude, Gemini, ChatGPT) to accelerate analysis, automate repetitive tasks, and draft documentation

Requirements

  • Experience scripting with SQL and/or Python or PySpark, extracting large sets of data and designing ETL flows
  • Prior experience working in Business intelligence/Data/Analytics teams and/or platforms building predictive data & analytics solutions
  • Bachelor’s or Master’s degree in a quantitative field (e.g., finance, economics, statistics, math)
  • Minimum 4+ years of working experience in a quantitative or analytics-driven environment with solid understanding of statistical techniques
  • Experience with data visualization tools (ThoughtSpot, Tableau, Qlik, Looker, etc)
  • Strong verbal and written communication skills, comfortable presenting detailed technical and statistical analyses to senior stakeholders
  • Ability to write effective prompts, critically evaluate AI-generated output, and integrate AI tools into day-to-day workflows
  • Programmatic Advertising experience/expertise in working with RTB, DSPs, SSPs, publishers or other related platforms preferred

Tech stack

SQLPythonPySparkETLThoughtSpotTableauQlikLookerAI/LLM toolsClaudeGeminiChatGPT

Benefits

Highly competitive salaryRetirement/401K/Pension Savings globallyCompetitive Paid time off packages including birthdays offAccess to a comprehensive mental health care programHealth benefits from day one of employmentWork from home reimbursementsOptional global WeWork membership for those who want a change from their home office and hubs in London and TorontoRobust training and onboarding programCoverage and support of personal development initiatives (conferences, courses, books etc)Access to StackAdapt programmatic courses and certifications to support continuous learningAn awesome parental leave programA friendly, welcoming, and supportive cultureSocial and team events

Apply now

This MVP uses a placeholder application flow. In production, this section can connect to an external apply URL or a native application form.

Similar jobs

More roles worth a look

Related opportunities based on specialty and working model so candidates can keep momentum.