Reporting & Insights - Specialist

Omnicomglobalsolutions

Bengaluru

On-site

INR 1,200,000 - 2,200,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 skilled Power BI Analyst to design and maintain dashboards that reveal operational and financial performance. You will develop complex DAX measures, data models, and KPIs while ensuring data accuracy across reporting platforms.

You will automate reporting processes, validate data between Excel and Power BI, and collaborate with stakeholders to translate business needs into insights that drive savings and efficiency.

Qualifications

  • Proven ability to build and validate Power BI dashboards.
  • Experience with advanced DAX measures and calculated columns.
  • Strong Excel skills including Pivot Tables and Power Query.

Responsibilities

  • Develop, maintain, and enhance Power BI dashboards and reports to provide visibility into operational and financial performance metrics.
  • Create and optimize DAX measures, calculated columns, and KPIs to support advanced reporting requirements.
  • Perform complex Excel-based calculations, data analysis, and reconciliations using formulas, Pivot Tables, Power Query, and other advanced functions.
  • Validate and reconcile data between Excel reports and Power BI dashboards, ensuring accuracy, consistency, and integrity across reporting platforms.
  • Collaborate with stakeholders to understand reporting requirements and translate business needs into analytical solutions.
  • Automate reporting processes and recommend efficiency improvements to reduce manual effort and improve data reliability.

Skills

Power BI
DAX
Excel
SharePoint
Power Automate
Data analysis
Stakeholder management

Tools

Power BI
DAX
Excel
SharePoint
Power Automate

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, maintain, and enhance Power BI dashboards and reports to provide visibility into operational and financial performance metrics.
  • Create and optimize DAX measures, calculated columns, and KPIs to support advanced reporting requirements.
  • Perform complex Excel-based calculations, data analysis, and reconciliations using formulas, Pivot Tables, Power Query, and other advanced functions.
  • Validate and reconcile data between Excel reports and Power BI dashboards, ensuring accuracy, consistency, and integrity across reporting platforms.
  • Conduct detailed report quality checks and identify discrepancies, data anomalies, and process improvement opportunities.
  • Manage and maintain reporting documentation and repositories using SharePoint, ensuring effective collaboration and version control.
  • Analyze savings performance across different regions and business units, identifying trends, variances, risks, and opportunities.
  • Monitor regional savings against targets and provide insights on performance drivers, gaps, and corrective actions.
  • Collaborate with stakeholders to understand reporting requirements and translate business needs into analytical solutions.
  • Automate reporting processes and recommend efficiency improvements to reduce manual effort and improve data reliability.
  • Prepare executive-level summaries and presentations highlighting key findings, savings achievements, and business insights.
  • Implement RLS to the dashboard based on different access levels in the organization.
Qualifications
  • Accurate and validate Power BI dashboards.
  • Reconciled Excel and Power BI reporting outputs.
  • Regional savings performance analysis and tracking.
  • Identification of savings opportunities and performance improvement recommendations.
  • Automated and standardized reporting processes.
  • Actionable business insights supporting target achievement and decision-making.
  • Excellent stakeholder management and communication skills.
Tools & Platforms (Required)
  • Power BI (minimum 5+ years of professional experience)
  • Advanced knowledge of DAX (Data Analysis Expressions).
  • Expert-level proficiency in Microsoft Excel, including complex formulas, Pivot Tables, Power Query, and data validation techniques.
  • Experience with SharePoint for document management and collaboration.
  • Strong analytical and problem-solving skills with attention to detail.
  • Ability to validate large datasets and reconcile information across multiple reporting platforms.
  • Knowledge of Power Automate to create flows and automate the process.
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

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
PowerBI Developer
PowerBI Developer

Anthesis Group • Pune District

On-site
INR 1,500,000 - 2,500,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
PowerBi Developer
PowerBi Developer

Anthesis Esp • India

On-site
INR 1,800,000 - 3,200,000
Power BI Lead
Power BI Lead

EXL • Gurugram District, Bengaluru

On-site
INR 3,000,000 - 4,000,000
Senior PowerBI Developer
Senior PowerBI Developer

Anthesis Group • Pune District

On-site
INR 1,500,000 - 2,500,000
Senior Power BI Developer
Senior Power BI Developer

Willware • Bengaluru

Hybrid
INR 2,800,000 - 4,200,000