Senior Python Developer, Cloud Data Warehouse

Job Description

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

Jobcode: Reference SBJ-gxoyz4-3-21-231-245-42 in your application.