Analytics Engineer Remote

7shifts is an all-in-one team management software platform designed for the restaurant industry. We're used by 1 in 10 restaurant workers and over 50,000 restaurants across North America. Our mission is to simplify Team Management and improve performance for restaurants, with a long-term vision of elevating what restaurant teams can achieve together.

As the Analytics Engineer at 7shifts, you will design and maintain revenue data pipelines, ensuring accurate analyses for our Sales, Partnerships, and Marketing teams. Your work will also guarantee reliable data to support workflows across various platforms. Reporting to the Manager, Data & Analytics, you will play a key role in driving revenue growth—transforming raw data into actionable insights to optimize sales performance.

We're building an inclusive work environment that is representative of the diverse industry we have the pleasure of serving and encourage candidates from all backgrounds to apply.

What you'll do:

• 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

What you bring:

• 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)

It'd be even cooler if you had:

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

• Opportunity: It's an exciting time to work at 7shifts—our product is evolving and our team is scaling quickly. Scale like this offers many unique learning opportunities in a short period of time, accelerating the professional growth of our team members
• Challenge: We're tackling real problems for restaurant owners and we're just getting started. Working at 7shifts means playing a key role in solving those problems and elevating an entire industry
• Culture: There's a reason we're one of the best workplaces in North America! We value integrity, adaptability and collaboration in an environment that moves quickly to drive incredible impact
• Equity: Equity in a Series C, VC-backed SaaS company—enabling every team member to be an owner of their future success!
• Health and Wellness: 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
• Flexibility: 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
• Support: 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