Data Engineer Specialist - Ads Campaign Operations - Gamma (Hybrid) at Google Operations Center in US-CHI-CARP210

Job description

• Data Specialist is the subject matter expert for everything data related for email marketing campaigns managed by the Ads Campaign Operations (ACO) team. From understanding the signals available, building and maintaining pipelines for campaign targeting sets to monitoring campaign health and troubleshooting if things go sideways. On top of their technical excellence, they can also confidently talk about the data aspect of our campaigns to internal and external stakeholders.

Responsibilities

• Collaborate with stakeholders to manage audience signals, build target audiences, and leverage them throughout the campaign execution process
• Create, manage, and validate campaign audiences using SQL scripting
• Collaborate with analytics teams on experiment setup, providing insights into campaign signals, explaining system behavior and its impact on setup, and confirming feasibility of implementation
• Maintain and operate data pipelines, ensuring smooth operation, resolving issues, and implementing improvements for efficiency and effectiveness
• Communicate campaign performance results to teams and stakeholders
• Create reporting dashboards and ad hoc reports for marketers
• Build key relationships with stakeholders and communicate technical information clearly to non-technical audiences
• Serve as the subject matter expert for data availability for marketing campaigns

Requirements

• 5+ years of experience with SQL, including data pipeline building and maintenance, and crafting complex SQL statements for precise audience targeting
• Ability to leverage code libraries for streamlined code readability and enhanced efficiency
• Experience working with data visualization tools such as Tableau, Looker, and Google's internal PLX/Data Studio
• 2-3 years of experience in data pipelines and analytics specifically for email marketing
• Proven experience in a marketing environment within the IT industry
• Experience with integrated development environments like XCode, VSC, or Eclipse (Google internal: Cider) and version control systems like GitHub (Google internal: google3)
• The following qualifications are a plus, but transferable skills and experience are equally valuable:
• Additional languages besides SQL (e.g. Python) are a plus, but not required
• Excellent collaboration and communication skills and stakeholder management
• Ability to clearly communicate data-driven observations and recommendations
• Proven expertise in email marketing best practices, including dynamic content, testing methodologies, deliverability, and automation
• Experience using GenAI (generative AI) to inform data targeting and personalization in email marketing
• Experience designing, executing, and evaluating A/B tests for email marketing

Skills

Required

• SQL
• Data pipeline building and maintenance
• Crafting complex SQL statements

Preferred

• Python
• GenAI (generative AI)
• A/B testing
• Email marketing best practices

Benefits

• We support you with competitive wages and with comprehensive health care including medical, dental and vision coverage
• We support your family with gender-neutral baby bonding leave, 24-26 week birth-parent maternity leave, and generous life, accident and disability insurance minimums
• Employees who work onsite can enjoy free meals and snacks, and fun onsite experiences
• The base salary range for this full-time position is $110,000 - $135,000 + bonus + benefits. Our salary ranges are determined by role and level. Within the range, individual pay is determined by additional factors, including job-related skills, experience, and relevant education or training.
• Please note that the compensation details listed in this role posting reflect the base salary only, and do not include bonus or benefits. Some benefits information is included in this job description, and your recruiter can share more about the specific salary range and benefits for this position during the hiring process.