Agency:Initiative
Job Function:Data and Analytics
Job Subfunction: Data Engineering
Job Description: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 PHD 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 PHD 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 manage 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 Management tools and processes
- Keeps up to date on digital Management - 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 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
Account Data Ops Leadership
- Will be the Data Management lead across several accounts, providing leadership, data management, data accuracy and opportunity identification
- Accountable to the team leadership and requirements to drive improvement and growth on the accounts
- Working with more junior team members to facilitate the timely delivery of accurate, quality, usable, and accessible data for various performance use cases
SKILLS & EXPERIENCE- Minimum 10 years' experience in data management, data engineering, data operations and/or business intelligence
- Minimum 8 years' experience in advertising agency
- Minimum 8 years' experience in digital media data (Ad Server, digital, search, social, video, offline, etc.)
- Minimum 8 years' experience in an agile development environment
- Minimum 8 years' experience in management role
- Minimum 8 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
TOOLS - Business Intelligence: Advanced Excel (required), Tableau, PowerBI, Datorama, Looker/Looker Studio, 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
$190,000 - $200,000
To the extent permissible by local law, 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.