Full Job Description
Job Summary
The Snowflake Data Architect will lead the architecture, design, and delivery of a Marketing Data Management platform built on Snowflake and AWS. The role will drive the creation of a trusted marketing data foundation that consolidates data from multiple marketing, CRM, ERP, and business platforms into a governed enterprise data platform. The position requires deep expertise in Snowflake architecture, cloud data engineering, data governance, SQL optimization, and large-scale enterprise data platforms.
Key Responsibilities
• Design and lead Snowflake architecture for the Marketing Data Management platform.
• Develop enterprise data models, ingestion frameworks, and data governance standards.
• Architect data pipelines integrating data from Google Analytics (GA4), Google Ads, Salesforce, SAP, JD Edwards, marketing platforms, and agency data feeds.
• Design Snowflake security, role-based access control (RBAC), data masking, and governance controls.
• Guide implementation of raw, curated, and presentation data layers.
• Establish metadata, data lineage, and data quality standards.
• Review and optimize SQL performance across Snowflake workloads.
• Work closely with business stakeholders, marketing teams, and executive leadership.
• Mentor engineering resources and provide technical leadership.
Required Qualifications
• 15+ years of experience in Data Architecture, Data Warehousing, and Analytics.
• 5+ years of hands-on Snowflake architecture experience.
• Extensive SQL expertise.
• Strong AWS cloud architecture experience.
• Experience designing enterprise-scale data platforms.
• Strong experience with Snowflake Data Cloud.
• Advanced SQL and data modeling skills.
• Experience with data warehousing and ETL/ELT design.
• Experience with data governance and data quality frameworks.
• Experience with Snowflake security and RBAC.
• Experience with data platform performance optimization.
• Experience working in Agile delivery environments.
Preferred Qualifications
• Marketing analytics experience.
• Experience with Google Analytics (GA4).
• Experience with Google Ads.
• Experience with Salesforce CRM.
• Experience with Power BI.
• Experience with dbt.
• Knowledge of marketing attribution and campaign measurement.
• Experience supporting executive dashboards and KPI reporting.