Senior Data Engineer

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

📋 Description

• Design, construct, and enhance scalable data pipelines for ad servers and associated data sources.

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

• Develop ETL/ELT workflows to transform raw data into analytics-ready datasets.

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

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

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

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

• Ensure compliance with GDPR and CCPA data privacy regulations in data collection, storage, and processing.

⛳️ Requirements

• Minimum of 5 years of professional experience in data engineering.

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

• Strong command of Python and SQL.

• Practical experience with data warehouses such as BigQuery, Snowflake, Redshift, and ClickHouse.

• Familiarity with batch processing frameworks including Spark, dbt, and Airflow.

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

• Experience with cloud platforms like AWS and GCP.

• Knowledge of infrastructure-as-code practices.

• Ability to work partial US hours, available until 2 PM ET.

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

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

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

• Knowledge of auction analytics including bid landscape, floor optimization, and timeout analysis.

• Familiarity with demand partner performance metrics such as SSP/bidder scoring, latency analysis, viewability metrics, and reach/frequency.

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

• Nice to have: Experience with Scala.

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

• Nice to have: Background in developing data products for publisher-side monetization.

• 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 careful client vetting to reduce risks and ensure reliable, timely payments.

• Career support and assistance in finding new projects.

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

• Dedicated HR support.