Data Analyst

Summary

Join Instacart's Flex First team as a Data Analyst and contribute to the growth of their off-platform advertising business. You will be responsible for collecting, analyzing, and interpreting data to drive insights and improvements. This role involves utilizing SQL, Python, and data tools to support existing delivery responsibilities, automate workflows, and optimize the data portfolio. You will also collaborate with cross-functional teams to enhance data-related processes and provide product feedback.

Requirements

• Bachelor’s degree or equivalent work experience (4 years) in a relevant business/domain
• 2+ years of hands-on experience with SQL, Data Manipulation, and Data Analysis
• 2+ years of experience applying Python (NumPy, Pandas, Other common libraries) programming to solve business challenges
• 2+ years of experience working with cloud data warehouses such as Snowflake, Amazon Redshift, or Google BigQuery
• Capable of collaborating effectively in team environments, especially on large/complex projects

Responsibilities

• Audience Enablement: Utilize internal tooling to manage the day to day operations of building audiences used for off-platform advertising. Leverage SQL expertise to write code required to enable custom audience requests
• SQL Expertise: Utilize efficient SQL writing and querying techniques to troubleshoot issues directly within the Snowflake data warehouse. Optimize queries for performance and maintainability
• Data Analysis and Research: Collect, analyze, and interpret data to identify trends and patterns affecting our Off-Platform audiences. Work with the core CATS team to research new audience segmentation methodologies
• Cross-Functional Collaboration: Collaborate with teams across different functions to support off-platform audience enablement. Identify process improvement opportunities and provide regular recommendations to enhance data-related processes
• Scripting and Automation: Execute Shell/Python scripts using command line tools to fulfill off-platform audience enablement. Leverage Python scripting to automate tasks and processes
• Product Support and QA: Work with CATS developers to perform technical QA on automation tools and frameworks. Provide product feedback, design recommendations, and feature requests
• Process Improvement: Continually evaluate operational processes to identify areas of improvement and implement changes that enhance operational effectiveness

Preferred Qualifications

• Experience working in digital advertising, ad technology, or retail media networks
• Development experience with Python, including working with APIs, building data pipelines, authentication, file handling, and raw data manipulation is a plus
• Experience with audience segmentation methodologies
• Exposure to working with large data platforms and handling sizable datasets