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.
- 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.
Job description provided by Omnicom Global Solutions.
View the original posting