Analytics Engineer

7shifts is a scheduling and payroll platform designed to help restaurant teams thrive. With an easy-to-use app and industry-specific solutions, 7shifts saves time, reduces errors, and helps keep costs in check for over 55,000 restaurants. Our mission is to simplify team management and improve performance for restaurants, with a long-term vision of creating a thriving restaurant industry through the power of connected & engaged teams. 

As the Analytics Engineer at 7shifts, you will design and maintain product 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 product growth by transforming raw data into actionable insights that optimize product 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 cloud-based data warehouses to support analytics and reporting
•  Implement, manage, and optimize ELT workflows to transform raw data into structured, high-quality datasets for 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 product 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 
• Regularly analyze and refine data pipelines to reduce latency, enhance reliability, and minimize costs

What you bring:

• Experience developing efficient, scalable data models using dbt, SQL, and Snowflake in a SaaS environment
• Proficiency in ETL/ELT pipeline development, with the ability to transform raw data into informative datasets
• Strong proficiency in advanced Python and 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 both dbt Core and dbt Cloud
• Experience with BI & Reporting tools (Thoughtspot preferred)
• Experience with event analytics tools (Mixpanel preferred)
• Experience managing complex data pipelines
• Experience in the SaaS industry

Our commitment to our Shifties:

• Opportunity: Our product is evolving in exciting ways, and we're focused on delivering even more value to restaurants. This momentum creates real opportunities to learn and grow. Whether you're honing your craft or exploring new paths, you'll be supported and empowered to own your growth and impact a product shaping the future of the restaurant industry.
• Challenge: We're tackling real problems in a fast-moving, complex industry. The work is scrappy and ambiguous, but meaningful. You'll think critically, act with intention, and shape solutions that make a real difference for restaurant teams.
• Culture: We're proud to be recognized among the best workplaces in North America. Guided by our mission and values, we move fast to solve meaningful problems and celebrate wins together. Whether through in-office and remote events, team offsites like Sparks, or everyday moments of connection, we create space for shared growth, collaboration, and fun.
• Equity: We're a Series C, VC-backed SaaS company, and we believe everyone should share in the success they help create. When we build together, we grow together.
• Health and Wellness: We support Shifties in and outside of work, knowing that what people need can change over time. From day one, you'll have access to benefits like health and dental, lifestyle spending accounts to a parental leave program built with flexibility in mind, to help you bring your best self to work.
• Flexibility: Our team is intentional around how and where we work, whether remotely, in person, or a mix of both. We prioritize candidates who thrive in a hybrid work environment with offices in Saskatoon and Toronto, ensuring in-person collaboration and connection when possible. Plus, we offer a flexible vacation policy to encourage everyone to recharge when needed. Oh, and our '90 Day Shift' program lets Shift work from (almost) anywhere because who wouldn't want to trade their desk for a beach view once in a while?
• Support: We set Shifties up for success with the tools they need, like the latest Apple tech, a home office setup, and some 7shifts swag to make it official. But support goes beyond day one. We're serious about professional growth, offering coaching, feedback, development planning, and opportunities to grow from within. 

We know you might not check every box, and that's okay. If you're excited about this role, inspired to contribute to a meaningful product, and eager to share ideas that drive real change, we'd love to hear from you. We're building an inclusive team that reflects the diverse industry we serve, and we welcome applicants from all backgrounds.

We thank you for your interest in joining the 7shifts team  

Our privacy policy can be found here.