stackadapt

BI Engineer

Apply Now

At a Glance

Location
Canada
Work Regime
remote
Experience
2+ years
Posted
2026-02-19T10:04:53-05:00

Key Requirements

Required Skills

ETLPythonSQLSnowflakeSparkTableau

Domain Knowledge

  • Advertising
  • Engineering
  • Finance

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.

Compensation & Benefits

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 Residents Only

$100,000

$118,750 CAD

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.

About the Company

We've been recognized for our diverse and supportive workplace, high performing campaigns, award-winning customer service, and innovation. We've been awarded:

Ad Age Best Places to Work 2024

G2 Top Software and Top Marketing and Advertising Product for 2024

Campaign’s Best Places to Work 2023 for the UK

2024 Best Workplaces for Women

and