Senior Data Engineer

This is a fully remote position, open to applicants in Armenia.

📋 Description

• Design, construct, and improve scalable data pipelines that process ad server and related data.

• Ingest and standardize data from various SSPs, DSPs, ad servers including GAM, and third-party reporting APIs.

• Create ETL/ELT workflows that convert raw data into datasets that are ready for analytics.

• Develop data models aimed at optimizing campaign performance, analyzing supply, managing supply allocations, and maximizing profits.

• Build and sustain data warehouses and data lakes tailored for ad-tech query patterns.

• Implement monitoring, validation, and anomaly detection to ensure data quality across data streams.

• Assist Executive, BI, and analytics teams by providing clean, well-documented, and efficient data infrastructure.

• Guarantee compliance with GDPR and CCPA in data collection, storage, and processing activities.

• Process large volumes of ad server, CRM, and ancillary data to support real-time analytics and business intelligence dashboards.

⛳️ Requirements

• Over 5 years of experience in professional data engineering.

• At least 2 years of experience in programmatic advertising and working with ad-tech data (GAM).

• Strong expertise in Python and SQL.

• Practical experience with data warehouses such as BigQuery, Snowflake, Redshift, and ClickHouse.

• Familiarity with batch processing frameworks like Spark, dbt, and Airflow.

• Understanding of ad-tech data structures, including bid requests, impressions, OpenRTB schemas, and log-level data.

• Experience with cloud platforms such as AWS and GCP.

• Knowledge of infrastructure-as-code practices.

• Ability to work partial hours aligned with US time zones, available until 2pm ET.

• Familiarity with SSP reporting APIs and log-level data from platforms like Magnite, PubMatic, Index Exchange, and Xandr.

• Experience with Google Ad Manager reporting, Data Transfer files, and BigQuery exports.

• Understanding of revenue metrics such as CPM, eCPM, RPM, fill rate, win rate, and bid density.

• Knowledge of auction analytics encompassing bid landscape, floor optimization, and timeout analysis.

• Familiarity with demand partner performance metrics including SSP/bidder scoring, latency analysis, viewability, reach/frequency, and IVT.

• Understanding of supply chain data including ads.txt validation, sellers.json mapping, and SPO analysis.

• Experience with tools like Apache Spark, dbt, Apache Flink, Airflow, Dagster, Prefect, S3, GCS, Delta Lake, Parquet, AWS, GCP, Terraform, and Kubernetes.

• Experience with Scala is a plus.

• Experience in ML feature engineering for bid optimization or yield prediction is a plus.

• Background in developing data products for publisher-side monetization is a plus.

• Familiarity with differential privacy and clean rooms is a plus.

• Experience with CTV/OTT advertising data and video ad metrics is a plus.

• Understanding of identity resolution and cross-device data challenges is a plus.

🏝️ Benefits

• Security through thorough client vetting to reduce risks and ensure reliable and timely payments.

• Career support and assistance in securing new projects.

• Legal assistance regarding independent contractor or sole proprietorship status, taxes, and related processes.

• English language courses.

• Opportunities for professional growth.

• Team-building events.

• Flexible working hours.

• 29 days of paid time off (18 working days per year in addition to all national holidays).

• 10 paid recovery days.

• Comprehensive financial and legal support for independent contractors.

• Free English classes with native speakers or Ukrainian instructors.

• Dedicated HR support.