Senior Snowflake Technical Lead​/Architect

Position: 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 Snow Pro Core and Snow Pro Advanced Data Engineer preferred.
• Nice to have:
  Databricks, Azure Synapse, additional Snow Pro certifications, platform analytics and cost optimization, C#/.NET, and experience with very large-scale datasets.

Recruitment Transparency Notice

Eliassen Group values transparency in our recruitment practices. Please be advised that Eliassen Group utilizes artificial intelligence (AI) tools as part of its initial application screening and hiring process. You may receive email and SMS notifications from the Eliassen Virtual Recruiting Team (, ) inviting you to complete a brief voice screening as part of your application process. These tools assist our hiring teams in different ways, including but not limited to, assistance in reviewing application materials to help identify candidates whose qualifications most closely match the requirements of the position.

All AI-assisted evaluations and responses are reviewed by human recruiters before any hiring decisions are made. The use of AI in our process is intended to support fairness, efficiency, and consistency, and Eliassen Group takes measures to prevent bias or discrimination in connection with its hiring practices. By proceeding, you acknowledge, agree, and consent to Eliassen Group's use of these tools, including AI tools, as part of the application and hiring process.

Skills, experience, and other compensable factors will be considered when determining pay rate. The pay range provided in this posting reflects a W2 hourly rate; other employment options may be available that may result in pay outside of the provided range.

W2 employees of Eliassen Group who are regularly scheduled to work 30 or more hours per week are eligible for the following benefits: medical (choice of 3 plans), dental, vision, pre-tax accounts, other voluntary…