Analyst, Data Architecture

StackAdapt; Canada; Remote; CAD 80,000 - 100,000; Full time

Job summary

A leading technology company is seeking an Analyst to join the Data Architecture team. This remote position requires managing data requests, optimizing data pipelines, and collaborating with stakeholders. Ideal candidates will have 2-3+ years of experience in data roles, advanced SQL and Python skills, and a focus on data quality and governance. Join a diverse team committed to making a significant impact.

Benefits

Highly competitive salary

401K/Pension savings

Paid time off packages

Mental health care platform access

Health benefits from day one

Work from home reimbursements

Optional WeWork membership

Robust training program

Personal development support

Access to training courses

Parental leave program

Friendly support culture

Qualifications

• 2-3+ years of experience in relevant data roles.
• Previous experience in building data pipelines.
• Advanced SQL skills with large-scale data warehousing.

Responsibilities

• Manage data requests from internal teams.
• Build and optimize data pipelines using SQL and Python.
• Collaborate with teams to understand data requirements.
• Ensure data quality and governance.
• Contribute to AI initiatives and support reporting efforts.

Skills

Business Intelligence Engineering

Data Engineering

Data Analysis

SQL

Python

Workflow orchestration

Data modeling

Problem-solving

Tools

SQL

Python

Airflow

Tableau

Snowflake

Job description

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.

We’re looking for an Analyst to join our Data Architecture team. This role sits within our Analytics and Reporting Insights team under the greater Revenue organization. In this role, you will manage data requests, improve data pipelines, and deliver solutions that enhance both internal efficiency and client outcomes. This role blends technical hands‑on work with business collaboration.

You’ll partner with analytics, product, engineering and business stakeholders to design pipelines, optimize data models, and set up the foundation for scalable insights.

StackAdapt is a Remote First company, we are open to candidates located anywhere in Canada for this position.

What You’ll Be Doing:

• Manage standard data and reporting requests from internal teams with accuracy and speed.
• Build and optimize data pipelines and transformations using SQL, Python and orchestration tools like Kestra.
• Collaborate with analytics and business teams to understand data requirements and translate them into scalable solutions.
• Ensure data quality, governance, and consistency across reporting and analytics environments.
• Contribute to the team’s AI initiatives by preparing structured datasets for modeling and experimentation.
• Support visualization and reporting efforts in Tableau/ThoughtSpot, enabling self‑serve access to business teams.
• Proactively identify opportunities to improve data efficiency, reliability, and usability.
• Establish and document data architecture standards and best practices for reusability and consistency.
• Support peer learning through documentation, code reviews, and sharing of best practices within the data team.

What You’ll Bring to the Table

• 2‑3+ years experience in Business Intelligence Engineering, Data Engineering, Data Analysis or Data Science roles in a fast moving, high impact software or technology environment.
• Previous experience building data pipelines and analyzing large datasets to solve problems.
• Advanced SQL skills including complex joins and window functions with experience in large‑scale data warehousing (Snowflake, Redshift, or BigQuery).
• Proficiency in Python for data processing and automation.
• Hands‑on experience with workflow orchestration (Airflow or equivalent).
• Understanding of data modeling best practices and query optimization.
• Strong problem‑solving skills with attention to detail and data accuracy.
• Comfortable collaborating across functions to identify data analytics problems and execute solutions with technical rigor and data‑driven insights.
• Familiarity with modern ML and AI data workflows, from feature engineering to preparing structured and unstructured data for downstream models, including emerging use cases involving LLMs or vector databases.
• Exposure to BI tools like Tableau (or similar) is a strong asset.
• Strong understanding of data in digital marketing and programmatic environments, including campaign, audience, and attribution data models is a strong asset.

Benefits

• Highly competitive salary.
• Retirement/401K/Pension savings globally.
• Competitive paid time off packages, including birthdays off.
• Access to a comprehensive mental health care platform.
• 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!

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.