Analytics Engineer, 7shifts

• 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)

Desirable

• As the Analytics Engineer at 7shifts, you will design and maintain revenue 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 revenue growth—transforming raw data into actionable insights to optimize sales performance
• 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 revenue 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