Senior Data Engineer

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

📋 Description

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

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

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

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

• Construct and maintain data warehouses and data lakes optimized for ad-tech query behaviors.

• Implement monitoring for data quality, validation, and anomaly detection across 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 all aspects of data collection, storage, and processing.

⛳️ Requirements

• Over 5 years of experience in professional data engineering.

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

• Experience with cloud platforms such as AWS and GCP.

• Familiarity with infrastructure-as-code practices.

• Availability for partial US work hours, with availability 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 exports to BigQuery.

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

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

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

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

• Experience using Airflow, Dagster, or Prefect.

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

• Knowledge of AWS, GCP, Terraform, and Kubernetes.

• Experience in ML feature engineering for bid optimization or yield prediction is nice to have.

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

• Familiarity with differential privacy and clean rooms is advantageous.

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

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

🏝️ Benefits

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

• Support for career development and assistance in finding new projects.

• Legal guidance regarding independent contractor status, taxes, and related matters.

• Access to English language courses.

• Opportunities for professional development.

• Team-building events to foster collaboration.

• Flexible working hours to accommodate personal needs.

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

• 10 paid recovery days for personal health.

• Comprehensive financial and legal support for independent contractors.

• Free English lessons with native speakers or Ukrainian instructors.

• Dedicated HR support to assist with any inquiries.