O

Omnicom Global Solutions

Integrated marketing solutions and analytics hub

Reporting & Insights Associate

Data Engineering +1Posted on Nov 17
Full-timeBengaluru, Karnataka, IndiaNo salary listed

About the Job

Requirements

  • Design, develop, and maintain scalable data pipelines using Snowflake, SQL, Python, and AWS to support data transformation, ETL processes, reporting, and business analytics.
  • Build and optimize SQL queries, data models, and Snowflake data architectures for advanced analytics, attribution modeling, and measurement frameworks.
  • Develop interactive dashboards and data visualizations using Microsoft Power BI and Tableau to track key performance indicators, campaign performance, and return on investment.
  • Implement data validation, testing, and monitoring processes to ensure data quality, integrity, accuracy, and reliability across reporting systems.
  • Translate business and analytics requirements into scalable data models, automated workflows, and efficient data engineering solutions.
  • Optimize data pipelines and query performance using SQL optimization, Python automation, and Snowflake performance management practices.
  • Collaborate with business stakeholders, analysts, and marketing teams to deliver data-driven solutions aligned with organizational objectives.
  • Build and maintain reporting datasets and dashboards supporting campaign measurement, performance tracking, attribution analysis, and business decision-making.
  • Apply data storytelling and visualization techniques to transform complex datasets into actionable insights and communicate findings to stakeholders.
  • Support data architecture, workflow orchestration, and ETL/ELT development to improve data accessibility, reporting efficiency, and analytics scalability.
  • Leverage consumer and marketplace data to analyze business trends, evaluate campaign effectiveness, and identify opportunities to improve performance and return on investment.
  • Follow data governance, documentation, and automation best practices to maintain reliable, scalable, and maintainable data solutions.

Responsibilities

  • Design, develop, and maintain scalable data pipelines using Snowflake, SQL, Python, and AWS to transform raw data into reliable, structured datasets for analytics and reporting.
  • Develop and optimize Snowflake data architectures and data models supporting advanced analytics, attribution modeling, and measurement frameworks.
  • Ensure data quality, integrity, and availability through validation, testing, and monitoring across data pipelines and reporting systems.
  • Translate business requirements into efficient data models, SQL queries, and scalable data engineering solutions in collaboration with analytics and business teams.
  • Monitor and optimize pipeline performance through SQL query optimization, Snowflake warehouse management, and AWS-based automation.
  • Manage data dependencies, streamline workflows, and deliver data engineering projects on schedule with cross-functional teams.
  • Build reliable data foundations for attribution modeling, performance measurement, and actionable business insights.
  • Use consumer and marketplace data to develop interactive dashboards and reports in Power BI and Tableau for data-driven decisions and business performance monitoring.

Desired Qualifications

  • B.Tech/BE in Computer Science, Information Technology, Engineering, or a related technical field.
  • An MBA in Business Analytics, Information Systems, Marketing, or a related discipline.
  • 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.

About the Company

Omnicom Global Solutions

Integrated marketing solutions and analytics hub

OGS is an embedded delivery hub within Omnicom that coordinates media, data, analytics, creative services, martech, digital commerce, and AI through a global India-based team of 5,500+. It operates via the Omni AI-driven marketing intelligence platform to move from audience insight to activation in a single workflow, reducing friction and enabling faster, data-led solutions at enterprise scale. Unlike agencies that stitch services from separate vendors, OGS unifies these capabilities under one umbrella to drive top-line growth for clients. Its goal is to provide integrated, technology-enabled marketing solutions across Omnicom’s network, simplifying collaboration and delivering measurable business outcomes.

Company size
1,001-5,000
Company stage
Not listed
Total funding
Not listed
Headquarters
Not listed
Founded
2012

Recently Posted Jobs

Explore more opportunities at Omnicom Global Solutions

See more jobs