Senior Data Engineer

Senior Data Engineer

At the COOL company, we believe in creating a win-win environment where everyone benefits. We are committed to ensuring users, publishers, franchisees, and advertisers all have a better experience and achieve more than they ever thought possible through our innovation, advanced AI, groundbreaking advertising technology, and teams of inspired experts. Our every move, expansion, acquisition, and upgrade is done to provide that better experience for an ever-growing list of satisfied clients and users all over the world.

COOL Media products under the COOL company include DCO & Creative Automation, a data-driven, creative ad server capable of personalizing, automating, measuring, and optimizing digital ads and placements for advertisers; Franchise & Multi-Location, a complete advertising management platform for franchise and network businesses; Media & Attribution, a managed service solution for agencies and brands to reach and measure audiences; Publisher Experiences, a premier SSP and engagement platform for publishers; and Supply-Side Platform, delivering website and app publishers everything they need to maximize their ad revenue.

Coming soon in 2026, COOL AI is a next-generation advertising platform that builds, buys, and optimizes digital ad campaigns faster and smarter using AI. It automates every step of the media journey—from generating ad creatives to launching campaigns and optimizing performance across channels like Google and Facebook. With no agency fees or waiting, COOL AI helps brands maximize ROI through data-driven strategy, automated creative generation, and real-time performance measurement.

Collectively, the COOL company reaches over 350 million consumers monthly across their network of premium publishers and advertisers, including Disney, Hyundai, Air France, Kohler, Suzuki, Acer, Pearle Vision, Trek, Brita, Viking Cruises, MLB, Playmaker, Blitz, Evolve Media, and more. Under the former umbrella of Insticator, the COOL company is a proud 7x recipient of the Inc 5000 list of America's fastest-growing private companies, a 2x recipient of Deloitte's Fast 500, recognized on Crain's New York Fast 50 list, recognized by Digiday's Digiday Media Awards as a company working to modernize digital media, and awarded as one of AdWeek's Top 10 Fastest Growing Solution Providers globally.

Our Core Values

At the COOL company, we believe in being C.O.O.L.: Creative - we look to find solutions that others can't and new ways of doing things that are smarter, faster, better and more efficient.

Open-minded - we're always evolving and keep an open mind as to new ways of doing things, new solutions and new processes that can help us.

Optimistic - The glass is always half full :) as a growing tech startup we're always faced with new challenges, we overcome them because we see them as opportunities.

Leaders - We look for drivers, people who like to set the pace of the organization, who don't simply go with the flow, you're setting a fast impact pace and holding others to it. We look for speed, impact, and setting the industry benchmark.

We creatively integrate new elements in innovative combinations, fueled by our optimism to drive success. Our open-mindedness allows us to embrace new ideas and approaches, empowering us to lead our industry through bold initiatives. That's the attitude we bring to work with us every day, and it's what we expect from everyone who works here.

That's just part of the values that drive us to greatness. We also believe in this trio of truths that inform every decision we make and everything we do:

• Sleeves Up: At the COOL company, we provide you with the autonomy and creativity needed to own your role. We encourage iteration where necessary so that you can drive massive impact.
• 100% Viewability: the COOL company is passionate about open feedback at all levels of the company. This allows us to fail fast, create in real-time, and build an open company culture.
• Be Defiantly Great: We're defiant, and that's in our blood. Challenging the status quo is a central part of who we are. We're capable of much more than what others deem impossible.

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