Senior Data Engineer

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

📋 Description

• Develop and expand the data infrastructure that powers a business intelligence platform.

• Design, manage, and improve scalable pipelines that handle billions of ad server and related data events.

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

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

• Construct data models aimed at optimizing campaign performance, supply analysis, supply allocations, and maximizing profits.

• Build and sustain data warehouses and data lakes that are optimized for ad-tech query patterns.

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

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

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

• Enable real-time analytics and dashboards that assist customers in optimizing campaigns, managing workflows, and driving efficiency and growth.

⛳️ 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 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 ad-tech data structures including bid requests, impressions, OpenRTB schemas, and log-level data.

• Experience working with cloud platforms such as AWS and GCP.

• Proficient in infrastructure-as-code.

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

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

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

• Understanding of ad-tech revenue metrics, auction analytics, demand partner performance, supply chain data, and related metrics.

• Familiarity with Python and SQL; knowledge of Scala is a plus.

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

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

• Experience using Airflow, Dagster, and Prefect.

• Knowledge of S3, GCS, Delta Lake, and Parquet.

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

• Nice to have experience in ML feature engineering for bid optimization or yield prediction.

• Nice to have knowledge of publisher-side monetization data products.

• Nice to have familiarity with privacy-preserving data techniques, including differential privacy and clean rooms.

• Nice to have experience with CTV/OTT advertising data and video ad metrics.

• Nice to have knowledge of identity resolution and cross-device data challenges.

🏝️ Benefits

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

• Career support and assistance in finding new opportunities.

• Legal assistance with 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 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 teachers.

• Dedicated HR support.