Architect

Job Description:

• Snowflake Cross‑Cloud Replication | Configure and validate Snowflake replication (DBs, roles, warehouses, shares) across AWS → Azure; monitor lag; execute cutover.
• Snowflake SQL & Object Parity Validation | Validate/migrate views, procedures, and tasks; reconcile logic differences; ensure identical behavior across environments.
• Snowflake RBAC & Security Model | Deep expertise in roles, grants, ownership, warehouse access, share permissions, and securing multi‑environment deployments.
• dbt Modeling & Testing | Build and maintain dbt models, tests, and macros; manage CI/CD and promotion across Dev/QA/Stg/Prod.
• Snowpipe / Streaming Ingestion | Validate Snowpipe auto‑ingest, streaming ingestion patterns, schema drift handling, and ingestion latency.
• ETL/ELT Pipeline Engineering | Build and optimize Snowflake SQL pipelines using tasks, streams, CDC logic, incremental processing, and performance tuning.
• Mult...