Senior Data Engineer

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

📋 Description

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

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

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

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

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

• Construct and maintain data warehouses and data lakes that are optimized for ad-tech query patterns.

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

⛳️ Requirements

• Over 5 years of professional experience in data engineering.

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

• Strong skills in Python and SQL.

• Practical experience with data warehouses: BigQuery, Snowflake, Redshift, ClickHouse.

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

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

• Experience with cloud platforms: AWS and GCP.

• Proficient in infrastructure-as-code.

• Able to work partial US hours and remain available until 2 PM 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.

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

• Familiarity with auction analytics including bid landscape, floor optimization, and timeout analysis.

• Knowledge of demand partner performance metrics like SSP/bidder scoring, latency analysis, viewability metrics, reach/frequency, and IVT.

• Insight into supply chain data, encompassing ads.txt validation, sellers.json mapping, and SPO analysis.

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

• Proficient in BigQuery, Snowflake, ClickHouse, and Redshift.

• Experienced with Airflow, Dagster, or Prefect.

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

• Proficient in AWS, GCP, Terraform, or Kubernetes.

• Scala knowledge is a plus.

• Experience with ML feature engineering for bid optimization or yield prediction is an advantage.

• Background in developing data products for publisher-side monetization is beneficial.

• Familiarity with privacy-preserving data techniques is an added advantage.

• Knowledge of CTV/OTT advertising data and video ad metrics is a plus.

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

🏝️ Benefits

• Security achieved through thorough client vetting, reducing risks and ensuring timely, reliable payments.

• Career assistance and support in finding new opportunities if a project does not align well.

• Legal support regarding independent contractor or sole proprietorship status, taxes, and associated 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.