Remote Jobs RockRemote Jobs Rock

Senior Data Engineer

πŸ•’ 3 days ago
Data EngineeringSQLPythonSpark
Apply Now

πŸ“œ Description

  • Build ingestion pipelines for bid, win, and impression logs, plus point-in-time-correct feature tables and aggregation pipelines.
  • Develop conversion and labeling pipelines, including delayed-label handling and safe historical reprocessing.
  • Own data-serving write paths, schema contracts, publishing flows, and freshness SLOs.
  • Create experimentation infrastructure, traffic-splitting and reporting pipelines, and automated data-quality validation.
  • Implement advertiser data-isolation and safe-aggregation controls, and support production reliability and scalability.
  • Collaborate with customer engineers, document operations, and contribute to architecture discussions.

πŸ› οΈ Requirements

  • 5+ years of experience in Data Engineering
  • At least 2 years of experience working with production ML or large-scale analytics pipelines
  • Expert-level SQL skills including window functions and incremental processing patterns
  • Strong Python skills for production-grade pipeline development
  • Hands-on experience with Spark or PySpark
  • Experience designing ETL / ELT pipelines with Airflow, Cloud Composer, Dagster, or similar tools
  • Experience working with cloud data warehouses at scale, preferably BigQuery
  • Strong understanding of data modeling and point-in-time correctness
  • Experience working with event-driven or clickstream datasets at very large scale
  • Experience supporting business-critical production pipelines
Full job description

Company Description

Join Sigma Software to build large-scale data infrastructure powering a real-time AdTech platform processing hundreds of millions of auction requests daily. We are looking for a Senior Data Engineer who enjoys solving complex distributed data challenges and building production-grade ML-oriented data systems.

You will become part of a dedicated Sigma Software team developing predictive modeling and optimization capabilities for a live advertising ecosystem. The role combines large-scale event processing, streaming and batch pipelines, experimentation infrastructure, and high-throughput data engineering in a cloud-native environment.

We as a company offer the opportunity to work on impactful global products, collaborate with experienced engineers, and contribute to architecture decisions while growing your expertise in large-scale distributed systems and modern data platforms.

CUSTOMER

Our Customer is a technology company operating supply-side infrastructure within the programmatic advertising ecosystem. The company manages a large-scale ad exchange handling hundreds of millions of auction requests per day and is actively investing in predictive decisioning technologies to optimize advertising outcomes in real time.

PROJECT

The project focuses on building a predictive modeling and optimization platform on top of a live ad exchange environment. The platform performs real-time supply scoring and filtering, contextual performance estimation, look-alike audience generation, and multi-objective optimization under business constraints.

The solution processes massive-scale event and auction datasets and includes feature engineering pipelines, streaming and batch ingestion, experimentation infrastructure, point-in-time-correct training data generation, and ML-oriented data services with strict operational reliability and compliance requirements.

Job Description

  • Write and defend diagnostic SQL queries against large-scale production datasets
  • Build and maintain ingestion pipelines for bid, win, and impression logs into BigQuery
  • Harmonize fields across independently designed datasets and maintain versioned field mappings
  • Develop point-in-time-correct feature tables and aggregation pipelines
  • Design and maintain conversion and labeling pipelines with delayed label handling
  • Own the data serving write path, schema contracts, publishing flows, and freshness SLOs
  • Build experimentation infrastructure including traffic splitting and reporting pipelines
  • Perform large-scale historical backfills and safe reprocessing after mapping changes
  • Implement data isolation and safe-aggregation controls for advertiser data protection
  • Develop automated data quality validation frameworks
  • Collaborate closely with Customer engineers and prepare operational documentation
  • Contribute to architecture discussions and platform scalability improvements

Qualifications

  • 5+ years of experience in Data Engineering
  • At least 2 years of experience working with production ML or large-scale analytics pipelines
  • Expert-level SQL skills including window functions and incremental processing patterns
  • Strong Python skills for production-grade pipeline development
  • Hands-on experience with Spark or PySpark
  • Experience designing ETL / ELT pipelines with Airflow, Cloud Composer, Dagster, or similar tools
  • Experience working with cloud data warehouses at scale, preferably BigQuery
  • Strong understanding of data modeling and point-in-time correctness
  • Experience working with event-driven or clickstream datasets at very large scale
  • Experience supporting business-critical production pipelines
  • Upper-Intermediate English level or higher

WILL BE A PLUS

  • Experience with GCP services including Dataflow, Pub/Sub, GCS, and Beam
  • Experience building streaming or near-real-time ingestion systems
  • Understanding of feature stores, train/serve skew, and label leakage prevention
  • Experience in AdTech or auction-based environments
  • Experience handling delayed or incomplete labels in ML systems
  • Experience with dbt or similar transformation frameworks
  • Experience delivering solutions into Customer-owned infrastructure
  • Knowledge of GDPR/CCPA-related privacy engineering practices
  • Experience with experimentation infrastructure and statistical validation pipelines
  • Experience working in hybrid cloud/on-prem Linux environments
  • Terraform and Kubernetes experience
  • Experience optimizing warehouse cost and performance

Additional Information

PERSONAL PROFILE

  • Strong analytical and problem-solving skills
  • Ownership-oriented mindset
  • Ability to work independently in a client-facing environment
  • Strong communication and documentation skills
  • Comfortable working in a fast-paced engineering environment
  • Collaborative and proactive attitude
FCamara

Senior Data Engineer

πŸ•’ 2 days ago
FCamaraπŸ‘₯ 501 - 1000 employees🏒 Information Technology And Services

Design, build, and maintain reliable, scalable data pipelines and infrastructure, partnering with analysts and stakeholders to support analytics and business initiatives in banking.

Data EngineeringData PipelinesETLSQL
ProArch

Sr. Data Engineer

πŸ•’ 4 days ago
ProArch🏒 Information Technology🀝 B2B

Architects enterprise data pipelines, models, and analytics solutions across cloud and hybrid platforms, while advancing data governance, security, and Power BI reporting for healthcare domains.

Data EngineeringData ArchitectureData PipelinesDimensional Modeling
Talan

Celonis Data Engineer

πŸ•’ 4 days ago
TalanπŸ‘₯ 1001 - 5000 employees🏒 Information Technology And Services

Build and maintain Celonis data models, integrations, and pipelines for process intelligence and automation, while defining technical standards and guiding delivery for an automotive client.

CelonisData EngineeringObject-centric Process Mining (ocpm)SQL
Sigma Software

Senior Data Engineer (Cybersecurity)

πŸ•’ 4 days ago
Sigma SoftwareπŸ‘₯ 1001 - 5000 employees🏒 Computer Software

Own and modernize scalable data infrastructure for a cybersecurity product by improving pipelines, data models, and SQL performance while driving reliability and architectural improvements.

Data EngineeringPythonSQLDBT

Trusted by Remote Workers