Overview We are an integral part of Annalect Global and Omnicom Group one of the largest media and advertising agency holding companies in the world Omnicom s branded networks and numerous specialty firms provide advertising strategic media planning and buying digital and interactive marketing direct and promotional marketing public relations and other specialty communications services Our agency brands are consistently recognized as being among the world s creative best Annalect India plays a key role for our group companies and global agencies by providing stellar products and services in areas of Creative Services Technology Marketing Science data analytics Market Research Business Support Services Media Services Consulting Advisory Services We currently have 2500 awesome colleagues in Annalect India who are committed to solve our clients pressing business issues We are growing rapidly and looking for talented professionals like you to be part of this journey Let us build this together Responsibilities Partner with internal and external client in their desire to create best-in-class data analytics to support their business decisions Be a passionate champion of data-driven marketing and create a data and insight-led culture across teams Requirement gathering and evaluation of clients business situations in order to implement appropriate analytic solutions Data management and reporting using different tools and techniques like Alteryx Datorama SQL R Python etc Strong knowledge on the media metrics custom calculations and metrics co-relation Data visualization using tools like Datorama Tableau Power BI Data studio etc Ability to identify and determine key performance indicators for the clients QA process Maintain create and re-view QA plans for deliverables to align with the requirements identify discrepancies if any and troubleshoot issues Responsible for maintaining the reporting requirements as per the delivery cadence defined by the client Create and maintain project specific documents such as process quality learning documents Able to work successfully with teams handling multiple projects and meeting client expectations Qualifications 3 to 5 years experience in data management and analysis in Media or relevant domain with robust problem-solving ability Good analytical ability and logical reasoning Strong knowledge and working experience in Advance SQL Redshift Alteryx Tableau Media knowledge Data modeling and Advance excel is mandatory skills to have Adverity and Python are good to have Strong excel skills Vlookups Pivot Tables Macros and other advanced functions Hands on experience and strong knowledge on the media metrics custom calculations cloud exposure and metrics co-relation is good to have Strong written and verbal communication Familiarity working with large data sets and creating cohesive stories Understanding of media domain and channels like Display Search Social Competitive is good to have skill Experience of creating tables in database like AWS Google Big Query etc Familiarity with data platforms like Double Click Campaign Manager DV360 SA360 MOAT IAS Facebook Business Manager Twitter Innovid Sizmek Kenshoo Nielsen Kantar MediaMath Prisma AppNexus