Senior Data Platform Engineer for Media & AI

Solstice; New York (NY); On-site; USD 200,000 - 300,000; Full time

Benefits offered by this job

Health, dental, and vision insurance

Ground-floor equity opportunity

Unlimited PTO

401(k) Match

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

Job summary

Solstice, a life sciences data and marketing platform, is hiring its first data engineer to build the foundation for media activation and measurement. You will own cloud data pipelines, identity mappings, data quality, and observability to enable trusted datasets for product, media, and AI teams.

You will ingest logs from DSPs and publishers, design canonical data models, and ensure data is accurate, timely, and auditable to support experimentation and attribution across campaigns.

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. You can turn an ambiguous business goal into a technical plan, ship it, and operate it.
• Clear communication. You can explain data quality and measurement tradeoffs to technical and non-technical partners, and you are comfortable working directly with external vendors.
• A high bar for craft, urgency, and follow-through.

Responsibilities

• Design, build, and operate the cloud data platform for Solstice's media products, from raw partner data through trusted, analysis-ready models.
• Ingest daily event and delivery logs from DSPs, publishers, claims-data providers, client systems, and Solstice's own content platform.
• Build durable mappings across vendor identifiers, NPIs, campaigns, audiences, assets, and atomic creative elements.
• Handle the hard cases in third-party data: de-aggregation, off-list records, unmatched identities, duplicates, late-arriving data, schema drift, and backfills.
• Create canonical data models that connect creative attributes and exposures to clicks, engagement, and longer-lag outcomes such as prescription or claims signals.
• Build reliable batch and event-driven pipelines with clear lineage, idempotent processing, automated data-quality checks, and actionable alerting.
• Make partner integrations repeatable, including APIs, secure file transfer, validation, reconciliation, and audit trails.
• Provide clean datasets and services that support campaign measurement, experimentation, attribution, and the creative-to-performance feedback loop.
• Own the reliability, security, and cost of the data platform as volume and the number of partners grow.
• Work directly with media, product, AI, and customer teams to launch the first campaigns, investigate discrepancies, and turn real operating problems into durable platform capabilities.

Skills

Python

SQL

ETL/ELT

Data quality

Observability

End-to-end ownership

Communication

Ambiguity to plan

Tools

GCP/BigQuery

dbt

Airflow

Dagster

Prefect

Redshift/AWS

Job description

Solstice, a life sciences data and marketing platform, is hiring its first data engineer to build the foundation for media activation and measurement. You will own cloud data pipelines, identity mappings, data quality, and observability to enable trusted datasets for product, media, and AI teams.

You will ingest logs from DSPs and publishers, design canonical data models, and ensure data is accurate, timely, and auditable to support experimentation and attribution across campaigns.