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.