Snowflake Data Architect
Core
Lead end-to-end Snowflake architecture and solution design for scalable, secure, and AI-ready data platforms serving the commercial real estate business and its stakeholders.
Role type
Senior IC Snowflake Data Architect
Builds
Scalable data platforms, semantic models, and AI-ready data layers for CRE domains
Domain
Commercial Real Estate + Data Architecture
Deliverable
production ML models
Required skills
Snowflake architecture, Snowpark, SQL, Python, data modeling, data governance, security, CI/CD, FinOps
Preferred skills
Snowflake certifications, cloud architecture certifications
Technologies
Snowflake, Snowpark, dbt, Airflow, Salesforce, Postgres, Streamlit, React
Responsibilities
Own end-to-end Snowflake architecture including account topology, databases, schemas, and multi-environment strategy; Design data layering models (raw to curated marts) for CRE domains; Define semantic views and models for BI and LLM/NL-query tools; Set warehouse sizing, scaling, and workload isolation; Establish naming conventions and reference architecture patterns; Guide ETL/ELT pipeline design including ingestion from CRM and third-party sources; Lead use of dynamic tables, streams, tasks, and Snowpark; Architect RBAC, column-level security, row-level security, and sensitive-data classification; Define data quality monitoring and auditing; Design integration patterns between Snowflake and downstream stores/apps; Optimize query performance and own cost governance (FinOps); Enable natural-language querying and analytics via semantic models and Cortex; Establish Infrastructure-as-Code and Git-based deployment; Set the Snowflake roadmap and act as design authority; Translate CRE business needs into platform capabilities.
Seniority
Senior, hands-on IC