Member of Technical Staff (Data Engineering)

The role

You will build the data foundation for media activation and measurement products. This includes designing and operating a cloud data platform, ingestion and transformation pipelines, and identity and attribution mappings.

What you will do

• Design, build, and operate the cloud data platform for media products.
• Ingest daily event and delivery logs from various providers and platforms.
• Build durable mappings across vendor identifiers, campaigns, audiences, and assets.
• Handle messy third-party data including de-aggregation, duplicates, and schema drift.
• Create canonical data models connecting creative attributes to outcomes.
• Build reliable batch and event-driven pipelines with lineage and automated checks.
• Make partner integrations repeatable including APIs and secure file transfer.
• Provide clean datasets for campaign measurement, experimentation, and attribution.
• Own the reliability, security, and cost of the data platform.
• Work with media, product, AI, and customer teams to launch campaigns and investigate discrepancies.

Required qualifications

• Strong Python and SQL, with experience building and operating production data systems.
• Deep experience with ETL or ELT pipelines, data modeling, workflow orchestration, and a modern cloud warehouse or lakehouse.
• Experience ingesting messy third-party data and reconciling records across systems with inconsistent identifiers and schemas.
• Strong instincts for data correctness: validation, lineage, observability, backfills, deduplication, and failure recovery.
• Experience designing systems that are reliable under growing volume, changing partner contracts, and imperfect upstream inputs.
• Independent judgment and end-to-end ownership.
• Clear communication.
• A high bar for craft, urgency, and follow-through.

Nice to have

• Experience with GCP and BigQuery, or comparable depth with AWS, Azure, Snowflake, Databricks, or Redshift.
• Experience with data transformation and orchestration tools such as dbt, Airflow, Dagster, or Prefect.
• Experience in adtech, media delivery, measurement, attribution, or marketing data platforms.
• Familiarity with healthcare or life sciences data, including NPI-keyed HCP data, claims, or prescription signals.
• Experience building secure data systems for regulated, privacy-sensitive, or enterprise environments.
• Experience preparing high-quality data for experimentation, analytics, machine learning, or AI systems.
• Experience integrating with DSPs, endemic publishers, identity vendors, or claims-data providers.
• Familiarity with creative-level or component-level measurement, incrementality, or experiment design.
• Experience building a data platform from zero to one at an early-stage company.

Benefits

• Health, dental, and vision insurance
• Ground-floor equity opportunity
• Unlimited PTO
• 401(k) Match
• Visa sponsorship (O-1, H-1B, TN) available
• Work in a high-velocity, high-impact environment

Before you apply

• Visa sponsorship (O-1, H-1B, TN) available

About the company

Solstice is redefining how life sciences organizations commercialize their therapeutics by building a commercial engine for pharmaceutical marketers. They are building applications at the frontiers of AI to expand what is possible in pharmaceutical marketing.