(Associate - Senior) Analytics Engineer, Caper

<div class="content-intro"><p><strong>We're transforming the grocery industry</strong></p> <p><span class="im">At Instacart, we invite the world to share love through food because we believe everyone should have access to the food they love and more time to enjoy it together. Where others see a simple need for grocery delivery, we see exciting complexity and endless opportunity to serve the varied needs of our community. We work to deliver an essential service that customers rely on to get their groceries and household goods, while also offering safe and flexible earnings opportunities to Instacart Personal Shoppers.</span></p> <p>Instacart has become a lifeline for millions of people, and we’re building the team to help push our shopping cart forward. If you’re ready to do the best work of your life, come join our table.</p> <p><strong>Instacart is a Flex First team </strong></p> <p>There’s no one-size fits all approach to how we do our best work. Our employees have the flexibility to choose where they do their best work—whether it’s from home, an office, or your favorite coffee shop—while staying connected and building community through regular in-person events. <a href="https://instacart.careers/remote/" target="_blank" data-saferedirecturl="https://www.google.com/url?q=https://instacart.careers/remote/source=gmailust=1651869232122000usg=AOvVaw37OlxP8hAKN7nq4YwHQH7e">Learn more about our flexible approach to where we work.</a></p></div><h2><strong>Overview</strong></h2> <p>In this role, you will leverage data-driven insights to enhance decision-making processes, identify new opportunities, and provide strategic guidance across Instacart’s Caper team. This role will have a focus on our Smart Cart and AI-powered retail systems, but will engage with all aspects of Caper's connected solutions.</p> <p>By collaborating closely with our product management, engineering, and data science teams, you will enhance our understanding of complex problems and identify opportunities for innovation. Your work will directly impact the optimization of Caper's solutions, contributing to Instacart’s mission of revolutionizing the grocery shopping experience through cutting-edge technology.</p> <h2><strong>About the Job</strong></h2> <p> </p> <ul> <li>Design, build, and maintain robust, production-grade data models (e.g., in dbt) that power incentives, promotions, and lifecycle analytics, including standardized fact/dimension tables and a consistent metrics layer.</li> <li>Partner with Data Engineering to model source data from multiple systems (e.g., marketing platforms, event streams, transactional data) and implement efficient, auditable ELT patterns in a modern cloud warehouse.</li> <li>Define and operationalize KPI and metric definitions for marketing efficiency and ROI; enable self-serve analytics in BI tools by implementing clean, documented semantic models and LookML (or equivalent).</li> <li>Set and enforce data quality standards with automated testing, lineage, documentation, and monitoring to ensure stakeholders can trust dashboards and analyses used to manage millions in annual spend.</li> <li>Collaborate with Product, Marketing, and Engineering to scope requirements, prioritize a roadmap, and deliver high-impact datasets for experimentation, attribution, cohorting, and lifecycle performance reporting.</li> <li>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.</li> </ul> <p> </p> <h2><strong>About You</strong></h2> <p> </p> <h3>Minimum Qualifications</h3> <p> </p> <ul> <li>4+ years of experience in analytics engineering, data engineering, or BI development building production data models in a modern cloud data stack.</li> <li>Advanced SQL proficiency (e.g., complex joins, window functions, query optimization) with a track record of performance tuning in Snowflake, BigQuery, or Redshift.</li> <li>2+ year ... (truncated, view full listing at source)