Analytics Engineer, Lifecycle Efficiency

📋 Description

• Design, build, and maintain production data models powering incentives, promotions, and lifecycle analytics.
• Partner with Data Eng to model source data from multiple systems and implement auditable ELT.
• Define KPI definitions for marketing efficiency and ROI; enable self-serve analytics with semantic models and LookML.
• Set and enforce data quality standards with automated tests, lineage, docs, and monitoring.
• Collaborate with Product/Marketing/Engineering to scope requirements and deliver datasets for experimentation.
• Improve pipeline performance, reliability, and cost; promote code review and CI/CD for analytics.

🎯 Requirements

• 4+ years in analytics/data engineering or BI building production data models in the cloud.
• Advanced SQL proficiency with performance tuning in Snowflake, BigQuery, or Redshift.
• 2+ years implementing dbt projects (models, tests, macros) in production with Git-based workflows.
• Hands-on experience orchestrating ELT/ETL with Airflow, Dagster, or similar.
• Experience building semantic layers and BI models (Looker/LookML) for self-serve analytics.
• Demonstrated automated data quality testing and data observability; ownership of docs and lineage.
• Bachelor’s degree or equivalent practical experience.
• Proven success partnering cross-functionally to translate ambiguous requirements into scalable datasets.

🎁 Benefits

• Flex First, remote-friendly policy; work from home, office, or other locations.
• New hire equity grant and annual refresh grants.
• Access benefits via Taste of Instacart program.
• Learn more about the Flex First policy at instacart.careers.