ETL Developer in San Francisco, CA

The EW Scripps Company   •  

San Francisco, CA 94102

Industry: Media

  •  

5 - 7 years

Posted 56 days ago

ETL Developer

San Francisco, CA

Stitcher is the world's largest pure-play podcasting company. We started as beloved comedy podcast network Earwolf; via Midroll, we provide ad sales and distribution services to 300+ shows such as The Bill Simmons Podcast, WTF with Marc Maron, Dead Ass with Khadeen and Devale Ellis and many more; and with Stitcher, we own one of the largest podcast apps and a network of original content from talent such as Bill Nye and LeVar Burton. We're on a mission to transform podcasting into a major part of the media landscape, and we're looking for like-minded enthusiasts to help.

At Stitcher, we're creating the best place in the world for podcasts -- the best place to discover, to listen, to distribute and to create. Our award-winning app has been downloaded over 12 million times and delivers listeners their favorite shows via smart phone, smart speaker and connected car. We love podcasts, and every day we're helping more people share in that love. We're looking for smart, motivated podcast enthusiasts to build and grow even faster.

Specifically You'll:


  • Oversee the full-cycle of back-end development of Stitcher's data warehouse, including the development of ETL processes, cube development for database and performance administration, and dimensional design of the table structure.
  • Work closely with product management, data analysts and data scientists to provide insight and avail meaningful data products
  • Provide day to day support of the data warehouse and troubleshoot existing procedures and data pipelines and strive to improve data organization and accuracy.
  • Monitor and troubleshoot performance issues on data warehouse servers and assists in the development of business intelligence, business data standards and processes

You're a fit if:


  • You have BA/BS in Computer Science, Information Systems, Statistics or other equivalent technical discipline
  • You have at least 5 years of experience in MySQL server coding and MYSQL server database administration
  • You have a minimum of 2 years in data warehouse development/architecture and hands-on physical and logical database designing
  • You have a passion for analytics technologies as well as analytical and dimension modeling
  • You are familiar with ETL (extraction, transformation & load) and have the skill to draft, analyze and debug SQL queries and are proficient in a scripting language
  • You have experience with AWS Redshift and S3
  • You have experience in Java, Python or R

Stitcher the best place to listen to, produce and monetize podcasts. The Stitcher app, available for iOS and Android devices, is one of the world's most popular podcast listening platforms, with a growing network of original content and a premium subscription service. Stitcher is the parent company of Midroll Media, the leading podcast advertising network representing over 200 of the world's largest podcasts, and top-ranked comedy podcast network Earwolf. With offices in Los Angeles, New York City and San Francisco, Stitcher was founded in 2007 and is a wholly owned subsidiary of The E.W. Scripps Company (NASDAQ :SSP )

As an equal employment opportunity employer, The E.W. Scripps Company and its affiliates do not discriminate in its employment decisions on the basis on race, sex, sexual orientation, gender, color, religion, age, genetic information, medical condition, disability, marital status, citizenship or national origin, and military membership or veteran status, or on any other basis which would be in violation of any applicable federal, state or local law. Furthermore, the company will make reasonable accommodations for qualified individuals with known disabilities unless doing so would result in an undue hardship for the company.

JR021750

Valid Through: 2019-11-11