Job Description

Locations

• United States, United States (Remote)

Salary

Skills Required

• SQLintermediate
• Python (NumPy, Pandas)intermediate
• Snowflakeintermediate
• Amazon Redshiftintermediate
• Google BigQueryintermediate
• Shell scriptingintermediate
• Data analysisintermediate
• Data manipulationintermediate
• Cloud data warehousesintermediate
• Collaborationintermediate

Required Qualifications

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

Preferred Qualifications

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

Responsibilities

• 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.
• Utilize efficient SQL writing and querying techniques to troubleshoot issues directly within the Snowflake data warehouse.
• Optimize queries for performance and maintainability.
• 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.
• 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.
• Execute Shell/Python scripts using command line tools to fulfill off-platform audience enablement.
• Leverage Python scripting to automate tasks and processes.
• Work with CATS developers to perform technical QA on automation tools and frameworks.
• Provide product feedback, design recommendations, and feature requests.
• Continually evaluate operational processes to identify areas of improvement and implement changes that enhance operational effectiveness.

Tags & Categories