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 other diagnostic tools.
• Recommend and implement optimizations in 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 demonstrated 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 and experience with large datasets.
• Experience with marketing data sources such as advertising and email analytics.
• Familiarity with Python and APIs.

Benefits & Perks

• Competitive salary range of $66,500-$70,000.
• Eligible for annual profit award or bonus based on company results.
• Comprehensive benefits including medical/prescription drug insurance, dental, vision, flexible spending accounts, health savings account, 401(k), disability insurance, life/AD&D insurance, commuter benefits, student loan repayment, educational assistance, and paid time off.