StackAdapt Logo

StackAdapt

Data Analyst, Business Intelligence

Posted 22 Days Ago
Remote
Hiring Remotely in Canada
Junior
Remote
Hiring Remotely in Canada
Junior
Design, build, and maintain BI dashboards and reports; write advanced SQL to extract and validate data; recommend KPIs; manage reporting projects; partner with Product/Revenue/Operations; own BI reporting cycles and adopt AI/LLM tools to accelerate analysis and automation.
The summary above was generated by AI

StackAdapt is the leading technology company that empowers marketers to reach, engage, and convert audiences with precision. With 465 billion automated optimizations per second, the AI-powered StackAdapt Marketing Platform seamlessly connects brand and performance marketing to drive measurable results across the entire customer journey. The most forward-thinking marketers choose StackAdapt to orchestrate high-impact campaigns across programmatic advertising and marketing channels.

StackAdapt is a self-serve programmatic advertising platform used by the world's top digital marketers. We are looking for a Data Analyst II to join our Business Intelligence team within Advertising Technologies. In this role, you will deliver advanced data analysis and reporting that drives strategic decision-making across product, revenue, and operations teams. You will work with complex datasets, build trusted reporting pipelines, and recommend new KPIs to improve business visibility. This is an excellent opportunity for a data professional who thrives on translating raw data into actionable insights in a fast-paced, AI-augmented environment.

This is a remote-friendly position open to candidates based in Canada.

What You'll Be Doing:
  • Design, build, and maintain high-quality dashboards, reports, and datasets that support business decision-making across product, revenue, and operations teams.
  • Write advanced SQL queries to extract, transform, and validate data from multiple sources, ensuring accuracy and reliability of reporting outputs.
  • Identify and recommend new KPIs and metrics that improve business visibility and stakeholder understanding of performance trends.
  • Manage project plans for new reporting needs, including requirements gathering, milestone tracking, and timely delivery.
  • Partner with cross-functional teams (Product, Revenue, Operations) to clarify data requirements, resolve data quality issues, and support evidence-based planning.
  • Within your first 6 months, you will own the delivery of regular BI reporting cycles, contribute to at least one new KPI framework, and actively support the team's adoption of AI-assisted workflows using Claude for reporting and coding tasks and Gemini for planning and meeting documentation.
  • Leverage AI/LLM tools (e.g., Claude, ChatGPT, Gemini) to accelerate analysis, automate repetitive tasks, and draft documentation.
What You'll Bring to the Table
  • 2+ years of experience in a data analytics role, with a track record of delivering actionable insights from complex datasets.
  • Advanced SQL proficiency, including the ability to write complex queries, troubleshoot data issues, and work with data warehouses (e.g., Redshift, Snowflake, BigQuery).
  • Experience building and maintaining dashboards and reports using BI tools (e.g., Looker, Tableau, Sigma, or similar).
  • Strong project management skills: ability to clarify requirements, set milestones, manage risks, and deliver reporting initiatives independently.
  • Excellent communication skills with the ability to present data findings clearly to both technical and non-technical stakeholders.
  • Ability to write effective prompts, critically evaluate AI-generated output, and integrate AI tools into day-to-day workflows.

The compensation range listed for this role reflects the expected base salary for candidates located in Ontario, Canada. It is informed by market data and the approved budget for this position. StackAdapt maintains different compensation ranges for roles across other countries and regions, and final offers will be aligned to the candidate’s current location.

This range represents base salary only. Depending on the role, candidates may also be eligible for additional compensation such as annual bonuses, commissions, equity awards, and a comprehensive benefits package.

Factors Influencing Final Compensation:

  • The final compensation offer will be determined by a variety of factors, which may include, but are not limited to: the candidate's specific experience, technical skills, knowledge, abilities, and relevant education, licensure, and certifications.
  • Other business factors, such as organizational needs and budget alignment, may also be considered in the final offer.
