Reporting & Insights - Lead

Job Description

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 are growing rapidly and looking for talented professionals like you to be part of this journey. Let us build this, together . Responsibilities Requirement gathering and evaluation of clients’ business situations in order to implement appropriate analytic solutions. Designs, generates and manages reporting frameworks that provide insight as to the performance of clients’ marketing activities across multiple channels. Be the single point of contact on anything data & analytics related to the project. QA process: Maintain, create and re-view QA plans for deliverables to align with the requirements, identify discrepancies if any and troubleshoot issues. Prioritize tasks and proactively manage workload to ensure timely delivery with high accuracy. Active contribution to project planning and scheduling. Create and maintain project specific documents such as process / quality / learning documents. Should be able to drive conversation with team, client and business stake holders Qualifications 6-9 years' experience in data management and analysis in Media or relevant domains with strong problem-solving ability. Mandatory to have Strong SQL skills with Good Exposure on ETL capabilites like Alteryx and Visualization skills in Tableau and storytelling capabilites. Prior knowledge of media/advertising domain would be beneficial Good to have Datorama API Capability (Not Mandate), Good Media domain Knowledge is good to have Prior experience in AWS(S3 and Redshift), GBQ is good to have. Exposure to other ETL tools is good to have. Strong knowledge on media metrics, custom calculations, and metrics co-relation Ability to identify and help determine key performance indicators for the clients. Strong written and verbal communication skills. Led delivery teams and projects to successful implementations Familiarity working with large data sets and creating cohesive stories. Able to work and lead successfully with teams, handling multiple projects and meeting timelines. Maintaining positive client and vendor relationships. Presentation skills using MS Power Point or any presentation platforms