Analytics Engineer, Lifecycle Efficiency at Instacart

Instacart

Canada - Remote (ON, AB, BC, or NS Only)·1w ago

Mid LevelFull-timePythonRustRailsData ScienceCI/CDGitData

Salary Range

$66,300 - $89,700 /year

Estimated

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

About the Role

Instacart’s Lifecycle Efficiency team is seeking an Analytics Engineer to build and own the data models, pipelines, and semantic layers that enable clear measurement of a marketing portfolio with millions in annual spend. This role will shape the data foundation for incentives, promotions, and lifecycle communications across Instacart’s marketplace.

Key Responsibilities

→Design, build, and maintain robust, production-grade 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 in a cloud warehouse
→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 or BI development
✓Advanced SQL proficiency with performance tuning experience
✓2+ years implementing and maintaining dbt projects
✓Hands-on experience with ELT pipelines and orchestration tools
✓Experience building semantic layers and BI models
✓Demonstrated use of automated data quality testing
✓Bachelor’s degree in Computer Science, Engineering, or related field
✓Proven success partnering cross-functionally with Product, Marketing, and Engineering