Senior Snowflake Technical Lead / Architect

Description Hybrid 4 Days a week on-site in either Orlando, FL or Burbank, CA or Seattle, WA or New York, NY Our client has an opportunity for a Senior Snowflake Technical Lead / Architect to serve as the technical authority for Snowflake platform strategy, architecture, governance, AI enablement, and large-scale data initiatives. The role combines hands-on engineering with architectural leadership to support enterprise data ecosystems at scale, mentor developers, and drive platform best practices. Due to client requirements, applicants must be willing and able to work on a w2 basis. For our w2 consultants, we offer a great benefits package that includes Medical, Dental, and Vision benefits, 401k with company matching, and life insurance. Rate: $83.00 to $93.00/hr. w2 Responsibilities • Design, develop, and optimize complex Snowflake solutions. • Lead Snowflake platform architecture, governance, security, and AI adoption initiatives. • Architect large-scale data ingestion and integration solutions across internal and external systems. • Design and maintain data lakes, data warehouses, and scalable enterprise data models. • Ensure compliance with PII, GDPR, PIPL, and CCPA requirements. • Develop platform analytics, performance analytics, and executive reporting capabilities. • Leverage Snowflake Intelligence, Cortex AI, Streamlit, and emerging Snowflake technologies. • Define technical standards, reference architectures, and engineering best practices. • Partner with Product, Security, Architecture, and Operations teams to deliver strategic solutions. • Mentor engineers through design reviews, code reviews, and technical leadership. • Drive troubleshooting, root cause analysis, performance optimization, and platform reliability efforts. Experience Requirements • 7+ years of software engineering experience. • 3–5+ years of hands-on Snowflake development and architecture experience. • Proficiency with Snowflake, SQL, JavaScript, Snowflake Scripting, Snowpark, Snowpipe, and Python. • Experience building and maintaining CI/CD pipelines. • Expertise in Data Warehousing and Medallion Data Lake architectures. • Experience with data governance, security, disaster recovery, and monitoring. • Experience with REST APIs, web services, and event-driven integrations. • Experience in Agile environments and large enterprise organizations. • Snowflake certifications such as SnowPro Core and SnowPro Advanced Data Engineer preferred. • Nice to have: Databricks, Azure Synapse, additional SnowPro certifications, platform analytics and cost optimization, C#/.NET, and experience with very large-scale datasets. Education Requirements