Analytics Engineer

Summary

Join 7shifts, a leading team management software platform for the restaurant industry, as an Analytics Engineer. You will design and maintain revenue data pipelines using SQL, dbt, and Snowflake, ensuring accurate analyses for Sales, Partnerships, and Marketing teams. This role involves developing ELT workflows, ensuring data accuracy, and collaborating with various teams. You will contribute to driving revenue growth by transforming raw data into actionable insights. The ideal candidate possesses 2+ years of experience in data modeling using dbt, SQL, and Snowflake, along with strong SQL skills and experience with Salesforce data integration. 7shifts offers a dynamic work environment with opportunities for professional growth and various benefits.

Requirements

• 2+ years of experience developing efficient, scalable data models using dbt, SQL, and Snowflake
• Proficiency in ETL/ELT pipeline development, with the ability to transform raw data into informative datasets
• Strong proficiency in advanced SQL techniques
• Experience working with Salesforce data and integrating it into data pipelines
• Familiarity with GitHub for version control and data transformation
• Strong collaboration and communication skills, with the ability to work effectively across teams
• Experience with data warehousing on cloud platforms (Snowflake preferred)

Responsibilities

• Design, build, and optimize scalable data models using SQL, dbt, and Snowflake to support analytics and reporting
• Develop and manage ELT workflows to transform raw data into structured, high-quality datasets that inform business intelligence and decision-making
• Ensure data accuracy, consistency, and reliability by implementing best practices in data validation and testing
• Collaborate with data analysts, data engineers, and revenue teams to understand data needs, build scalable solutions, and enable self-service analytics
• Maintain clear, up-to-date documentation for data models, pipelines, and processes to support knowledge sharing across teams
• Continuously analyze and refine data pipelines to reduce latency, enhance reliability, and minimize costs

Preferred Qualifications

• Experience with BI & Reporting tools (Thoughtspot preferred)
• Experience with event analytics tools (Mixpanel preferred)
• Experience managing complex data pipelines
• Experience in the SaaS industry

Benefits

• Competitive health benefits right from the start, lifestyle spending accounts, access to corporate discounts, and a parental leave program that supports caregivers during an important time in their lives
• Our team is intentional around how and where we work—whether that’s remotely, in person at our Toronto and Saskatoon offices, or a mix of both. Plus, we offer a flexible vacation policy to encourage everyone to recharge when they need it. Oh, and a ‘90 Day Shift’ program that supports our team members in exploring the world
• We set our team members up for success with the latest Apple technology, a home office set up, and some fun 7shifts swag to make it official! Plus, we take professional growth seriously and support this through coaching, IDPs, peer and leader feedback, internal promotions, and more
• Equity in a Series C, VC-backed SaaS company—enabling every team member to be an owner of their future success!