Business Overview IPG Mediabrands is the media and marketing solutions division of Interpublic Group (NYSE: IPG). IPG Mediabrands manages over $47 billion in marketing investment globally on behalf of its clients across its full-service agency networks UM, Initiative and Mediahub and through its award-winning specialty business units Healix , Kinesso , MAGNA , Mediabrands Content Studio, Orion Holdings, Rapport, and the IPG Media Lab. IPG Mediabrands clients include many of the world s most recognizable and iconic brands from a broad portfolio of industry sectors including automotive, personal finance, consumer product goods (CPG), pharma, health and wellness, entertainment, financial services, energy, toys and gaming, direct to consumer and e-commerce, retail, hospitality, food and beverage, fashion and beauty. The company employs more than 18,000 diverse marketing communication professionals in more than 130 countries. Learn more at www.ipgmediabrands.com . Position Summary We are looking for experienced Data Engineer to manage in-progress and upcoming data infrastructure projects. The candidate will be responsible for expanding and optimizing our data and data pipeline architecture, as well as optimizing data flow and collection for cross functional teams. The ideal candidate is an experienced data pipeline builder using Python and data wrangler who enjoys optimizing data systems and building them from the ground up. They must be self-directed and comfortable supporting the data needs of multiple teams, systems and products. Responsibilities Create and maintain optimal data pipeline architecture, assemble large, complex data sets that meet functional / non-functional business requirements using Python and SQL / AWS / Snowflakes. Identify, design, and implement internal process improvements through automating manual processes using Python, optimizing data delivery, re-designing infrastructure for greater scalability, etc. Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL / AWS / Snowflakes technologies. Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency and other key business performance metrics. Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs. Keep our data separated and secure across national boundaries through multiple data centers and AWS regions. Work with data and analytics experts to strive for greater functionality in our data systems Required Skills Experience Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases. Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement. Strong analytic skills related to working with unstructured datasets. Build processes supporting data transformation, data structures, metadata, dependency and workload management. A successful history of manipulating, processing and extracting value from large, disconnected datasets. Desired Skills Experience 3+ years of experience in a Python Scripting and Data specific role, with bachelors degree. Experience with data processing and cleaning libraries e.g. Pandas, numpy, etc., web scraping/ web crawling for automation of processes, API s and how they work. Debugging code if it fails and find the solution. Should have basic knowledge of SQL server job activity monitoring and of Snowflake. Experience with relational SQL and NoSQL databases, including PostgreSQL and Cassandra. Experience with most or all the following cloud services: AWS, Azure, Snowflake, Google Strong project management and organizational skills. Experience supporting and working with cross-functional teams in a dynamic environment. We See You At IPG Mediabrands, we are unified behind a commitment to fostering a culture of inclusion and belonging. Together, we shine through a set of shared values and behaviors. We take pride in our responsibility to our clients, communities, and to each other. We embrace differences and recognize the unique value that each of us brings to our community. We encourage you to apply, as unique backgrounds, perspectives, and lived experiences are welcomed. We See You at IPG Mediabrands. About IPG Mediabrands IPG Mediabrands is the media and marketing solutions division of Interpublic Group (NYSE: IPG). IPG Mediabrands manages over $47 billion in marketing investment globally on behalf of its clients across its full-service agency networks UM, Initiative and Mediahub and through its award-winning specialty business units Healix , Kinesso , MAGNA, Mediabrands Content Studio, Orion Holdings, Rapport, and the IPG Media Lab. IPG Mediabrands clients include many of the world s most recognizable and iconic brands from a broad portfolio of industry sectors including automotive, personal finance, consumer product goods (CPG), pharma, health and wellness, entertainment, financial services, energy, toys and gaming, direct to consumer and e-commerce, retail, hospitality, food and beverage, fashion and beauty. The company employs more than 18,000 diverse marketing communication professionals in more than 130 countries. Learn more at www.ipgmediabrands.com .

