Reporting & Insights - Analyst

Annalect, Omnicom Media Group India Private Limited.

Pune

On-site

INR 600,000 - 1,000,000

Full time

2 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Omnicom Global Solutions in Pune is seeking an Analyst in Data Solutions to drive data-driven decisioning for top brands in marketing and communications. You will develop and automate reports, validate data, and transform data from multiple sources to generate insights.

The role emphasizes data governance, dashboard design, and collaboration with teams and clients, requiring 3–5 years in data management in the media domain and strong SQL/ETL experience.

Qualifications

  • 3–5 years hands-on experience in data management and analysis within the Media domain.
  • Experience in Advertising, Marketing, and/or Media industry with analytical context.
  • Strong SQL skills for data querying and manipulation along with ETL concepts and experience building scalable data pipelines.
  • Experience working in ETL tools like Adverity, Alteryx.
  • Data visualization expertise using Power BI or Tableau.
  • Strong Microsoft Excel skills and presenting data using MS PowerPoint or similar tools.

Responsibilities

  • Reporting & Analytics: Develop, automate, and maintain recurring reports and dashboards for operational and business performance tracking.
  • Data Management & Visualization: Design, manage, and optimize dashboard templates and Excel-based tools; work with large data sets.
  • QA and governance: Maintain QA plans, ensure data quality, secure access, and document processes.
  • Collaboration: Drive conversations with team, client, and business stakeholders.

Skills

SQL
ETL concepts
Power BI
Tableau
Excel

Tools

Adverity
Alteryx

Job description

Overview

About Omnicom Global Solutions

Omnicom Global Solutions (OGS) is Omnicom's integrated solutions engine, bringing together a global talent community and connected capabilities to build adaptive, future-ready solutions.

As an integral part of Omnicom, the world's leading marketing and sales company, OGS helps agencies and clients navigate what's next through expertise spanning Media, Data & Analytics, Technology, Creative, Strategy & Insights, MarTech, Commerce, Healthcare, and Business Support Solutions.

With over 8,000 professionals across India, the Philippines, and Colombia, and a growing global footprint, OGS combines deep domain expertise with scaled delivery to drive innovation, accelerate growth, and create meaningful business impact.

At OGS, the future is tested, built, and scaled every day for some of the world's most ambitious agencies, brands, and clients.

Let’s build what’s next.

Responsibilities

Role Overview: We have an exciting role of Analyst in Data Solutions to drive data-driven decisioning in the marketing and communication space for some of the best brands in the world

Roles & Responsibilities:

Reporting & Analytics

  • Develop, automate, andmaintainrecurring reports and dashboards for operational and business performance tracking.
  • Collect,validate, and transform data from multiple sources to generateaccurateinsights.
  • Conduct trend, variance, and KPI analysis to identify opportunities and highlight risks.
  • Document reporting processes and ensure consistency and backup procedures are in place.

Data Management & Visualization

  • Design, manage, and optimize dashboard templates and Excel-based tools.
  • Work with large data sets to ensure quality, accuracy, and timeliness of insights.
  • QA process: Maintain, create and re-view QA plans for deliverables to align with the requirements, identify discrepancies if any and troubleshoot issues.
  • Apply data governance principles to ensure secure access and appropriate usage of data.
  • 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

Required Qualifications

  • 3-5 years of hands-on experience in data management and analysis within the Media domain, demonstrating strong problem-solving capabilities
  • Experience in Advertising, Marketing, and/or Media industry with ability to apply industry context to analytical work would be preferred
  • Strong SQL skills for data querying and manipulation along with strong ETL concepts and experience building scalable data pipelines
  • Experience working in ETL tools like Adverity, Alteryx
  • Data visualization expertise using Power BI or Tableau or Salesforce MCI or any other relevant BI tool
  • Strong working knowledge of Microsoft Excel (including advanced formulas and data analysis) and presentation skills using MS PowerPoint or similar platforms

Preferred Qualifications

  • Ability to work in dynamic team environments, manage multiple concurrent projects, and meet tight deadlines
  • Strong analytical ability and logical reasoning with ability to work with large, complex datasets
  • Ability to create compelling data-driven stories from complex datasets that communicate business insights effectively
  • Proven ability to maintain positive client relationships, ensuring satisfaction and collaboration

Experience collaborating across teams to implement change initiatives and drive business solutions

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Reporting & Insights - Analyst
Reporting & Insights - Analyst

Omnicomglobalsolutions • Pune

On-site
INR 550,000 - 1,000,000
Reporting & Insights - Specialist
Reporting & Insights - Specialist

Annalect, Omnicom Media Group India Private Limited. • Bengaluru

On-site
INR 900,000 - 1,500,000
Product Enablement - Analyst
Product Enablement - Analyst

Annalect, Omnicom Media Group India Private Limited. • Pune

On-site
INR 900,000 - 1,500,000
Product Enablement - Analyst
Product Enablement - Analyst

Omnicomglobalsolutions • Pune

On-site
INR 800,000 - 1,200,000
Reporting & Insights - Lead
Reporting & Insights - Lead

Annalect, Omnicom Media Group India Private Limited. • Bengaluru

On-site
INR 1,600,000 - 2,200,000
Reporting & Insights - Associate
Reporting & Insights - Associate

Annalect, Omnicom Media Group India Private Limited. • Bengaluru

On-site
INR 420,000 - 620,000
Reporting & Insights - Specialist
Reporting & Insights - Specialist

Annalect, Omnicom Media Group India Private Limited. • Hyderabad

On-site
INR 2,500,000 - 4,000,000
Reporting & Insights - Specialist
Reporting & Insights - Specialist

Omnicomglobalsolutions • Hyderabad

On-site
INR 1,500,000 - 3,000,000
Reporting & Insights - Analyst
Reporting & Insights - Analyst

Annalect, Omnicom Media Group India Private Limited. • Bengaluru

On-site
INR 1,200,000 - 1,800,000
Reporting & Insights - Associate
Reporting & Insights - Associate

Omnicomglobalsolutions • Bengaluru

On-site
INR 1,200,000 - 1,800,000