We're seeking an Analytics Engineer to join our expanding Data & Analytics team during a pivotal transformation period. You'll play a crucial role in our initiative to build a modern data infrastructure while supporting 60+ business users who rely on data-driven insights. This is an exceptional opportunity to shape data architecture from the ground up, work with cutting-edge tools, and directly impact business decisions across marketing, merchandising, operations, and executive leadership. Responsibilities: Data Infrastructure & Modeling - • Build and maintain dbt models transforming raw e-commerce data into business-ready insights • Design incremental data models for high-volume datasets • Optimize Snowflake queries for performance and cost efficiency with large datasets • Implement data quality monitoring using custom dbt tests Project Foundation Migration - • Migrate business logic and transformations to dbt • Convert existing SQL logic to modern, maintainable data models • Validate data accuracy between old and new systems during parallel operation • Implement clustering and partitioning strategies for large e-commerce tables Business Intelligence & User Support - • Support the development and maintenance of Looker dashboards serving marketing, merchandising, and executive teams • Support power users with complex analytical requests and training • Translate business requirements into technical data solutions • Create self-service analytics capabilities to reduce ad-hoc request burden Data Quality & Governance - • Implement comprehensive data testing frameworks using dbt • Monitor data pipeline health and performance across all sources • Ensure data accuracy for critical business metrics • Establish data documentation and best practices for the growing team Requirements: Education - • Bachelor's degree in Business, Economics, Mathematics, Statistics, Data Science, or related analytical field • Equivalent professional experience in business intelligence or analytics roles will be considered in lieu of degree • Relevant certifications (Snowflake, dbt, Google Analytics, Looker, etc.) are a plus Technical Skills - • 3+ years experience with SQL in production environments • 3+ years experience with dbt (data build tool) including incremental models, testing, and documentation • Business intelligence tools: Looker, Omni or similar tools • Cloud data warehouse experience (Snowflake, BigQuery, AWS or Redshift) • Data quality monitoring: dbt, Elementary or similar • Version control proficiency with Git/GitHub workflows E-commerce Analytics Experience - • E-commerce metrics expertise: conversion funnels, customer lifetime value, cohort analysis • Digital marketing analytics: attribution modeling, campaign performance, traffic analysis • GA4 and Google Analytics data modeling experience Business Acumen - • Stakeholder communication: Translate business requirements into technical solutions • Data storytelling: Present insights clearly to non-technical audiences • Problem-solving: Debug data quality issues and performance bottlenecks • Project management: Handle multiple priorities in a fast-paced environment Preferred Qualifications: Advanced Technical Skills - • Python for data analysis and automation • Shopify or NetSuite data integration experience • Data pipeline orchestration (Airflow, dbt Cloud, or similar) • API integration and data connector management • Performance optimization for large datasets Modern Data Stack Experience - • Cloud data platforms: Snowflake, AWS, GCP, or similar Industry Experience - • Retail/E-commerce domain knowledge • Inventory management analytics • Customer analytics and segmentation • Marketing attribution and performance measurement