Apply now »

Senior Python Developer, Cloud Data Warehouse

Penguin Random House is the leading publishing firm globally.  Our mission is to foster a passion for reading by partnering with authors to create stories that inform, entertain, and inspire, and to connect authors with readers everywhere.


We are looking for a Senior Python Developer to join our Data Warehouse team.  In this role, you will help us to design, build, and run a wide variety of custom data ingestion (ETL) systems using Python, SQL, Linux, and related technologies.  We are currently in an expansion phase as we build out our Snowflake and Azure-based global analytics platform.  We are looking for a creative, energetic problem-solver with strong analytical and communication skills to help lead the way as we migrate our suite of core ETL systems to the AWS cloud platform.



  • Work both individually and in a team setting to design, code, and maintain custom ETL systems to support our global analytics platform
  • Interact with a variety of colleagues to help research and improve data quality and to strategize about new opportunities to leverage data that will help further our mission as the world's largest and most innovative book publisher
  • Provide collaborative leadership in a team setting, as you share your knowledge of data warehousing and the AWS cloud platform to help propose new strategies and improvements
  • Additional opportunities to build solutions that span the AWS/Snowflake and Azure/Power BI environments


Qualifications & Experience:

  • Minimum 5 years of professional experience in software application development
  • Bachelor's degree or higher in a computer-science field
  • In-depth experience with relational databases, data warehousing and data modeling
  • 5+ years of Python development experience
  • 5+ years of SQL development and Linux shell scripting
  • 3+ years of experience with Snowflake or other cloud-based data warehouse platform
  • Experience with AWS, including use of containers (Docker, etc.)
  • Expertise in writing and maintaining stable production-level code
  • Experience with Java and object-oriented programming is a plus
  • Ability to develop projects autonomously, end-to-end, from user requirements through delivery
  • Interest and ability to learn other coding languages and technologies as needed


Given how popular these roles can be, when you apply, we’d love for you to showcase as much as possible in your resume how your experience will add to our team.  We look forward to hearing from and hopefully meeting you soon!


Full-time employees are eligible for our comprehensive benefits program. Our range of benefits include, but are not limited to, Medical/Prescription drug insurance, Dental, Vision, Health Care/Dependent Care Flexible Spending Account, Health Savings Account, Pre-Tax and Roth 401(k), Short and Long-Term Disability Insurance, Life/AD&D Insurance, Commuter Benefits, Student Loan Repayment Program, Educational Assistance & generous paid time off. 


Penguin Random House is the leading adult and children’s publishing house in North America, the United Kingdom and many other regions around the world.  In publishing the best books in every genre and subject for all ages, we are committed to quality, excellence in execution, and innovation throughout the entire publishing process: editorial, design, marketing, publicity, sales, production, and distribution.  Our vibrant and diverse international community of nearly 250 publishing brands and imprints include Ballantine Bantam Dell, Berkley, Clarkson Potter, Crown, DK, Doubleday, Dutton, Grosset & Dunlap, Little Golden Books, Knopf, Modern Library, Pantheon, Penguin Books, Penguin Press, Penguin Random House Audio, Penguin Young Readers, Portfolio, Puffin, Putnam, Random House, Random House Children’s Books, Riverhead, Ten Speed Press, Viking, and Vintage, among others.  More information can be found at
Penguin Random House values the array of talents and perspectives that a diverse workforce brings. All qualified applicants will receive consideration for employment without regard to race, national origin, religion, age, color, sex, sexual orientation, gender identity, disability, or protected veteran status.



Company: Penguin Random House LLC 

Country: United States of America 

State/Region: New York 

City: New York 

Postal Code: 10019 

Job ID: 157551

Date:  May 15, 2022

New York, NY, US, 10019

Nearest Major Market: Manhattan
Nearest Secondary Market: New York City

Job Segment: Database, Medical, Cloud, Data Warehouse, Developer, Technology, Healthcare

Apply now »