Senior AWS Data Engineer

Omnicom Global Solutions; Bengaluru; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

Omnicom Global Solutions in Bengaluru is seeking a highly technical Data Delivery Engineer to own end-to-end delivery of complex data projects. You will design and implement datalake architectures, integrate multiple marketing platforms, and collaborate with project teams to ensure high-quality outcomes.

The role requires strong AWS expertise, data modelling, SQL, Python, and CI/CD practices. You will contribute to scalable backend solutions and support multi-channel campaign initiatives for

Qualifications

• Strong design and development experience on datalake and database solutions using AWS services.
• Min 5+ Years of experience needed.
• Strong Data Modelling, Database & Data Warehouse analysis and design skills.
• Experience in ETL & Database design and development.

Responsibilities

• Managing delivery of multiple complex simultaneous development projects from design through to release
• Capable of understanding and contributing to the technical solution from design through to code level
• Working closely with Project Managers to produce accurate delivery estimates
• Hands on development and maintenance of CRM database and datalake solutions
• Writing technical specifications, participating in code reviews and meetings, and providing updates on project progress
• Liaising with key stakeholders, client, and other Code departments to facilitate the transition of solution from analysis through to design and delivery
• Attend client meetings if required to discuss and demonstrate solutions at both technical and business level
• System integration of multiple products to build multichannel communications solutions to meet client requirements
• General development and support programming involving investigation of code and data issues.
• Providing training to internal & external personnel
• Ready to learn new skills and technologies required for the job

Skills

AWS services

Datalake design

Data modelling

ETL development

SQL

Python

C# / .NET

Data warehousing

Apache Airflow

Git

Terraform

CI/CD

Tools

AWS Glue

PySpark

Apache Airflow

AWS Lambda

S3

Redshift

Terraform

Git

CI/CD tools

Job description

We are OGS—Omnicom's Integrated Solutions Engine that brings together a global talent community and connected capabilities in data, creative, media, commerce, and technology to build adaptive, future-ready solutions.

We are redefining the global capability center - not as an offshoring hub, but as a true inside edge. OGS is the place where the future is tested, built, and scaled for the world’s most ambitious agencies and clients.

With over 4300+ talented professionals in India, we are proud to be a diverse, inclusive, and collaborative community that thrives on innovation and excellence. Our teams work with some of the world’s most iconic brands, helping them move faster and achieve more—everywhere. We are growing rapidly and looking for passionate individuals to be part of this journey.

Role Summary

We want to make sure that OGS is the first choice for customers for marketing solutions and customer communications. It’s our goal to be seen as the best in class for technical innovation – and the company that delivers a great customer experience for our clients’ customers.

This role sits within the data & technology arm of our business, specifically within the Tech Delivery team.

This role is highly technical and hands-on capable and involves delivering solutions independently and at very high standard.

OGS delivers large scale back end database solutions & implements multi-channel campaign management applications such as Adobe Campaign, Acoustic, Braze and Salesforce Marketing Cloud which are generally hosted and managed by a team of Service Delivery, Campaign Management and email experts. We provide web services around these solutions, integration to web sites, back office systems and deliver anything from simple email templates to more complex website & digital applications as well as stand‑alone tactical digital communication programs in support of our Creative & Media Agency.

YOUR RESPONSIBILITIES

• Managing delivery of multiple complex simultaneous development projects from design through to release
• Capable of understanding and contributing to the technical solution from design through to code level
• Working closely with Project Managers to produce accurate delivery estimates
• Hands on development and maintenance of CRM database and datalake solutions
• Writing technical specifications, participating in code reviews and meetings, and providing updates on project progress
• Liaising with key stakeholders, client, and other Code departments to facilitate the transition of solution from analysis through to design and delivery
• Attend client meetings if required to discuss and demonstrate solutions at both technical and business level
• System integration of multiple products to build multichannel communications solutions to meet client requirements
• General development and support programming involving investigation of code and data issues.
• Providing training to internal & external personnel
• Ready to learn new skills and technologies required for the job

SKILLS AND EXPERIENCE

• Strong design and development experience on datalake and database solutions using AWS services
• Min 5+ Years of experience needed
• Experience in delivery of complex data projects
• Strong Data Modelling, Database & Data Warehouse analysis and design skills
• Experience in ETL & Database design and development
• Data manipulation, exploration, analysis, and data integrity (experience of manipulating data of varied sources and targets like RDBMS, XML, JSON and Flat Files)
• Demonstrated ability to understand and discuss complex technical concepts.
• Knowledge of software development processes including Agile, Lean, Waterfall & V-model
• Commercial experience in technical delivery of projects
• Integration of 3rd party products, such as Adobe Campaign, Acoustic Campaign Automation & Salesforce Marketing Cloud to solutions to enable multi-channel communications
• AWS Glue with PySpark/Python
• AWS Lambda with Python
• AWS Step functions or Apache Airflow
• Amazon S3
• Amazon Redshift and Redshift Spectrum
• Data Analysis and Data Modelling
• Other AWS Services: IAM, CloudWatch, Secrets Manager, Parameter Store
• Experience in development of Datalake on AWS
• Experience in specifying deployment packages on AWS
• Advanced SQL knowledge
• Amazon Athena
• AWS API Gateway
• Amazon Cognito
• Terraform and CI/CD
• Git
• .Net C#
• Web service utilities
• Experience in Adobe Campaign, Salesforce Marketing Cloud or Acoustic Campaign Automation