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

About the Role

Key Responsibilities

• 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
• Develop and implement automated data checks, perform root-cause analysis, and resolve data issues to ensure data integrity across marketing datasets
• Create and maintain documentation for data ingestion processes, update data dictionaries, and manage taxonomy mapping for marketing and consumer datasets
• Configure and enhance API and file-based integrations to improve efficiency and scalability of data ingestion
• 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 diagnostic tools
• Recommend and optimize SQL/Python scripts and monitor their performance
• Support marketing attribution and measurement initiatives by aligning data pipelines with analytics needs

Requirements

• Experience in data integration, data engineering, or marketing analytics roles
• Strong SQL skills, with experience writing and optimizing queries for large datasets
• Experience working with marketing data sources such as advertising campaign performance and 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

Nice to Have

• 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

Qualifications

• Experience in data integration, data engineering, or marketing analytics roles
• Strong SQL skills with experience optimizing large datasets
• Experience with marketing data sources such as advertising and email analytics
• Familiarity with Python and APIs for data extraction and automation

Benefits & Perks

• Salary range of $66,500-$70,000 with potential annual profit award or bonus
• Comprehensive benefits including 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