Data Analyst Contractor

Instacart • San Francisco, CA

14d • $70 - $90

About The Position

As a Data Analyst operating within our highly efficient contractor team, you will play a crucial role in collecting, analyzing, and interpreting data to drive insights and improvements for our off-platform advertising business. You will use your expertise in SQL, Python, and data tools to support existing delivery responsibilities, contribute to automating manual workflows, and optimize our data portfolio managed by the Ads CATS team.

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.

Nice To Haves

• 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

Responsibilities

• Audience Enablement: Utilize internal tooling to manage the day to day operations of building audiences used for off-platform advertising.
• SQL Expertise: Leverage SQL expertise to write code required to enable custom audience requests. 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.

What This Job Offers

• Career Level: Mid Level