Reporting & Insights - Analyst

Omnicomglobalsolutions

Pune

On-site

INR 550,000 - 1,000,000

Full time

2 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Omnicom Global Solutions in Pune is seeking an Analyst in Data Solutions to drive data-driven decisioning in the marketing space for global brands. You will develop reports and dashboards, transform data from multiple sources, and perform KPI analysis to uncover opportunities.

The role emphasizes data governance, dashboard design in Power BI/Tableau, and collaboration with teams and clients to translate insights into actionable recommendations, with a focus on scalability and data quality.

Qualifications

  • 3-5 years of hands-on data management and analysis experience within the Media/Advertising domain.
  • Experience in Advertising, Marketing, and/or Media industry with ability to apply industry context to analytical work.
  • 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 BI tool.
  • Strong working knowledge of Microsoft Excel and presentation skills using MS PowerPoint or similar platforms.

Responsibilities

  • Develop, automate, and maintain recurring reports and dashboards for operational and business performance tracking.
  • Collect, validate, and transform data from multiple sources to generate accurate insights.
  • Conduct trend, variance, and KPI analysis to identify opportunities and highlight risks.
  • Document reporting processes and ensure consistency and backup procedures are in place.
  • Design, manage, and optimize dashboard templates and Excel-based tools.
  • QA processes: maintain QA plans for deliverables, ensure data governance and troubleshoot issues, and drive conversations with team and stakeholders.

Skills

SQL
ETL concepts
Data visualization
Excel skills
KPI analysis
Data storytelling

Tools

Power BI
Tableau
Adverity
Alteryx
Salesforce MCI

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

Annalect, Omnicom Media Group India Private Limited. • Pune

On-site
INR 600,000 - 1,000,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. • Bengaluru

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

Annalect, Omnicom Media Group India Private Limited. • Bengaluru

On-site
INR 1,200,000 - 1,800,000
Product Enablement - Analyst
Product Enablement - Analyst

Omnicomglobalsolutions • Pune

On-site
INR 800,000 - 1,200,000
Product Enablement - Analyst
Product Enablement - Analyst

Annalect, Omnicom Media Group India Private Limited. • Pune

On-site
INR 900,000 - 1,500,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 - Specialist
Reporting & Insights - Specialist

Omnicomglobalsolutions • Hyderabad

On-site
INR 1,500,000 - 3,000,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 - Associate
Reporting & Insights - Associate

Omnicomglobalsolutions • Bengaluru

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