Marketing Data Integration Specialist, Consumer Marketing, Penguin Random House (Open to Remote)

We are looking for a detail-oriented Marketing Data Integration Specialist to join our Data Marketing and Audience Operations team. In this role, you will take ownership of data shares and API integrations, ensuring seamless data ingestion from various sources into our data ecosystem. You will document data processes, write and optimize SQL queries, and support marketing analytics by importing data for efficient downstream transformation and reporting. 

Recognized as the home to best-in-class storytellers, Penguin Random House’s publishing lists include more than 80 Nobel Prize laureates and hundreds of the world’s most widely read authors, including Barack and Michelle Obama, John Grisham, Margaret Atwood, Ibram Kendi, and George R.R. Martin, among many others.

The ideal candidate thrives at the intersection of marketing and data engineering, has experience with SQL, Python, APIs, and cloud data platforms, and is driven by curiosity, precision, and process improvement. 

Essential Functions & Responsibilities:

• Data Pipeline Operations – Monitor, maintain, and troubleshoot ETL jobs, data shares, API connections, and batch file processes across paid media, email, web analytics, and affiliate/retail data sources
• Data Quality & Validation – Develop and implement automated data checks, perform root-cause analysis, and resolve data issues to ensure integrity across our centralized advertising database, consumer data platform (CDP), and other marketing datasets
• Process Documentation & Governance – Create and maintain documentation for data ingestion processes, update data dictionaries, and manage taxonomy mapping for marketing and consumer datasets
• Integration Development – Configure and enhance API and file-based integrations to improve efficiency and scalability of data ingestion. 

Other Functions:

• Partner with Advertising, Email, and Analytics teams to scope and implement new data feeds and reporting capabilities
• Conduct ad-hoc data health investigations using SQL and other diagnostic tools
• Recommend and implement optimizations in SQL/Python scripts and monitor their performance
• Support marketing attribution and measurement initiatives by ensuring data pipelines align with analytics needs

Qualifications:

Required:

• Experience in data integration, data engineering, or marketing analytics roles
• Strong SQL skills, with demonstrated experience writing and optimizing queries for large datasets
• Experience working with marketing data sources (e.g., advertising campaign performance, email analytics)
• Familiarity with Python and working with APIs for data extraction and automation
• Solid understanding of data architecture principles and marketing measurement concepts
• Ability to translate business requirements into technical specifications and communicate technical concepts to non-technical stakeholders

Preferred:

• Experience with Customer Data Platforms (CDPs), cloud data warehouses (e.g., Snowflake, BigQuery, Redshift), and marketing lifecycle platforms
• Familiarity with Git, Docker, Kubernetes, and Rancher
• Background in consumer products, omnichannel marketing, or performance media

The salary range for this position is $66,500-$70,000.  All positions are currently eligible for annual profit award or bonus, subject to Company results.

Please apply using our ATS system by September 29, 2025, and include your resume and cover letter for consideration. Before applying for any role at Penguin Random House, we recommend you review our applicant resources page and look over our hybrid and open-to-remote guidelines on our FAQs page.

Penguin Random House job postings include a good faith compensation range for each open position. The salary range listed is specific to each particular open position and takes into account various factors including the specifics of the individual role, and candidate's relevant experience and qualifications.

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 300 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/.

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 | Job ID: 283040