Software Development Engineer, Advanced Analytics - LLD

Build the foundational infrastructure to capture, process, store, and analyze petabyte-scale log-level advertising data — delivering unprecedented transparency into the programmatic supply chain for Amazon's most strategic advertising partners. Your work will directly empower teams to understand auction competitiveness, identify revenue opportunities, optimize floor pricing, and ensure supply chain integrity. We own and operate the premier advanced analytics capability within Amazon Ads, delivering innovative AI, modeling, and data solutions that help Holding Companies, independent agencies, technology integrators, and large-scale advertisers make smarter, faster, and more impactful advertising decisions. Log-level data — granular, non-aggregated, event-level information from ad servers, exchanges, and SSPs — provides advertisers with visibility into individual ad impressions, bid prices, viewability scores, and supply path. This is a greenfield infrastructure challenge at massive scale, and you'll be building it from the ground up. Key job responsibilities - Implement and maintain scalable data pipelines to ingest, process, and store petabyte-scale log-level advertising data from multiple sources (ad servers, exchanges, SSPs) - Build ETL workflows that transform raw event-level data into queryable, analysis-ready formats following established architectural patterns and best practices - Create and maintain APIs that enable analytics teams and data scientists to query log-level data efficiently - Implement data quality checks, validation logic, and monitoring for data pipelines and services - Optimize performance and cost efficiency of data processing jobs and queries - Write clean, well-tested code and participate in code reviews to maintain high engineering standards - Collaborate with senior engineers to contribute to design discussions and architectural decisions - Debug and resolve production issues, participating in on-call rotations as needed - Document systems, processes, and runbooks to support operational excellence