Remote Position
Snowflake Architect
🌍 Remote · United States
💼 Full-time
Position: Snowflake Architect Work Location: Remote – East Cost Employment Type: 3 Contract Job Summary We are looking for an experienced Snowflake Architect to design, develop, and implement scalable, secure, and high-performance data solutions using Snowflake. The ideal candidate will have strong expertise in cloud data architecture, data warehousing, ETL/ELT processes, and data integration, along with the ability to translate business requirements into effective technical solutions.
Key Responsibilities
- Design and implement end-to-end data warehouse and cloud data architectures using Snowflake.
- Develop scalable and high-performance data solutions to support enterprise analytics and reporting.
- Define data modeling strategies, including dimensional modeling and data warehouse design.
- Optimize Snowflake performance, including query tuning, warehouse sizing, and cost management.
- Design and implement data ingestion, transformation, and integration pipelines using ETL/ELT tools.
- Establish data governance, security, access controls, and data quality standards.
- Integrate Snowflake with cloud platforms such as AWS, Azure, or Google Cloud Platform.
- Collaborate with business stakeholders, data engineers, analysts, and other technical teams.
- Provide technical leadership, architecture guidance, and best practices for Snowflake implementations.
- Troubleshoot complex data pipeline and performance issues and recommend effective solutions.
Required Skills and Qualifications
- Strong hands-on experience with Snowflake architecture and cloud data warehousing.
- Expertise in SQL, data modeling, and database design.
- Experience with ETL/ELT tools and data integration frameworks.
- Proficiency in Python and/or other scripting languages.
- Experience with cloud platforms such as AWS, Azure, or Google Cloud Platform.
- Knowledge of Snowflake security, role-based access control (RBAC), data sharing, and governance.
- Experience with query optimization, performance tuning, and cost optimization.
- Strong understanding of data warehouse concepts, lakehouse architecture, and modern data engineering practices.
- Excellent communication, analytical, and problem-solving skills.
Preferred Qualifications
- Experience with Snowflake features such as Snowpipe, Streams, Tasks, Dynamic Tables, and Snowpark.
- Familiarity with orchestration tools such as Airflow or similar platforms.
- Experience with CI/CD, Git, and infrastructure-as-code tools.
- Snowflake certification is a plus.