Data Engineer

# Data Engineer New York Apply for this job
* Permanent* Experienced Professionals
* Software Engineering
* -en _USChoosing Capgemini 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. Join us and help the world’s leading organizations unlock the value of technology and build a more sustainable, more inclusive world.##

Job Description What You Will Own Medallion Architecture - Bronze through Gold
• Design, build, and operate the full medallion stack on Databricks: raw landing (Bronze), identity-resolved and feature-engineered Silver, and the governed serving layer (Gold) that the Helm agent layer queries on every conversational turn  
• Implement Delta Live Tables (DLT) and Lakeflow pipelines for batch and structured-streaming ingestion of transaction signals, behavioral events, and third-party identity data  
• Own schema enforcement and evolution at the Bronze boundary so upstream change surfaces as a controlled event, not a downstream failure  
• Build the unstructured processing tier (Bronze → Silver) using Databricks AI Functions or ai _query to convert PDFs, brand guidelines, compliance rule sets, and creative assets into governed Silver tables

Unity Catalog & Governance
• Own Unity Catalog as the governance layer: access control, lineage tracking, and per-client tenant isolation across Helm's financial institution client base  
• Implement PII governance controls at the pipeline layer - redacted s, consent signal propagation, and guardrail alignment to GLBA, Fair Lending, and UDAAP  
• Build and maintain data-quality expectations frameworks: reconciliation, deduplication, and lineage checks that reduce manual investigation cycles

Serving Layer & Platform Operations
• Build and operate the Gold serving layer behind Helm's twelve analytical models: MTA, MMM, incrementality, LTV:

CAC, reach/frequency, cohorts, cobrand overlap, channel viability, card activation, product holdings, scenario reallocation, and channel universe  
• Meet the serving contract the agentic layer depends on: fixed signal shapes, live query on every turn, predictable latency, and per-client isolation  
• Own CI/CD, infrastructure-as-code, cost management, and pipeline observability for the Databricks environment

Required Qualifications
• 5-7 years of data engineering experience with 2+ years of production Databricks work:
Delta Lake, Unity Catalog, DLT/Lakeflow, structured streaming, and SQL warehouses  
• Strong Python for transformation logic, data-quality automation, and pipeline orchestration  
• Expert-level SQL; comfort designing schemas for both analytical and serving workloads  
• GCP fluency:
Big Query, Cloud Storage, Cloud Run, IAM - Helm runs on GCP and Databricks runs within it  
• Hands-on experience with at least one clean room or privacy-preserving data exchange technology  
• PII governance knowledge in a regulated industry context: data residency, consent frameworks, GLBA, Fair Lending, UDAAPPreferred Qualifications  
• Databricks AI Functions (ai _query) or Vertex AI used inside pipelines for document extraction and normalization  
• dbt or a comparable transformation and lineage framework  
• Identity resolution concepts at the pipeline layer: deterministic matching, RampID or UID2 linkage, match-rate monitoring  
• Live Ramp, AMC, GMP, or XMi clean room connector experience  
• Familiarity with Lang Smith or Lang Graph as a data consumer - understanding what the agentic layer needs from the serving layer

The base compensation range for this role in the posted location is 86129 - 127189

Capgemini provides compensation…