BI Engineer

StackAdapt

3d•Remote

About The Position

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 hiring a BI Engineer to join our growing Advertising Technologies Team. You will report to the Senior Lead, Business Intelligence and will be responsible for the design and execution of automated & scalable reporting, insights & analytics infrastructure. You will get to interact with other internal teams addressing their data requests and building data pipelines & dashboards to track key business and performance metrics. It is important that you maintain data accuracy with extreme attention to detail. StackAdapt is a remote-first company, we are open to candidates located anywhere in Canada for this position.

Requirements

2+ years of experience in a quantitative or analytics-driven environment with a solid understanding of statistical concepts and analytical techniques.
Strong expertise in SQL and strong experience with Python and/or PySpark for large-scale data processing and ETL design.
Hands-on experience with Airflow and modern cloud data warehouses such as Snowflake, BigQuery, or Redshift, including performance tuning and optimization.
Strong background in data warehouse design (e.g., dimensional modeling) and building production-grade BI and analytics solutions.
Proven experience working in Business Intelligence, Data, or Analytics teams delivering scalable, self-serve reporting and analytics platforms.
Bachelor’s or Master’s degree in a quantitative field (e.g., statistics, mathematics, economics, finance, engineering) with a strong academic foundation.
Extensive experience with data visualization tools such as Tableau, Looker, Qlik, or similar platforms
Excellent verbal and written communication skills, with the ability to present complex technical and analytical concepts to senior and non-technical stakeholders.

Nice To Haves

Experience in programmatic advertising, including RTB, DSPs, SSPs, publishers, or related ad tech platforms, is strongly preferred.

Responsibilities

Support the design and implementation of automated, scalable, and high-performance reporting infrastructure and analytics solutions used across multiple teams.
Develop and maintain data pipelines, ETL workflows, and BI dashboards, setting technical standards and best practices for the BI Engineering team.
Partner closely with Analysts, BI Engineers, Data Scientists, and business stakeholders to translate ambiguous business needs into well-defined, self-serve analytics solutions.
Continuously monitor, validate, and improve data quality, reliability, and performance across BI systems; proactively identify and resolve root causes of data issues.
Perform deep-dive and exploratory analyses to uncover trends, anomalies, and opportunities, delivering clear, actionable, and prescriptive recommendations to senior stakeholders.
Optimize queries, data models, and compute resource usage to improve scalability, cost efficiency, and performance.
Act as a technical owner for critical BI assets, including core data models, pipelines, and dashboards.
Participate in code reviews and design reviews, and adopt BI engineering best practices to ensure high-quality delivery.
Contribute to large BI initiatives end-to-end, breaking down work into parallelizable components, estimating effort, and ensuring high-quality delivery.
Support maintenance of BI infrastructure and provide guidance on complex ad-hoc requests as needed.

Benefits

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!