Senior Data Analyst, Business Intelligence

Remote from
USA, Canada
Salary, yearly, USD
100,000 - 118,500
Employment type
Full Time,
Job posted
Apply before
26 Jul 2026
Experience level
Senior
Views / Applies
113 / 10

About StackAdapt

Discover the self-serve programmatic advertising platform used by digital marketers around the world.

Actively Hiring
Verified job posting
This job post has been manually reviewed for authenticity and compliance.

AI Summary

StackAdapt is seeking a Senior Data Analyst for its Business Intelligence team to drive data-driven decision-making across the Advertising Technologies department. The role involves designing advanced dashboards, leading end-to-end analysis, and collaborating with cross-functional stakeholders. Candidates need 3+ years of experience, advanced SQL, and data visualization skills. The position offers a remote-first culture and is based in Canada, with a salary range of $100,000-$118,500 USD.

Role DNA

Job Complexity
Easy Hard
Pace & Pressure
Relaxed Fast-paced
Autonomy Level
Guided Full Ownership
Communication Load
Independent Highly Collaborative
AI Insight The role requires advanced technical skills in SQL and data visualization, but the 3+ year experience requirement and defined responsibilities make it a moderately difficult senior-level position.

Salary Analysis

Median Market Rate
USD109,250
US Market
USD80k – 140k
0 USD154k
AI Insight The offered salary range of $100,000-$118,500 USD is competitive for a Senior Data Analyst role in the US market, falling within the market median to upper quartile. However, this position is based in Canada, so the actual compensation should be considered against Canadian market rates, which may be slightly lower.

Key Skills

SQL Data Visualization Business Intelligence Data Analysis KPI Development Data Quality ETL Cross-functional Collaboration Automated Reporting AI/LLM Tools

Dear Hiring Manager,

I am excited to apply for the Senior Data Analyst, Business Intelligence position at StackAdapt. With over 4 years of experience in data analytics and a strong background in SQL and data visualization, I have successfully delivered advanced reporting solutions that drove strategic decisions. In my previous role, I led end-to-end analysis projects, defined KPIs, and automated workflows using tools like Tableau and Python.

I am particularly drawn to StackAdapt's innovative approach to programmatic advertising and its data-driven culture. Your emphasis on leveraging AI/LLM tools to accelerate analysis aligns perfectly with my recent experience integrating ChatGPT into reporting pipelines to improve efficiency.

I look forward to the opportunity to contribute to your Business Intelligence team and help drive impactful insights across the organization.

Sincerely, [Your Name]

Can you describe a complex SQL query you wrote to solve a business problem?
I wrote a query to calculate customer lifetime value by joining transaction, customer, and campaign tables. It involved window functions, CTEs, and handling NULLs to derive accurate LTV segments for marketing strategy.
How do you approach designing a dashboard for executive stakeholders?
I start by understanding their key metrics and decision points. I use a clean layout with high-level KPIs at the top, followed by trend charts and filters for drill-down. I ensure the dashboard is intuitive and provides actionable insights at a glance.
Tell me about a time you had to handle data quality issues. What steps did you take?
I noticed discrepancies in revenue reports between systems. I traced the issue to a ETL mapping error, documented the root cause, implemented validation checks, and coordinated with engineering to fix the pipeline. I also set up automated alerts to prevent recurrence.
How do you prioritize multiple requests from different stakeholders?
I align with stakeholders on business impact and urgency. Using a prioritization matrix, I categorize tasks into high-impact quick wins and long-term projects. I also communicate timelines transparently and re-prioritize during sprint planning as needed.
Can you give an example of how you used AI or LLM tools to improve your analytics workflow?
I used ChatGPT to generate initial SQL queries for recurring reports and draft documentation. I then refined them for accuracy, which saved 30% of my time on routine tasks, allowing me to focus on deeper analysis.

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 leading agencies and brands. The Business Intelligence team plays a central role in enabling data-driven decision-making across the organization. As a Senior Data Analyst on the BI team, you will own advanced reporting and analysis for multiple internal stakeholders, driving strategic planning and operational insights across the Advertising Technologies department.

This role is based in Canada. StackAdapt operates with a remote-first culture.

What You’ll Be Doing:

  • Design and maintain advanced reporting solutions and dashboards that support stakeholder decision-making across multiple teams and business segments
  • Lead end-to-end data analysis projects, defining technical requirements for ETL processes and data models
  • Develop customized KPIs and metrics that quantify business performance, risks, and opportunities
  • Identify and resolve data quality issues, implementing validation frameworks and best practices across the BI team
  • Collaborate with cross-functional stakeholders to align on reporting needs, probe assumptions, and communicate findings clearly at all levels
  • Own and deliver a portfolio of recurring and ad-hoc stakeholder reports with minimal supervision
  • Build or optimize at least two automated reporting workflows using available tools (including AI tools such as Claude or Gemini)
  • Establish strong working relationships with key internal stakeholders across the Advertising Technologies department
  • Document data definitions, reporting procedures, and ETL logic to reduce knowledge concentration risk
  • Participate actively in sprint planning and backlog prioritization for the BI team
  • 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

  • 3+ years of experience in a data analytics role, with a strong track record of delivering advanced reporting for multiple stakeholder teams
  • Advanced SQL skills; ability to define ETL requirements and work with complex, heterogeneous datasets
  • Experience with data visualization tools (e.g., Tableau, Looker, or equivalent) and building client-facing or executive-ready dashboards
  • Strong communication skills with experience presenting data-driven findings to senior management and cross-functional teams
  • Demonstrated ability to identify data quality root causes and implement systematic solutions

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
$100,000—$118,500 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:
 
 
To learn more about our privacy practices, please see our Privacy Policy.
 
#LI-REMOTE

Apply now >

This job listing has been manually reviewed by the Jobicy Trust & Safety Team for compliance with our posting guidelines, including verification of the company's legitimacy, accuracy of job details, clarity of remote work policy, and absence of misleading or fraudulent content.

How to apply

Did you apply? Let us know, and we’ll help you track your application.

See a few more

Similar Data Science & Analytics remote jobs

Job Search Safety Tips

Here are some tips to help you search and apply for jobs safely:
Watch out for suspicious jobs Don't apply for jobs that offer high pay for little work or offer to hire you without an interview. Read more ›
Check the employer's profile Make sure you're applying for a trustworthy job by visiting the employer's profile and learning more about them. Read more ›
Protect your information Don't share personal details like your bank account or government-issued ID on suspicious websites or messengers. Read more ›
Report jobs that feel unsafe If you see a job that seems misleading, inappropriate or discriminatory, report it for going against our policies and we'll review it.

Share this job

Jobicy+ Subscription

Jobicy

617 professionals pay to access exclusive and experimental features on Jobicy

Free

USD $0/month

For people just getting started

  • • Unlimited applies and searches
  • • Access on web and mobile apps
  • • Weekly job alerts and digest
  • • Access to additional tools like Bookmarks, Applications, and more

Plus

USD $8/month

Everything in Free, and:

  • • Ad-free experience
  • • Daily job alerts and digest
  • • Personal career consultant
  • • AI-powered job advice
Go to account ›