Algoleap Technologies - Data Architect - Snowflake DB

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+ yearsKey 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. (ref:hirist.tech)