Full Time Job

Developer, Data Etl - IT Applications

Penguin Random House

New York, NY 08-24-2021
 
  • Paid
  • Full Time
  • Mid (2-5 years) Experience
Job Description
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.

Responsibilities:
• 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

Qualifications:
• 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

Preferred
• 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

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 http://www.penguinrandomhouse.com/ .

Company: Penguin Random House LLC

Country: United States of America

State/Region: New York

City: New York

Postal Code: 10019

Job ID: 146407

Date:

Jul 15, 2021

Location:

Jobcode: Reference SBJ-gx3x5z-3-87-33-97-42 in your application.

Company Profile
Penguin Random House

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.