BURGEON IT SERVICES

Compensation

Full Description

Job Title: Snowflake Architect Location: Remote (Must work EST hours) Duration: 6 Months plus only on w2 Visa: Visa-independent candidates only Please share me the resumes at pranay@burgeonits.com Role Summary We are looking for an experienced Snowflake Architect to lead Snowflake data architecture and large enterprise data programs. The role involves hands-on Snowflake design, ETL/ELT architecture, reporting, and technical leadership while working closely with Directors and business stakeholders. Key Responsibilities • Lead Snowflake architecture and data platform design • Design and optimize ELT/ETL pipelines and data models • Provide technical leadership to data engineering teams • Work with Directors and stakeholders on requirements and program status • Lead large-scale data programs end-to-end Required Skills • 10+ years of experience in data architecture, data engineering, or analytics • 5+ years of hands-on Snowflake implementation (enterprise scale) • Strong Snowflake architecture and advanced SQL • ELT/ETL concepts and tools (Coalesce preferred) • Reporting & analytics tools (Sigma or similar) • Data modeling (Dimensional modeling, Medallion architecture) • Snowflake features: Streams, Tasks, Dynamic Tables, Time Travel, Cloning • Data governance, security, RBAC, data masking • Experience leading teams and large programs Nice to Have • Snowflake certification (SnowPro Core) • Strong leadership and stakeholder management skills