Customer Data & Lakehouse Architect

Courtavenue, Inc.
San Diego, CA, United States
2 days ago
Apply on www.thejobnetwork.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
8 years minimum
Working hours
Regular working hours

Tech stack

Adobe Experience Manager Airflow Apache HTTP Server Cloud Computing Continuous Integration Customer Data Management Data Architecture Data Deduplication Information Engineering Extract Transform Load (ETL) Data Retention Data Sharing
+21 more
Distributed Data Store Python (Programming Language) Automation of Marketing Metadata Cloud Services Salesforce.Com Data Streaming Enterprise Data Management Feature Engineering Sql Optimization Snowflake Apache Spark Adobe Data Lakes Pyspark Network Support Tealium Operational Systems Marketing Cloud User Identification Databricks

Job description

GTX Solutions leads data activation and delivery for enterprise CRM programs on the Salesforce platform, including Marketing Cloud and Data 360, spanning email, SMS and direct mail. Our teams take over, stabilize and modernize live, high-volume programs, improving journeys, decisioning and measurement over time.

At GTX Solutions, the Customer Data & Lakehouse Architect leads customer data strategy and architecture across client engagements, from Snowflake and Databricks lakehouses to Salesforce Data 360 and other CDPs. This role designs data models, transformation patterns, identity and governance, reusable data products and measurement-ready datasets that make trusted enterprise data available for marketing, analytics, personalization and applied AI. It defines what should happen upstream in the warehouse or lakehouse versus inside a CDP and partners with the Salesforce Solution Architect on Data 360 integration and activation. The architect remains hands-on enough to validate designs and prototypes while directing engineers, including our LATAM delivery team, on production implementation.

Responsibilities

  • Lead current-state discovery and define target-state customer data architecture for enterprise warehouse and lakehouse environments, with deep work in Snowflake and/or Databricks.
  • Design scalable ingestion and ELT/ETL patterns across operational systems, CRM, transactional sources, digital events and approved third-party datasets, including incremental refresh, scheduling, lineage and data observability.
  • Own canonical data models for customers, accounts, households, vehicles, products, transactions, interactions and identity relationships as applicable to each client; define source precedence, golden-record logic and reliable join keys.
  • Apply medallion architecture where appropriate, including bronze, silver and gold layers, data quality validation, deduplication, normalization, enrichment, standardization and curated consumption datasets.
  • Build reusable, governed data products for customer 360, audience eligibility, suppression, measurement, attribution, experimentation, reporting and predictive features rather than one-off transformations for each campaign.
  • Design the integration boundary between enterprise data platforms and Salesforce Data 360, including data streams, Data Lake Objects (DLOs), Data Model Objects (DMOs), identity inputs, segmentation-ready attributes, activation feeds and zero-copy/federated access where supported and appropriate.
  • Define customer identity, consent, privacy, access control, data retention, permitted third-party exchanges and governance rules in partnership with client data owners, security and legal teams.
  • Architect campaign and customer measurement datasets, including exposure-to-outcome joins, sales matchback, attribution rules, reusable KPIs, historical continuity and approved data sharing.
  • Design feature engineering and recurring scoring workflows for propensity, churn, lifetime value and next-best-action use cases; prototype or implement models when expertise permits and collaborate with data scientists on evaluation, deployment and monitoring.
  • Translate architecture into source-to-target mappings, data contracts, transformation specifications, backlog priorities, acceptance criteria and delivery roadmaps; review implementation work by distributed data engineers.
  • Lead technical workshops, explain platform trade-offs and operating costs, and guide client stakeholders toward pragmatic decisions that preserve client ownership of data and analytical assets.
  • Partner with Salesforce, CDP, marketing automation, analytics and journey teams to ensure data products can be used reliably and compliantly in activation platforms., * This role supports multiple GTX client engagements across industries and technology platforms, including enterprise data foundations supporting CDP and marketing automation programs.
  • The role requires close coordination with client marketing, technology, analytics, privacy and data teams; occasional travel or on-site presence may be required.
  • Southern California preferred, in the San Diego or Los Angeles area, to support in-person collaboration with client and partner teams. GTX Solutions has team members across the United States.

Final compensation will be determined based on total related experience related to the role as well as geography.

Requirements

  • 8+ years of experience in data architecture, data engineering or analytics engineering, including senior ownership of production customer or enterprise data solutions.
  • Deep hands-on architecture and production experience in Snowflake OR Databricks, with strong knowledge of warehouse/lakehouse storage, transformation, performance, governance and cost management.
  • Advanced SQL and practical Python proficiency, including the ability to validate data, prototype transformations, investigate pipeline failures and review technical implementation.
  • Proven experience with dimensional and relational modeling, canonical customer data models, ELT/ETL, data quality, medallion/layered architectures and reusable data products.
  • Working knowledge of Salesforce Data 360 (formerly Data Cloud), including DLOs, DMOs, data streams, identity resolution, segmentation and downstream Salesforce Marketing Cloud activation; ability to collaborate effectively with hands-on Salesforce specialists.
  • Strong understanding of customer identity, profile unification, deduplication, consent, source precedence, household or account relationships and privacy-aware data sharing.
  • Ability to define technical architecture and lead implementation by engineers while staying hands-on when investigation, prototyping or delivery validation is required.
  • Experience translating business and analytical needs into data models, integration contracts, architecture decisions and clear documentation for technical and business stakeholders., * Production experience with both Snowflake and Databricks; knowledge of Spark/PySpark, Delta Lake, Apache Iceberg, Unity Catalog or similar metadata, catalog and interoperability capabilities.
  • Direct implementation experience or Salesforce Data Cloud Consultant certification; familiarity with zero-copy/federated patterns and consumption-aware design between cloud data platforms and Data 360.
  • Experience with dbt, Airflow or comparable orchestration, automated data testing, CI/CD, monitoring and data catalog or observability solutions.
  • Applied data science and machine learning experience, especially feature engineering, propensity modeling, churn prediction, lifetime value estimation, forecasting, experimentation or production scoring.
  • Experience with additional CDPs or activation platforms such as Tealium, Hightouch, Segment, Adobe Experience Platform or Adobe Real-Time CDP.
  • Automotive, OEM or dealer-network experience, including vehicle ownership, VIN and household relationships, registrations, dealership data, conquest suppression or sales matchback.
  • Experience coordinating approved third-party identity, enrichment, address hygiene, measurement or data providers.
  • Background in consulting or agency delivery, client-facing architecture leadership and mentoring distributed or nearshore data engineering teams.

About the company

GTX Solutions, a CourtAvenue Company, is a boutique consulting firm focused on helping brands unlock the power of their customer data. We specialize in Customer Data Platforms (CDPs), real-time activation, personalization, and MarTech integrations. Our team blends strategic insight with technical expertise to drive measurable business outcomes for high-growth companies and global enterprises alike.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.thejobnetwork.com
Prepare application

Good distractions

Loading talks and stories from around this role…