[Remote] Analytics Engineer at 7shifts

Saskatoon, Saskatchewan, Canada

Apply Now

Not SpecifiedCompensation

Mid-level (3 to 4 years)Experience Level

Full TimeJob Type

UnknownVisa

Hospitality, RestaurantsIndustries

Requirements

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)

Responsibilities

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

Skills

Key technologies and capabilities for this role

SQLdbtSnowflakeELTdata modelingdata pipelinesdata validation

Questions & Answers

Common questions about this position

What technical skills are required for the Analytics Engineer role?

The role requires experience developing scalable data models using dbt, SQL, and Snowflake, proficiency in ETL/ELT pipeline development, strong advanced Python and SQL techniques, experience with Salesforce data integration, and familiarity with GitHub for version control.

What is the salary or compensation for this position?

This information is not specified in the job description.

Is this Analytics Engineer position remote or does it require office work?

This information is not specified in the job description.

What is the company culture like at 7shifts?

7shifts is building an inclusive work environment representative of the diverse restaurant industry they serve and encourages candidates from all backgrounds to apply.

What makes a strong candidate for the Analytics Engineer role?

A strong candidate has required experience with dbt, SQL, Snowflake, ETL/ELT, Python, Salesforce integration, and GitHub, plus nice-to-haves like dbt Cloud, Thoughtspot, Mixpanel, complex pipelines, and SaaS industry experience.

7shifts

Workforce management platform for restaurants

About 7shifts

7shifts is a workforce management platform designed for the restaurant industry, offering tools for scheduling, payroll, hiring, and compliance. It simplifies the hiring process and includes features for labor law compliance and staff engagement monitoring. The platform's AI-driven auto-scheduling and actionable insights help restaurant owners make informed decisions and improve operational efficiency. 7shifts aims to enhance team retention and guest experiences by addressing the specific needs of restaurant management.

Regina, CanadaHeadquarters

2014Year Founded

$127.4MTotal Funding

SERIES_CCompany Stage

Consulting, Enterprise SoftwareIndustries

201-500Employees

Benefits

Health Insurance

Company Equity

Flexible Work Hours

Remote Work Options

Parental Leave

Home Office Stipend

Professional Development Budget

Risks

Recent layoffs may impact 7shifts' operational capabilities and service quality.

Increased competition from Square's integrations could affect 7shifts' market share.

Dependency on Lightspeed's ecosystem may limit strategic flexibility for 7shifts.

Differentiation

7shifts offers a comprehensive platform tailored specifically for the restaurant industry.

The platform integrates scheduling, payroll, and compliance tools in one seamless solution.

AI-driven auto-scheduling enhances operational efficiency and decision-making for restaurant managers.

Upsides

7shifts ranked 382 on the 2024 Deloitte Technology Fast 500, showing strong growth.

Partnership with Lightspeed enhances 7shifts' integration capabilities and market reach.

Instant tip payouts feature meets high demand, boosting employee satisfaction and retention.

Land your dream remote job 3x faster with AI

Try Jobo Free