Reporting & Insights - Specialist

Annalect, Omnicom Media Group India Private Limited.

Hyderabad

On-site

INR 2,500,000 - 4,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 is seeking a senior analytics professional to design and deliver client-ready Power BI dashboards and data insights. You will transform data from Excel, CSV, and databases into compelling reports and datastories, collaborating with cross-functional teams across client projects.

The role requires 6+ years of experience, strong SQL skills, and expertise in data visualization and ETL concepts.

Qualifications

  • 6+ years of work experience.
  • Strong understanding of data storytelling principles and visual design best practices.
  • Proficiency in SQL, including writing queries, extracting data, and preparing datasets for reporting and analysis.
  • Experience with data from Excel, CSV files, and relational database sources.
  • Knowledge of basic ETL concepts, data preparation, cleansing, and transformation techniques.

Responsibilities

  • Develop interactive, dynamic dashboards and visualizations using Power BI.
  • Transform data from Excel, CSV files, and database sources into meaningful reporting solutions.
  • Analyse datasets and present insights through datastorytelling and visualization techniques.
  • Support the transition from manual Excel reporting to automated Power BI dashboards.
  • Write and utilize SQL queries to extract, structure, and prepare data for reporting and analysis.
  • Perform basic data transformation and work with ETL-generated datasets as required.
  • Standardize recurring reports and visualizations to improve efficiency.
  • Collaborate with analytics, creative, and design teams to develop engaging, branded outputs.
  • Work across multiple client projects, managing historical datasets to deliver actionable insights.
  • Contribute to evolving reporting capabilities, including more SQL-driven reporting and automation.
  • Showcase strong visualization and storytelling capabilities through a portfolio.

Skills

Power BI
SQL
Data storytelling
Visual design
Excel
ETL concepts

Tools

SQL
ETL

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
  • Develop interactive, dynamic, and client-ready dashboards and visualizations using Power BI.
  • Transform data from Excel, CSV files, and database sources into meaningful reporting solutions.
  • Analyse datasets and present insights through effective datastorytelling and visualization techniques.
  • Support the transition from manual Excel and PowerPoint reporting to automated and refreshable
  • Power BI dashboards.
  • Write and utilize SQL queries to extract, structure, and prepare data for reporting and analysis.
  • Perform basic data transformation and work with ETL-generated datasets as required
  • Apply statistical concepts such as mean, median, confidence intervals, and box plots to supportreporting and interpretation.
  • Standardize recurring reports and visualizations to improve efficiency and reduce manual effort.
  • Collaborate with analytics, creative, and design teams to develop engaging, branded, and client-ready outputs.
  • Work across multiple client projects, managing historical and recurring datasets to deliver actionable insights.
  • Contribute to the ongoing evolution of reporting capabilities, including increased adoption of SQL-driven reporting and automation.
  • Showcase strong visualization and storytelling capabilities through a portfolio of previous work.
Qualifications
  • Good understanding/experience of reporting metrics, critical thinking, understanding of working with multiple data sources
  • 6+ years of work experience
  • Strong understanding of data storytelling principles and visual design best practices.
  • Proficiency in SQL, including writing queries, extracting data, and preparing datasets for reporting and analysis.
  • Experience working with data from Excel, CSV files, and relational database sources.
  • Knowledge of basic ETL concepts, data preparation, cleansing, and transformation techniques.
  • Understanding of statistical concepts such as mean, median, confidence intervals, box plots, and other common analytical measures.
  • Ability to analyse datasets and translate findings into meaningful business insights and recommendations.
  • Experience standardizing recurring reports and developing scalable reporting solutions.
  • Portfolio showcasing Power BI dashboards, data visualization projects, and data storytelling capabilities.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Reporting & Insights - Specialist
Reporting & Insights - Specialist

Omnicomglobalsolutions • Hyderabad

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

Omnicomglobalsolutions • Bengaluru

On-site
INR 1,200,000 - 2,200,000
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

Omnicomglobalsolutions • Bengaluru

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

Annalect, Omnicom Media Group India Private Limited. • Bengaluru

On-site
INR 420,000 - 620,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