Reporting & Insights - Associate
Description
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.
Role Overview:
We are seeking an Associate - Reporting & Insights to join our team. This role is responsible for designing, building, and maintaining scalable data pipelines, developing robust data architectures, and creating interactive dashboards that drive advanced analytics, attribution modeling, and measurement frameworks for our business and analytics teams.
Roles & Responsibilities:
- Designed, developed, and maintained scalable data pipelines using Snowflake, SQL, Python, and AWS to transform raw data into reliable, structured datasets for analytics and reporting.
- Developed and optimized data architectures and data models in Snowflake to support advanced analytics, attribution modeling, and measurement frameworks.
- Ensured data quality, integrity, and availability through robust data validation, testing, and monitoring processes across data pipelines and reporting systems.
- Collaborated with analytics and business teams to translate business requirements into efficient data models, SQL queries, and scalable data engineering solutions.
- Monitored and optimized data pipeline performance through SQL query optimization, Snowflake warehouse management, and AWS-based automation to improve scalability and efficiency.
- Partnered with cross-functional teams to manage data dependencies, streamline workflows, and deliver high-quality data engineering projects on schedule.
- Supported advanced analytics initiatives by building reliable data foundations for attribution modeling, performance measurement, and actionable business insights.
- Leveraged consumer and marketplace data to develop interactive dashboards and reports using Power BI and Tableau, enabling data-driven decision-making and business performance monitoring.
Required Qualifications
- Designed, developed, and maintained scalable data pipelines using Snowflake, SQL, Python, and AWS to support data transformation, ETL processes, reporting, and business analytics.
- Built and optimized SQL queries, data models, and Snowflake data architectures to enable advanced analytics, attribution modeling, and measurement frameworks.
- Developed interactive dashboards and data visualizations using Microsoft Power BI and Tableau to track key performance indicators (KPIs), campaign performance, and return on investment (ROI).
- Implemented data validation, testing, and monitoring processes to ensure data quality, integrity, accuracy, and reliability across reporting systems.
- Translated business and analytics requirements into scalable data models, automated workflows, and efficient data engineering solutions.
- Optimized data pipelines and query performance using SQL optimization, Python automation, and Snowflake performance management best practices.
- Collaborated with cross-functional teams, including business stakeholders, analysts, and marketing teams, to deliver data-driven solutions aligned with organizational objectives.
- Built and maintained reporting datasets and dashboards to support campaign measurement, performance tracking, attribution analysis, and business decision making.
- Applied data storytelling and visualization techniques to transform complex datasets into actionable insights and communicate findings effectively to stakeholders.
- Supported data architecture, workflow orchestration, and ETL/ELT development to improve data accessibility, reporting efficiency, and analytics scalability.
- Leveraged consumer and marketplace data to analyze business trends, evaluate campaign effectiveness, and identify opportunities to improve performance and ROI.
- Followed data governance, documentation, and automation best practices to maintain reliable, scalable, and maintainable data solutions.
Preferred Qualifications
- B.Tech/BE in Computer Science, Information Technology, Engineering, or a related technical field; an MBA in Business Analytics, Information Systems, Marketing, or related discipline is an added advantage.
- Strong proficiency in SQL and Python for data engineering, data transformation, ETL/ELT development, and building and optimizing scalable data pipelines.
- Hands-on experience with Snowflake and AWS for cloud-based data processing, data warehousing, and modern data architecture.
Skills
Sign in to read and join the discussion.