** 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.

**Responsibilities:**

* 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, wed 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 childrens 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 Childrens 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: Oct 22, 2021 Location: 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

Provider Description Enabled SAP as service provider

* "route" is used for session stickiness

* "careerSiteCompanyId" is used to route the request to the correct data center

* "JSESSIONID" is placed on the visitor's device during the session so the server can identify the visitor

* "Load balancer cookie" (actual cookie name may vary) prevents a visitor from bouncing from one instance to another

Provider Description Enabled Google Tag Manager Google Tag Manager is a tag management system for conversion tracking, site analytics and more.

LinkedIn