Developer, Data ETL - IT Applications

The Data Warehouse Operations team is responsible for all development and operational activity related to an existing enterprise data warehouse for the largest English language publisher. Proprietary applications are used to transform and populate cloud repositories in both Snowflake and Azure, providing information for a wide variety of applications throughout the company.



  • Involved in all aspects of data warehousing development and operations.
  • Write both ad-hoc and proprietary C and Python production ETL code.
  • Perform analysis of raw data sets and comparisons of similar data sets, providing results.
  • Focus on maintaining and increasing the quality of the company’s data assets.
  • Communicate effectively and professionally with internal and external customers



  • 3-5 years of hands-on software development experience
  • Linux and SQL expertise is required.
  • Hands-on experience in one or more of the following:
    • C, Python, Java
    • Snowflake, Postgres,  MySQL, Azure Data Factory, Informix
  • Strong testing, debugging and problem solving skills
  • Ability to prioritize and multi-task without impacting attention to detail
  • Ability to work independently and proactively, including on multiple projects simultaneously
  • Comfortable with organizing and managing competing priorities, and continuously learning
  • Interest and ability to learn and leverage new tools and languages



  • Knowledge of data warehousing and/or more general data governance principles.
  • Experience with the Microsoft suite of BI tools (PowerBI, Analysis Services, etc.)


The environment you’ll be working in

Linux, Informix, C, Python, Snowflake, Azure, AWS


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: 146407

Date:  Jun 16, 2021

New York, NY, US, 10019

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

Job Segment: Application Developer, Database, Developer, Warehouse, Linux, Technology, Manufacturing