AdTechTalent
Data Science5 days agoRemote

StackAdapt

Data Analyst, Business Intelligence

sqldata analysisbusiness intelligencedata visualizationdashboardprogrammaticai toolsproject managementkpireportingredshiftsnowflakebigquerylookertableausigmaclaudechatgptgemini

Key details

Salary

CA$76K – CA$90K

Employment type

Full-time

Seniority

Mid-level

Years experience

3-5

Location

Canada

Full job description

StackAdapt is seeking a Data Analyst II for the Business Intelligence team within Advertising Technologies. This remote-friendly full-time role based in Canada requires 2+ years of data analytics experience, advanced SQL skills, and experience with BI tools such as Looker, Tableau, or Sigma. Responsibilities include designing and maintaining dashboards and reports, writing complex SQL queries, recommending KPIs, managing reporting projects, and collaborating with cross-functional teams. The role involves leveraging AI tools like Claude, ChatGPT, and Gemini to enhance workflows. The salary range for Ontario candidates is $76,000 to $90,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, build, and maintain dashboards, reports, and datasets to support product, revenue, and operations teams
  • Write advanced SQL queries to extract, transform, and validate data from multiple sources
  • Identify and recommend new KPIs and metrics to improve business visibility
  • Manage project plans for new reporting needs including requirements gathering and milestone tracking
  • Partner with cross-functional teams to clarify data requirements and resolve data quality issues
  • Own delivery of regular BI reporting cycles and contribute to KPI frameworks within first 6 months
  • Support adoption of AI-assisted workflows using Claude, ChatGPT, Gemini
  • Ensure reporting SLA adherence and data quality improvements
  • Achieve stakeholder satisfaction through quality insights and responsiveness
  • Complete reporting project plans on time and within scope

Requirements

  • 2+ years of experience in a data analytics role
  • Advanced SQL proficiency including complex queries and troubleshooting
  • Experience with data warehouses such as Redshift, Snowflake, BigQuery
  • Experience building and maintaining dashboards and reports using BI tools like Looker, Tableau, Sigma
  • Strong project management skills including requirements gathering, milestone tracking, risk management
  • Excellent communication skills for presenting data findings to technical and non-technical stakeholders
  • Ability to write effective AI prompts, critically evaluate AI-generated output, and integrate AI tools into workflows

Tech stack

SQLRedshiftSnowflakeBigQueryLookerTableauSigmaClaudeChatGPTGemini

Benefits

Highly competitive salaryRetirement/401K/Pension Savings globallyCompetitive paid time off packages including birthdays offComprehensive mental health care programHealth benefits from day oneWork from home reimbursementsOptional global WeWork membership (London and Toronto hubs)Robust training and onboarding programSupport for personal development initiatives (conferences, courses, books)Access to StackAdapt programmatic courses and certificationsParental leave programFriendly, 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.

Continue to applicationBrowse more jobs

Similar jobs

More roles worth a look

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