As an Analytics Engineer, you will develop scalable data models, manage ELT workflows, ensure data accuracy, and collaborate with teams to support analytics for product growth.
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 Product 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 user growth, transforming raw data into actionable insights to optimize performance.
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 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
- 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
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.
Top Skills
Dbt
Git
Mixpanel
Python
Salesforce
Snowflake
SQL
Thoughtspot
Similar Jobs
_0.png)
AdTech • Marketing Tech
As a Senior Engineer on the Data Platform team, you will design and build data pipelines and optimize storage systems to enhance analytics and machine learning capabilities.
Top Skills:
AirflowKafkaPinotPrestoSnowflakeSparkTidbTrino
Artificial Intelligence • Cloud • Consumer Web • Productivity • Software • App development • Data Privacy
The Data Analytics Developer will design and maintain data pipelines, ensure data quality, and collaborate with cross-functional teams to drive decision-making processes through analytics.
Top Skills:
AirflowDatabricksGitPythonSalesforceSnowflakeSQLSupersetTableau
Artificial Intelligence • Information Technology • Machine Learning • Software • Virtual Reality • Analytics
Seeking an experienced SAP Analytics Solution Architect to design and implement SAP-based data and analytics solutions, primarily using SAP Analytics Cloud and S/4HANA. The role involves creating data models and dashboards, gathering requirements, and collaborating with cross-functional teams.
Top Skills:
Bw/4HanaSap Analytics CloudSap Cds ViewsSap S/4Hana
What you need to know about the Ottawa Tech Scene
The capital city of Canada and the nation's fourth-largest urban area, Ottawa has proven a rapidly growing global tech hub. With over 1,800 tech companies, many of which are leaders in their sectors, the city's tech talent now makes up more than 13 percent of its total workforce. This growth is driven not only by the big players like UL Solutions and Dropbox, but also by a thriving startup ecosystem, as new businesses emerge to follow in the footsteps of those that came before them.
