[![Image]() Meet Jobicy Copilot — free AI autofill for job applications + remote job alerts ›](#) [All remote jobs](https://jobicy.com/jobs.md)Open role[![Instacart logo](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2023/03/fe39c2bc9bb5ebb0b5e24318b1f3b60d.jpeg)](https://jobicy.com/company/instacart.md)Remote opportunity at[Instacart](https://jobicy.com/company/instacart.md) # Analytics Engineer II Review the role, location requirements, compensation details, and application process before deciding whether this opportunity fits your next career move. [Apply for this job](#job-application)[View company](https://jobicy.com/company/instacart.md)Share16 Sep 2026Published38Listing views3Application actions16 Oct 2026Apply before Opportunity details ## About this role. AI SummaryInstacart is seeking an Analytics Engineer II to build and maintain marketing analytics data models and ETL pipelines supporting paid marketing, SEO, retailer marketing, and attribution. The role requires end-to-end ownership of dimensional models, data quality testing, documentation, monitoring, and pipeline observability using dbt, Snowflake, Airflow, and SQL. This engineer will partner closely with Data Scientists, Analysts, and Marketing stakeholders to translate business questions into trusted datasets. The position is remote but limited to candidates residing in Ontario, Alberta, British Columbia, or Nova Scotia. It is a mid-level individual-contributor role with meaningful technical ownership and cross-functional impact on marketing-spend decisions. ## Role DNA A quick view of the complexity, pace, ownership and collaboration implied by the job description. ### Job Complexity 4/5EasyHard ### Pace & Pressure 4/5RelaxedFast-paced ### Autonomy Level 4/5GuidedFull ownership ### Communication Load 4/5IndependentCollaborative AI insightThe role requires independent delivery of reliable production data assets, strong dimensional modeling expertise, and ownership of data-quality issues through root-cause resolution. Its marketing attribution scope and cross-functional stakeholder engagement add meaningful technical and business complexity. ## Salary analysis Estimated compensation compared with the broader CA market for similar roles. Estimated job medianMarket rateC$142,750CA market rangeC$125k–C$170k0C$187k AI insightThe disclosed base-pay range is CAD 139,000 to CAD 146,500 yearly, with a midpoint of CAD 142,750. For comparison, the estimated US market base-salary range for a mid-level Analytics Engineer with modern data-stack and marketing-attribution experience is approximately USD 125,000 to USD 170,000 annually; this market comparison is an estimate and excludes equity, bonuses, and benefits. ## Core skills Skills and capabilities most closely associated with this opportunity. [SQL](https://jobicy.com/jobs?search_keywords=SQL.md)[dbt](https://jobicy.com/jobs?search_keywords=dbt.md)[Snowflake](https://jobicy.com/jobs?search_keywords=Snowflake.md)[Airflow](https://jobicy.com/jobs?search_keywords=Airflow.md)[Dimensional Modeling](https://jobicy.com/jobs?search_keywords=Dimensional%20Modeling.md)[ETL Pipelines](https://jobicy.com/jobs?search_keywords=ETL%20Pipelines.md)[Data Quality](https://jobicy.com/jobs?search_keywords=Data%20Quality.md)[Data Observability](https://jobicy.com/jobs?search_keywords=Data%20Observability.md)[Marketing Attribution](https://jobicy.com/jobs?search_keywords=Marketing%20Attribution.md)[Python](https://jobicy.com/jobs?search_keywords=Python.md) Sample interview questionsHow would you design a dimensional model for paid-marketing performance and attribution reporting?I would start by defining the business grain, such as campaign-day-channel or conversion-event, and align metric definitions with marketing stakeholders. I would create conformed dimensions for date, channel, campaign, retailer, geography, and attribution model, with fact tables for spend, impressions, clicks, conversions, and attributed revenue. I would document lineage, apply incremental loading where appropriate, and include tests for unique keys, referential integrity, freshness, and reconciliation to source platforms. Describe how you would investigate a sudden drop in attributed conversions in a marketing dashboard. I would first identify the affected time window, channels, and downstream models, then check pipeline freshness, orchestration logs, source extract volumes, and recent code or schema changes. I would compare raw-source counts with staging and mart-layer counts to isolate where the discrepancy began. After correcting the root cause, I would backfill affected data, validate results with stakeholders, and add monitoring or tests to prevent recurrence. How do you balance stakeholder requests for quick analysis with the need to build durable data models? I clarify the decision being supported, the required level of accuracy, and whether the request is recurring. For urgent one-time needs, I can provide a clearly labeled exploratory solution while documenting assumptions and limitations. When a request is likely to recur or affect important decisions, I prioritize a reusable modeled dataset, tests, documentation, and an agreed ownership model. What practices would you use to maintain quality in a dbt-based analytics environment? I would use layered modeling conventions, source freshness checks, schema tests, custom business-rule tests, and clear model documentation. Pull requests should receive peer review, and significant changes should have lightweight design proposals covering grain, dependencies, metric definitions, and migration risks. I would also monitor job failures, data volume anomalies, and key KPI changes to catch issues not covered by static tests. How would you collaborate with data scientists on an incrementality or attribution project? I would begin by agreeing on the experiment or attribution methodology, required input grain, treatment definitions, outcomes, and exclusions. I would produce versioned, reproducible feature and outcome datasets with transparent transformation logic and validation against source systems. Throughout the project, I would communicate assumptions, data limitations, and changes early so analytical conclusions remain interpretable and repeatable. We’re transforming the grocery industry 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. 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. Instacart is a Flex First team 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. [Learn more about our flexible approach to where we work.](https://www.instacart.careers/flex-first) Overview The Marketing Enablement & Technology (MET) team sits natively within Instacart’s Marketing organization, owning the data foundations that power Paid Marketing, SEO, and Retailer Marketing attribution. These datasets directly inform how we allocate hundreds of millions of dollars in marketing spend and how we measure growth. We’re hiring an Analytics Engineer II to help build and evolve the marketing analytics data foundation. In this role, you’ll independently design and deliver high-quality, business-aware data models and pipelines that Data Scientists and Analysts trust — owning your work end-to-end, raising the quality bar through code reviews and design discussion, and growing toward broader technical ownership of marketing data. About the Job * Marketing Analytics Data Development: Independently build and maintain high-quality dimensional data models and ETL pipelines that support marketing analytics across Paid Marketing, SEO, Retailer Marketing, and attribution — delivering complete data assets end-to-end with minimal oversight. * Cross-functional Partnership: Work closely with Data Scientists, Analysts, and Marketing stakeholders to translate analytical needs and business questions into data requirements, and deliver trusted, decision-ready datasets. * Data Quality Ownership: Own data quality for the models you build — writing tests, documentation, and monitoring, and resolving data issues at their root cause across the marketing workflows you support. * Code Review & Design: Conduct thorough code reviews, write and share designs publicly before building, and apply simple, reusable modeling patterns that leave the codebase better than you found it. * Pipeline Evolution & Observability: Improve existing marketing data pipelines to reduce manual effort and improve performance, enhance observability (logging, metrics, freshness and quality checks), and participate in incident response for the data platform. About You Minimum Qualifications * 3–5 years of experience in Analytics Engineering, Data Engineering, or closely related roles, with hands-on ownership of production data models and pipelines. * Strong SQL skills and hands-on experience building well-architected dimensional data models (star schemas, fact/dimension tables, SCDs). * Hands-on experience with the modern data stack, including dbt, Snowflake, and Airflow. * Working knowledge of marketing data and metrics — including paid media performance, attribution concepts, and channel-level measurement — or the ability to ramp quickly. * Demonstrated ability to deliver complete data models and pipelines independently, manage multiple priorities, and write clean, well-documented, well-tested code. * Effective communicator who can collaborate across data, marketing, and engineering teams to understand requirements and deliver solutions. Preferred Qualifications * Experience partnering with Data Scientists on experimentation, attribution, or incrementality measurement. * Familiarity with marketing platforms (ie Google Ads, Meta, Google Analytics, SEO tooling). * Python experience for automation or advanced transformations. * Comfort using AI-assisted developer tools to improve code quality and speed (e.g., generating tests, validating logic, comparing suggestions). * Experience contributing to analytics engineering best practices such as testing, documentation, or data quality standards. #LI-Remote Instacart provides highly market-competitive compensation and benefits in each location where our employees work. This role is remote and the base pay range for a successful candidate is dependent on their permanent work location. Please review our Flex First remote work policy [here](https://instacart.careers/flex-first/). Currently, we are only hiring in the following provinces: Ontario, Alberta, British Columbia, and Nova Scotia. Offers may vary based on many factors, such as candidate experience and skills required for the role. Additionally, this role is eligible for a new hire equity grant as well as annual refresh grants. Please read more about our benefits offerings [here](https://instacart.careers/taste-of-instacart/). For Canadian based candidates, the base pay ranges for a successful candidate are listed below. CAN $139,000—$146,500 CAD Show more [Apply now >](https://jobicy.com/jobs/153357-analytics-engineer-ii-2.md) * ![Upload CV](data:image/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHdpZHRoPSI2NSIgaGVpZ2h0PSI2NSIgZmlsbD0ibm9uZSIgeG1sbnM6dj0iaHR0cHM6Ly92ZWN0YS5pby9uYW5vIj48ZyBjbGlwLXBhdGg9InVybCgjQSkiPjxwYXRoIGQ9Ik0wIDBINjVWNjVIMFYwWiIgZmlsbD0iIzAyOWFlYiIvPjxnIGZpbGw9IiNmZmYiIHN0cm9rZT0iI2ZmZiIgc3Ryb2tlLXdpZHRoPSIyIj48cGF0aCBkPSJNMzMuMDQ5IDE1LjQ1NGExLjQzIDEuNDMgMCAwIDAtMi4wOTcgMGwtNy41NzkgOC4xNDdhMS4zOCAxLjM4IDAgMCAwIC4wOSAxLjk3MyAxLjQ0IDEuNDQgMCAwIDAgMi4wMDgtLjA4OGw1LjEwOS01LjQ5MnYyMC42MWExLjQxIDEuNDEgMCAwIDAgMS40MjEgMS4zOTdjLjc4NSAwIDEuNDIxLS42MjUgMS40MjEtMS4zOTd2LTIwLjYxbDUuMTA5IDUuNDkyYTEuNDQgMS40NCAwIDAgMCAyLjAwOC4wODggMS4zOCAxLjM4IDAgMCAwIC4wOS0xLjk3M2wtNy41NzktOC4xNDZ6TTE2Ljc2OSAzOC40YzAtLjc3My0uNjItMS40LTEuMzg1LTEuNFMxNCAzNy42MjcgMTQgMzguNHYuMTAybC4yMTUgNi4yMjljLjIyMyAxLjY4LjcwMSAzLjA5NSAxLjgxMyA0LjIxOHMyLjUxIDEuNjA3IDQuMTcyIDEuODMzYzEuNi4yMTggMy42MzYuMjE4IDYuMTYuMjE4aDExLjI4bDYuMTYtLjIxOGMxLjY2Mi0uMjI2IDMuMDYxLS43MDkgNC4xNzItMS44MzNzMS41ODktMi41MzggMS44MTMtNC4yMThDNTAgNDMuMTEzIDUwIDQxLjA1NSA1MCAzOC41MDNWMzguNGMwLS43NzMtLjYyLTEuNC0xLjM4NS0xLjRzLTEuMzg1LjYyNy0xLjM4NSAxLjRsLS4xOSA1Ljk1OGMtLjE4MiAxLjM3LS41MTUgMi4wOTUtMS4wMjYgMi42MTJzLTEuMjI4Ljg1My0yLjU4MyAxLjAzOGMtMS4zOTUuMTktMy4yNDMuMTkzLTUuODkzLjE5M0gyNi40NjJjLTIuNjUgMC00LjQ5OC0uMDAzLTUuODkzLS4xOTMtMS4zNTUtLjE4NC0yLjA3Mi0uNTIxLTIuNTgzLTEuMDM4cy0uODQ0LTEuMjQyLTEuMDI2LTIuNjEyYy0uMTg3LTEuNDEtLjE5MS0zLjI3OS0uMTkxLTUuOTU4eiIvPjwvZz48L2c+PGRlZnM+PGNsaXBQYXRoIGlkPSJBIj48cGF0aCBmaWxsPSIjZmZmIiBkPSJNMCAwaDY1djY1SDB6Ii8+PC9jbGlwUGF0aD48L2RlZnM+PC9zdmc+) ### Upload your resume now To unlock remote work opportunities and be discovered by global employers. This job listing has been manually reviewed by the Jobicy Trust & Safety Team for compliance with our posting guidelines, including verification of the company's legitimacy, accuracy of job details, clarity of remote work policy, and absence of misleading or fraudulent content. Next step ## Apply now. Follow the employer’s application method and review Jobicy’s safety guidance before sharing personal information. Keep exploring ## Related remote jobs. Matched by job category10 related opportunities[Data Science & Analytics](https://jobicy.com/categories/data-science.md) [Browse all jobs](https://jobicy.com/jobs.md) * ![Welo Global logo](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2026/06/83c40f94-221.webp) Welo Global Sep 16 ### [Circinus – Audio Contributor English Southern American (US)](https://jobicy.com/jobs/153445-circinus-audio-contributor-english-southern-american-us.md) About the Role:  We’re looking for fluent native or near native Southern American dialect speakers to take part in a scripted audio data collection project. This is a remote, freelance opportunity that’s… * ![Tala logo](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2022/02/a788b3a65c0fc717303f0b5b049cc7e6.jpeg) Tala Sep 16 ### [Analytics Platforms Architect](https://jobicy.com/jobs/153391-analytics-platforms-architect.md) About Tala Tala is AI-native credit infrastructure for the global majority, combining proprietary risk intelligence with an expanding network of capital and distribution partners to power credit access at scale…. * ![Oddball logo](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2022/02/8c034287ffd7b6474f90645b1c72e60a.jpeg) Oddball Sep 16 ### [Applied AI/ML Engineer](https://jobicy.com/jobs/153362-applied-ai-ml-engineer-2.md) Oddball believes that the best products are built when companies understand and value the things they are working on. We value learning and growth and the ability to make a… * ![Cresta logo](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2022/08/4d686e40b22cf2510b627c59afe5fd95.jpg) Cresta Sep 16 ### [Data Science Intern (Customer Success)](https://jobicy.com/jobs/150863-data-science-intern-customer-success.md) Cresta unlocks the true potential of the customer experience, turning every conversation into a competitive advantage. Cresta’s unified AI platform combines conversational AI agents, real-time human agent augmentation, and comprehensive… * ![Gopuff logo](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2021/05/Jobicy-210510095548-598926.jpg) Gopuff Sep 16 ### [Data Engineer](https://jobicy.com/jobs/150836-data-engineer.md) At Gopuff, data sits at the heart of our strategy. We are reimagining how people purchase everyday essentials, from snacks to household goods to alcohol, all delivered in minutes. To… * ![Who Gives A Crap logo](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2025/06/389bf597-221.png) Who Gives A Crap Sep 15 ### [Data Analytics and Insights Team Lead (CX)](https://jobicy.com/jobs/153324-data-analytics-and-insights-team-lead-cx-2.md) Not all heroes wear capes — but plenty of them use toilet paper Want to challenge yourself at a purpose-led scale up AND make a difference in the world? Come… * ![Meta logo](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2025/06/750f86a9-221.jpeg) Meta Sep 15 ### [Data Scientist, Product Analytics](https://jobicy.com/jobs/150667-data-scientist-product-analytics.md) As a Data Scientist at Meta, you will shape the future of people-facing and business-facing products we build across our entire family of applications (Facebook, Instagram, Messenger, WhatsApp, Oculus). By… * ![Meta logo](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2025/06/750f86a9-221.jpeg) Meta Sep 15 ### [Data Engineer, Product Analytics](https://jobicy.com/jobs/150666-data-engineer-product-analytics.md) As a Data Engineer at Meta, you will shape the future of people-facing and business-facing products we build across our entire family of applications (Facebook, Instagram, Messenger, WhatsApp, Reality Labs,… * ![Worldwide Clinical Trials logo](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2025/06/d46acd29-221.jpeg) Worldwide Clinical Trials Sep 15 ### [Senior Statistician](https://jobicy.com/jobs/149258-senior-statistician.md) Who we areWe’re a global, midsize CRO that pushes boundaries, innovates and invents because the path to a cure for the world’s most persistent diseases is not paved by those… * ![UpGuard logo](https://jobicy.com/data/server-nyc0409/galaxy/mercury/2025/06/474a12c7-221.png) UpGuard Sep 14 ### [Product Data Science Lead](https://jobicy.com/jobs/153276-product-data-science-lead.md) Who are we? At UpGuard, we are replacing manual security bottlenecks with AI-driven precision. Fresh off a US$75M Series C, we are scaling our infrastructure to process 100 billion risk…