КанадаInstacart
Analytics Engineer II
1 мес. назад
139k–146.5k USDКанадаMiddleRemote
sqldbtsnowflakeairflowpythonetl
Instacart is hiring an Analytics Engineer II to independently design and deliver high-quality marketing analytics data models and pipelines, working remotely in Canada (Ontario, Alberta, British Columbia, Nova Scotia).
About the company
- Instacart is a popular online grocery delivery and store pickup service.
- Instacart works to deliver an essential service that customers rely on to get their groceries and household goods, while offering safe and flexible earnings opportunities to Instacart Personal Shoppers.
- Instacart is a Flex First team where employees choose where to work: from home, office, or coffee shop, connected by regular in-person events.
About the product
- The Marketing Enablement & Technology (MET) team owns the data foundations powering Paid Marketing, SEO, and Retailer Marketing attribution.
- These datasets inform allocation of hundreds of millions of dollars in marketing spend and measure growth.
Responsibilities
- Independently build and maintain high-quality dimensional data models and ETL pipelines supporting marketing analytics across Paid Marketing, SEO, Retailer Marketing, and attribution.
- Work closely with Data Scientists, Analysts, and Marketing stakeholders to translate analytical needs into data requirements and deliver trusted decision-ready datasets.
- Own data quality for models built by writing tests, documentation, monitoring, and resolving root cause data issues across marketing workflows.
- Conduct thorough code reviews, write and share designs before building, and apply reusable modeling patterns.
- Improve existing marketing data pipelines to reduce manual effort, enhance observability (logging, metrics, freshness and quality checks), and participate in incident response for the data platform.
Requirements
- 3–5 years of experience in Analytics Engineering, Data Engineering, or related roles with hands-on ownership of production data models and pipelines.
- Strong SQL skills and experience building dimensional data models (star schemas, fact/dimension tables, SCDs).
- Hands-on experience with modern data stack including dbt, Snowflake, and Airflow.
- Working knowledge or ability to quickly learn marketing data and metrics including paid media performance, attribution concepts, and channel-level measurement.
- Ability to deliver complete data models and pipelines independently, manage priorities, and write clean, well-documented, tested code.
- Effective communicator able to collaborate across data, marketing, and engineering teams.
Nice to have
- Experience partnering with Data Scientists on experimentation, attribution, or incrementality measurement.
- Familiarity with marketing platforms like Google Ads, Meta, Google Analytics, and SEO tooling.
- Python experience for automation or advanced transformations.
- Comfort using AI-assisted developer tools to improve code quality and speed.
- Experience contributing to analytics engineering best practices including testing, documentation, or data quality standards.
Conditions
- Role is remote, limited to candidates located in Ontario, Alberta, British Columbia, or Nova Scotia, Canada.
- Compensation is highly market-competitive and dependent on permanent work location.
- Base pay range for this role in Canada is $139,000 to $146,500 CAD plus equity grants and benefits.
- Eligible for new hire equity grant and annual refresh grants.
- Instacart has a Flex First remote work policy.