Analytics Engineer leveraging data-driven insights to enhance decision-making processes at Instacart. Focusing on Smart Cart and AI-powered retail systems with a collaborative team approach.
Responsibilities
Leverage data-driven insights to enhance decision-making processes, identify new opportunities, and provide strategic guidance across Instacart’s Caper team.
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.
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.
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).
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.
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.
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 (e.g., complex joins, window functions, query optimization) with a track record of performance tuning in Snowflake, BigQuery, or Redshift.
2+ years implementing and maintaining dbt projects (models, tests, macros, documentation) in production with Git-based workflows.
Hands-on experience orchestrating ELT/ETL pipelines with Airflow, Dagster, or similar, including scheduling, dependency management, and alerting.
Experience building semantic layers and BI models (e.g., Looker/LookML, Semantic Layer, or equivalent) to enable reliable self-serve analytics.
Demonstrated use of automated data quality testing and data observability (e.g., dbt tests, Great Expectations, or similar) 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 to translate ambiguous requirements into scalable datasets and clear deliverables.
Prototyping analytical tools developed by the engineering and analytics teams for Clir Renewables. Collaborating on automation scripts and methods for renewable energy analysts.
AI & Analytics Engineer I at Finning tasked with developing data models and AI agents. Collaborating with senior engineers and supporting Analytics Engineering initiatives.
Analytics Engineer at Trulioo focusing on building Python applications for analytics. Collaborating with data teams to automate reporting and enhance data accessibility.
Staff Analytics Engineer developing AI growth solutions for real estate professionals at Luxury Presence. Collaborating on high - impact analytics initiatives and shaping innovative products in a fast - paced environment.
Senior Analytics Engineer at Caribou optimizing data models and building dashboards for home care operations. Collaborating across teams to enhance data quality and facilitate decision - making.
BI & Analytics Developer transforming raw data into business insights for decision - making at PCL Constructors. Focused on reporting, analytics, and ETL development.
Data and Analytics Engineering Manager focusing on designing AI - driven data solutions for clients. Collaborating with teams to enhance data engineering processes and tools.
Analytics Engineer transforming data into trusted insights for mobile app growth. Collaborating with various teams to ensure accurate KPIs and building data infrastructure.