(Associate - Senior) Analytics Engineer, Caper at Instacart

Instacart

Canada - Remote (ON, AB, BC, or NS Only)·7h ago

SeniorFull-timePythonRustRailsData ScienceCI/CDGitAIData

Salary Range

$86,190 - $116,610 /year

Estimated

This salary is estimated based on similar roles. The actual salary may vary.

About the Role

We are looking for a Data Engineer to join Instacart's Caper team, focusing on Smart Cart and AI-powered retail systems. This role will leverage data-driven insights to enhance decision-making processes and provide strategic guidance across the organization.

Key Responsibilities

→Design, build, and maintain robust data models in dbt that power incentives, promotions, and lifecycle analytics
→Partner with Data Engineering to model source data from multiple systems and implement efficient ELT patterns
→Define and operationalize KPI and metric definitions for marketing efficiency and ROI
→Set and enforce data quality standards with automated testing and monitoring
→Collaborate with Product, Marketing, and Engineering to deliver high-impact datasets
→Continuously improve performance and reliability of pipelines and queries

Requirements

✓4+ years of experience in analytics engineering, data engineering, or BI development
✓Advanced SQL proficiency with experience in Snowflake, BigQuery, or Redshift
✓2+ years implementing and maintaining dbt projects in production
✓Hands-on experience with ELT/ETL pipelines using Airflow or similar tools
✓Experience building semantic layers and BI models
✓Demonstrated use of automated data quality testing and data observability
✓Bachelor’s degree in Computer Science, Engineering, Mathematics, Statistics, or related field
✓Proven success partnering cross-functionally with Product, Marketing, and Engineering