Working Model: Hybrid
Work Authorisation: Candidates must have permanent US work authorisation. Visa sponsorship and relocation assistance are not available.
The Role
We are looking for a Customer Data & Lakehouse Architect to help organisations build modern data environments that support better customer insight, analytics, personalisation and activation.
This is a broad data architecture role, with the data warehouse and lakehouse forming the foundation of the architecture. You will work across platforms such as Snowflake and Databricks, designing how customer and enterprise data is collected, structured, transformed and made available to downstream analytics and activation platforms.
Salesforce Data 360 is an important part of the ecosystem, but this is not a Salesforce-only architecture role. We are particularly interested in people who understand the wider data landscape and can make informed decisions about what belongs in the enterprise data platform, what should be exposed through a customer data platform, and how the two should work together.
You will work with business, data and technology stakeholders to turn complex requirements into practical data architectures, models and delivery plans. You'll also provide technical direction to engineering teams and remain close enough to the technology to review designs, troubleshoot issues and validate solutions.
What You'll Be Doing
Data Architecture & Modelling
- Develop end-to-end data architecture for enterprise customer and analytics environments.
- Design scalable solutions using modern cloud data warehouses and lakehouse platforms, particularly Snowflake and Databricks.
- Establish logical and physical data models that support customer intelligence, reporting, analytics and activation.
- Define relationships between customers, accounts, products, transactions, interactions and other relevant business entities.
- Create consistent approaches to data structures, keys, reference data, master data and data relationships.
- Determine how data should be organised to support both operational requirements and analytical consumption.
- Establish reusable datasets and data products rather than creating isolated solutions for individual use cases.
Data Engineering & Platform Design
- Define how data should move between source systems, enterprise data platforms and downstream applications.
- Design appropriate ingestion, transformation and processing strategies for structured and semi-structured data.
- Establish patterns for batch and incremental processing, data quality, validation and monitoring.
- Work with engineering teams to ensure architectural standards are translated effectively into production environments.
- Consider scalability, performance, reliability and cost when evaluating technical approaches.
- Support the development of layered data architectures where appropriate, including raw, refined and curated data environments.
Analytics & Customer Intelligence
- Design data structures that enable reliable business intelligence, reporting and advanced analytics.
- Work with analytical teams to understand the data required for customer segmentation, measurement, forecasting and predictive use cases.
- Develop architectures that support customer-level analysis, behavioural insights and measurement across multiple channels.
- Help establish consistent definitions for KPIs, metrics and analytical datasets.
- Support the development of data foundations for machine learning and AI applications.
- Ensure historical data, analytical context and customer relationships are preserved where required for meaningful analysis.
Salesforce Data 360 & Activation
- Design how enterprise data platforms integrate with Salesforce Data 360 and other customer data technologies.
- Establish appropriate data flows between Snowflake, Databricks, Data 360 and downstream Salesforce environments.
- Help determine which data should be transformed and governed within the enterprise data platform versus managed or consumed within Data 360.
- Support the creation of customer profiles, audiences and activation-ready datasets.
- Work alongside Salesforce specialists on areas including data ingestion, identity resolution, segmentation and activation.
- Ensure customer data remains consistent and governed as it moves between analytical and activation environments.
Governance & Identity
- Help establish practical approaches to data governance across customer and enterprise data environments.
- Define requirements around data quality, ownership, lineage, access and retention.
- Design approaches to customer identity and record matching across multiple source systems.
- Establish rules around source priority, duplicate management and trusted customer records.
- Consider privacy, consent and appropriate use of customer data throughout the architecture.
- Work with business and technical stakeholders to ensure data solutions meet organisational governance requirements.
Technical Leadership
- Lead architecture discussions and technical workshops with business and technology stakeholders.
- Translate business requirements into clear architecture, modelling and implementation decisions.
- Produce architecture documentation, data models, technical specifications and delivery roadmaps.
- Review engineering designs and provide direction to distributed development and data teams.
- Investigate complex data and integration issues when required.
- Build prototypes or proof-of-concepts where this helps validate an architectural approach.
- Explain technical trade-offs clearly, including the impact of different platforms and architectural decisions.
- Act as a technical bridge between data engineering, analytics, Salesforce and wider digital technology teams.
What You'll Bring
- 8+ years' experience across data architecture, data engineering, analytics engineering or a closely related discipline.
- Strong experience designing and delivering enterprise data platforms in production environments.
- Significant hands-on experience with Snowflake and/or Databricks.
- Strong understanding of modern warehouse and lakehouse architecture.
- Excellent SQL skills and practical experience with Python.
- Strong knowledge of data modelling, including relational, dimensional and customer-centric modelling approaches.
- Experience designing data pipelines and transformation processes using modern ELT/ETL approaches.
- Strong understanding of data quality, governance, lineage and observability.
- Experience designing data environments specifically to support analytics and reporting, not just operational data processing.
- Experience working with complex customer data and integrating information from multiple source systems.
- Good understanding of customer identity, profile matching, deduplication and data relationships.
- Working knowledge of Salesforce Data 360 / Data Cloud and how it fits into a wider enterprise data architecture.
- Ability to work across technical and business stakeholders and communicate complex architecture clearly.
- Experience providing technical leadership to engineers without needing to be the primary production developer.
Nice to Have
- Experience working across both Snowflake and Databricks.
- Familiarity with Spark, PySpark, Delta Lake, Apache Iceberg or Unity Catalog.
- Experience with dbt, Airflow or similar data transformation and orchestration technologies.
- Experience implementing automated data testing, CI/CD, monitoring or data observability.
- Salesforce Data 360 implementation experience or relevant certification.
- Experience integrating Salesforce Data 360 with modern cloud data platforms.
- Knowledge of other CDP or customer activation technologies, including Adobe Experience Platform, Adobe Real-Time CDP, Segment, Tealium or Hightouch.
- Experience supporting machine learning or AI initiatives through feature engineering and well-structured analytical datasets.
- Exposure to use cases such as customer propensity, churn, lifetime value, forecasting or next-best-action.
- Consulting or agency experience, particularly working directly with enterprise stakeholders.
- Experience leading distributed or nearshore engineering teams.