Design, build, and maintain robust, production-grade data models that power incentives, promotions, and lifecycle analytics.
Partner with Data Engineering to model source data from multiple systems and implement efficient, auditable ELT patterns in a modern cloud warehouse.
Define and operationalize KPI and metric definitions for marketing efficiency and ROI; enable self-serve analytics in BI tools.
Set and enforce data quality standards with automated testing, lineage, documentation, and monitoring.
Collaborate with Product, Marketing, and Engineering to scope requirements, prioritize a roadmap, and deliver high-impact datasets.
Continuously improve performance, reliability, and cost efficiency of pipelines and queries; drive best practices in version control, code review, and CI/CD for analytics engineering.
Requirements
4+ years of experience in analytics engineering, data engineering, or BI development building production data models in a modern cloud data stack.
Advanced SQL proficiency with a track record of performance tuning in Snowflake, BigQuery, or Redshift.
2+ years implementing and maintaining dbt projects in production with Git-based workflows.
Hands-on experience orchestrating ELT/ETL pipelines with Airflow, Dagster, or similar.
Experience building semantic layers and BI models to enable reliable self-serve analytics.
Demonstrated use of automated data quality testing and data observability and ownership of documentation and lineage.
Bachelor’s degree in Computer Science, Engineering, Mathematics, Statistics, or a related field, or equivalent practical experience.
Proven success partnering cross-functionally with Product, Marketing, and Engineering.
Tech Stack
Airflow
Amazon Redshift
BigQuery
Cloud
ETL
SQL
Benefits
Instacart provides highly market-competitive compensation and benefits in each location where our employees work.
This role is eligible for a new hire equity grant as well as annual refresh grants.