Senior Data Engineer

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

📋 Description

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

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

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

• Develop data models aimed at optimizing campaign performance, supply analysis, allocations, and maximizing profit.

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

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

• Provide support to Executive, BI, and analytics teams with clean, well-documented, and efficient data infrastructure.

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

⛳️ Requirements

• Over 5 years of experience in professional data engineering.

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

• Strong skills 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.

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

• Experience with AWS and GCP cloud services.

• Proficiency in infrastructure-as-code.

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

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

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

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

• Knowledge of auction analytics, demand partner performance, supply chain data, ads.txt validation, sellers.json mapping, and SPO analysis.

• Technical knowledge in the stack: Python, SQL, Apache Spark, dbt, Apache Flink, BigQuery, Snowflake, ClickHouse, Redshift, Airflow, Dagster, Prefect, S3, GCS, Delta Lake, Parquet, AWS, GCP, Terraform, and Kubernetes.

• Experience with ML feature engineering for bid optimization or yield prediction (preferred).

• Background in building data products for publisher-side monetization (preferred).

• Familiarity with differential privacy and clean rooms (preferred).

• Experience with CTV/OTT advertising data and video ad metrics (preferred).

• Knowledge of identity resolution and cross-device data challenges (preferred).

🏝️ Benefits

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

• Career support and assistance in finding new project opportunities.

• Legal support for independent contractor or sole proprietorship status, taxes, and related matters.

• English language courses.

• Opportunities for professional development.

• Team-building activities.

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