Ecommerce Analytics Engineer

Role Overview

Collaborate with Ecommerce BI Analysts to understand business needs and translate them into efficient data structures. Enable analysts to focus on delivering insights by ensuring timely access to curated, high-quality datasets. Partner with Data Engineers to ensure data availability in staging environments.

What You Will Do

Own the transformation layer between staging and analytics-ready datasets, applying business logic to create trusted sources for analysis. Develop and manage layered transformation workflows that promote modularity, traceability, and alignment with governance and AI-readiness standards.

Why It Might Be a Fit

Strong communication skills and ability to work cross-functionally. Ability to lead data modeling efforts and mentor junior engineers. Strong understanding of data governance and documentation best practices.

Requirements

• Moderate SQL proficiency and understanding of data modeling principles
• Experience with Alteryx or similar ETL platforms
• Advanced SQL skills and experience with performance tuning
• Strong understanding of ecommerce metrics and digital product data needs
• Ability to optimize data models for performance and usability
• Strong skills in mathematics
• Solid organizational skills, ability to handle multiple projects and meet deadlines
• Good presentation, oral, and written communication skills
• Bachelor’s degree in a related field or equivalent related work experience
• 2+ to 7+ years of combined experience with dbt or similar transformation tools based on level
• 2+ to 7+ years of experience with cloud data platforms and scalable data modeling based on level
• 6+ years digital analytics data (Google Analytics Preferred) experience required