Senior Data Engineer

The COOL Company; Delhi; On-site; INR 2,500,000 - 4,500,000; Full time

Benefits offered by this job

Competitive Salary

Paid Time Off

Job summary

The COOL Company is seeking a Senior Data Engineer to join the Ad Engineering team, responsible for building and maintaining data pipelines that power our advertising analytics platform and attribution dashboards.

You will work across Snowflake, AWS, and PostgreSQL to ensure reliable ingestion, transformation, and delivery of advertising data from multiple DSPs into reporting systems, while scaling the data layer for international markets.

Qualifications

• 5+ years of experience in data engineering or a related role.
• Proven track record of designing and owning end-to-end data pipelines in production.
• Ability to mentor junior engineers and drive technical decisions on data architecture.

Responsibilities

• Build and maintain ETL/ELT pipelines that ingest advertising data feeds into Snowflake.
• Develop and optimize Snowflake stored procedures for data rollups, attribution calculations, and analytics aggregations.
• Manage AWS Lambda functions for real-time and batch data processing including pixel event ingestion and Snowflake notifications.
• Design and maintain data models in Snowflake to support dashboard reporting, attribution analysis, and Cool AI features.
• Collaborate with the engineering team to integrate new data sources and DSP connections.
• Build and manage S3-based data lake architecture for raw feed storage and processing.
• Implement data quality checks and alerting for pipeline failures or data anomalies.
• Document data flows, schemas, and pipeline architecture.

Skills

Data pipelines

Mentoring

Data architecture

Tools

Snowflake

AWS

PostgreSQL

Node.js

Java

Job description

About The COOL Company

The COOL company is a global leader in AI-powered advertising technology, helping brands, agencies, and publishers simplify advertising and amplify performance.

Powered by COOL AI, our intelligent platform unifies creative generation, media activation, optimization, and attribution into one continuously learning system. Instead of relying on fragmented tools and manual campaign management, COOL AI executes thousands of real-time micro-optimizations across search, social, display, video, and connected TV—helping customers launch faster, optimize continuously, and achieve stronger business outcomes.

Our innovation and growth have earned industry-wide recognition, including being named a 7-time recipient of the Inc. 5000 list of America's Fastest-Growing Private Companies, a 2-time Deloitte Technology Fast 500 honoree, recognized on Crain's New York Fast 50, honored by the Digiday Media Awards for helping modernize digital media, and named one of Adweek's Top 10 Fastest Growing Solution Providers globally.

We're building the future of advertising, where every signal becomes intelligence and every optimization drives performance. As we continue to grow globally, we're looking for curious, ambitious people who want to work with cutting-edge AI technology, solve complex challenges, and help redefine what's possible in modern advertising.

About The Role

We are looking for a Senior Data Engineer to join our Ad Engineering team, reporting to the Engineering Manager (Bi Yoo). This role is responsible for building and maintaining the data pipelines that power our advertising analytics platform, attribution dashboard, and Cool AI product.

The Senior Data Engineer will work across our data infrastructure - including Snowflake, AWS (S3, Lambda, SQS), and PostgreSQL - to ensure reliable ingestion, transformation, and delivery of advertising data from multiple demand-side platforms (Adform, Xandr, Google Ads, Meta) into our reporting and analytics systems.

Challenges and Opportunities

This role sits at the intersection of ad tech and data engineering. You'll work with high-volume programmatic advertising data (impression logs, click streams, conversion events) and build pipelines that directly impact how advertisers measure campaign performance. There is a significant opportunity to shape the data architecture as we expand into new DSP integrations, enhance our attribution methodology, and scale Cool AI's data layer across international markets.

Responsibilities and Duties

• Build and maintain ETL/ELT pipelines that ingest advertising data feeds (Adform master data feeds, Google Ads API, Meta
• Marketing API) into Snowflake
• Develop and optimize Snowflake stored procedures for data rollups, attribution calculations, and analytics aggregations
• Manage AWS Lambda functions (Node.js, Java) for real-time and batch data processing including pixel event ingestion and
• Snowflake notifications
• Monitor and troubleshoot data pipeline health, ensuring data accuracy and freshness across the platform
• Design and maintain data models in Snowflake to support dashboard reporting, attribution analysis, and Cool AI features
• Collaborate with the engineering team to integrate new data sources and DSP connections
• Build and manage S3-based data lake architecture for raw feed storage and processing
• Support SQS-based async workflows for report generation and data processing queues
• Implement data quality checks and alerting for pipeline failures or data anomalies
• Document data flows, schemas, and pipeline architecture

Qualifications

Professional Competencies

• 5+ years of experience in data engineering or a related role
• Proven track record of designing and owning end-to-end data pipelines in production
• Ability to mentor junior engineers and drive technical decisions on data architecture

Cultural Competencies

• Must be able to work primarily between the hours of 9:30 AM - 6:30 PM ET
• Must have a player/coach mentality, willing to both execute and lead
• Ability to juggle multiple projects concurrently and set and meet deadlines
• Skilled at receiving and providing direct feedback
• Collaborative mindset and great teamwork skills
• Entrepreneurial & adaptable; great learning skills
• Curious, research-minded, data-informed
• Able to search for possible solutions and apply them
• Creative confidence
• Proactive communicator
• A sense of humor and a love of online culture
• Thrives in a start-up culture

Benefits

• Competitive Salary
• Paid Time Off