SlipstreamJobs tracks this role from the company's public career site. Apply directly on the employer's site.
Salary: USD 117,688 - 148,289 / annual
iSpot.tv is seeking a Software Development Engineer 3 (data engineer) to join the Ad Optimization team in Bellevue, WA. You will build and own large-scale Apache Spark and Snowflake data pipelines that deliver TV and streaming measurement data (impressions, conversions, attribution) to partners including DSPs, CTV platforms, and ad servers, enabling advertisers to optimize campaigns in real time.
Key responsibilities include:
- Design, build, tune, and maintain production batch Spark pipelines that transform measurement data into partner-ready optimization feeds
- Build and optimize Snowflake processing, including SQL transformations, scheduled and incremental pipelines, and data modeling
- Optimize pipeline performance and cost across Spark and Snowflake environments
- Design data models, table layouts, and partitioning strategies across S3, lakehouse tables, and Snowflake
- Build partner data feeds with file and API deliveries, identity matching, privacy-sensitive data handling, and delivery SLAs
- Implement data-quality checks, reconciliation, telemetry, and alerting; handle late-arriving data and backfills
- Write and review technical designs and test plans; lead small-to-medium projects from ambiguous requirements to production
- Own releases, deployments, and staged rollouts with rollback capabilities
- Participate in on-call rotation, respond to alerts and incidents, lead root-cause analysis, and maintain runbooks
- Mentor other engineers through code review, pairing, and design feedback
- Use AI-assisted tools for design, development, testing, and incident work with appropriate verification
The role is hybrid for those local to Bellevue or New York offices (1-3 days/week in office); fully remote for those further away. iSpot offers competitive salary, equity in a Seattle-based startup, and standard benefits.
Qualifications:
- 5+ years of professional software or data engineering experience
- 3+ years building, optimizing, and operating production Apache Spark pipelines in Java/Scala and Python/PySpark
- 2+ years of production Snowflake experience, including complex SQL transformations, performance and cost tuning (warehouse sizing, clustering, query profiling), and tasks/streams or dynamic tables for scheduled and incremental processing
- 2+ years running data workloads on AWS (S3, Spark on Kubernetes/EKS or EMR)
- Production experience with Airflow or equivalent workflow orchestrator
- Advanced SQL and relational data modeling
- Experience building external partner or client data feeds involving file and API deliveries, identity matching, privacy-sensitive data, and delivery SLAs
- Experience designing data-quality checks, reconciliation, telemetry, and alerting for batch pipelines, including handling late-arriving data and backfills
- Experience writing unit and integration tests for data pipelines
- Production ownership experience covering CI/CD, releases and rollback, incident response, and root-cause analysis
- Experience writing and reviewing technical designs and leading small-to-medium engineering projects through production delivery
- Experience mentoring engineers through code review, pairing, and design feedback
- Experience using AI-assisted engineering tools responsibly with appropriate verification for security, correctness, and maintainability
Preferred skills:
- Snowflake external Iceberg tables, catalog integrations, secure data sharing, or Snowpark (Python)
- Apache Iceberg and MySQL
- Spark on Amazon EKS and Airflow on Amazon MWAA
- Ad tech or advertising measurement experience (attribution, conversions, audience/impression data, identity matching, partner optimization feeds)
