Snowflake Architect

Confiz is seeking an experienced Snowflake Data Platform Architect / Lead Engineer to design, build, and operationalize a modern enterprise Snowflake data platform from the ground up. This role will lead platform architecture, data engineering, governance, security, automation, performance optimization, and production operations while partnering with business, analytics, infrastructure, and security teams.

Responsibilities

• Design and implement enterprise Snowflake architecture, including databases, schemas, virtual warehouses, RBAC, networking, security, governance, and environment strategy (Dev/Test/Prod).
• Build scalable batch, CDC, streaming, and real-time data ingestion pipelines using Snowpipe, Streams, Tasks, Dynamic Tables, APIs, cloud storage, and ETL/ELT tools.
• Develop enterprise data models including raw, staging, curated, dimensional, semantic, and analytics layers using star schema, Data Vault, and modern data warehouse practices.
• Implement security, governance, compliance, masking, row/column-level security, object tagging, lineage, and access policies.
• Optimize Snowflake performance through warehouse tuning, clustering, query optimization, resource monitoring, and cost management.
• Establish CI/CD and DataOps processes using Git, Terraform, dbt, Azure DevOps, GitHub Actions, Flyway, Liquibase, or similar tools.
• Build operational monitoring, alerting, disaster recovery, backup, replication, and production support processes.
• Enable secure data sharing and integration with BI platforms including Power BI, Tableau, Looker, and other analytics tools.
• Lead technical design sessions, mentor engineering teams, define enterprise standards, and support modernization initiatives.

Qualifications

• 10+ years of experience in Data Engineering, Data Architecture, or Enterprise Data Warehousing.
• 5+ years of hands-on Snowflake experience in enterprise production environments.
• Proven experience designing and deploying Snowflake platforms from the ground up.
• Strong expertise in SQL, Snowflake architecture, performance tuning, security, RBAC, data governance, and workload optimization.
• Experience with AWS, Azure, or Google Cloud Platform.
• Hands-on experience with ETL/ELT technologies such as dbt, Informatica, Matillion, Fivetran, Airflow, ADF, Glue, or similar.
• Experience implementing CI/CD, Infrastructure-as-Code, automated deployments, and DataOps practices.
• Excellent communication skills with the ability to collaborate across technical and business teams.

We have a global team of amazing individuals working on highly innovative enterprise projects & products. Our customer base includes Fortune 100 retail and CPG companies, leading store chains, fast growth fintech, and multiple Silicon Valley startups.

What makes Confiz stand out is our focus on processes and culture. Confiz is ISO 9001:2015 (QMS), ISO 27001:2022 (ISMS), ISO 20000-1:2018 (ITSM) and ISO 14001:2015 (EMS) Certified. We have a vibrant culture of learning via collaboration and making workplace fun.

People who work with us work with cutting-edge technologies while contributing success to the company as well as to themselves.

To know more about Confiz Limited, visit https://www.linkedin.com/company/confiz/