Snowflake Data Architect

Compunnel

• $150K — $180K *
Enterprise Technology
11 - 15 years of experience
Job Overview by Ladders

Qualifications

  • 15+ years in Data Architecture, Data Warehousing, and Analytics.
  • 5+ years hands-on experience with Snowflake architecture.
  • Extensive expertise in SQL.
  • Strong background in AWS cloud architecture.
  • Experience in designing enterprise-scale data platforms.
  • Deep knowledge of Snowflake Data Cloud.
  • Advanced SQL and data modeling skills.

Responsibilities

  • Design and lead the architecture for the Marketing Data Management platform using Snowflake.
  • Develop data governance standards and enterprise data models.
  • Architect complex data pipelines integrating various marketing and business platforms.
  • Implement Snowflake security measures, including role-based access control (RBAC).
  • Establish and maintain data lineage, metadata, and quality standards.
  • Guide the implementation of data layers: raw, curated, and presentation.
  • Review and optimize SQL performance for Snowflake workloads.

Benefits

  • Opportunity to work on cutting-edge Snowflake and AWS technologies.
  • Collaborative environment with business stakeholders and leadership.
  • Role includes mentoring and guiding engineering resources.
  • Focus on creating a trusted marketing data foundation.
  • Involvement in agile delivery processes.
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.

Similar Jobs

More Jobs at Compunnel

  • Senior Data Analyst
    $120K — $145K *
    New York, NY 10025 (New York County)
    Media
    In-Person
  • Automation Engineers
    $100K — $120K *
    Philadelphia, PA 19120 (Philadelphia County)
    Information Technology
    In-Person
  • Software Engineer
    $90K — $110K *
    San Diego, CA 92154 (San Diego County)
    Enterprise Technology
    In-Person
  • Actimize Technical Consultant
    $100K — $120K *
    Dearborn, MI 48126 (Wayne County)
    Finance & Insurance
    In-Person
  • Software Developer
    $110K — $130K *
    Austin, TX 78745 (Travis County)
    Manufacturing & Automotive
    In-Person

More Enterprise Technology Jobs

Find similar Snowflake Data Architect jobs: