Data Architect - Snowflake DB
First seen by Alion on Oct 13, 2026.
Role Overview :
The ideal candidate will lead end-to-end architecture - solution design centered on Snowflake, enabling scalable, secure, and AI-ready data platforms for commercial real estate business and its stakeholders.
Total Experience : 15+ years
Key Responsibilities :
- Own the end-to-end Snowflake architecture: account/org topology, databases, schemas, warehouses, and multi-environment strategy.
- Design the data layering model for CRE domains: property, lease, availability, sales, organization, contact.
- Define semantic views and models so BI and LLM/NL-query tools consume governed, business-friendly entities.
- Set warehouse sizing, scaling, and workload isolation.
- Establish naming conventions, object ownership, and reference architecture patterns.
Data Modeling & Engineering Leadership :
- Define dimensional/data-vault or hybrid models and canonical join keys to prevent fanout.
- Guide ETL/ELT pipeline design, including ingestion from CRM (Salesforce), market feeds, and third-party CRE sources.
- Lead use of dynamic tables, streams, tasks, and Snowpark for transformation.
Data Governance, Security & Compliance :
- Architect RBAC: role hierarchy, functional/access roles, and segregation of duties.
- Implement column-level security, row-level security, object tagging, and sensitive-data classification.
- Define data quality monitoring and auditing via Access History.
Performance, Cost & Reliability (FinOps) :
- Optimize query performance: clustering keys, search optimization, pruning, and caching.
- Own cost governance: warehouse auto-suspend/resume, resource monitors, and budgets.
AI / Analytics Enablement :
- Enable natural-language querying and analytics on CRE data through semantic models and Cortex.
- Partner with data science on feature stores and governed access to sensitive attributes.
DevOps, CI/CD & Operations :
- Establish Infrastructure-as-Code (schemachange/Terraform/dbt) and Git-based deployment.
Strategy & Leadership:
- Set the Snowflake roadmap and reference standards; act as design authority.
- Translate CRE business needs into platform capabilities.
Key Qualifications :
- 15+ years of overall experience in data architecture, data engineering, or enterprise data platforms.
- Advanced SQL skills and strong Python experience.
- Hands-on expertise with Snowflake key features (Account/warehouse/database design, RBAC, Snowpark, governance suite).
- Strong dimensional modeling and medallion/layered architecture patterns.
- Experience with dbt, orchestration (Airflow), and CI/CD pipelines.
- Cloud proficiency (Azure preferred) and familiarity with containerization.
- Excellent stakeholder management and architectural leadership skills.
Skills
Data Architect, Data Engineering, SQL, Python, Data Modeling, Snowflake DB, Data Build Tool