Data Engineer Specialist - Ads Campaign Operations - Gamma (Hybrid)

Google Operations Center; Chicago (IL); On-site; USD 110,000 - 135,000; Full time

Benefits offered by this job

Health care included

Birth-parent leave

Free meals onsite

Job summary

Google Operations Center in Chicago is seeking a Data Specialist who will own data pipelines and audience targeting for email marketing campaigns managed by the Ads Campaign Operations (ACO) team. You will build and maintain pipelines, run SQL scripts, monitor campaign health, and explain data implications to internal and external stakeholders while collaborating across analytics and marketing teams.

The role emphasizes technical excellence, collaboration, and translating data-driven

Qualifications

• 5+ years of SQL experience with data pipeline building and crafting complex queries.
• Experience with data visualization tools such as Tableau, Looker, and Google's PLX/Data Studio.
• 2-3 years of data pipelines and analytics specifically for email marketing.
• Proven marketing IT experience and ability to communicate data insights to stakeholders.

Responsibilities

• Collaborate with stakeholders to manage audience signals and build target audiences for campaigns.
• Create, manage, and validate campaign audiences using SQL scripting.
• Collaborate with analytics on experiment setup and explain data implications.
• Maintain and operate data pipelines, resolve issues, and implement efficiency improvements.
• Communicate campaign performance results to teams and stakeholders.
• Create dashboards and ad hoc reports for marketers.
• Build relationships and translate technical data to non-technical audiences.

Skills

SQL

Data pipelines

Data visualization tools

Python

Version control

Tools

XCode

VS Code

Eclipse

GitHub

google3

Job description

At Google Operations Center we help Google users and customers solve problems and achieve their goals—all while enjoying a culture focused on improving continuously and being better together.

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.

The base salary range for this full-time position is $110,000 - $135,000 + bonus + benefits. 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.

Position 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

Minimum Qualifications

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

Preferred Qualifications

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

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

Equal Opportunity Statement

Google Operations Center (GOC) is committed to equal employment opportunities regardless of race, creed, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or veteran status or any other basis protected by law. We also consider qualified applicants regardless of criminal histories, consistent with legal requirements.

Data Privacy

Information collected and processed as part of your Google Operations Center (GOC) jobs profile, and any job applications you choose to submit, is subject to GOC's Applicant and Candidate Privacy Policy.

Agency Policy

To all recruitment agencies: Google Operations Center (GOC) does not accept agency resumes. Please do not forward resumes to our jobs alias, GOC employees, or any other organization location. GOC is not responsible for any fees related to unsolicited resumes.

Locations

With locations from North America to Asia, we hope you'll explore opportunities in your corner of the world.