Snowflake Architect

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.