Ontario Salary Band
$76,000$90,000 CAD
StackAdapter's Enjoy:
  • Highly competitive salary
  • Retirement/ 401K/ Pension Savings globally
  • Competitive Paid time off packages including birthday's off!
  • Access to a comprehensive mental health care program
  • Health benefits from day one of employment
  • Work from home reimbursements
  • Optional global WeWork membership for those who want a change from their home office and hubs in London and Toronto
  • Robust training and onboarding program
  • Coverage and support of personal development initiatives (conferences, courses, books etc)
  • Access to StackAdapt programmatic courses and certifications to support continuous learning
  • An awesome parental leave program
  • A friendly, welcoming, and supportive culture
  • Our social and team events!

Please note: Benefits and perks may vary depending on your country of employment and the nature of your engagement. In locations where StackAdapt does not have a legal entity, employment and benefits are administered in accordance with local regulations and partner policies.

StackAdapt is a diverse and inclusive team of collaborative, hardworking individuals trying to make a dent in the universe. No matter who you are, where you are from, who you love, follow in faith, disability (or superpower) status, ethnicity, or the gender you identify with (if you’re comfortable, let us know your pronouns), you are welcome at StackAdapt. If you have any requests or requirements to support you throughout any part of the interview process, please let our Talent team know.
 
We use artificial intelligence (AI) to streamline the resume reviews of candidates and assess their fit based on the criteria outlined in the job posting. We do not use AI to make any final hiring or interview decisions.
 
About StackAdapt
 
We've been recognized for our diverse and supportive workplace, high performing campaigns, award-winning customer service, and innovation. We've been awarded:
 
G2 Top Software for 2026
2026 Best Workplaces™ for Young Talent and in Canada by Great Place to Work®
#1 DSP on G2 and leader in a number of categories including Cross-Channel Advertising
 
To learn more about our privacy practices, please see our Privacy Policy.
 
#LI-REMOTE

Similar Jobs

Yesterday
Remote
Canada
Senior level
Senior level
AdTech • Marketing Tech
Lead BI reporting and analysis for Advertising Technologies: design dashboards, define ETL/data models, create KPIs, resolve data quality issues, deliver recurring and ad-hoc reports, automate reporting workflows, document data logic, and collaborate with stakeholders to communicate insights.
Top Skills: ChatgptClaudeETLGeminiLookerSQLTableau
51 Minutes Ago
Easy Apply
Remote or Hybrid
Canada
Easy Apply
Senior level
Senior level
Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Own and optimize Okta identity infrastructure and Google Workspace, build Workato automations (OWL-IT), support IAM initiatives (RBAC, provisioning, SCIM), act as Tier 3 escalation for identity incidents, ensure StateRAMP/FedRAMP compliance, document runbooks, and collaborate with Security/GRC to strengthen identity security.
Top Skills: ConfluenceGemini EnterpriseGoogle Apps Manager (Gam)Google Cloud Platform (Gcp)Google WorkspaceIgaOktaOkta WorkflowsOwl-ItPamPythonRbacRest ApisSaviyntScimSplunkSsoTerraformVertex AiWorkatoWorkato Connector SdkWorkato One
An Hour Ago
Remote
Canada
Senior level
Senior level
Artificial Intelligence • Cloud • Consumer Web • Productivity • Software • App development • Data Privacy
The Senior Manager, Corporate FP&A will oversee revenue forecasting, support executive communications, analyze revenue metrics, and enhance forecasting processes in Corporate Finance.
Top Skills: AnaplanDatabricksExcelOracle FinancialsOracle PbcsPigmentTableau

What you need to know about the Ottawa Tech Scene

The capital city of Canada and the nation's fourth-largest urban area, Ottawa has proven a rapidly growing global tech hub. With over 1,800 tech companies, many of which are leaders in their sectors, the city's tech talent now makes up more than 13 percent of its total workforce. This growth is driven not only by the big players like UL Solutions and Dropbox, but also by a thriving startup ecosystem, as new businesses emerge to follow in the footsteps of those that came before them.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account