Senior Snowflake Architect, Platform and Administration

Rishi Writes; United States; Remote; USD 180,000 - 260,000; Full time

Job summary

Rishi Writes is seeking a senior Snowflake specialist to design and run a scalable Snowflake platform for data warehouse, data lake and data sharing use cases. You will own day-to-day administration across Development, Test and Production with focus on performance, security and cost, and guide a distributed offshore Snowflake team.

The role combines architecture and administration responsibilities in a remote environment open to the United States, requiring 8–10+ years in data platforms and 4–5+

Qualifications

• 8 to 10+ years in data engineering, data architecture or data platform roles.
• 4 to 5+ years of hands-on Snowflake architecture and administration.
• Strong expertise in Snowflake architecture, performance tuning and cost optimization.
• Knowledge of Cortex AI and Data Agents.
• Advanced SQL skills. Python experience is preferred.
• Scripting and automation with Bash, Terraform or similar tools.
• Experience with CI/CD pipelines and GitHub.
• Experience with AWS and/or Azure.
• Strong troubleshooting, communication, collaboration and technical leadership skills.

Responsibilities

• Design scalable Snowflake architectures for data warehouse, data lake and data sharing use cases.
• Lead performance tuning and cost optimization on Snowflake.
• Build dimensional and analytical data models and analytics-ready datasets across Bronze, Silver and Gold layers and semantic views.
• Design and operate batch and near real-time ETL/ELT pipelines.
• Manage Snowflake data sharing, data integration, replication, disaster recovery, failover and backup strategies.
• Apply Snowflake security and governance, including RBAC, masking policies, row access policies, encryption and Snowflake Horizon.
• Administer warehouses, databases, schemas, users, roles and resource monitors across Dev, Test and Production.
• Monitor and optimize Snowflake performance, availability and cost.
• Provide technical guidance to distributed or offshore Snowflake administration teams.

Skills

Snowflake architecture and admin

SQL

data architecture

data engineering

ETL/ELT

data warehousing

cloud platforms (AWS/Azure)

Python

CI/CD

GitHub

Tools

Bash

Terraform

Job description

Location: United States
Work arrangement: Remote
Job type: Contract to hire
Experience: 8 to 10+ years in data engineering, data architecture or data platform roles, including 4 to 5+ years of hands-on Snowflake architecture and administration

About the Role

We are looking for a senior Snowflake specialist who can both design the platform and run it. You will shape scalable Snowflake architectures for data warehouse, data lake and data sharing use cases. You will also own day-to-day platform administration across Development, Test and Production, with a sharp eye on performance, security and cost. Part of the role is guiding a distributed or offshore Snowflake administration team.

Primary Skills

Snowflake architecture and administration, SQL, data architecture, data engineering, ETL/ELT, data warehousing, AWS or Azure, Python, CI/CD and GitHub.

What You Will Do

• Design scalable Snowflake architectures for data warehouse, data lake and data sharing use cases
• Lead performance tuning and cost optimization on Snowflake
• Build dimensional and analytical data models and analytics-ready datasets across Bronze, Silver and Gold layers and semantic views
• Design and operate batch and near real-time ETL/ELT pipelines
• Manage Snowflake data sharing, data integration, replication, disaster recovery, failover and backup strategies
• Apply Snowflake security and governance, including RBAC, masking policies, row access policies, encryption and Snowflake Horizon
• Administer warehouses, databases, schemas, users, roles and resource monitors across Dev, Test and Production
• Monitor and optimize Snowflake performance, availability and cost
• Provide technical guidance to distributed or offshore Snowflake administration teams

What You Bring

• 8 to 10+ years in data engineering, data architecture or data platform roles
• 4 to 5+ years of hands-on Snowflake architecture and administration
• Strong expertise in Snowflake architecture, performance tuning and cost optimization
• Knowledge of advanced Snowflake capabilities, including Cortex AI and Data Agents
• Advanced SQL skills. Python experience is preferred
• Scripting and automation with Bash, Terraform or similar tools
• Experience with CI/CD pipelines and GitHub
• Experience with AWS and/or Azure
• Strong troubleshooting, communication, collaboration and technical leadership skills

Nice to Have

• Predictive modeling and anomaly detection using Snowflake Cortex AI
• Snowflake SnowPro Core certification

Frequently Asked Questions

1. Is this job remote?

Yes. It is a remote role.

2. Which country is it open to?

The United States.

3. What type of job is it?

Contract to hire.

4. How much overall experience is required?

8 to 10+ years in data engineering, data architecture or data platform roles.

5. How much Snowflake experience is required?

4 to 5+ years of hands-on Snowflake architecture and administration.

6. Is this an architecture or an administration role?

Both. You will design the platform and run its administration.

7. Which environments will I administer?

Development, Test and Production.

8. Which cloud platforms are relevant?

AWS and/or Azure.

9. Is Python required?

Python experience is preferred. Advanced SQL is required.

10. Which security features should I know?

RBAC, masking policies, row access policies, encryption and Snowflake Horizon.

11. Is Snowflake Cortex AI part of the role?

Knowledge of Cortex AI and Data Agents is required. Predictive modeling with Cortex AI is a plus.

12. Will I lead a team?

You will provide technical guidance to distributed or offshore Snowflake administration teams.

13. Is SnowPro certification required?

No. SnowPro Core is preferred.

14. Does the role cover disaster recovery?

Yes, including replication, failover and backup strategies.

15. How do I apply?

Email your resume to [e-mail].