VisaJobSearch
Jobs / Cap***

Data Engineer with Expert-level SQL

Cap*** · New York, NY, United States
Visa sponsorship details are locked. Unlock company name and apply link with .
New York, NY, United States100,000-130,000 USD/yearlyOnsite
Remuneration
100,000-130,000 USD/yearly
Location
New York, NY, United States
Visa sponsorship
Sponsors visa

Job summary

Choosing Cap*** means choosing a company where you will be empowered to shape your career in the way you’d like, where you’ll be supported and inspired by a collaborative community of colleagues around the world, and where you’ll be able to reimagine what’s possible.

Benefits

Package to all regular, full-time employees.In the U.And Canada, availableAre determined by local policy and eligibility and may include:Medical, dental, and vision coverage (or provincial healthcare coordination in CRetirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada)Life and disability insuranceEmployee assistance programsOtherAs provided by local policy and eligibilityThe Company reserves the right to amend or withdraw compensation programs at any

Qualifications

  • 5+ years of data engineering experience
  • Expert-level SQL across at least one major cloud data warehouse: Snowflake, Google BigQuery, Amazon Redshift, or Azure Synapse
  • Proficiency in Python for pipeline development, transformation logic, and data quality automation
  • Hands-on experience with at least one clean room technology: AWS Clean Rooms, LiveRamp DCR, Google ADH, InfoSum, or equivalent privacy-preserving data collaboration platform
  • Deep understanding of identity resolution concepts: deterministic matching, probabilistic graph construction, household-level aggregation, and device graph assembly
  • Strong PII governance knowledge: data residency, consent frameworks, and financial services regulatory
  • GLBA, Fair Lending, UDAAP)
  • Experience integrating with DSPs, CDPs, or marketing activation platforms at the data layer
  • Ability to operate in client-facing consulting delivery contexts - translating business
  • into technical specifications
  • Preferred
  • Experience with graph database

Responsibilities

  • Pipeline Engineering
  • Design and maintain high-throughput ingestion pipelines for transaction signals, behavioral events, and third-party identity graphs - including LiveRamp RampID, UID2, GCLID chains, and household device graphs
  • Implement identity resolution logic at scale: deterministic matching, probabilistic graph construction, and household + device-level cluster assembly across 1B+ data points
  • Build and maintain data clean room connectors and privacy-preserving data exchange pipelines (AWS Clean Rooms, LiveRamp DCR, Google ADH, or equivalent)
  • Develop integrations between activation platforms (email, CDP, DSP) and the identity graph layer - supporting real-time audience push and match rate monitoring
  • Data Modeling & Quality
  • Design medallion-architecture or equivalent data models optimized for cohort-level LTV/CAC attribution and multi-touch attribution across owned, paid, and clean room channels
  • Build automated QC and reconciliation frameworks - deduplication, compliance validation, and data lineage tracking - capable of reducing manual reconciliation cycles from weeks to hours
  • Implement PII governance controls at the pipeline layer: redacted ID egress, consent signal propagation, and guardrail validation aligned to GLBA, Fair Lending, UDAAP, and TCPA/CAN-SPAM
  • Platform Integration
  • Integrate LLM-based APIs (e.g., Anthropic Claude, OpenAI, Vertex AI) for AI-powered signal enrichment, audience brief generation, and compliance pre-screening within pipeline workflows
  • Build serverless microservices and API bridge layers connecting clean room outputs to activation destinations - using any major serverless or edge compute platform

Degrees

Associate

Industry

AutomotiveBankingEducationEnergyHealthcareInsuranceLogistics

Company size

EnterpriseSmb