← Back to jobsJob ID col-cmv9a6idt0nnxmd01a9twcopk

OmnicomPosted 30+ days ago

Data Engineer

Full-time
Hybrid
3+ years
$50K – $95K/yr
Posted 30+ days ago

Omnicom's Hearts & Science agency is seeking a Data Engineer to join its Data Engineering Team. The role focuses on designing, developing, optimizing, and supporting ETL/ELT processes, enterprise data warehouse solutions, and batch and real-time data platforms in AWS, while collaborating with Analytics, Data Science, IT, Investment, and other stakeholders.

Posted
30+ Days Ago
Source
interpublic.wd5.myworkdayjobs.com
Sector
Information Technology & AI

Opens the employer's application page in a new tab

Responsibilities

  • Contribute to the growth of the enterprise data warehouse (EDW) by working alongside stakeholders to produce accurate information within database objects used in reporting, strategic planning and decision making
  • Assist the Senior Director in developing long-term strategies and capacity planning for meeting future data warehouse and data automation needs
  • Meet with end-users and data SMEs to clarify requirements and business rules needed to design, develop and implement ETL/ELT processes
  • Collaborate with peer Data Engineers to build upon and support our CI/CD pipelines hosted within our extensive GIT repository
  • Mentor our emerging Data Analysts, including providing feedback and suggestions for their planned workflows prior to deployment into production
  • Respond, investigate and correct reported data inaccuracies within the EDW compared to source and business-expected results
  • Establish relationships with external and internal POCs to ensure seamless inbound and outbound Data Delivery expectations are met
  • Implement and support backend maintenance processes that enforce ongoing data optimization and corporate retention policies while ensuring the historical data needs of the client are met
  • Document and maintain all the processes and procedures pertaining to ETL and data warehouse usage/development, contributing to the team knowledgebase when applicable

Qualifications

  • Bachelor's in Computer Science or similar technical degree within a STEM field
  • 3+ years of hands-on experience in building data pipelines using traditional ETL tech stack, platform APIs and big data technologies
  • 3+ years of experience in programming languages including as Python and working within a Linux based environment
  • Experience designing, deploying and supporting production cloud services in AWS ecosystem including EC2, S3 and Redshift
  • Can speak to concepts and designs/benefits to multiple audiences as well as interpret high level business requirements from conversation
  • Able to work within a cross-functional team environment with people from multiple business units, vendors, countries, and cultures
  • Working experience within the advertising/media industry with knowledge of basic media math

Preferred

  • Experience in Social Media Datasets such as Twitter, Facebook, Instagram is a plus
  • Experience in Google Campaign Manager, Xandr, or Adobe Analytics datasets is a plus
  • Experience with Google Cloud products is a plus
  • Experience with Microsoft PowerAutomate is a plus
  • Experience using Project Management tools such as Jira is a plus
  • Experience creating data visualizations and using tools such as Tableau is a plus

Required skills

Data WarehousingData Pipeline DevelopmentETLSQLPythonAWSAmazon EC2Amazon S3Amazon RedshiftLinuxAdvertising and Media IndustryTwitterFacebookInstagram

Full job description

Omnicom's Hearts & Science agency is seeking a Data Engineer to join its Data Engineering Team. The role focuses on designing, developing, optimizing, and supporting ETL/ELT processes, enterprise data warehouse solutions, and batch and real-time data platforms in AWS, while collaborating with Analytics, Data Science, IT, Investment, and other stakeholders.

Responsibilities

  • Contribute to the growth of the enterprise data warehouse (EDW) by working alongside stakeholders to produce accurate information within database objects used in reporting, strategic planning and decision making
  • Assist the Senior Director in developing long-term strategies and capacity planning for meeting future data warehouse and data automation needs
  • Meet with end-users and data SMEs to clarify requirements and business rules needed to design, develop and implement ETL/ELT processes
  • Collaborate with peer Data Engineers to build upon and support our CI/CD pipelines hosted within our extensive GIT repository
  • Mentor our emerging Data Analysts, including providing feedback and suggestions for their planned workflows prior to deployment into production
  • Respond, investigate and correct reported data inaccuracies within the EDW compared to source and business-expected results
  • Establish relationships with external and internal POCs to ensure seamless inbound and outbound Data Delivery expectations are met
  • Implement and support backend maintenance processes that enforce ongoing data optimization and corporate retention policies while ensuring the historical data needs of the client are met
  • Document and maintain all the processes and procedures pertaining to ETL and data warehouse usage/development, contributing to the team knowledgebase when applicable

