Sales Research Analyst Agency Temp, Pandora

  • Anywhere

Company :
Pandora Media, Inc.

Location :
Los Angeles, California

Expiry Date :
Tue, 15 Jun 2021 23:59:59 GMT

Apply Job :
Open Link

Description :
Description SiriusXM and Pandora have joined together to create the leading audio entertainment company in the U.S. Together, we are uniquely positioned to lead a new era of audio entertainment by delivering the most compelling subscription and ad-supported audio experiences to millions of listeners — in the car, at home and on the go. Our talent, content, technology and innovation continue to be at the forefront, and we want you to be a part of it! Check out our current openings below and at Position Summary: The Sales Research Analyst Contractor will support the Pandora advertising sales team by building, troubleshooting, and updating our automated data feed pipeline for external vendors. This is a highly technical role that requires a unique and wide range of skills. This candidate should be detail oriented, highly adept at problem solving and an effective communicator. Training to be provided. The data feed pipeline supports the Ad Effectiveness team in delivering log files to over three dozen 3rd party vendors. These files are then used to conduct ad measurement studies (brand lift, sales lift, location analysis, etc.). The demand for advertisers to measure the effectiveness of their campaigns on Pandora has created an insatiable demand which resulted in over 3,000+ studies in 2019. As scale and demand continue to grow, the Analyst role will play an integral part in the development and maintenance of our automated data feed pipeline. Duties and Responsibilities: Writing SQL queries specifically for 3rd-Party vendor exposure files: Write or rewrite custom queries that are specific to the dozen or so vendors we work with. This requires following the vendor’s specs and ensuring that the output of the query matches precisely. Often times, this also involves going back and forth with the vendor b/c their requests aren’t always spelled out properly. Additionally, this calls for very advanced SQL skills as sometimes they need to be written from scratch. Create/modify automated data feed process for different jobs: The set up and structure of our ad products (direct sold, programmatic, SoundCloud, etc.) are constantly changing and evolving. We are always playing catch up to ensure our exposure files incorporate the latest changes. Contractor will be asked to account for these different changes in a proactive manner. Troubleshooting exposure files: Invariably, there is something that will always break down. There could be a number of reasons why, particularly when we’re working at the scale we do and with the number of vendors we have. We have a Slack channel where issues are brought up and addressed. Contractor will have to identify where the issue originated from and go in and fix it. This can often times be like finding a needle in a haystack. Contractor must have a high proficiency in SQL and Python to do this efficiently. Optimizing data feed process files: With our migration to Google Cloud Platform, there is now increased scrutiny on the amount each department generates in processing costs. with the evolution of our business we will need to monitor costs and ensure our entire operation is optimized as much as possible. Supervisory Responsibilities: There will be no supervisory responsibilities. Minimum Requirements: 1-2 years’ experience in an analytical role in a digital, tech and/or media environment 1+ year Advanced SQL skills 1+ year Intermediate Python Requirements and General Skills: Bachelor’s Degree in math, analytics, statistics or related quantitative field. Knowledge of other languages (Bash, Javascript) is a plus Good public speaking and presentation skills. Interpersonal skills and ability to interact and work with staff at all levels. Excellent written and verbal communication skills. Ability to work independently and in a team environment. Ability to pay attention to details and be organized. Ability to project professionalism over the phone and in person. Ability to handle multiple tasks in a fast-paced environment. Commitment to internal client and customer service principles. Willingness to take initiative and to follow through on projects. Creative writing ability. Excellent time management skills, with the ability to prioritize and multi-task, and work under shifting deadlines in a fast-paced environment. Must have legal right to work in the U.S. Technical Skills: Advanced experience with different SQL frameworks (Hive/Hadoop, Presto, BigQuery). Python and Airflow framework. Experience with cloud database is a plus. More details about our company benefits can be found at the following link: Our goal at SiriusXM+Pandora is to provide and maintain a work environment that fosters mutual respect, professionalism and cooperation. SiriusXM+Pandora is an equal opportunity employer that does not discriminate on the basis of actual or perceived race, creed, color, religion, national origin, ancestry, alienage or citizenship status, age, disability or handicap, sex, gender identity, marital status, familial status, veteran status, sexual orientation or any other characteristic protected by applicable federal, state or local laws. The requirements and duties described above may be modified or waived by the Company in its sole discretion without notice.