Position Summary In this role, you will be a part of the centralized global office based in India and work closely with each of our markets globally to understand the clients communication objectives, access multiple data sources and visualize it using Tableau / Datorama, support on of ETL process using MSSQL / Alteryx Flow and has sound knowledge of Excel VBA. Responsibilities Own the design, development, and maintenance of ongoing metrics, reports, analyses, dashboards on the key drivers of our business. Partner with operations/business teams to consult, develop and implement KPIs, automated reporting/process solutions and data infrastructure improvements to meet business needs. Enable effective decision making by retrieving and aggregating data from multiple sources and compiling it into a digestible and actionable format. Manage on-time delivery of regular client reports including: Building reports from data warehouse. Review of completed reports for anomalies discrepancies. Troubleshooting data issues/discrepancies. Ensure formatting delivery parameters are met. Updating Tableau dashboards and Excel Dashboard as required for daily/weekly client reporting. Investigate and understand the opportunities of new data sources in the context of integration into Tableau. Updating Tableau/Excel/ or any similar dashboards for daily/weekly client reporting. Support data cleansings manipulation process including but not limited to: Taxonomy classification Conversion re-naming, grouping Removal of test/ghost impressions Required Skills Experience Minimum 2+ years of experience in Analytics Strong verbal/written communication and data presentation skills, including an ability to effectively communicate with both business and technical teams. Hands on experience in creating complex Excel reports, SQL Queries joining multiple datasets Data Visualization tools such as Quick Sight / Tableau / Power BI / Datorama An ability and interest in working in a fast-paced, ambiguous and rapidly changing environment Experience in developing requirements and formulating business metrics for reporting, familiarity with data visualization tools, e.g. Tableau, Power BI Willingness to work in night shifts Desired Skills Experience Experience in Adtech industry will be preferred.

In this role, you will work closely with members of the Programmatic Team to successfully execute, manage, report and optimize programmatic campaigns on multiple platforms across the global Mediabrands. Responsibilities Campaign Implementation Manage the end-to-end process from brief through to set up, tagging and optimization to ensure report metrics are fully captured Strategize and execute campaigns on our platform and ensure optimal delivery and performance Analyze campaign data to develop insights and strategies for campaign optimization Provide in-depth campaign insights and optimization recommendations for campaign improvement Provide guidance to junior members of the team Be creative: develop and share test and learn campaign optimization strategies to drive learnings and better campaign performance Become a trusted advisor and expert within the programmatic trading field Take an active role in developing broader programmatic strategic recommendations and best practices Get the programmatic newest develop trends in global and local market to build new product and service package for local business Be responsible for the client service and campaign management/operation to achieve the successful programmatic campaign delivery within KPI Maintain good relationship with the partners including Media partners, DSP, Data partner, AD verification Strategy Provide recommendations to your Client Services team for use in brief responses. Present industry updates and campaign optimizations to Working with Senior Campaign Manager and Programmatic to execute tests within the DSPs. Update the industry benchmarks according to the Media Plans received. Required Skills & Experience 8 years professional experience in a related field with hands on end-to-end Programmatic ecosystem/campaign lifecycle and optimization experience along with Team handling capabilities Hands on experience and knowledge in programmatic trading Deep understanding of DSPs/SSPs, RTB, ad exchanges, DMPs, audience targeting, Ad Verification Partners Experience in campaign implementation, optimization and reporting, experience with response driven/demand generation campaigns Understanding of the digital media ecosystem and technology including ad tagging and site analytics Knowledge and passion for overall digital marketing crafts: digital display, digital branding, digital direct response, SEM, video & mobile Must be able to work in a fast-paced environment - harvest vast amounts of information, news, data, and research and distil the most important/relevant information for your agency team and their clients Well organized and capable of managing your time effectively A good communicator with great listening and interpersonal skills Motivated by working in a fast-paced environment where you are constantly learning and will have a career path in talent acquisition