Analytics Engineer, Lifecycle Efficiency

Posted 5 days ago

Apply Now

About the role

  • Analytics Engineer at Instacart building data models to optimize marketing efficiency and lifecycle communications. Collaborating with Data Engineering, Product, Marketing, and Engineering teams for robust analytics.

Responsibilities

  • 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.

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.
  • Flexible work arrangements

Job type

Full Time

Experience level

Mid levelSenior

Salary

CA$139,000 - CA$146,500 per year

Degree requirement

Bachelor's Degree

Tech skills

AirflowAmazon RedshiftBigQueryCloudETLSQL

Location requirements

RemoteCanada

Report this job

Found something wrong with the page? Please let us know by submitting a report below.