Senior Data Engineer - Data Squad

Stay22; Montreal; On-site; CAD 80,000 - 100,000; Full time

Job summary

A forward-thinking technology company in Montreal is seeking a Senior Data Engineer to develop end-to-end data pipelines and empower teams through actionable insights. The ideal candidate will have 5+ years of experience in data engineering, proficiency in SQL and Python, and a solid understanding of data warehousing concepts. This role offers a vibrant work environment and opportunities for professional growth, with a focus on collaboration and innovation.

Benefits

Health & dental benefits

Retirement plans

Learning & development opportunities

Qualifications

• 5+ years of experience in data engineering or a closely related role.
• Hands-on experience building and maintaining ETL/ELT pipelines.
• Solid understanding of data warehousing concepts and best practices.

Responsibilities

• Design and implement efficient ETL/ELT pipelines.
• Build key datasets and analytics layers for decision-making.
• Analyze data flows to design optimized data models.
• Optimize and tune data pipelines for scalability.
• Integrate with third-party systems and APIs.

Skills

Proficiency in SQL

Proficiency in Python

Excellent communication

Collaboration skills

Education

B.S. or M.S. in Computer Science

Tools

Snowflake

Databricks

BigQuery

Airflow

dbt

GCP

Job description

About Stay22

Stay22 is revolutionizing how people convert online. Our AI-powered affiliate platform helps publishers, ticketing platforms, and content creators unlock new revenue streams while levelling up their audience's user experience. Our partners don’t just earn more, they deliver more. Join us and be part of something big that's shaking up the affiliate world.

Position overview

The Data team at Stay22 is on a mission to transform raw data into actionable insights that drive our business forward. As a Senior Data Engineer, you will be at the heart of this mission, developing and owning end-to-end data pipelines and products that empower teams across the company. You will take on squad-level data projects – from designing robust data ingestion processes to building data models and analytics layers – ensuring that stakeholders have access to reliable, timely data for decision-making. You will collaborate closely with data analysts, product managers, and software engineers to integrate data solutions into our products and workflows. In this role, you’ll also contribute to data governance initiatives and share best practices, while mentoring junior data engineers and fostering a culture of continuous improvement within the team.

Key responsibilities

• Design and implement efficient ETL/ELT pipelines to ingest, transform, and load data from various sources, ensuring high reliability and scalability

• Build and evolve key datasets and analytics layers across Stay22’s product areas, making data easily accessible and usable for analysis and decision-making

• Analyze data flows and dependencies to design data models optimized for efficient storage and retrieval

• Optimize and tune data pipelines for performance, scalability, and reliability as data volumes grow

• Integrate with third-party systems and APIs to source or distribute data, expanding our overall data capabilities

• Collaborate with product managers, software engineers, and analysts to understand data requirements and deliver effective data solutions that support product features and business decisions

• Implement data governance best practices to ensure data quality, integrity, and security across all data assets

• Maintain clear documentation for data pipelines, datasets, and data lineage to promote transparency and knowledge sharing

• Stay up-to-date with industry trends in data engineering, and proactively recommend improvements to our data infrastructure and workflows

• Mentor and guide junior data engineers, sharing knowledge and best practices to strengthen the team’s capabilities

Requirements

• B.S. or M.S. in Computer Science, Engineering, or a related field (or equivalent experience)

• 5+ years of experience in data engineering or a closely related role

• Proficiency in SQL and Python, with proven experience working with modern data warehouses (e.g. Snowflake, Databricks, BigQuery, etc)

• Hands-on experience building and maintaining ETL/ELT pipelines, including using workflow orchestration tools (such as Airflow or dbt)

• Experience with cloud platforms (GCP, etc.) and their data processing and storage services

• Solid understanding of data warehousing concepts, data modeling techniques, and data architecture best practices (including data quality and governance)

• Proven ability to design solutions for complex data problems and drive data projects from conception to production

• Excellent communication and collaboration skills, with the ability to work effectively across teams and explain data concepts to non-technical stakeholders

What to Expect from our Hiring Process

We know your time’s valuable, so here’s the quick rundown of what to expect.

• Screening call with our Talent Acquisition Partner (30-45 minutes)

• Whiteboarding session (Miro) with the Engineering Team (90 minutes)

• Final interview with our CEO (30 minutes)

• Offer & onboarding

Please note that this process is subject to change at any point, based on additional requirements from the team.

Why join Stay22?

• Support Travel Creators: Be part of a team that empowers travel creators to explore the world by increasing their passive income potential.

• Empower Your Growth: We hire champions and give them the opportunity to excel, skipping levels and honing their superpowers.

• Lead with Impact: We empower our team members to take charge and make a real impact in the Stay22 universe.

• Location, Location, Location: Enjoy our bright and vibrant office in the heart of Little Italy, surrounded by great shops and restaurants

• Be Yourself: Embrace a come-as-you-are dress code and a flexible work schedule.

• Comprehensive Benefits: We offer health & dental benefits, retirement plans, learning & development opportunities, and social & team-building activities, including exciting retreats.

Stay22 is an equal-opportunity employer. All qualified applicants are given consideration. If you have a disability or particular need that requires accommodation, please contact us at careers at stay22.com