Software Engineer, Instacart

• 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

Desirable

• As a MarTech Engineer, your contributions will play a crucial role in optimizing the efficiency and effectiveness of our Paid Marketing efforts, encompassing a diverse array of channels such as Paid Social, Display, SEM, Online Video, Linear Television, and Streaming Audio
• Your work will directly impact the scalability and performance of these channels, enabling us to reach broader audiences and amplify Instacart's market presence
• By leveraging cutting-edge technology and collaborating with various departments, you will help create strategies that deliver measurable results and foster sustained growth
• Building and maintaining data pipelines using Python and Snowflake: Design and oversee efficient data pipelines that handle extensive data processing, ensuring seamless data flow and troubleshooting issues as they arise
• Integrating and extracting data from multiple sources such as Google Analytics and Snowflake: Manage ETL processes for integrating diverse data sources, ensuring accurate and timely data flow into centralized systems to support decision-making
• Automating tasks like data retrieval and report generation: Develop scripts and workflows to automate data retrieval and report generation, utilizing APIs and scheduling tools to streamline processes and minimize manual effort
• Leading DBT initiatives to enhance model efficiency: Spearhead the development and optimization of data models using DBT, ensuring scalability and maintainability, while documenting best practices and providing guidance to the team
• Harnessing Airflow for automation tasks and configuring manual runs: Use Apache Airflow to automate and schedule complex workflows, ensuring efficient and accurate execution of data-related tasks
• Collaborating with marketing teams utilizing your marketing data experience: Work closely with marketing to translate data into actionable insights, providing analytical support and enhancing data-driven strategies
• Works with multiple third-party channels to streamline Ad conversions: Able to work closely with stakeholders across third-party channel providers and debug issues when they arise
• Collaborating with Marketing to launch new Paid Listing Ads across channels: Working with various channels (Snap, Google, Facebook, etc) on managing and pushing data to multiple channels and product lists for various product feed Ad consumption
• Writing advanced SQL queries and setting up data marts: Create complex SQL queries and establish data marts, providing easy access to clean and structured data for marketing analytics
• This role will be positioned within the marketing organization, embedded directly into our Cross Channel Integrations team – the technical arm of Instacart Marketing
• The Cross Channel Integrations team is composed of forward-thinking marketing technologists, strategists and engineers committed to developing solutions that elevate Instacart's marketing channels