| Location | Chicago, New York |
Agency:
Hearts & ScienceJob Function:
Data and AnalyticsJob Subfunction:
Data EngineeringJob Description:
JOB DESCRIPTION
DataStrategy & Governance: Direct the development, implementation, and maintenance of datastrategies, quality standards, business rules, and governance processes for diverse client accounts and media channels.
Project & Process Leadership: Oversee the creation and management of project plans, assign and prioritize tasks, and ensure standardized processes. Facilitate regular status meetings, proactively resolve roadblocks, and drive initiative progression in a fast-paced, agile environment.
Cross-Functional Collaboration: Act as liaison among internal teams (Strategy, Digital Investment, Planning, Analytics, Finance), offshore resources, external vendors, and clients. Foster positive working relationships and effectively communicate roles, responsibilities, and expectations.
DataQuality & Problem Solving: Supervise investigation and resolution of dataintegrity issues, define/implement business rules for datacleansing and QA, and ensure best practices in all dataand technology projects.
Technical Solution Oversight: Advise on or lead the deployment of business intelligence tools, datawarehousing, ETL processes, and automation initiatives. Champion adoption of new technology and process solutions, ensuring datais the backbone for all media and analytics disciplines.
Team Leadership: Supervise and mentor Managers, Senior Analysts, and Analysts; cultivate a supportive, growth-oriented environment. Guide teams in Data Management, quality assurance, and client management tasks.
SKILLS & EXPERIENCE
5–7 years’ experience in data management, data engineering, Data Management and/or business intelligence
3–5 years’ experience in digital media data(ad server, digital, search, social, video, offline, etc.)
3–5 years’ experience in agile development environments
3–5 years’ experience in client-facing work and managing offshore or cross-functional teams
4+ years’ experience in datagovernance and quality processes within datawarehousing, ETL, and BI environments
5+ years’ experience in business analysis or related disciplines
In-depth expertise across digital and traditional media channels and handling diverse datasets (paid, owned, etc.)
Demonstrated ability to diagnose, escalate, and solve complex dataquality and operational issues
Outstanding organizational and project management skills
Comfortable multitasking and adapting to fast-evolving needs
Superior attention to detail, with excellent verbal and written communication skills
Proven ability to build relationships across internal teams, vendors, and clients
Comfort and accuracy working with budgets and large sets of numerical data
Media industry experience highly preferred
TOOLS
Business Intelligence: Advanced Excel (required), Tableau, PowerBI, Datorama, Looker/Looker Studio, Domo, PowerPoint
DataManagement & Transformation: ETL Tools (Adverity, Datorama), Alteryx, SQL (preferred), Python (nice to have)
DataStorage/Cloud: Snowflake, AWS (Redshift, S3), Starburst.io, Datorama, Domo
Media Platforms: DCM, DV360, Google Ads, DoubleVerify, IAS, TradeDesk, Facebook, Instagram, Snapchat, Twitter, TikTok, Prisma
Project Management: HIVE, Asana, Smartsheet, Microsoft Teams
Media Planning: MediaTools, Lumina, Hudson (bonus)
Other: Experience with writing business and technical requirements documents; comfort with business rules design and BI tool administration
$70,000 - $125,000
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. Our objective is to increase this requirement over time, and many of our agencies as well as Omnicom’s corporate group already require five days of in-office attendance.
Omnicom is committed to hiring and developing exceptional talent. We agree that talent is uniquely distributed, and we’re focused on developing inclusive teams that can bring the best solutions to everything we do. We strongly believe that celebrating what makes us different makes us better together. Join us—we look forward to getting to know you. We will process your personal data in accordance with our Recruitment Privacy Notice.
Link to Recruitment Privacy Notice: https://www.omc.com/privacy-notice
For US Job Seekers:
It is the policy of Omnicom and any of its affiliates to provide equal employment opportunities to all employees and applicants for employment without regard to race, religion, color, ethnic origin, gender, gender identity, age, marital status, veteran status, sexual orientation, disability, or any other basis prohibited by applicable federal, state, or local law. EOE/AA/M/D/V/F.