Data Engineer, GCP
NucleusTeq
AirflowBigQueryGoogle Cloud PlatformHadoopMySQLNoSQLPySparkPythonSparkSQL
Lead Analyst, Exchange Optimization
OpenX
full-time
Posted on:
Origin: • 🇺🇸 United States
Visit company websiteSalary
💰 $127,500 - $142,500 per year
Job Level
Senior
Tech Stack
AirflowBigQueryCloudETLGoogle Cloud PlatformPythonSQL
About the role
- 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
Similar jobs on JobTailor
Analytics Engineer, People Data
OpenAI
AirflowBigQueryCloudPythonSQLTableau
Data Engineer, Team Lead
Deloitte
AirflowBigQueryCloudETLJavaPythonScalaSparkSQL
Data Engineer
Ford Motor Company
AirflowBigQueryCloudGoogle Cloud PlatformPythonSQLTerraform
Data Engineer, Java
NucleusTeq
AirflowBigQueryCassandraCloudETLGoogle Cloud PlatformHadoopHBaseJavaJenkinsKafkaMicroservices+9 more