Senior Data Engineer

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

📋 Description

• Design, construct, and enhance 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.

• Develop ETL/ELT workflows to convert raw data into datasets ready for analytics.

• Create data models aimed at optimizing campaign performance, analyzing supply, allocating supply, and maximizing profit.

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

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

• Provide support to 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.

• More than 2 years of experience working with programmatic advertising and ad-tech data (GAM).

• Strong expertise in Python and SQL.

• Hands-on experience with data warehouses: BigQuery, Snowflake, Redshift, ClickHouse.

• Familiarity with batch processing frameworks: Spark, dbt, Airflow.

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

• Experience with cloud platforms: AWS, GCP.

• Proficiency in infrastructure-as-code.

• Availability to work partial US hours, specifically until 2pm ET.

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

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

• Knowledge of revenue metrics including CPM, eCPM, RPM, fill rate, win rate, and bid density.

• Understanding of auction analytics such as bid landscape, floor optimization, and timeout analysis.

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

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

• Experience with Apache Spark, dbt, and Apache Flink.

• Experience with BigQuery, Snowflake, ClickHouse, and Redshift.

• Experience utilizing Airflow, Dagster, and Prefect.

• Familiarity with S3, GCS, Delta Lake, and Parquet.

• Experience with AWS, GCP, Terraform, and Kubernetes.

• Experience in 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.

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

🏝️ Benefits

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

• English language courses.

• Opportunities for professional growth.

• Team-building events.

• Flexible working hours.

• 29 days of PTO (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.

• Security ensured through client vetting and reliable, timely payments.

• Career support and assistance in finding new project opportunities.