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