Agency:Omnicom Media
Job Function:Data and Analytics
Job Subfunction: Data Engineering
Job Description:Administrative & Departmental Development
- Administrative & Departmental Development
- Works with Senior Data Management leadership and executive team to establish agency-level standard Data Management practices and thought leadership. Oversees application of such standards across all agency accounts
- Participates in business pitches. Serves as the subject matter expert on data Management and business intelligence topics and their potential applications to address client business needs
- Writes client statement of work (SOW) and/or service-line agreements (SLA) during contract negotiations, re-negotiations and/or renewals
- Works with agency finance, OMG and Annalect India leadership to establish resource rate cards, platform costs and various business engagement requirements
- Staffing accounts according to client business requirements and anticipates future needs. Interviews and hires new employees
- Serves as the escalation contact to address critical business issues and have tough conversations with internal teams and clients. Supports development of short-term plans to prioritize needs and resolve urgent issues
- Constantly analyze employee time utilization to minimize over-burns and ensure employee hours are properly scoped to the right projects
- Periodically evaluates and re-evaluates new and existing business intelligence tools/platforms to ensure they meet the changing requirements of media data and organizational best practices
Data Management & Strategy
- Establishes departmental data strategy and data solutions. Defines standards and best practices for data ingestion, data harmonization, data storage, data governance and dashboard visualization
- Acts as the subject matter expert for projects relating to data quality and business rules. Demands best practices are being followed by onshore and offshore data teams amongst all projects
- Collaborate with Media/Ad Ops to establish agency taxonomy naming convention standards, adoption strategy and execution workflow. Actively promote the use of technology to standardize taxonomy creation and implementation
- Leads and manages cross-functional and cross-organizational teams to understand complex data issues involving multiple systems, establish priorities, develop improvement plans, allocate resources, and implement solutions
- Works with and promotes the adoption of new and existing in-house media Data Operations tools and processes
- Keeps up to date on digital operations - buy changes, creative specifications, etc.
Data Governance & Documentation
- Leads the development of a comprehensive departmental data management and integrity program, including being accountable on cross-account adoption of a coordinated governance process
- Provides consultation for junior employees to ensure industry data standards are appropriately utilized and leveraged to drive data quality and compliance and to ensure impact is minimized, mitigated appropriately
- Drives cross-discipline documentation process and create standardization for validating the implementation, optimization, and reconciliation of all campaign data
- Oversees documentation of processes, workflows, and technical implementations of any project. Proactively identifies, proposes, and generates targeted solutions for data quality issues and operational inefficiencies
People & Project Management
- Supervise Directors and Managers to perform data operations, data quality assurance, and client management tasks. Provides guidance to team members and nurtures/promotes team environment
- Accountable for growth of direct reports. Tailor client-, agency- and personal goals to develop and emphasize strengths of each direct report
- Acts as liaison between agency internal team leads, onshore and offshore data operations teams to improve the collaboration process for validating the implementation, optimization, and reconciliation of all campaign data
- Fosters positive relationships and works with internal teams (Client Business Lead, Strategy, Digital Investment, Programmatic, Search, Social).
- Communication of roles, responsibilities and expectations in an effective manner and clear department RACIs
- Creates and manages project timelines and tasks in project management tools such as HIVE and Microsoft Teams.
- Develops effective project plans for new implementation and change logs for on-going data and account management
SKILLS & EXPERIENCE- Minimum 15 years' experience in data management, data engineering, data operations and/or business intelligence
- Minimum 10 years' experience in advertising agency
- Minimum 10 years' experience in digital media data (Ad Server, digital, search, social, video, offline, etc.)
- Minimum 10 years' experience in an agile development environment
- Minimum 10 years' experience in management role
- Minimum 10 years' experience in client facing work
- Experience managing offshore team a big bonus
- Strong verbal and communication skills
- Strong organizational and project management skills
- Can multi-task effectively
- Project scoping experience
- Drives adoption, training, and ownership of departmental requirements & projects
- Naturally curious and a problem-solver, interested in finding solutions and sharing them broadly
TOOLS - Business Intelligence: Advanced Excel (required), Tableau, PowerBI, Looker/Looker Studio, Agentic / AI-based visualization tools, Datorama ,Domo, PowerPoint
- Data Management & Transformation: ETL Tools (Adverity, Datorama), Alteryx, SQL (preferred), Python (nice to have)
- Data Storage/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
$225,000 - $250,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.
