Job Description

Designation: Associate Experience Required: 6 Months - 2 Years Skills Required: MS Excel / SQL / Alteryx About Annalect India We are an integral part of Annalect Global and Omnicom Group, the second-largest advertising agency holding company in the world in terms of revenue and is the leading global marketing communications company. Our portfolio includes three global advertising agency networks: BBDO, DDB, and TBWA; three of the world\xe2\x80\x99s premium media services under Omnicom Media Group: OMD, PHD, and Hearts & Science. 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) and Media Services. We currently have 2000+ awesome colleagues (in Annalect India) who are committed to solve our clients\xe2\x80\x99 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! This is an exciting role and would entail you to

• End-to-end performance reporting across all media channels
• Data extraction/ ingestion from various platforms and channels.
• Data cleansing & harmonization using ETL tools like Alteryx, Datorama, etc.
• Data Visualization of reports using tools like Tableau, Power BI, and Data Studio
• Collaborate and assist Analysts/Senior Analysts in the team with various analytic tasks
• QA process: QA of client deliverables to align with the requirements, identify discrepancies if any, and troubleshoot issues
• Responsible for maintaining the reporting refresh as per the delivery cadence defined by the client
• Client engagement \xe2\x80\x93 understand requirements and execute reporting accordingly.
• Able to work successfully with teams, handling multiple projects and meeting client expectations
• Work with various tools/platforms to help deliver/automate performance reports
• Create and maintain project-specific and learning documents
• Data extraction/ ingestion from various platforms and channels.
• Data cleansing & harmonization using ETL tools like Alteryx, Datorama, etc.
• Data Visualization of reports

This may be the right role for you if you have

• 1 to 3 years of experience in data management and analysis in Media or relevant domains with strong problem-solving ability.
• Strong written and verbal communication skills.
• Must have good analytical ability and logical understanding/reasoning
• Experience in delivering reports for clients or internal teams.
• Basic Media understanding/Digital marketing certification
• Understanding of data management programs (SQL, Access, etc.)/Programming languages (R, Python)
• Knowledge of data visualization platforms (Tableau, Power BI, etc.) & awareness of media data sources like DCM, Facebook, Twitter, Innovid, Sizmek, Kenshoo, Nielsen, Kantar, Media Math, Prisma, AppNexus, and Amazon Pacing, would be added advantage

Job Type: Full-time Salary: 9340,000.00 - 9400,000.00 per year Benefits:

• Health insurance
• Internet reimbursement
• Leave encashment
• Provident Fund

Schedule:

• Morning shift

Application Question(s):

• How many years of work experience do you have with SQL?
• How many years of work experience do you have with MS Excel?
• What is your current annual CTC?
• What is the notice period at your current company?
• The budget for this role is 3.4\xe2\x80\x934 LPA (5 days working, Monday to Friday). Are you fine with this?

Speak with the employer
+91-XXXXXXXXXX