Software Engineer II

Summary

Join Instacart's marketing team as a MarTech Engineer and play a pivotal role in driving growth through paid marketing channels. This role involves building and maintaining data pipelines, integrating data from various sources, automating tasks, leading DBT initiatives, and collaborating with marketing teams. You will leverage your expertise in Python, Snowflake, Google Analytics, DBT, and Airflow to optimize marketing efficiency and effectiveness across multiple channels. The position offers a flexible remote work environment and competitive compensation and benefits, including equity grants. We are currently hiring in Ontario, Alberta, British Columbia, and Nova Scotia.

Requirements

• Python Expertise: Daily use and extensive knowledge of Python for data integration, automation, and more
• Snowflake Proficiency: Regular use for creating data pipelines, performing admin tasks, and managing roles
• Google Analytics: Experience with Google Tag Manager and generating daily reports
• DBT Leadership: Leading initiatives, model creation, and process documentation
• Airflow Experience: Daily automation and configuration of tasks
• Marketing Experience: Ability to work with marketing data and collaborate effectively
• SQL and ETL Skills: Advanced proficiency in SQL and experience with ETL processes across Snowflake, Redshift, and PostgreSQL
• Collaboration Skills: Proven ability to work with various stakeholders including product, sales, and finance teams

Responsibilities

• Building and maintaining data pipelines using Python and Snowflake
• Integrating and extracting data from multiple sources such as Google Analytics and Snowflake
• Automating tasks like data retrieval and report generation
• Leading DBT initiatives to enhance model efficiency
• Harnessing Airflow for automation tasks and configuring manual runs
• Collaborating with marketing teams utilizing your marketing data experience
• Works with multiple third-party channels to streamline Ad conversions
• Collaborating with Marketing to launch new Paid Listing Ads across channels
• Writing advanced SQL queries and setting up data marts

Preferred Qualifications

• Basic understanding of digital marketing and previous experience working with marketing teams
• Possesses general familiarity with performance marketing KPIs (ROAS, LTV, CAC, CPA, etc)
• Understanding of Marketing event channel operations, and knowledge of launching new channels through the above-mentioned technologies is appreciated
• Having previous experience working with third-party analytics/tracking platforms
• Having previous experience managing Google Tag Manager for a Marketing or Advertising organization
• Past knowledge within a Data Platform Engineering organization or Data Engineering role
• Has previous experience on an on-call rotation

Benefits

• Highly market-competitive compensation and benefits
• Remote work
• New hire equity grant
• Annual refresh grants
• $140,000 — $155,000 CAD