As an Analytics Engineer, you will design and maintain data pipelines for product analysis, ensuring accurate insights for various teams. You'll collaborate with stakeholders to optimize data workflows and implement best practices for data integrity.
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.
Top Skills
Bi & Reporting Tools
Cloud-Based Data Warehouses
Dbt
Git
Mixpanel
Python
Salesforce
Snowflake
SQL
Thoughtspot
Similar Jobs
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
Cloud • Consumer Web • Enterprise Web • Information Technology • Software
As a Staff Analytics Engineer at Render, you will architect and maintain data models, pipelines, and analytics tools, collaborating across departments to establish reliable data foundations and ensure data quality for decision-making.
Top Skills:
BigQueryDbtMetabasePythonSnowflakeSparkSQL
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 Charlotte Tech Scene
Ranked among the hottest tech cities in 2024 by CompTIA, Charlotte is quickly cementing its place as a major U.S. tech hub. Home to more than 90,000 tech workers, the city’s ecosystem is primed for continued growth, fueled by billions in annual funding from heavyweights like Microsoft and RevTech Labs, which has created thousands of fintech jobs and made the city a go-to for tech pros looking for their next big opportunity.
Key Facts About Charlotte Tech
- Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
- Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
- Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
- Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus
