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.