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).
- Solid 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.

📌 Algoleap Technologies - Data Architect - Snowflake DB (India)
🏢 AlgoLeap Technologies
📍 India