Preferred

  • Experience in Social Media Datasets such as Twitter, Facebook, Instagram is a plus
  • Experience in Google Campaign Manager, Xandr, or Adobe Analytics datasets is a plus
  • Experience with Google Cloud products is a plus
  • Experience with Microsoft PowerAutomate is a plus
  • Experience using Project Management tools such as Jira is a plus
  • Experience creating data visualizations and using tools such as Tableau is a plus
  • Social Media Datasets
  • Twitter
  • Facebook
  • Instagram
  • Google Campaign Manager
  • Xandr
  • Adobe Analytics
  • Google Cloud
  • Microsoft Power Automate
  • Project Management Tools
  • Jira
  • Data Visualization
  • Tableau

Benefits

  • Hybrid work arrangement
  • Omnicom’s policy requires employees to work in the office for a minimum of three days a week, unless additional in-office days are directed by their agency or manager.

Company

  • Marketing and sales services including advertising, media, and PR
  • New York, New York, USA
  • https://www.omc.com/
  • Founded in 1986
  • 10001+ employees

Qualifications

  • Bachelor's in Computer Science or similar technical degree within a STEM field
  • 3+ years of hands-on experience in building data pipelines using traditional ETL tech stack, platform APIs and big data technologies
  • 3+ years of experience in programming languages including as Python and working within a Linux based environment
  • Experience designing, deploying and supporting production cloud services in AWS ecosystem including EC2, S3 and Redshift
  • Can speak to concepts and designs/benefits to multiple audiences as well as interpret high level business requirements from conversation
  • Able to work within a cross-functional team environment with people from multiple business units, vendors, countries, and cultures
  • Working experience within the advertising/media industry with knowledge of basic media math
  • Experience in Social Media Datasets such as Twitter, Facebook, Instagram is a plus
  • Experience in Google Campaign Manager, Xandr, or Adobe Analytics datasets is a plus
  • Experience with Google Cloud products is a plus
  • Experience with Microsoft PowerAutomate is a plus
  • Experience using Project Management tools such as Jira is a plus
  • Experience creating data visualizations and using tools such as Tableau is a plus

Required skills

  • Data Warehousing, Data Pipeline Development, ETL, SQL, Python, AWS, Amazon EC2, Amazon S3, Amazon Redshift, Linux, Advertising and Media Industry, Twitter, Facebook, Instagram

Preferred skills

  • Experience with Google Cloud products is a plus, Experience with Microsoft PowerAutomate is a plus

Experience

  • 3+ years

Job details

Employment type

Full-time

Seniority level

3+ years

Date posted

Sep 24, 2026

Work mode

Hybrid

Job source

interpublic.wd5.myworkdayjobs.com

Company

Omnicom

Information Technology & AI

Marketing and sales services including advertising, media, and PR

See all 7 jobs from Omnicom →
  • New York, New York, USA
  • Information Technology & AI
  • 10001+ employees
  • Founded 1986
  • omc.com

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Engineer jobs in New York

M Science

1d ago

New

Data Engineer

Full-timeOn-siteNew York, NY$110K – $150K/yr

M Science is hiring a Data Engineer to build and improve large-scale data pipelines and datasets for analytics, experimentation, and machine learning.

Why similarSame roleAWSNew York

Net2Source (N2S)

1d ago

New

Sr. Data Engineer

Full-timeOn-siteNew York, NYCompetitive

Net2Source is recruiting for a confidential client seeking a Senior Data Engineer. The role focuses on designing and supporting data pipelines and solutions, performing data analysis and ingestion, and implementing CI/CD pipelines for reliable data delivery.

Why similarSame roleData Pipeline DevelopmentNew York

Trexquant Investment LP

1d ago

New

Senior Data Engineer

Full-timeOn-siteNew York, NY$150K – $200K/yr

Trexquant Investment LP is hiring a Senior Data Engineer to build and maintain the data infrastructure powering its quantitative research platform.

Why similarSame roleLinuxNew York

Get new Data Engineer jobs in New York by email

Create job alert

Data Engineer

Omnicom · $50K – $95K/yr

Apply on company site