Senior Data Engineer

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

📋 Description

• Design, develop, and enhance scalable data pipelines for ad servers and related data sources.

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

• Create ETL/ELT workflows to convert raw data into analytics-ready datasets.

• Develop data models for optimizing campaign performance, analyzing supply, allocating supply, and maximizing profits.

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

• Implement data quality assurance, validation, and anomaly detection for data streams.

• Assist Executive, BI, and analytics teams with clean, documented, and efficient data infrastructure.

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

• Process large volumes of data and billions of events to enable real-time analytics and business intelligence dashboards.

⛳️ Requirements

• Over 5 years of professional experience in data engineering.

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

• Strong command of Python and SQL.

• Practical experience with BigQuery, Snowflake, Redshift, or ClickHouse.

• Familiarity with Spark, dbt, or Airflow.

• Understanding of bid requests, impressions, OpenRTB schemas, and log-level data.

• Experience with AWS or GCP and infrastructure-as-code practices.

• Ability to work partial US hours and be available until 2pm ET.

• Knowledge of SSP reporting APIs and log-level data, including Magnite, PubMatic, Index Exchange, and Xandr.

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

• Familiarity with ad-tech revenue metrics, auction analytics, demand partner performance, and supply chain data.

• Scala experience is a plus.

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

• Background in publisher-side monetization data products 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, timely payments.

• Career support and assistance in discovering new opportunities.

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

• English language courses.

• Opportunities for professional growth.

• Team-building activities.

• Flexible working hours.

• 29 days of paid time off (18 working days per year plus 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.