Data Analyst

Summary

Join 7shifts as a Data Analyst and partner with the Payroll and Tips teams to measure performance, uncover insights, and drive business impact. You will conduct in-depth analyses using SQL and BI tools, build and maintain dashboards and reports, develop data models using dbt and SQL, and collaborate with cross-functional teams. Your responsibilities include providing ad hoc analyses, building self-serve data tools, validating data, and presenting findings to both technical and non-technical audiences. The ideal candidate possesses strong SQL proficiency, experience with BI tools, dbt, and a background in business, analytics, or a technical field. 7shifts offers a supportive and collaborative work environment with opportunities for growth and development. The company provides various benefits, including health and dental insurance, lifestyle spending accounts, a flexible parental leave program, flexible vacation policy, and support for professional growth.

Requirements

• Strong proficiency in SQL with the ability to write complex queries and work with large datasets
• Hands-on experience with BI tools such as Tableau, Looker, or Power BI
• Experience building and maintaining data models using dbt
• Background in business, analytics, or a technical field
• Proven ability to collaborate effectively with cross-functional teams
• Strong communication skills, with the ability to explain technical concepts to non-technical audiences
• Experience working in a SaaS or tech environment

Responsibilities

• Conduct in-depth analyses using SQL and BI tools to identify trends, measure performance, and uncover actionable insights
• Build, maintain, and enhance dashboards and recurring reports that provide accurate, timely, and business-relevant information
• Develop and maintain data models using dbt and SQL to transform raw data into clean, reliable, and scalable datasets for analysis and reporting
• Partner with teams across the organization to understand data needs, define analytical approaches, and deliver data-driven recommendations
• Provide timely ad hoc analyses and contribute to building self-serve data tools and resources that empower teams to independently explore and use data
• Validate, reconcile, and troubleshoot data to ensure accuracy and reliability in reporting and decision-making
• Effectively present findings and recommendations to both technical and non-technical audiences in a clear and actionable way

Preferred Qualifications

• Experience working with Snowflake as a data warehouse
• Familiarity with event analytics tools like Mixpanel or Amplitude
• Experience working with Salesforce or other CRM tools

Benefits

• Health and dental
• Lifestyle spending accounts
• Parental leave program
• Flexible vacation policy
• Professional growth