Lead Analyst, Exchange Optimization

September 23

Apply Now

Receive Emails with Similar Jobs

OpenX

WebsiteLinkedInAll Job Openings

Advertising

OpenX is an independent supply-side platform specializing in ad tech, enabling publishers and advertisers to achieve better ad buying and selling experiences with a focus on addressability, transparency, and sustainability. Established in 2008, OpenX provides omnichannel targeting capabilities across all channels, including CTV, and integrates seamlessly with various data sets and identity types. As the first Net-Zero verified adtech company, OpenX emphasizes responsible media practices, helping clients reduce their environmental impact while supporting social initiatives. They offer a platform that democratizes identity access for marketers, allowing for seamless audience targeting similar to walled gardens. OpenX has established itself as a leader in programmatic advertising, working with high-profile clients to integrate their technology efficiently and effortlessly.

201 - 500 employees

Founded 2008

💰 Secondary Market on 2015-05

📋 Description

• Analyze large-scale exchange data (bid requests, impressions, wins, revenue) to surface actionable insights and optimization opportunities • Design, execute, and evaluate experiments that test hypotheses around traffic shaping, bid filtering, pricing floors, or other monetization levers • Develop and maintain dashboards and recurring reports in SQL and BI tools like Looker to monitor key exchange metrics and alert on anomalies • Partner closely with product, engineering, and data science teams to refine exchange logic and build smarter systems for request routing, deal handling, and QPS allocation • Work collaboratively across demand and supply teams to identify bottlenecks, inefficiencies, and growth opportunities • Focus on identifying and executing optimization opportunities in international regions (EMEA, APAC, LATAM) • Serve as an internal subject matter expert on bid request data quality, ad decisioning paths, and exchange performance drivers • Translate complex data findings into clear narratives and strategic recommendations for cross-functional stakeholders • We offer: A high-scale, cloud-native environment with full access to raw logs and preprocessed data views; Sub-second query performance across billions of records using modern, scalable infrastructure; End-to-end ownership: identify opportunities, run online experiments, and deploy successful changes to production within hours; A culture that values business context, self-agency, and fast iteration over rigid process; The chance to directly shape how one of the largest ad exchanges in the world operates, in real time

🎯 Requirements

• 7+ years of experience in analytics, data operations, or optimization within a high-scale programmatic environment (SSP, DSP, or ad exchange) • Expert-level SQL skills, especially in BigQuery or a similar large-scale data platform • Strong background in data analysis, statistics, or experimentation and able to interpret noisy signals and guide decision-making with evidence • Proven ability to break down complex systems, identify optimization levers, and implement data-driven strategies • Demonstrated ability to manipulate, aggregate, and pivot large datasets for insight discovery • Familiarity with OpenRTB, programmatic auction mechanics, and bidstream signals • Clear communicator who can articulate technical findings to product managers, business leads, and engineers alike, including regional stakeholders across EMEA, APAC, and LATAM • Preferred skills: Analytics & Data Exploration; Skilled in pivoting, aggregating, and slicing large datasets to identify patterns and anomalies; Comfort with exploratory data analysis and ad hoc investigations in SQL-based environments; Relentlessly curious about testing new ideas; Strong ability to summarize and synthesize trends; Experience with Excel/Google Sheets pivot tables, vlookups; Advanced proficiency with Looker (or equivalent) • Programmatic Advertising Expertise: Familiarity with OpenRTB specifications, bid request/response structure, auction flows; Understanding of SSP/DSP mechanics, campaign delivery, win rates, QPS and traffic shaping; Exposure to supply path optimization (SPO), ad quality signals; Basic knowledge of identity frameworks (cookies, IPs, UID2) • Technical Proficiency: Heavy (expert level) SQL; Comfort with BigQuery or similar; Familiarity with structuring analytical pipelines; Comfortable with scripting in Python for ETL or statistical analysis • Bonus: Exposure to Airflow, GCP Dataform • Entrepreneurial problem-solver who thrives in ambiguity and complexity; Strong ownership mentality; Naturally curious; Comfortable operating in lightly structured environments; Thrives in fast-paced setting; Communicates clearly and concisely

🏖️ Benefits

• A summary of our benefits, which include medical, dental, vision, 401k, equity and more, can be viewed here: https://www.openx.com/company/careers/